Unexpected error in replicate while loading

[suvbin]

Table 'uso21' (subtask 0 thread 1) is suspended. Failed (retcode -1) to execute statement: 'INSERT INTO [dbname].[uso21__ct] ( [header__change_seq],[header__change_oper],[header__change_mask],[header__stream_position],[header__operation],[header__transaction_id],[header__timestamp],[MANDT],[BNAME],[BCODE],[GLTGV],[GLTGB],[USTYP],[CLASS],[LOCNT],[UFLAG],[ACCNT],[ANAME],[ERDAT],[TRDAT],[LTIME],[OCOD1],[BCDA1],[CODV1],[OCOD2],[BCDA2],[CODV2],[OCOD3],[BCDA3],[CODV3],[OCOD4],[BCDA4],[CODV4],[OCOD5],[BCDA5],[CODV5],[VERSN],[CODVN],[TZONE],[ZBVMASTER],[PASSCODE],[PWDCHGDATE],[PWDSTATE],[RESERVED],[PWDHISTORY],[PWDLGNDATE],[PWDSETDATE],[PWDINITIAL],[PWDLOCKDATE],[PWDSALTEDHASH],[SECURITY_POLICY] ) VALUES ('2020093014789652345350000000004908384260','U',0x07FFFFFFFFFF80,'13;63737072648934253564770;202009389029074401631124B|810009903455870:810888009898:515:810008889888','UPDATE','04799A3E0000000020C5473034500000000','2020-09-30 14:23:45.356477','900','RFCUSER',0x000000000000000000000,'0101-01-01','0101-01-01','B','S

[David_Fergen]

Hi Sundeep,

Sorry, you are having this issue. Can I ask if you are on batch apply or trans apply and if the settings allow for duplicates? Also, if the Insert actually was a Duplicate or not? Also, what is your error handling if you could provide that? If you could compare the Create DDL between the Source and Target Tables.  As there are two dates of 0101-01-01', '0101-01-01'. Let us know once you get the information.

Thanks,

David

[suvbin]

thank you for the quick response. let me check and get back to you

[suvbin]

its a batch apply. both the dates are from different columns. And also how to check whether settings allow for duplicates? if your mentioning about the below screen, didn't do any changes there. And also another screen shows that , its been set "batch apply". Is this what your asking?  Checked the DDL , the datatypes for the two columns that has date is of the datatype date in the change table (in target) , varchar  (in target) and in the source (SAPHANA) it is String

[Bill_Steinagle]

Hi,

Thank you for the post to the QDI forums. I would suggest you have Replicate on the Full Load do the Drop/Create of the Target Table to keep the Source and Target DDL in sync as if there is a change on the Source this could cause an issue if the Target is not recreated with the updated Source change. If  you use this option and still run into an issue I would suggest opening a support case with the QDI Team.

Thanks!

Bill