Hello,

We are getting Transaction is on, Can't Continue error for one session today in production server.
This session is used to update interim tables.
This session is running in Job without any error from many years, Only today it is giving error.
when ran manually also same error is being generated.
I checked the program script, it is last modified in 2003. so no any recent changes also.

can anyone advise how to resolve this issue.

Quick help is really appreciated.

You have to check through the code and make sure all of the update are getting committed before the next transaction. It is very possible that the code is hitting something (new data or new condition) that was not thought of when it was designed. And it is possible an error condition that is now occurring that has not occurred in all those years since its original design.