BPC Errror CX_SY_OPEN_SQL_DB

[Former Member]

Hello,

I have received the following error message while running a data manager package.  The message says "An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause.  The database returned a value containing an error"

There are no other descriptions of what this error means or any other backup to help me fix this error.  Could someone help me understand what caused this so that we can avoid it in the future?

Thank you,

Robert

[former_member186338 · Accepted solution]

Hi Robert,

Please provide info about the package. Is it script?

Have you tried to run it again?

Vadim

[Former Member · Accepted solution]

Hello Vadim,

Yes, it is a script and it was run successfully the next day on the same parameters.  I have attached the script logic and a screen shot of the same package run successfully the following day.

Thanks,

Robert

Calc_UK6280 script.txt.zip

[former_member186338 · Accepted solution]

Nothing wrong with the script (may be not very efficient ). For the CX_SY_OPEN_SQL_DB error - talk to the basis team, looks like it's some hardware or DB issue.

Vadim

P.S. Also look on ST22...

[Former Member · Accepted solution]

Okay, I will reach out to the basis team.  I thought our script might not be the most efficient but could you please elaborate more on what we can do better to make it more efficient? What we know about building scripts came from the SAP team that helped install BPC on our servers as well as trying to read about scripts in SAP books.

Thank you,

Robert

[former_member186338 · Accepted solution]

For the first scope you can add:

*XDIM_MEMBERSET ACCOUNT=BAS(UA6200,UA6350,UA6460) //Just to minimize scope

Remove useless COMMIT!

Second scope will be only (without COMMIT you don't need to repeat scope!):

*XDIM_MEMBERSET FLOW = BAS(K700)

*XDIM_MEMBERSET ACCOUNT=BAS(UK6050,UK6065,UK6070,UK6080...)

Remove useless COMMIT at the end.

Vadim

[former_member186338 · Accepted solution]

Finally the script will be only:

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET FLOW = E70

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET RPTCURRENCY = %RPTCURRENCY_SET%

*XDIM_MEMBERSET ACCOUNT=BAS(UA6200,UA6350,UA6460)

//--- Write Records ---

*WHEN ACCOUNT

*IS *

*REC(FACTOR = 1, ACCOUNT = UK6280_INPUT, FLOW = K600, AUDITTRAIL = SystemCalc)

*ENDWHEN

*XDIM_MEMBERSET FLOW = BAS(K700)

*XDIM_MEMBERSET ACCOUNT=BAS(UK6050,UK6065,UK6070,UK6080,UK6085,UK6090,UK6110,UK6130,UK6132,UK6134,UK6136,UK6140,UK6150,UK6170,UK6190,UK6230,UK6240,UK6250,UK6260,UK6265,UK6270)

//--- Write Records ---

*WHEN ACCOUNT

*IS *

*REC(FACTOR = -1, ACCOUNT = UK6280_INPUT2, FLOW = K600, AUDITTRAIL = SystemCalc)

*ENDWHEN

Vadim