Database Error Codes and Troubleshooting

Database Error Codes and Troubleshooting

The following table provides common database errors and corresponding troubleshooting tips.

Error ID

 

Error

Root cause and troubleshooting steps

1000

ERROR_WHILE_GETTING_CONNECTION

Root cause: Connection could not be established with the MSSQL database.


Troubleshooting: Refer this page.

1001

ENCRYPTION_NOT_SUPPORTED

Root cause: Master Key is supported only for versions greater than 2000 in MSSQL

 

Troubleshooting: Upgrade MSSQL to version higher than 2000.

1002

MASTER_KEY_NOT_CREATED

Root cause: The Master Key is not created.
Note: Only users with administrator privileges can create the Master key.

 

Troubleshooting: Provide the Master Key password which matches your MSSQL installed machine's Password Policy.

Check if the user has the "dbcreator" role.

1003

CREATE_MASTER_KEY_FAILED

Root cause: Error when creating the Master key. Some causes for this could be the specified master key may not satisfy the windows password policy for the database server or the database access permission for the specific user does not have permission to create a database.
Note: Users must have administrator privileges to create Master Key.

 

Troubleshooting: Provide the Master Key password which matches your MSSQL installed machine's Password Policy.

Check if the user has the "dbcreator" role.

1004

OPEN_MASTER_KEY_FAILED

Root cause: The Master Key failed to open. Please specify the correct Master Key password that was used to configure the database.

 

Troubleshooting:

The Master Key password should be the same as the one which was given during the database creation. If you have forgotten the Master Key password, then refer the altering master key query.

1005

ASSOCIATE_MASTER_KEY_WITH_SERVICE_MASTER_KEY_FAILED

Contact support

1006

CERFICATE_NOT_CREATED

Root cause: Certificate is not created in the database.

 

Troubleshooting: Contact support.

1007

CREATE_CERTIFICATE_FAILED

Root cause: Certificate already exists or open Master Key command should have failed.

 

Troubleshooting: Contact support.

1008

OPEN_CERTIFICATE_FAILED

Root cause: Certificate doesn't exist or Master Key is closed.

Troubleshooting: Contact support.

1009

SYMMETRIC_KEY_NOT_CREATED

Root cause: Symmetric key is not created in the database.

 

Troubleshooting: Contact support.

1010

CREATE_SYMMETRIC_KEY_FAILED

Root cause: Symmetric key already exists or open Master key command should have failed.

 

Troubleshooting: Contact support.

1011

OPEN_SYMMETRIC_KEY_FAILED

Root cause: Symmetric key cannot be opened since the Master key is closed.

 

Troubleshooting: Contact support.

1012

CLOSE_SYMMETRIC_KEY_FAILED

Root cause: Symmetric key cannot be closed since the Master key cannot be closed.

 

Troubleshooting: Contact support.

1013

CREATE_EXTENSIONS_FAILED

Contact support

1014

ERROR_WHILE_RETRIEVING_COLLATION

Contact Support

1015

ERROR_WHILE_RETRIEVING_DATABASE_METADATA

Contact Support

1016

ERROR_WHILE_CREATING_STATEMENT

Contact Support

 


    • Related Articles

    • Troubleshooting Mail Server Settings

      Troubleshooting Mail fetching problems After you configure the mail server, test the settings by fetching a sample mail. To do so, click the Fetch a sample mail button. If the settings are configured right and the connection is successful, the oldest ...
    • Configuring Database

      In GUI Setups Configuring Database Server SupportCenter Plus is bundled with PostgreSQL database. You can also configure the application to set up MS SQL database. PostgreSQL 1. Go to <SupportCenter_Plus_Home>\bin directory in the command prompt and ...
    • Mail Fetching Troubleshooting

        1. Unable to fetch mails into SupportCenter Plus as the ports are being blocked by Firewall/Antivirus. 2. Is it important to configure an SSL Certificate to use POPS/IMAPS for fetching mails? 3. Authentication and Configuration Errors: Settings ...
    • Database Migration

      Migration between Postgres and Microsoft SQL SupportCenter Plus comes bundled with Postgres. From build 14000, the database files generated from the scheduled backup are no longer cross-compatible. However, you can migrate between Postgres and ...
    • Database Migration Tool

      You can use this tool to migrate data between two databases (Postgres to MSSQL and vice versa) as well as between operating systems (Linux to Windows and vice versa). You can perform the following data migration with this tool: Server migration ...