Appendix E. - Limitations

Parallellization limitation

You can not run imports that affect the same dataset simultaneously, otherwise this results in the following failures and errors.

Error messages

11:12:19.821 [jobExecutor-927] 

ERROR

c.c.d.c.s.job.impl.JobServiceImpl - Job ActiveJob
{id='4c43611f-4ab1-4272-a6b8-607f3ceaf6bf', name='Import', user='b351c493-428e-4c82-a18b-46089b1dbc4e', state= *ERROR* }

 

error:

'{"type":"MESSAGE","message":"An unexpected error occurred during the execution of the job. Please check the log files for more details."}'.

ERP/CRM Integrator log

<item LogTitle="the Collibra importer API reported a problem with the job. The resulting status was not set to "COMPLETED" as expected! / Result of the call: status = ERROR
message = {"type":"MESSAGE","message":"An unexpected error occurred during the execution of the job. Please check the log files for more details."}
file = C:\Users\Public\Documents\Safyr\Import\Z2L_100\clAssetImport00019.json" LogType="SINGLELOG" LogStatus="FINISHED" LogResult="ERROR" StartDate="15.09.2020 11:12:25.647" EndDate="15.09.2020 11:12:25.647"/>

dgc.log

2020-09-15 11:12:19.820 [jobExecutor-927] ERROR o.h.e.j.batch.internal.BatchingBatch - HHH000315: Exception executing batch [org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: HikariProxyPreparedStatement@1365540544 wrapping update dgc.REPRESENTATIONS set CREATOR='b351c493-428e-4c82-a18b-46089b1dbc4e', CREATIONDATE=1585043280717, LASTMODIFIED=1600161123489, MODIFIEDBY='b351c493-428e-4c82-a18b-46089b1dbc4e', IS_SYSTEM='FALSE', OPT_LOCK=19, HL_EXCLUDE='FALSE', STATUS='00000000-0000-0000-0000-000000005055', ASSET_TYPE='00000000-0000-0000-0000-000000031008', VOCABULARY='88517912-c352-437b-8110-5c2322b54f67', ARTICULATION=100.0, AVG_RATING=0.0, DISPLAY_NAME='LIFNR', RATINGS_COUNT=0, SIGNIFIER='A017 > LIFNR' where ID='ffbb459a-3800-40ae-899c-764a3089be68' and OPT_LOCK=18], SQL: update dgc.REPRESENTATIONS set CREATOR=?, CREATIONDATE=?, LASTMODIFIED=?, MODIFIEDBY=?, IS_SYSTEM=?, OPT_LOCK=?, HL_EXCLUDE=?, STATUS=?, ASSET_TYPE=?, VOCABULARY=?, ARTICULATION=?, AVG_RATING=?, DISPLAY_NAME=?, RATINGS_COUNT=?, SIGNIFIER=? where ID=? and OPT_LOCK=?

Resolution

  1. In ERP/CRM Integrator, start the Export Data Model wizard.
  2. At step 2b, go to the Collibra settings.
  3. In the Export Target Definition, set the Parallel Load Processes to 1.