Hi, I have developed update session in which 10 to 11 tables are updating, but the problem is it is not running with spacific user , ie user type is normal, It hangs. While running with my user its working perfectly. Problem is cannot make that user as super user. what could be the reason. Please guide me.


Regards,
Alers

Hi,

Check if that user has insert/update authorization for those tables.

First that update session was running by the same user, after some tuning and modification he cannot. what i did in that session was i just removed all commitransactions and placed once at end of the session. Its working with my user Id.


Regards,
Alerts

Hi,

The best thing you can do is, put the session under debug mode and check at which table it is hanging. That will give you some ideas.

Yes while debugging it successfully updating, but normally it hangs.


Regards,
Alerts

Hi,

That sounds weird. Can you post your code?

Hi,

what about writing a log file?

Regards Günther

One more question. In debug mode, are you executing the complete program or just checking if all updates are done? Make sure you go through whole program i.e. check if commit is executing or not.

Also, as gunther said, you can check return values for all update statements and commit transaction and write it to a file or simply check the return values in debug mode.

Check if its going to db.retry.point() ...

I debugged for 2 to 3 records and continued. It was working.

its probably authorization or locked record issue.