topic Re: Unexpected error in replicate while loading in Qlik Replicate

Unexpected error in replicate while loading

suvbin — Thu, 01 Oct 2020 11:45:29 GMT

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

Re: Unexpected error in replicate while loading

David_Fergen — Thu, 01 Oct 2020 12:25:43 GMT

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

Re: Unexpected error in replicate while loading

suvbin — Thu, 01 Oct 2020 16:06:18 GMT

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

Re: Unexpected error in replicate while loading

suvbin — Mon, 12 Oct 2020 19:40:22 GMT

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

Re: Unexpected error in replicate while loading

Bill_Steinagle — Fri, 11 Nov 2022 14:27:59 GMT

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