Database selection with invalid cursor !

[Former Member]

hi experts,

When execute SAP BW processchar, it occur some system error: (sm21)

Database selection with invalid cursor

The database interface was called by a cursor (in a FETCH or CLOSE

cursor operation) that is not flagged as opened. This can occur if a

COMMIT or ROLLBACK was executed within a SELECT loop (which closes all

opened cursors), followed by another attempt to access the cursor (for

example, the next time the loop is executed).

this error occur when apply bw support package 19.

sap notes 1118584 Solution is: Import Support Package 17 . but my support package is 19.

how can i solve this error?

thanks,

xwu.

[Former Member]

hi, Oliver,

frist, you should check the sap database redo log space. maybe the redo file too small.

if this can't solve the question, pls update the sap kernel to lastest version.

thanks.

xwu.

[Former Member]

Hi,

how did you solve the problem?

kind regards

Oliver

[Former Member]

I have solved this issue. Then Oracle checkpoint not complete.

thanks,

xwu.

[Former Member]

I am only assuming things, but it might be worth to look closely if you were experiencing an ORA- error during the execution. This could have caused a rollback and thus closed the cursor. Please check the job log, the workprocess trace (dev_wX file) and the system log SM21 and ST22 as well.

Besides that check the oracle alertlog and the usertrace destination.

Best regards, Michael