Database Connection Errors

Before going through this section, see Prerequisites for Debugging Exceptions.

1. While opening the Central Configuration or while opening the Farm Configuration Wizard, the following database connection error message appears on Welcome to the AVEVA Work Tasks Configuration Wizard.

• A valid connection to AVEVA Work Tasks database could not be established. Would you like to change the Database User Settings?

• The following error message appears in the Central Configuration.

  Cannot proceed further. A valid connection to the AVEVA Work Tasks Farm could not be established. Check the Connection settings and also MSDTC settings.

  You will also get the message in the WTLogger Console:

  Probable Cause

Database User's credentials are changed:

• From Active Directory

• From SQL Database instance

Solution

From Active Directory

1. On the Windows Start menu, point to Programs, point to AVEVA, and then click Farm Configuration Wizard.

   The AVEVA Work Tasks Farm Configuration Wizard appears.

2. Click Next.

   The Edit AVEVA Work Tasks Farm settings screen appears.

3. Select Database User Settings.

4. Click Next.

   The Database User Settings screen appears.

5. Enter the updated User Name, Password, and Domain.

6. Click OK. The following confirmation message appears:

   Make sure that the login used for connecting to database has SELECT, INSERT, UPDATE, DELETE permissions on all tables and Execute permission on the Stored Procedures.

7. Click OK. A message indicating successful updates of database user settings appears.

8. Click OK.

From SQL Database instance

9. On the Windows Start menu, point to Programs, point to AVEVA, and then click Farm Configuration Wizard.

   The AVEVA Work Tasks Farm Configuration Wizard appears.

10. Click Next.

    The Edit AVEVA Work Tasks Farm settings screen appears.

11. Click Database Settings.

    The Connect to existing database screen appears.

12. From the Connection String option, modify the User Id and Password for connecting to the database.

13. Click Test Connection. On success, the Test Connection Succeeded message appears.

14. Click OK.

15. Click Next. The user credentials are updated.

2. User is getting the following database connection error message while creating Repository Datasource or while opening an Enterprise Console.

Error while creating Repository Datasource in the Central Configuration:

Invalid connection string. Please check MSDTC settings and check if Database User Settings are valid, if you are using windows authentication. Check AVEVA Work Tasks Logger Console for more details.

Error while opening an Enterprise Console. This page gets hanged and displays the following message in the Logger Console.

Probable Cause

Database User Settings are not set and Windows authentication is used in the Repository Datasource.

Solution

• Either use Windows authentication for the Repository Datasource

• SQL authentication for the Repository Datasource

Steps for Windows authentication

16. On the Windows Start menu, point to Programs, point to AVEVA, and then click Farm Configuration Wizard.

    The AVEVA Work Tasks Farm Configuration Wizard appears.

17. Click Next.

    The Edit AVEVA Work Tasks Farm settings screen appears.

18. Select Database User Settings.

19. Click Next.

    The Database User Settings screen appears.

20. Enter the updated User Name, Password, and Domain.

21. Enter Database User credentials.

22. Click OK.

Steps for SQL authentication

23. On the Windows Start menu, point to Programs, point to AVEVA, and then click AVEVA Work Tasks Central Configuration.

    The Central Configuration page appears.

24. Click Datasource Settings. The Datasource List appears.

25. Click required Datasource from Datasource column.

26. Make changes to user SQL authentication. Select SQL from Authentication Type drop down list.

27. Click Test Connection, and then click OK.