Database Related Errors

Database Connectivity Issues

  • In case of database connectivity issues, perform the following checks.
  • Verify whether the database server is up and if network connectivity is available. 
  • Verify if the required database port is open for proper database communication. 
  • Verify if the connection string is in the proper format.
  • Server name, database, and password must be entered correctly.
  • In case of the Oracle database, DLL versions as listed in Client Download Software document need to be downloaded on the web server. The download path should be readily available before initiating product installation.
  • Verify if the Database user account is locked. If it is locked, unlock it.
  • Validate the expiry date of the password of the Database user account.
  • In case of Oracle DB, listener service must be running.
  •  In case of connecting to Oracle DB using the execute DB query component, in the robot machines, an error message System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. may be observed. To resolve this error, ensure that the machine on which the robot is running has the compatible oracle client installed as per the oracle DB version along with the read and execute permission.
     

 

Errors while searching for a user in the Database Deployment Utility

  • In case of custom authentication, ensure that while “building” the custom authentication DLL in Visual Studio Editor, “any CPU” option is selected.
  • If XML files are used for the database deployment, the file name and path that are mentioned must be the same, as entered in the custom authentication project.
  • In case of LDAP authentication, validate the availability of the domain connection.

SQL Server Error

In case of the errors: Unable to change the default schema of the user to “usch_aese” or tables are not getting created under the schema “usch_aese”, perform the following checks.

  • The user is not mapped to a database with a different schema, other than “usch_aese”.
  • SQL server has permissions to a particular group of users under which the logging-in user is also available.
     

Other Database Errors

If there are multiple instances of SQL servers installed on the database server machine, each instance must have a distinct port assigned to it.