2631-Transaction ABORTed due to %VSTR.

Tools & Utilities
Enthusiast

2631-Transaction ABORTed due to %VSTR.

Hi,

I am getting the sqlcode 2631 which is "Transaction ABORTed due to %VSTR." when i execute my stored procedure.My stored procedure is basically fetches the data from multiple tables and do some calculations then it updates the data in an another table by using dynamic SQL.

If anybody knows about this issue, please help me out as soon as possible.

Thanks,
Uma Kathir
2 REPLIES
Enthusiast

Re: 2631-Transaction ABORTed due to %VSTR.

This normally happens when you have a dead lock situation.

It's generally difficult to reproduce, you will have to know what other SQL operations where happening during the same time.

Look for other apps that could be locking the same tables during the same time the stored proc was being executed.

You can use PMON to check on blocking, generally gives a good start on debugging ...

There are other tools like lokdisp (shows all the locks currently on) ... locking logger etc ... (to keep track of locks...).

Most of these stuff, only your DBA would have access to.
Enthusiast

Re: 2631-Transaction ABORTed due to %VSTR.

Thank you.

As you said, I'll try to the analysis on other apps which was running at that time.