Database Errors

Database Errors
Error Code	Error Description	Error Resolution
SQL-8201	Database error. SQL state <Parameter name='DBSTATE'>. Database specific error code (if any) was <Parameter name='DBERRORCODE'>. Database error message (if any) was: <Parameter name='EXCEPTIONMESSAGE'>.
SQL-8202	Failed while executing SQL statement. SQL state <Parameter name='DBSTATE'>. Database specific error code (if any) was <Parameter name='DBERRORCODE'>. Database error message (if any) was: <Parameter name='EXCEPTIONMESSAGE'>.	If two users send the web service query requests, and validations were set `ON` for one of the users and `OFF` for another user, change the web service request to use only the user with validations set to `OFF`. You may not get this error.
SQL-8203	Null connection returned by connection pool. Incorrect installation or application has run out of resources.
SQL-8208	No tablespace name specified in configuration file.
SQL-8209	Specified tablespace <Parameter name='VALUE'> does not exist. Update Configuration.
SQL-8210	Unsupported option <Parameter name='VALUE'> for 'Create Tablespace'.
SQL-8213	No connection pool defined to access database; application incorrectly installed.
SQL-8215	Unsupported <Parameter name='VALUE'> database.	Check the supported database.
SQL-8216	Database host not provided.	Log in to the Configurator. Search for the `Database Host` property. Enter the IP address or host name of the server where database is installed.
SQL-8217	Database name not provided.	Enter the database user details for the following properties. The database values are based on the selected database in the Settings > Database option in the Configurator. The available database options are Oracle and SQL Server. `Database Name` `Database User Name` `Database Password`
SQL-8218	Database user not provided.
SQL-8219	Database password not provided.
SQL-8220	Database port not provided.	Log in to Configurator. Search for the `Database Port` property. Specify the value of the selected database. For Oracle, the default database port is 1521 and for SQL Server, the default database port is 1433. You can change the port value, if required
SQL-8221	Error connecting database with the <Parameter name='HOST'> host, <Parameter name='DATABASE'> database, <Parameter name='USER'> user, and <Parameter name='PORT'> port.	NA

SQL-8201

Database error. SQL state <Parameter name='DBSTATE'>. Database specific error code (if any) was <Parameter name='DBERRORCODE'>. Database error message (if any) was: <Parameter name='EXCEPTIONMESSAGE'>.

SQL-8202

Failed while executing SQL statement. SQL state <Parameter name='DBSTATE'>. Database specific error code (if any) was <Parameter name='DBERRORCODE'>. Database error message (if any) was: <Parameter name='EXCEPTIONMESSAGE'>.

If two users send the web service query requests, and validations were set ON for one of the users and OFF for another user, change the web service request to use only the user with validations set to OFF. You may not get this error.

SQL-8203

Null connection returned by connection pool. Incorrect installation or application has run out of resources.

SQL-8208

No tablespace name specified in configuration file.

SQL-8209

Specified tablespace <Parameter name='VALUE'> does not exist. Update Configuration.

SQL-8210

Unsupported option <Parameter name='VALUE'> for 'Create Tablespace'.

SQL-8213

No connection pool defined to access database; application incorrectly installed.

SQL-8215

Unsupported <Parameter name='VALUE'> database.

Check the supported database.

SQL-8216

Database host not provided.

Log in to the Configurator.
Search for the Database Host property.
Enter the IP address or host name of the server where database is installed.

SQL-8217

Database name not provided.

Enter the database user details for the following properties. The database values are based on the selected database in the Settings > Database option in the Configurator. The available database options are Oracle and SQL Server.

Database Name
Database User Name
Database Password

SQL-8218

Database user not provided.

SQL-8219

Database password not provided.

SQL-8220

Database port not provided.

Log in to Configurator.
Search for the Database Port property.
Specify the value of the selected database.
For Oracle, the default database port is 1521 and for SQL Server, the default database port is 1433.
You can change the port value, if required

SQL-8221

Error connecting database with the <Parameter name='HOST'> host, <Parameter name='DATABASE'> database, <Parameter name='USER'> user, and <Parameter name='PORT'> port.

NA