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 Connection → Save.

  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>

    • Related Articles

    • "DB003: No suitable driver found" when configuring 360Suite databases

      Symptoms When configuring 360Suite main database. When configuring 360Eyes database. When trying to create a 360Cast SQL source. When trying to create a 360View SQL Query. In any of these situations, when the database type was selected, the following ...

    • Error : "java.lang.OutOfMemoryError: GC overhead limit exceeded"

      Symptom When running 360Eyes jobs, the following error may be encountered: "java.lang.OutOfMemoryError: GC overhead limit exceeded"  2014-11-14 15:05:00 +0100 INFO Creating hash for CUID-ShortName/path universe link: done 2014-11-14 13:52:18 -0500 ...

    • FAQ: Migrate to the new 360Eyes for SAP BusinessObjects Audit Job

      Context Version 2025.2 introduced changes to the behavior of 360Eyes Jobs. Previously, we had a list of jobs consisting of: - CMS - Webi - Crystal - Universe - IA & Other Each job had an option to extract audit information. This could sometimes lead ...

    • JDBC drivers matrix

      DataBase Management System (DBMS) JDBC driver names PostgreSQL postgresql-xx.x.xx.jar Oracle ojdbcX.jar MySQL mysql-connector-java-x.x.xx.jar Microsoft SQL Server mssql-jdbc-x.x.xx.jar SAP Hana ngdbc.jar SAP Sybase / SQL Anywhere jconn4.jar ...

    • 360Eyes evolution: from "standalone" to 360Suite web application

      Context On the meta-level, 360Eyes is part of 360Suite, a suite a modules working with BusinessObjects environments to help BI administrators with their day-to-day activities. On a practical level, the 360Eyes module itself has known changes over ...