Incorrect syntax error near ‘50003’ or ‘50004’ or ‘50005’ and returns NULL as row_id. (Doc ID 2283365.1)

Last updated on JULY 04, 2017

Applies to:

Siebel CRM - Version 16.13 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.13 [IP2016] version, Upgrade

When attempting to run upgrep (upgrep_dev_822) the following error occurs.

ERROR
-----------------------
DBCLog DBCLogError 1 0000000259561118:0 2017-07-01 00:48:08 [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '50003'.
UpgradeLog UpgradeError 1 0000000259561118:0 2017-07-01 00:48:08 [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '50003'.
SQLError Statement 0 0000000259561118:0 2017-07-01 00:48:08 SQL Statement:
 exec tmp_daily_end_dt
DBCLog DBCLogError 1 0000000259561118:0 2017-07-01 00:48:08 [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '50004'.
UpgradeLog UpgradeError 1 0000000259561118:0 2017-07-01 00:48:08 [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '50004'.
SQLError Statement 0 0000000259561118:0 2017-07-01 00:48:08 SQL Statement:
 exec tmp_daily_end_dt
DBCLog DBCLogError 1 0000000259561118:0 2017-07-01 00:48:08 [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '50005'.
UpgradeLog UpgradeError 1 0000000259561118:0 2017-07-01 00:48:08 [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '50005'.
SQLError Statement 0 0000000259561118:0 2017-07-01 00:48:08 SQL Statement:
 exec tmp_daily_end_dt
DBCLog DBCLogError 1 0000000259561118:0 2017-07-01 00:48:08 [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'ROW_ID', table 'SiebelDB.dbo.S_CAL_REPT_EVT'; column does not allow nulls. INSERT fails.
UpgradeLog UpgradeError 1 0000000259561118:0 2017-07-01 00:48:08 [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'ROW_ID', table 'SiebelDB.dbo.S_CAL_REPT_EVT'; column does not allow nulls. INSERT fails.
SQLError Statement 0 0000000259561118:0 2017-07-01 00:48:08 SQL Statement:
 exec tmp_daily_end_dt
DBCLog DBCLogError 1 0000000259561118:0 2017-07-01 00:48:08 [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Installed Siebel Innovation Pack 2016 (version 16.0) for upgrade.
2. Pointing the application to Siebel 8.2.2.1 DB
3. Run the upgrade wizard and select upgrep.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, not able to continue the upgrep process.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms