Skip to Content
Author's profile photo Former Member

ACR failure?? tips to analyze the reason

ACR Failed for your Master data objects? Simple tips to analyze

This document will gives you summarized view about the ACR failure and how to analyze the root cause for the issues.

The ACR for your master data objects are failing with error message “Locked against indexing or tablethen the reason would be any of the below.

Reason 1 :

Loads to that master data object might be running in parallel with the ACR.

Solution : Stop/Cancel the loads and rerun the ACR manually. Later you can resume back your loads.

Reason 2 :

Check for any ROLLUP or BIA Indexing is running for the cubes associated with that Objects.

Solution : Wait till the ROLLUP or BIA Indexing completes and rerun the ACR manually.

Reason 3 :

Check for any daemon jobs running for that Objects.

Solution : Wait till the daemon job completes and rerun the ACR manually.

Reason 4 :

Check for any other ACR is already running for the same object.

Solution : If the failed ACR contains other Objects also, then repeat the ACR after the actively running change run is completed.

Tips to Quick check the ROLLUP or BIA Index running in the System.

ROLLUP

Go to the T-Code SM37(where all the background processes running will be visible) -> type the Job Name “BI_PROCESS_ROLLUP” and check job status “Active”,”Finished” & “Cancelled” then execute. then check in the job logs.

BIA Index

Go to the T-Code SM37 -> type the Job Name “BIACTI_*” and check job status “Active”,”Finished” & “Cancelled” then execute.then check in the job logs.

For Checking the status of ACR, you can use T-Codes CHANGERUNMONI or RSATTR.

Other Usefull T-Codes are,

  1. RSDDBIAMON
  2. TREXADMIN
  3. RSDDB

Note: Always rerun manully the failed ACR job from TCODE : CHANGERUNMONI because, If we are repeating ACR from the process chain, it will generate one more job. But already failed ACR job will be locked with BIA job. So it will get fail again. (If ACR job failed because of lock with the BIA Indexing then we have to follow above procedure).

Assigned tags

      24 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Bharath...

      That is nice one!.

      but include steps wherever necesary (eg: a demon jobs name with *)...

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Dileepkumar,

      Daemon Jobs are kind of semaphores(Child processes) created to a main process and that will be running though the parent process is completed.

      These Jobs will own seperate ID irrespective of the parent job ID.

      Eg:-

      Let us consider a DTP loads triggered by a process chain variant with Job "BI_PROCESS_DTP_LOAD" shown below. A new deamon job will be created to load data from source to target. That job will be started with same ID "BIDTPR_6648977_1" showed in next figure.

      /wp-content/uploads/2013/07/11_242101.jpg

      /wp-content/uploads/2013/07/12_242234.jpg

      Please let me know if you require further more in detail.

      Regards,

      Bharath. S

      Author's profile photo Former Member
      Former Member

      Hi Bharath..

      that is clear!!

      This would help me analyse !

      Thanks for reply.

      Author's profile photo Former Member
      Former Member

      Nice document with case scenario's. Better if you would have attached sample screen shots too 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Ramesh.. 🙂

      Author's profile photo Harshawardhan Ghatge
      Harshawardhan Ghatge

      Nice Document Jaya..

      Author's profile photo Former Member
      Former Member

      Hi Bharat..

      Good post.

      Helped me in solving issue with acr.

      Thanks a ton!!

      Keep sharing...

      Regards,

      Siva...

      Author's profile photo Former Member
      Former Member

      Nice document..

      Explained well with solutions..

      thnx,

      Nethaji

      Author's profile photo Harish Allachervu
      Harish Allachervu

      Hi Bharath,

      Its really good stuff 🙂 actually i've so many doubts regarding the ACR & deamon jobs you have cleared all those.

      keep posting buddy so it can be helpful to our fellow mates in the community and it will helps them in enriching their BW/BI knowledge 😉

      Regards,

      Harish

      Author's profile photo Former Member
      Former Member

      nice doc.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thnks Arunkumar

      Author's profile photo Former Member
      Former Member

      Good document..! Keep it up.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thnks Naveen

      Author's profile photo praveen kumar V
      praveen kumar V

      Hi

      Good document

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thnks Praveen

      Author's profile photo vinod bokade
      vinod bokade

      nice document, keep sharing 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thnks Vinod

      Author's profile photo Former Member
      Former Member

      nice explanation on how to analyze ACR  failure. Thanks for uploading this.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Manna Das

      Author's profile photo Former Member
      Former Member

      Good document.. explained well..

      Thanks for sharing 🙂

      Author's profile photo Former Member
      Former Member

      nice document Jay Bharat !!!

      Author's profile photo Former Member
      Former Member

      awesome doc Jaya!

      Author's profile photo Martin Grob
      Martin Grob

      good summary to bad people don't consider it before creating a discussion 😉

      Author's profile photo Former Member
      Former Member

      Really helpful for monitoring purposes. Cleared the concept od Daemon jobs.