on 2020 Jan 21 4:25 PM
Hi,
Our System SAP BW 7.3 SP19, BPC 10.0 NW SP26. Our delta loads triggered the below error.
Task name SOURCE DELTA INFOPROVIDER:
An exception with the type CX_SY_TABLE_KEY_SPECIFICATION occurred, but was neither handled locally, nor declared in a RAISING clause
Line type does not contain a component with the name AUDITTRAIL
model: XXXXXX Package status: ERROR
We processed Dimension in BPC and performed Refresh Dimension Cache in BW and still we have the issue.
Could you please help me in resolving this.
Thanks
Sekhar SR
Request clarification before answering.
Thanks Vadim.
BI Cube got deactivated. This is the reason for the error.
Thanks for the help.
Sekhar SR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, but something was done wrong with this manual data load...
Delta load is very sensitive to any manual changes.
Looks like you have to restart delta load with initialization.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
After revalidating the Transformation file, it triggerred error "No row can be added to a DataGridView control that does not have columns. Columns must be added first." but unable to understand from where this error was??? where to correct... No clue...
Could you please help to understand the issue. so that i can try to resolve it.
And i doubt that the re-initialization of Delta will work. And one more thing is that the same transformation file and delta loads working fine in other systems.
Thanks
Sekhar SR
Hi Vadim,
Due to Table Space issue some data was not loaded to BW. So BW team manually loading them after their delta loads. As they are manually loading data to BW, just postponed the BPC delta loads for 30 mins. Nothing else we did at that time. We just postponed the BPC Deltas, thats all.
We validated Transformation file also after the issue, It validated successfully.
Thanks
Sekhar SR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
We have already configured Delta loads and it is working fine till yesterday. Due to some BW related activity, we postponed one delta load for 30 mins. Since then all the delta loads, including the postponed delta load, failing with the above error. We performed AUDITRAIL Cache Refresh in BW and proccessed AUDITRAIL Dimension in BPC. Still facing the issue.
Thanks
Sekhar SR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 8 | |
| 8 | |
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.