Skip to Content
Former Member
May 25, 2016 at 11:27 AM

Routing download causing database lock


Hi All,

I am downloading routing to ME for a while and everything was working fine until we added more Custom Fields for the Routings (image attached).

The XSLT is responsible for transforming the Classification (that comes from ECC) into SAP ME Custom Fields (xml attached).

But, after these fields were added, whenever we try to import Routings, the database is running into a lock (image attached) on the command ALTER TABLE AL_ROUTER ADD ( "C018_110G_PROD_VAR_006" NVARCHAR2( 1024 ) ).

After the timeout is reached the error on MII monitor is: distributed transaction lock

Any idea on how to solve it?

Thank you.


command lock.png (6.8 kB)