Engine Unable to Access e-Work Tables

Metastorm

The information in this article applies to product: e-Work 5.4 6.x

Issue

• When trying to start the e-Work Engine, one of the following errors is written to the Windows Application Event log:

  • Version 5.4:
    Source: e-Work Engine
    Category: eServerConfigurer
    Description: eServer table empty - e-work Engine initialisation cannot continue
  • Version 6.x:
    Source: e-Work Engine
    Category: eDatabase
    Description: Unable to open table while doing initialisation. Table name: eServer. Additional info: Source=Microsoft OLE DB Provider for SQL Server - Error=Invalid object name 'eServer'.

Resolution

• This error indicates that the Engine cannot access the eServer table. Verify table ownership of the e-Work tables, and ensure that the database user for the Engine, specified in the connection string(s) in the registry, has access to these tables.

• Check the following registry entries (1 for version 5.4 and 2 for 6.x) to verify the user:

  5.4: HKEY\_LOCAL\_MACHINE\\SOFTWARE\\Metastorm\\e-work\\Engine\\Database\\Connection
  The value for this (configured as the system DSN) should be in this format:
  ODBC;DSN=e-work;UID=ework;PWD=ework;

  6.x: HKEY\_LOCAL\_MACHINE\\SOFTWARE\\Metastorm\\e-work\\Engine\\Database\\Conection
  The value for this (configured as the system DSN) should be in this format:
  ODBC;DSN=e-work;UID=ework;PWD=ework;

  If Oracle is used:
  HKEY\_LOCAL\_MACHINE\\SOFTWARE\\Metastorm\\e-work\\Engine\\Database Connectors\\Oracle DBC\\Connection
  The value for this should be in this format:
  Provider=OraOLEDB.Oracle.1;Data Source=vmOracle;User Id=ework;Password=ework;FetchSize=100;CacheType=Memory;PLSQLRSet=1

  If SQL Server is used:
  HKEY\_LOCAL\_MACHINE\\SOFTWARE\\Metastorm\\e-work\\Engine\\Database Connectors\\SQL Server DBC\\Connection
  The value for this should be in this format:
  Provider=SQLOLEDB;Data Source= dbServerName;Initial Catalog=e-work;User ID=ework;Password=ework;