SAP Commerce Cloud: "Error converting data type nvarchar to bigint" on data migration.

[NilsBremer]

Hi,

I am migrating data with sap-commerce-db-sync tool from an on-premise mysql database to the SAP CC database. I am currently getting the following error:

cmscomponent->cmscomponent | 239591 / 284591 | FAILED! Reason: java.lang.RuntimeException: BatchUpdateException: Error converting data type nvarchar to bigint.

I activated JDBC logging (migration.log.sql), but (as specified in the documentation) the log does not contain the parameters for queries against the target datasource. So I don't really see a way to find the problematic items from the source...

Is there any other way to find out which exact items (PKs) could be causing this error?

Best regards
Nils Bremer

[NilsBremer · Accepted solution]

Hi,

we found the issue:

An attribute definition in an items.xml was changed from java.lang.String to an Enum. Unfortunately not all existing items were migrated properly to the enum values. After fixing this inconsistency the cmscomponent table was migrated successfully.

Best regards

Nils Bremer