Skip to Content

Data Cleansing Advisor Error unable to access staging table

Hi, I'm trying to generate a DCA using a view that has multiple joins and a filter. To finally get the DCA I had to create views on top of views.

I needed to take Business Partner information therefore I tried creating 1 view joining the BUT020, ADRC (inner join on address number) then the additional table was BUT000 (inner join with BUT020 on partner ID) I had 2 filters one with ADRC nation is null and BUT000 XBLK is null. Can someone tell me if this is normal behavior for DCA not to work when joining multiple tables in one view with filters from 2 different tables? I was receiving the error " unable to access staging tables". Content profiling & rules tasks have no errors just DCA.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 24, 2020 at 01:42 PM

    If you can check the log file and share the exact error that would be great.

    As per my past experience with same error, I resolved it by below method by following a SAP KBA Note(Don't remember the Number exactly).

    1) Stop the EIM Adaptive Processing Server
    2) Take a backup of DCA DB file and log file from the below location. <install dir>\SAP BusinessObjects Enterprise XI 4.0\Data\DCA-SA\Data

    3) Remove/Delete the DCA database files from the above location

    4) Restart the EIM APS or SIA(Server Intelligence Agent).

    once all the services and servers are up an running then a new SQLAnywhere DB file and log file get generated at the same location. After that you can check you DCA.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.