SQL Anywhere: JZ0C0: Connection already closed

SQL Anywhere: JZ0C0: Connection already closed

Symptoms

When running Web Intelligence (WebI) jobs in SAP BusinessObjects connected to a SQL Anywhere (Sybase) audit database, the job may fail with the following error:

JZ0C0: Connection already closed.

This results in WebI job crashes and interruptions in auditing or reporting processes.


Cause

This issue occurs because the Sybase JDBC driver automatically closes idle connections.
If a WebI job or auditing service leaves the JDBC connection inactive for too long, the driver terminates the connection, resulting in the "Connection already closed" error.


Resolution

To prevent the JDBC connection from closing due to inactivity, add the parameter &Idle=0 to the JDBC connection URL.
This disables the client-side idle timeout, ensuring the connection stays open.

Example updated JDBC connection string

jdbc:sybase:Tds:apollon:2638?ServiceName=BI4_Audit&Idle=0

Steps to Apply

  1. Log in to the SAP BusinessObjects Central Management Console (CMC).

  2. Navigate to Auditing → Configure Audit Database.

  3. Edit the JDBC connection URL by adding &Idle=0 at the end.

  4. Save the changes.

  5. Restart the required services if needed.


Environment

  • SAP BusinessObjects BI Platform using SQL Anywhere (Sybase) for the Audit database

    • Related Articles

    • How to install 360Eyes on SQL Server on Azure

      Symptom Installing 360Eyes using SQL Server on Azure. Environment 360Eyes SAP BusinessObjects Enterprise XI 3.1 SAP BusinessObjects Business Intelligence 4.0 SAP BusinessObjects Business Intelligence 4.1 SAP BusinessObjects Business Intelligence 4.2 ...

    • How to configure SQL Server with Windows Authentication

      Symptom When trying to configure a SQL Server database using Windows Authentication as part of the 360eyes database configuration, the following error is returned: "The driver is not configured for integrated authentication". Environment 360Eyes ...

    • Wrong collation for 360Eyes database on SQL Server

      Error Updating SQL Server Password in 360Eyes – Collation Issue Description After updating the SQL Server account password used in 360Eyes, attempts to update the password in the Eyes Configuration (Admin Page) result in a runtime error: [ERROR] ...

    • How to improve performance with 'Last Snapshot (xxx)' filters on 360Eyes reports

      Symptom How to improve performance on 'Last Snapshot (xxx)' filters in 360eyes reports? Environment 360Eyes SAP BusinessObjects Enterprise XI 3.1 SAP BusinessObjects Business Intelligence 4.0 SAP BusinessObjects Business Intelligence 4.1 SAP ...

    • How to expand Dataprovider SQL Query column in 360Eyes database

      Symptom When running 360Eyes Impact Analysis Reports (such as Report 52), users observe that the SQL query stored in the 360eyes_REPORTS.unx / Eye Document / Dataprovider / Dataprovider Sql Queryfield is incomplete, partial or truncated. This often ...