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

    • 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 ...
    • 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 ...
    • FAQs on Encryption at Rest

      What are symmetric keys? A symmetric key or a secret key is an input to the encryption algorithm that helps produce a different output for different values provided at any given time. It is used for both encryption and decryption of data. What is a ...
    • Manage Two-Factor Authentication Settings

      You can manage trusted browsers, modify mode, view, download, or generate backup codes from the user panel. ​ Click the user icon on the upper-right corner and click Two Factor Authentication.     To modify mode, click Authentication Mode and then ...
    • Two Factor Authentication

      Two-Factor Authentication    Two-factor Authentication (2FA) provides an extra layer of security for your Support Reps by mandating an additional mode of authentication along with regular passwords. Two-Factor Authentication is applicable only for ...