topic VARCHAR to FLOAT column conversion in batch mode- Sybase in Qlik Replicate

VARCHAR to FLOAT column conversion in batch mode- Sybase

akaradhya — Thu, 18 Sep 2025 15:20:05 GMT

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.

Re: VARCHAR to FLOAT column conversion in batch mode- Sybase

DesmondWOO — Fri, 19 Sep 2025 04:59:17 GMT

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

Re: VARCHAR to FLOAT column conversion in batch mode- Sybase

narendersarva — Mon, 22 Sep 2025 23:55:21 GMT

Hi @akaradhya

Please check your ASE ODBC Driver compatible with qlik replicate.

Thanks
Naren

Re: VARCHAR to FLOAT column conversion in batch mode- Sybase

Dana_Baldwin — Tue, 23 Sep 2025 16:31:43 GMT

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