Symptom
- Installation of ASE Cockpit is successful
- ASE Cockpit monitor overview gives error "JZ0R2 No result set for this query"
- ASE Cockpit repository.log shows many errors like :
SQL Error: 0, SQLState: null
Couldn't perform the operation prepareStatement: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).
SQL Error: 0, SQLState: null
Couldn't perform the operation getAutoCommit: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).
Fail to find objects by criterions
followed by java exceptions :
org.hibernate.exception.GenericJDBCException: could not inspect JDBC autocommit mode
- there is no error reported in the ASE log
- a sybdiag was also reporting error JZ0R2 on various reports:
Collecting data for "Server License" (ase_license) ...
Failed data collection for "Server License" (ase_license).
14005 - Executing Query Error: Error occurred while executing the SQL query statement "select * from master..monLicense". The message returned was "JZ0R2: No result set for this query."
- A simple isql command like
1> select * from master..monLicense
2> go
would not return anything, including the column headers.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
JZ0R2, resultset, no resultset, 14005, SQL Error: 0 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.