The information in this article applies to:
Product: Metastorm BPM (e-Work)
Version: 6.x 7.x
Issue
After Metastorm BPM version 7.5 or SR1 for 7.5 is installed, user actions fail with the message Failed to invoke action.
In addition, the following error message may be written to the Windows application event log if SQL Server is used:
'-2147467259' Description: 'Cannot create new connection because in manual or distributed transaction mode.' Source: 'Microsoft OLE DB Provider for SQL Server' SQL State: '' NativeErrorCode: '0'
Client message Failed to obtain list is displayed when trying to retrieve To Do or Watch list.
In addition, the following error message may be written to the Windows application event log:
ErrorCode: '265929' Description: 'No more results.' Source: 'Provider' SQL State: ' ' NativeErrorCode: '265929'
An error message that includes the following is written to the Windows application event log:
Invalid column name 'eEventHandlerFunction'
Resolution
Run the updated stored procedure scripts as specified in the Installation Guide or Release Notes. Stored procedures are located in the Metastorm BPM installation folder. The default location is C:\\Program Files\\Metastorm BPM\\Engine\\Database or C:\\Program Files\\Metastorm e-Work\\Engine\\Database.
The following stored procedure scripts need to be run for MS SQL Server:
eWorkProcedures.sql
ProcessMetadataProcedures.sql (version 7.5 and later)
The following stored procedure scripts need to be run (in order) for Oracle:
eWorkTypes.sql
eWorkPackage.sql
eWorkProcedures.sql
The following apply to version 7.5 and later:
MetastormXMLPackageOracleNine.sql / MetastormXMLPackageOracleTen.sql (depending on whether the version of Oracle is 9i or 10G)
ProcessMetadataPackage.sql
ProcessMetadataProcedures.sql
