Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #1 

Engine Unable to Access e-Work Tables

Last edited: 04 Feb 2005


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 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;


Keywords: kb493


__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!