webMethods Knowlegebase : dbConfigurator fails to create Archive database component in SQL Server (1728807)

Troubleshooting

Problem

Customer is getting the following when running dbConfigurator to create Archive database in SQL Server:

* Executing script : e:\SoftwareAG81\common\db/scripts/mssql/archive/30/create/mss_arc_c_ddl_tables_indexes.sql

* Executing script : e:\SoftwareAG81\common\db/scripts/mssql/archive/30/create/mss_arc_c_dml.sql

* Executing script : e:\SoftwareAG81\common\db/scripts/mssql/archive/30/create/activation_archive_start_activationarchive.sql

Error: [wm-cjdbc40-0034][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near 'TRY'.

CREATE ARCHIVE [30] FAILED

CDC ERROR [wm-cjdbc40-0034][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near 'TRY'.

Suspending execution...

CDC Error: java.sql.SQLException: [wm-cjdbc40-0034][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near 'TRY'.

------------------------------------------------------------

Summary of installation errors

------------------------------------------------------------

Error in executing file e:\SoftwareAG81\common\db/scripts/mssql/archive/30/create/activation_archive_start_activationarchive.sql

SQL error [wm-cjdbc40-0034][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near 'TRY'.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSVYEV","label":"IBM webMethods Integration"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Database Configuration (WDA)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Win Server 2003 Enterprise Edt"}],"Version":"8.0"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFIWYE","label":"IBM webMethods B2B"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Database Configuration (WDA)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Win Server 2003 Enterprise Edt"}],"Version":"8.0"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSQKXP","label":"IBM webMethods API Management"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Database Configuration (WDA)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Win Server 2003 Enterprise Edt"}],"Version":"8.0"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSQG2X","label":"IBM webMethods Managed File Transfer"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Database Configuration (WDA)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Win Server 2003 Enterprise Edt"}],"Version":"8.0"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM webMethods Integration

Component:
webMethods Database Configuration (WDA)

Software version:
8.0

Operating system(s):
Win Server 2003 Enterprise Edt

Document number:
7193161

Modified date:
20 March 2025

UID

ibm17193161

IBM Support

Tips