Troubleshooting

Test connection failed

  • Verify the database connection information.

  • Verify the keytab file.

  • Verify the jaws.properties uses the correct SQL Server URL.

Exception or error after editing database connection using the Configuration Tool and clicking OK

Use the OK button in the Edit Database Connection to test the connection a few times. As long as the final attempt to connect is successful, you can ignore these exceptions.

Automic Automation Intelligence start up exception in server.log

  1. Bring up the Configuration Tool

  2. Select the Params tab

  3. Change the Show drop-down to hidden named parameters

  4. Select the Show hidden param button

  5. Enter featureToggle.subscriptionService in the box.

  6. Select OK

  7. Change the Value column to false

  8. Select Apply

Automic Automation Intelligence start up exception in multiple logs

The error messages are as below:

  • hibernate.log

    WARN                                               [BasicResourcePool]
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@219b47d4
-- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: : java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

  • server.log

    ERROR [org.jboss.stdio.AbstractLoggingWriter] Exception in thread "Thread-95" org.hibernate.exception.GenericJDBCException: Cannot open connection

  • jaws.log

    WARN [DataManagerModule] Error getting session for JAWS DB: com.termalabs.common.JawsException: Error while getting session

    This means the native SPPI library is not found. Please refer to the Windows Specific Installation section.

Automic Automation Intelligence cannot retrieve data

  • Use the Configuration Tool to test the connection.

  • Verify the user has the correct Default schema on the SQL Server.

  • Verify the user does not have sysadmin role on the SQL Server.

The password of the Automic Automation Intelligence database user has expired or changed

  1. Regenerate the keytab file using the current password.

  2. Replace the old keytab file with the new one.

  3. Use the Configuration Tool to test the connection.

  4. Restart the Automic Automation Intelligence server.

Upgrade Failed with the Following Error

Unable to connect: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://SERVER_NAME:PORT;databaseName=DB_NAME

Open the jaws.properties file and make sure the following line is used:

dbms.mssql.url=jdbc:jtds:sqlserver://