- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] Reading and writing data is performed to a column different from the set column.
Search via FAQ No.
NEW
[DataSpider Servista] Reading and writing data is performed to a column different from the set column.
When I use the database adapter to set a data, reading and writing, the following errors have occurred.
- Read data from a column different from the set column
- Write data to a column different from the set column
Please explain the cause and a way to resolve this problem.
- Category :
Answer
■Cause
The DataSpider Servista reads and writes data to the connected table, based on the schema set by the component icon. For this reason, if there is a difference between the connection destination table and the schema set in the component icon, an event which given in the question will occur.
In the past case, an event occurred when adding or deleting a column to the connected table after setting the schema with the component icon.
■Workaround
Please click on the link "set the schema by running the SQL statements" in the component icon which an event has occurred, and update the schema to the latest status.
■Note
In the versions prior to 2.3, there is no "Execute SQL statement and set schema" link. In this case, please specify another table once and specify the destination table again.