Skip to Content
avatar image
Former Member

Database selection with invalid cursor !

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    May 15, 2009 at 12:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 27, 2009 at 08:30 AM

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

    thanks,

    xwu.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 16, 2009 at 11:51 AM

    Hi,

    how did you solve the problem?

    kind regards

    Oliver

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 17, 2009 at 08:52 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded