topic Re: Query execution failed in Qlik Replicate

Query execution failed

suvbin — Wed, 01 Nov 2023 03:26:30 GMT

Hi,

Noticed a warning in the logs , Insert is getting failed . and all columns are not there in the insert statement . The task is running fine. Since its a warning. But logged many data error in the exeception table

Statement: INSERT INTO [rawload].[salesadd] ( [client_id],[add_num],[number1],[DATe1],[NUMBER2],[SrcSys],[date2],[time],[Operation_Indicator] ) VALUES ('100','1100010925','2200681871','0001-01-01','001','salesadd sys','2023-04-20','11:12:42','D')

Error: RetCode: SQL_ERROR SqlState: 23000 NativeError: 515 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'defval', table 'abc.[rawload].[salesadd]'; column does not allow nulls. INSERT fails. Line: 1 Column: -1

Source is SAP Application and

Target is Azure SQL Database

There are no filters in the task.

Checked the DDL for source and target, for "defval" column , it's "not null" .

Tested running same insert statement into target , got the same error

The below is the settings.

Re: Query execution failed

Heinvandenheuvel — Wed, 01 Nov 2023 03:16:57 GMT

ell, that column 'defval' is not pesent in the insert statement and therefor it will be treated as NULL, which is apparently not allowed.

Why is it not there? Your description suggests it exists on source and target (with non-null attribute). It would seem there is a table edit which drops that column. How else?

Repeat with just that table and just a few row, and Logging verbose for source_reader and target_apply and afterwards search the log for any and all mention of 'defval'

btw... that date ,'0001-01-01', looks odd also. It may be a silly test value or is might be wrong.

Hein

Re: Query execution failed

suvbin — Thu, 02 Nov 2023 03:32:21 GMT

Issue resolved by giving some default value to the column in the transform section .

Re: Query execution failed

DesmondWOO — Thu, 02 Nov 2023 06:45:57 GMT

Hi @suvbin ,

If our response has been helpful, kindly consider clicking "Accept as Solution" button for the corresponding post. This will help other users identify the answer.

Thanks,
Desmond