Data Cleansing Advisor Error unable to access staging table

[former_member743802]

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.

[former_member690658]

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.