topic Re: Type CX_SY_OPEN_SQL_DB occurred in Application Development and Automation Discussions

Type CX_SY_OPEN_SQL_DB occurred

Former Member — Mon, 05 Mar 2007 10:45:00 GMT

Hi guys,

sorry if you see the same post in another thread.

I got an BSP error like this

SAP Note

The following error text was processed in the system:

An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause

Exception Class CX_SY_OPEN_SQL_DB

Error Name DBIF_RSQL_INVALID_CURSOR

Program /CAG/SAPLCSV_EXPORT

Include /CAG/LCSV_EXPORTU01

Line 362

Long text: A database COMMIT occurred during an Open SQL database selection. This selection was to have then continued. However, all database selections must be completed before a database COMMIT.

The most strange is that the same thing I did in Developement System works well, but in Test System I got this error message. Actually I don't have any commit in SQL selections like th message says.

What's wrong with it?

Thanks for ur suggestion

Regards,

Liying

Re: Type CX_SY_OPEN_SQL_DB occurred

Former Member — Mon, 05 Mar 2007 10:48:04 GMT

Give the code snippet around line number 362

Re: Type CX_SY_OPEN_SQL_DB occurred

Former Member — Mon, 05 Mar 2007 10:53:05 GMT

the line 362 is "IF sy-subrc <> 0." of the following code.

In debug mode, I saw that it works once, but the second one (in loop) it shrows this error .

...

OPEN CURSOR WITH HOLD dbcur2 FOR

SELECT aincon_{userid aincon}firstname aincon_{lastname aincon}bu acon_{firstname acon}lastname acon_{email aexcon}power aexcon~influence

FROM zbrap_apro AS apro INNER JOIN zbrap_aincon AS aincon ON apro_{project_id = aincon}project_id

INNER JOIN zbrap_aexcon AS aexcon ON apro_{project_id = aexcon}project_id

INNER JOIN zbrvp_acon AS acon ON aexcon_{cprnr = acon}cprnr

WHERE apro~project_id = project_no.

DO.

FETCH NEXT CURSOR dbcur2 INTO (userid, int_fname, int_lname, bu, ext_fname, ext_lname, email, power, influence).

IF sy-subrc <> 0.

EXIT.

endif.

.....

enddo.

Re: Type CX_SY_OPEN_SQL_DB occurred

Former Member — Mon, 05 Mar 2007 11:00:14 GMT

How many rows does this SQL returns:

SELECT aincon_{userid aincon}firstname aincon_{lastname aincon}bu acon_{firstname acon}lastname acon_{email aexcon}power aexcon~influence

FROM zbrap_apro AS apro INNER JOIN zbrap_aincon AS aincon ON apro_{project_id = aincon}project_id

INNER JOIN zbrap_aexcon AS aexcon ON apro_{project_id = aexcon}project_id

INNER JOIN zbrvp_acon AS acon ON aexcon_{cprnr = acon}cprnr

WHERE apro~project_id = project_no.

Re: Type CX_SY_OPEN_SQL_DB occurred

Former Member — Mon, 05 Mar 2007 11:03:15 GMT

hi,

more than one row. But I don't know exactly...

I think it is the problem in codes between "where" and "endselect".