Error Codes Returned by Virtual DataPort

The following table lists the error codes returned by the JDBC API of Virtual DataPort.

Error codes returned by the Denodo JDBC API
Error Type Error Codes Meaning
Authentication

20

21

22

23

Range from 600 to 700

The Server cannot authenticate the user.

Usually, it means that the credentials of the user are not valid or that the user does not have enough privileges to connect to the database.

If the user is trying to connect to an LDAP-authenticated database, it could there be an error establishing a connection to the LDAP server.

Parsing

1

19

Range from 1100 to 1199

There was an error parsing the query. It usually means that some clause of the query is misspelled or some parameter is missing.
Connection Range from 10000 to 19999

The Server could not open a connection to a data source.

This happens when the source is down, in case of JDBC data sources, the JDBC driver cannot be loaded, there was an error creating an instance of a Custom wrapper, etc.

Security

11

12

Range from 20000 to 29999

The user does not have enough privileges to execute the request.

For example, when a user with READ privileges tries to execute an INSERT query.

Compute capabilities

2

9

Range from 30000 to 39999

There was an error while creating a view or preparing the execution plan of a query because:

  • The schema of the view or the query cannot be calculated. E.g., the query tries to project a field that does not exist.
  • Or, the restrictions of one or more sources used in the query are not met. E.g., the query does not provide a value for the mandatory fields.
Metadata management

5

8

10

17

18

24

Range from 40000 to 49999

There was an error loading/storing the metadata of an object (data source, wrapper, view, etc.). This may happen when there is already an object with the same name, the name of the new object is not valid, etc.
Execution

4

6

7

13

14

15

16

25

Range from 50000 to 59999

There was an error during the execution of the query.