Exception with type CX_SY_OPEN_SQL_DB occurred during Master Data Load

[Former Member]

All, I'm experiencing an interesting error and looking for some ideas on how to approach it.

We're running BI 7.0 SP 13. We are running a full load for some master data. The InfoPackage for this master data runs perfectly fine but the DTP errors out with the message "An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause"

This only happens for this one piece of master data which has no transformations. Any ideas on what is going on here?

Pts awarded accordingly.

[PatrickRieken · Accepted solution]

Hi Randall,

Sounds like an old one, try this by playing with the package size and/or parallelism.

Note 930712 - CX_SY_OPEN_SQL_DB exception when you execute DTPs

Regards, Patrick Rieken.

[Former Member · Accepted solution]

did the note that was mentioned help ?

do you have any enhancements in the extractor ?

could you give us more details about the dump....in st22 ...on the top you would see ABAP editor...if you click on that ...it would show the point at which it is breaking....that info might help ...

Assign points if it helps

[Former Member]

Turns out that if you tweak the package size it miraculously fixes the problem. Weird.

It should also be noted that although the load errored, nothing showed up in ST22 for it.