Error 7487 : AMP step ailure: Please do not resubmit the last request
Hi, Every one, Our batch could not worked well since last Thursday. The Error is the same as the title. We have already contact with GTS , and the reply is that not commit the sql again. We do not know what's wrong with the sql. It has already worked for more than one year. Now we have already stop our batch , waiting for the reply. This is a very important sql, the customer has already been angry......... I can not upload the script , but the SQL is a MERGE statement as below " MERGE INTO TABLE1 AS T1 USING TABLE2 AS T2 ON ( T1.COL1= T2."HOST" AND T1.COL2 = T2.COL2 AND T1.DATETIMESTAMP = T2.DATETIMESTAMP ) WHEN MATCHED THEN UPDATE SET XXXXX = T2.XXXX WHEN NOT MATCHED THEN INSERT( XXXXXX ) VALUES( T2.XXXX....... ) ; " Thank you for your help.