ALEREMOTE LOCK at Process chain level

[Former Member]

hello experts,

Please suggest me to resolve this ALEREMOTE LOCK at process chain level.

Because of this the chain is failed at different process levels.

the below mentioned is the job log.

Job tarted

Step 001 started (program RSPROCESS, variant &0000000464318, user ID ALEREMOTE)

Object requested is currently locked by user ALEREMOTE

Entire chain now has status 'R'

Process Generate Index, variant Generated from LOADING ZPAK_3TLYNXGWP514GLCXQ33XDE has status Undefined (instance )

Process Execute InfoPackage, variant PC : Quotation NA to Pipe has status Undefined (instance )

Process Start Process, variant Start Hist and Pipe load has status Completed (instance 4B15FK2YHXC7EW1D221A4EHIM)

Process Local Process Chain, variant 6660 ZSDC2ABC has status Successfully completed (instance 4B14MFS6APTW94XB79A4MSTV2)

Process Delete Index, variant Generated from LOADING ZPAK_3TLYNOIAKRPCQAO2X0DLN4 has status Successfully completed (instance DIDX_4B16EOQH4JK3BMJ41536QIHPQ)

Process Execute InfoPackage, variant PC : Quotation NA to Historical has status Successfully completed (instance REQU_4B180R5J6D8OIIEK0S9K0OH0U)

Process Generate Index, variant Generated from LOADING ZPAK_3TLYNOIAKRPCQAO2X0DLN4 has status Successfully completed (instance INDX_4B18Q9XP4GQZLL7LXGI5JYFXQ)

Process Delete Index, variant Generated from LOADING ZPAK_3TLYNXGWP514GLCXQ33XDE has status Undefined (instance DIDX_4B18CADCFC1SL10FHBFZ7ZINI)

Termination of chain has been reported to meta chain 4B154CLBHDTKWHZEYFNE6RWOE

Job finished

Additional information::

For the fisrt month - Error occured in block load infopackage

Message text:Process Execute Info Package, variant PC: Quotation NA to Pipe has status Ended with errors (instance REQU_49OKKAVXV8WM75XY9268J

Second month - Error occured in block load infopackage(same as last month)

message text:Process Execute Info Package, variant PC: Quotation NA to Pipe has status Ended with errors (instance REQU_4ACQBCYASM88BVNSCWVG6

Fourth month - error already in the first load

Message text:Process Execute InfoPackage, variant PC : Quotation NA to Historical has status Ended with errors (instance REQU_4APCZRLE8E4BAY0

Fifth month - error in the "delete indexes" step

Message text: Process Delete Index, variant Generated from LOADING ZPAK_3TLYNXGWP514GLCXQ33XDE has status Ended with errors (instance DIDX_4B1.

Thanks in advance

Edited by: S MB on Sep 9, 2008 12:01 PM

Edited by: S MB on Sep 9, 2008 2:29 PM

Edited by: S MB on Sep 9, 2008 2:31 PM

[Former Member · Accepted solution]

The lock error is coming because the load is going at multiple places at the same time. You are loading to a data target (hopefully it will be master data) which has already been laoding thru some other process/IP, hence causing in lock. You can see the lock in SM12. You need to wait the ongoing job is over and then start the load again.

Thanks..

Shambhu

[Former Member]

thanks

[Former Member]

thanks

[Former Member]

Thanks for replies.

Its a issue related to Transaction data(No master data is in these PC loading).

Any body let me know is there any TCode available in BW to see all jobs which are running on a specific CUBE / ODS.

I mean...How can we come to know the jobs(all jobs in a same time) which are running on a perticular CUBE/ODS?

Instead of SM12 & SM58

Thanks in advance.

Edited by: S MB on Sep 10, 2008 7:32 AM

Edited by: S MB on Sep 10, 2008 8:02 AM

Edited by: S MB on Sep 10, 2008 8:08 AM

Edited by: S MB on Sep 10, 2008 10:58 AM

[Former Member]

You are either running a process already on a data target or you are starting two processes at the same time creating locks on a single object.

To avoid this, load master data attributes sequentially first, then load texts, then load your data targets.

Do not load master data in parallel (if you have two infopackages for one master data object, never run both at the same time, this will create a lock as seen in tcode SM12).

Also, never load a cube and a master data object at the same time (if the master data object is in the cube or ODS). This will also cause locking.

Also, you cannot load into a cube if you are dropping it's indexes and you cannot read from a cube if you are creating it's indexes.

Brian