Audit Snapshot Fails in 360Eyes — Unsupported DB URL (jdbc:sqlanywhere)

Audit Snapshot Fails in 360Eyes — Unsupported DB URL (jdbc:sqlanywhere)

Symptoms

When running the 360Eyes – Audit job, the job fails during DO_SPECIFIC_JOB_ACTIONS and the log displays:

Could not generate snapshot : Current DB URL (jdbc:sqlanywhere:DSN=BIA_Audit_PROD) is not supported.


Cause

The Audit data source is configured with a SQL Anywhere–specific JDBC URL (jdbc:sqlanywhere:…). 360Eyes does not support that driver for snapshot generation. 360Eyes supports SAP’s jConnect JDBC driver (generic for SQL Anywhere and ASE) using jdbc:sybase:Tds.

Resolution

  1. Add the jConnect driver to Tomcat.
    Copy the jConnect JAR into:

    C:\Program Files (x86)\360Suite\360.suiteX.X\tomcat\webapps\360.suite\WEB-INF\lib

    Restart Tomcat after adding the JAR.

  2. Use the jConnect JDBC URL format.

    jdbc:sybase:Tds:<server>:<port>?ServiceName=<AuditDB>&user=<user>&password=<password>

    Replace any jdbc:sqlanywhere: URL.

  3. Save and test the connection.
    Open the Audit data source in 360Eyes/360Suite → paste the new URL → provide credentials → Test ConnectionSave.

  4. Run the Audit job.
    Confirm the snapshot step completes without the “not supported” error.


Environment

  • Job: Audit (360Eyes)
  • Previously observed URL: jdbc:sqlanywhere:DSN=BIA_Audit_PROD (unsupported)

  • Supported: SAP jConnect / jdbc:sybase:Tds:<server>:<port>