SAP Knowledge Base Article - Preview

3241137 - SAP ASE is reporting "Failed to execute COMMIT TRANSACTION, because this is a read-only connection" - SAP ASE

Symptom

After upgrade from ASE 16 SP03 PL09 to ASE 16 SP04 PL01.

Some processes are reporting the foillowinbg error. 

ERROR 1:
Caused by: java.sql.SQLException: Failed to execute COMMIT TRANSACTION, because this is a read-only connection. Read-only connections can only execute SELECT statements. Use 'set readonly off' to execute COMMIT TRANSACTION.

ERROR 2:

com.sybase.jdbc3.jdbc.SybSQLException: Failed to execute ROLLBACK TRANSACTION, because this is a read-only connection. Read-only connections can only execute SELECT statements. Use 'set readonly off' to execute ROLLBACK TRANSACTION. 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL01

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Failed to execute COMMIT TRANSACTION, failed to execute ROLLBACK TRANSACTION, read-only connection, set readonly off , 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.