Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'tran'."
gets generated when executing instjdbc.sql
Problem Description

The following errors get generated when executing the instjdbc.sql script in a MS SQL Server 2008 - 2008 R2 - 2012​:

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'tran'.

Cause

This error occurs due to the following command:

dump tran master with no_log

The reserved word "DUMP" was used in MS SQL Server 2005, but is deprecated from MS SQL Server 2008 and replaced by "BACKUP"

Solution

​You can safely ignore these errors as long as the following "Extended Stored Procedures" are present in Master schema in Databases\master\Programmability.

'xp_jdbc_close'

'xp_jdbc_close2'

'xp_jdbc_start'

'xp_jdbc_start2'

'xp_jdbc_end'

'xp_jdbc_end2'

'xp_jdbc_prepare'

'xp_jdbc_prepare2'

'xp_jdbc_commit'

'xp_jdbc_commit2'

'xp_jdbc_rollback'

'xp_jdbc_rollback2'

'xp_jdbc_forget'

'xp_jdbc_forget2'

'xp_jdbc_recover'

'xp_jdbc_recover2'

Last message should be:

creating JDBC XA procedures
instxa.sql completed successfully.

 

More Information

​PROGRESS DATADIRECT has created the bug DD00046338 for the same:

With Connect for JDBC, when executing the instjdbc.sql script on SQL Server 2008 to configure XA, the above error is returned from the DUMP TRAN command.
Instjdbc.sql script, which is included with connect for JDBC driver for configuring XA contains the "dump tran master with no_log" command.
SQL Server 2008 does not support the "dump tran" command anymore, so the script gives an invalid syntax error on all of the dump tran commands.

Reproduced the issue with build 40.00.0013.
Filed defect DD00046338.

Applies To
Product: Data Quality
Problem Type:
User Type: Administrator
Project Phase:
Product Version: Data Quality 9.5.1
Database: Microsoft SQL Server 2008
Operating System: Windows
Other Software:

Reference
Attachments
Last Modified Date:7/12/2013 2:21 AMID:150173
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)