ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

ERRORCODE=-4461, SQLSTATE=42815 when scanning DB2 database with Symantec Data Loss Prevention

book

Article ID: 226071

calendar_today

Updated On:

Products

Data Loss Prevention

Issue/Introduction

When trying to run a discover scan against a DB2 database, the following error appears in the Enforce Console scan results:

Unable to create a database connection: Unable to create connection: jdbc:db2://<path to database server>:<port>/<databasename>;, Reason: [jcc][10165][10036][3.59.81] Invalid database URL syntax: jdbc:db2://<path to database server>:<port>/<databasename>;. ERRORCODE=-4461, SQLSTATE=42815


Checking the ScanDetail-<scan name>.log on the Discover server, the following errors are seen:

Unable to create a database connection: Unable to create connection: jdbc:db2://<path to database server>:<port>/<databasename>;, Reason: [jcc][10165][10036][3.59.81] Invalid database URL syntax: jdbc:db2://<path to database server>:<port>/<databasename>;. ERRORCODE=-4461, SQLSTATE=42815

Unable to create a database connection: Unable to create connection: jdbc:db2://<path to database server>:<port>/<databasename>, Reason: [jcc][t4][2057][11264][3.59.81] The application server rejected establishment of the connection. An attempt was made to access a database, <database name>, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004.

Cause

Credentials specified in the Discover Scan does not have permission to access the database.

Environment

Symantec Data Loss Prevention 15.7

Resolution

Confirm the user specified in the Discover scan credentials has permissions to access the DB2 database.