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.
  1. Log in to Configurator.
  2. Search for the Database Host property.
  3. 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 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.
  1. Log in to Configurator.
  2. Search for the Database Port property.
  3. 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.