IBM Support

SQL-42000 is reported when applying the schema to a new SQL Server 2005 database

Troubleshooting


Problem

When trying to apply a schema to a new Microsoft® SQL Server 2005 database, []DBD::ODBC::st execute failed: [Microsoft][SQL Native Client][SQL Server]Unclosed quotation mark after the character string '1.00'. (SQL-42000)[], is reported with several like errors in IBM® Rational® Build Forge®.

Symptom

The Build Forge engine throws an error when trying to create the table bf_levels during the initial schema application for a new database.

The output is similar to:

C:\Program Files\BuildForge>buildforge.exe
Thu Jan 24 12:27:34 2008 Database: 178568: Doesn't have table bf_sysconfig
Thu Jan 24 12:27:34 2008 Database: 178568: Applying Schema
Thu Jan 24 12:27:36 2008 Database: 178568: Creating table bf_store
Thu Jan 24 12:27:36 2008 Database: 178568: Creating table bf_uid
Thu Jan 24 12:27:36 2008 Database: 178568: Creating table bf_messages
Thu Jan 24 12:27:36 2008 Database: 178568: Creating table bf_notifications
Thu Jan 24 12:27:36 2008 Database: 178568: Creating table bf_sysconfig
Thu Jan 24 12:27:37 2008 Database: 178568: Creating table bf_access
Thu Jan 24 12:27:37 2008 Database: 178568: Creating table bf_accesscache
Thu Jan 24 12:27:37 2008 Database: 178568: Creating table bf_jobcount
Thu Jan 24 12:27:37 2008 Database: 178568: Creating table bf_builds
Thu Jan 24 12:27:37 2008 Database: 178568: Creating table bf_scopes
Thu Jan 24 12:27:37 2008 Database: 178568: Creating table bf_classes
Thu Jan 24 12:27:37 2008 Database: 178568: Creating table bf_env
Thu Jan 24 12:27:37 2008 Database: 178568: Creating table bf_levels
Argument "50.00\0" isn't numeric in subtraction (-) at /PerlApp/BuildForge/Utilities/UID.pm line 105.
DBD::ODBC::st execute failed: [Microsoft][SQL Native Client][SQL Server]Unclosed quotation mark after the character string '1.00'. (SQL-42000)
[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near '1.00'. (SQL-42000)
[Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at /PerlApp/BuildForge/DB/Handle.pm line 211.

178568 /PerlApp/BuildForge/DB/Handle.pm(BuildForge::DB::Handle):827

178568 /PerlApp/BuildForge/DB/Schema/SchemaTools.pm(BuildForge::DB::Schema::SchemaTools):153

178568 /PerlApp/BuildForge/DB/Schema/SchemaTools.pm(BuildForge::DB::Schema::SchemaTools):41
Thu Jan 24 12:27:37 2008 Database: 178568: Trying to call [execute] on a non-existant database handle
Unable to execute schema statement INSERT INTO bf_levels (bf_level,bf_name,bf_def,bf_dn,bf_lvl) VALUES (1,'Guest','Y','1.00 generic1',5).
Thu Jan 24 12:27:37 2008 Database: 178568: Error creating table bf_levels: [Microsoft][SQL Native Client][SQL Server]Unclosed quotation mark after the character string '1.00'. (SQL-42000)
[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near '1.00'. (SQL-42000)
[Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1)
Thu Jan 24 12:27:37 2008 BuildForge: 178568: Unable to apply Schema. Exiting

[{"Product":{"code":"SSB2MV","label":"Rational Build Forge"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database: SQL Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.0.2;7.0.1;7.0","Edition":"Enterprise;Standard;Express","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

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.

Document Information

Modified date:
16 June 2018

UID

swg21294041

Page Feedback