Updating to 9.1.3.x - Transactional Support in Engine

Ryan Saul

Hi,

 

Thought it would be useful to share some info/potential issues when updating to Metastorm 9.1.3.x

(Caused me a week of troubleshooting and fixing)

 

A new feature is: Transactional Support in Engine

 

This can break multiple items in your process that would have worked previously AFTER your next deployment on the new version.

 

1) Any set commands run within your insert or select statements will no longer work.

eg. "SET CONCAT_NULL_YIELDS_NULL ON; select col1+col2 from table"

 

2) SQL and Oracle connection strings called from external libraries; such as dll's require - 'enlist=false'

Without this in the connection string, you may see errors such as:

• Communication with the underlying transaction manager has failed. The MSDTC transaction manager was unable to push the transaction to the destination transaction manager due to communication problems.