OraFAQ Forum: Server Administration » could not roll back the transaction

Home » RDBMS Server » Server Administration » could not roll back the transaction

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

could not roll back the transaction [message #211476]

Thu, 28 December 2006 21:07

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all,

when i am working with the application, suddenly the page crash occured, in the application logs i found the following error.

can u pls suggest me how to handle the below error.

Thanks

22:07:03 [ERROR ] java.sql.SQLException: Closed Connection: there was an error on the database could not rollback the transaction

22:07:03 [ERROR ] java.sql.SQLException: ORA-00600: internal error code, arguments: [qerixGetKey:optdesc], [], [], [], [], [], [], []

SQL:SELECT  LKP_STATIC_DATA_DETAIL.CODE

FROM            

        LKP_STATIC_DATA_DETAIL

WHERE                  (LKP_STATIC_DATA_DETAIL.LIST_NAME = N'NOTIFICATION_TEMPLATE_UPGRA'

                        AND LKP_STATIC_DATA_DETAIL.IS_ACTIVE = N'-1'

                        AND UPPER(LKP_STATIC_DATA_DETAIL.LANGUAGE_CODE) = N'EN'

                        AND LKP_STATIC_DATA_DETAIL.CONTEXT_CODE = N'DEFAULT')

ORDER BY        LKP_STATIC_DATA_DETAIL.DISPLAY_SEQUENCE ASC

)

Report message to a moderator