I am getting the following warning message for the ODBC stage, in which I am using Update or Insert strategy.
Code: Select all
jbGenerateKeyForAddress.BG.FilterGoodKeys.LnkTgtGoodKeys: DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE COMET_ETL.XREF SET SOURCE_KEY = ? WHERE (GSFA_CUSTOMER_ID = ? AND DIVISION_ID = ? AND COUNTRY_ID = ?)
2 Rows affected.
GSFA_CUSTOMER_ID = "BGC3160811550"
DIVISION_ID = "0"
COUNTRY_ID = "BG"
SOURCE_KEY = "ALEXSOFI32"
Is this error is because of more than one record for the key columns????
or any other reason.
I don't want to have any warning msgs if it updates more than one record at a time.
Though the jobs is giving warnings the records are getting updated.
How to avoid these types of warning msgs??
Thanks & Regards
Vijay Kumar