Database Insert Error using write append

[Kartik Dharia]

Hi
I have 2 environments PRD and PRD_SUP. The job reads from the message queue and loads in the Staging table.For loading into the database table i am using write append.
The job is working fine in PRD_SUP but when i execute the same job it aborts giving the following error :

The statement named in the EXECUTE statement is not in a prepared state or is a SELECT or VALUES statement.
SQLSTATE=07003


Moreover I have cross project compared both the jobs and there were no changes. Also the database tables is in sync in both the environments .

Can anyone had came across such issue .Please help