HULFT Technical Support & FAQ

  • Font Size
  • S
  • M
  • L

My Page

Search via FAQ No.

Enter the FAQ record number and click "Browse."

  • No : 30731
  • Open Date : 2019/09/09 15:49
  • Print
NEW

[DataSpider Servista] The CannotConvertException error occurred in Mapper

The following error occurred in Mapper
 
com.appresso.ds.vp.mapper.fastconverter.CannotConvertException <number of columns> Error occurred in columns:
Cannot logic-Could not convert from <pre-conversion data type> type to <post-conversion data type> type
 
Please explain the cause and a way to resolve this problem.
 
Category : 

Answer

■Cause
 
CannotConvertException is an exception that is output when the data type conversion fails in the Mapper logic. The cause is that the type of data to be registered did not match the type of actual data to be registered.
 
*Please refer to the link of "Reference Information" for details about message codes and logic data types.
 
In the past case, the error occurred in the following cases:
  • When a user tried to write a string to a database numeric column.
  • When a user tried to convert numeric type to a date/time type
  • When a user tried to assign an empty character to a numeric or date/time script variable
■Workaround
 
Please make sure that the input data matches the write destination item and the logic data type. Also, you need to check that the mapping link is connected as expected and then please set it up so that appropriate conversion can be performed.
 
If the error occurs even after checking the mapping and matching the types, please obtain the following information and contact the product support desk.
 
■Information Required for investigation
 
  1. XML log
Please send an XML log of when you execute the script with the log level set to "DEBUG".
  1. Project
Please send us a project that contains a script in which the error occurred. If it happens at a specific script version, please send a project including all versions.
  1. Input Data
Please send us the input data that is required for executing the process. Also, if there is a difference in the error occurrence depending on the data, please also provide us with data that does not occur.
  1. Before and After the Error
If the error started to occur from the particular script version, please explain the detail of the operation performed just before saving the script.
 
 
Reference Information
 
*The following links will be the latest version of Help. If you are using a version earlier than the latest version, please refer to the product help or the corresponding version help from FAQ No. 24306.
 
・Message Code (Mapper)
 
・Data Type of Conversion Logic
 
 
An example of logic that is useful when converting blanks and nulls is noted in the following:
 
・Conversion of Null Character (can convert null characters to 0, etc.)
 
・Each Side Trim (blanks can be removed from both ends)
 

Top