Resolution:
Description:
==========
When using SQL Server as a backing store, BusinessEvents(BE) complains that "A table can only have one timestamp column.".

Environment:
==========
TIBCO BusinessEvents Studio
Microsoft SQL Server

Symptoms:
=========
BE complains about the timestamp column.

Cause:
=====
Required property "java.property.jdbc.database.type" is not mentioned correctly in the JDBC configuration (tra) file.


Resolution:
=========
Check for property "java.property.jdbc.database.type" in  be-jdbcdeploy.tra . It should resemble the following without any leading/ending whitespace.

java.property.jdbc.database.type sqlserver

When using SQL Server as a backing store, BusinessEvents(BE) complains that "A table can only have one timestamp column.".