Exception with the type CX_SY_TABLE_KEY_SPECIFICATION occurred when running packages after upgrading to SP06 (BPC 10.1)

[Former Member]

We were on SP03 and upgraded to SP06 (we are on 10.1 Netweaver version).  Now when the packages are run there is the error message: An exception with the type CX_SY_TABLE_KEY_SPECIFICATION occurred, but was neither handled locally, nor declared in a RAISING clause

Line Type Contains a Component with the Name CONSOSCOPE.

[david_ings]

Hi Amy,

Did you find a solution to this issue? I'm also having the same problem on 10.1 - master data/hierarchy packages are running correctly but data loads from BW are getting the same error message as you did.

Thank you

David

[Former Member]

Hi David,

After a lot of testing, the actual solution that worked for us was to just process the CONSOSCOPE dimension again.  After processing it, we no longer got the error messages we were having.

I hope this works for you as well.

Thanks,

Amy

[david_ings]

Hi Amy,

Thank you very much for your reply. Unfortunately processing our group/scope dimension did not work, not did UJA_REFRESH_DIM_CACHE.

However, while we have been unable to resolve the root cause, we found that copying the environment resolved our issue.

Thank you again for your help,

David