VARCHAR to FLOAT column conversion in batch mode- Sybase

[akaradhya]

I am performing Sybase to Sybase replication. The task I am creating is a CDC only task. The table schema is already created in the target. During the job execution, I am facing the below error for columns which have FLOAT data type on the source.

RetCode: SQL_ERROR  SqlState: 42000 NativeError: 257 Message: [SAP][ASE ODBC Driver][Adaptive Server Enterprise] Implicit conversion from datatype 'VARCHAR' to 'FLOAT' is not allowed.  Use the CONVERT function to run this query.

Attaching the tasks log and Diagnostic package in this ticket.

[DesmondWOO]

Hi @akaradhya ,

Thank you for reaching out to the Qlik Community.

In your task log, you can see the message "Failed to execute bulk insert statement." You can use your log.key to decrypt the task log and view the original statement. Based on this statement and the DDL of the source and target tables, you should be able to identify the root cause.

If you're still unsure about the cause, I recommend creating a support ticket. Since the diagnostic package and task log contain sensitive information, it is not advisable to upload the files here.

Regards,
Desmond

[narendersarva]

Hi @akaradhya 

Please check your ASE ODBC Driver compatible with qlik replicate.

Thanks
Naren

[Dana_Baldwin]

Hi @akaradhya 

You can check the required driver version here for the source:

Prerequisites #Prerequisites | Qlik Replicate Help

And here for the target:

Prerequisites | Qlik Replicate Help

Please change the version number at the top left of the screen to match the version you are running.

Steps to decrypt the task log using file log.key (found in the task's folder on the server) are here:

Log file encryption | Qlik Replicate Help

Thanks,

Dana