We are having issues getting a successful first run of the Load Data Warehouse job (v.126.96.36.199).
We have done the necessary pre-configuration (set up dblink, database, currency, entity and successful timeslicing run) but each time we run it fails trying to execute some early delete SQL
We have looked at this post which also mentions the same issue but we can't get any further. We do have a support case open but wanted to ask the wider community for ideas.
The table referenced is definitely there:
We haven't configured Jaspersoft in to our environment at all yet as we want to get a working data warehouse first, so it's not a Jasper issue (unless there's an undocumented dependency we don't know about!)
Thanks for any help as usual.
From the description it looks like the default schema is not set to PPM_DWH schema, if you see in our install guide we have documented the same
Another test can prove that, login to management studio and run below
SELECT * FROM DWH_CFG_LOG; -> you will get invalid object SELECT * ppm_dwh.FROM DWH_CFG_LOG; -> should work fine.
Database Schema Name
The login name can be anything, but the default schema name for the login user must be ppm_dwh.
let me know how it goes
We have managed to run the job now - I'm still waiting for the exact reasons as to why it was failing but it seems to be something to do with the configuration of the PPM_DWH login in SQL server. If I get more information I'll post it here.
I had a similar problem, for resolve, you need delete db user or use a new db user with default schema ppm_dwh.