DDLIMP utility is failing while running the DDL_OLTP.ctl script for Siebel
971430Nov 8 2012 — edited Nov 8 2012DDLIMP utility is failing while running the DDL_OLTP.ctl script for Siebel source on DB2.
Below is the the log details:
2021 2012-11-08 03:23:46 2012-11-08 03:25:56 -0700 0000002a 001 003f 0001 09 ddlimp 604 736 C:\OBIA\Upgrade\CTLFiles\DDL_.log
ContextInit ContextInit 0 0 2012-11-08 03:23:46 Message Facility failed to init. Siebel Root: C:\DAC\client\utilities
Trace Trace 3 0 2012-11-08 03:23:46 Siebel Enterprise Applications ODBC DDL Import Utility, Version 7.7 [18030] ENU
Trace Trace 3 0 2012-11-08 03:23:46 Copyright (c) 2001 Siebel Systems, Inc. All rights reserved.
Trace Trace 3 0 2012-11-08 03:23:46
This software is the property of Siebel Systems, Inc., 2207 Bridgepointe Parkway,
San Mateo, CA 94404.
User agrees that any use of this software is governed by: (1) the applicable
user limitations and other terms and conditions of the license agreement which
has been entered into with Siebel Systems or its authorized distributors; and
(2) the proprietary and restricted rights notices included in this software.
WARNING: THIS COMPUTER PROGRAM IS PROTECTED BY U.S. AND INTERNATIONAL LAW.
UNAUTHORIZED REPRODUCTION, DISTRIBUTION OR USE OF THIS PROGRAM, OR ANY PORTION
OF IT, MAY RESULT IN SEVERE CIVIL AND CRIMINAL PENALTIES, AND WILL BE
PROSECUTED TO THE MAXIMUM EXTENT POSSIBLE UNDER THE LAW.
If you have received this software in error, please notify Siebel Systems
immediately at (650) 295-5000.
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:23:46 ddlimp /U SIEBEL /P ***** /C siebel /G SSE_ROLE /F C:\OBIA\Upgrade\CTLFiles\DDL_OLTP.CTL /L C:\OBIA\Upgrade\CTLFiles\DDL_
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:23:46
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:23:46 Connecting to the database...
DBCLog DBCLogError 1 0 2012-11-08 03:23:52 SQL Warning, SQL State 01004, 0, [DataDirect][ODBC DB2 Wire Protocol driver]String data, right truncated.
DBCLog DBCLogError 1 0 2012-11-08 03:23:52 SQL Warning, SQL State , 40042692, CLog DBCLogError 1 0 2012-11-08 03:23:52 SQL Warning, SQL State 01004, 0, [DataDirect][ODBC DB2 Wire Protocol driver]String data, right truncated.
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:23:52 Connected.
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:23:52
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:23:52 Reading tables and indexes from DDL file...
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:23:52 Read 522 tables and 1084 indexes from DDL file...
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:23:52
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:23:52 Reading existing schema...
SARMLog SARMInformation 3 0 2012-11-08 03:23:52 SARM is OFF -change param SARMLevel to enable
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 Read 0 tablespaces, 6137 tables and 24846 indexes from existing schema...
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 Running SQL statements against the database...
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 Merging table S_ETL_COSTLST ...
SQLError Statement 0 0 2012-11-08 03:25:56 SQL Statement:
alter table S_ETL_COSTLST modify
CONFLICT_ID varchar(15)
DBCLog DBCLogError 1 0 2012-11-08 03:25:56 [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]ILLEGAL SYMBOL modify; VALID SYMBOLS ARE table S_ETL_COSTLST. ADD
SQLError Statement 0 0 2012-11-08 03:25:56 SQL Statement:
alter table S_ETL_COSTLST modify
CONFLICT_ID varchar(15)
DBCLog DBCLogError 1 0 2012-11-08 03:25:56 [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]An error occurred during implicit system action type '2'. Information returned for the error includes SQLCODE '-104', SQLSTATE '42601' and message tokens 'modify|table S_ETL_COSTLST|ADD'.
SQLError Statement 0 0 2012-11-08 03:25:56 SQL Statement:
alter table S_ETL_COSTLST modify
CONFLICT_ID default '0'
DBCLog DBCLogError 1 0 2012-11-08 03:25:56 [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]ILLEGAL SYMBOL modify; VALID SYMBOLS ARE table S_ETL_COSTLST. ADD
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 37000: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]ILLEGAL SYMBOL modify; VALID SYMBOLS ARE table S_ETL_COSTLST. ADD
SQLError Statement 0 0 2012-11-08 03:25:56 SQL Statement:
alter table S_ETL_COSTLST modify
CONFLICT_ID default '0'
DBCLog DBCLogError 1 0 2012-11-08 03:25:56 [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]An error occurred during implicit system action type '2'. Information returned for the error includes SQLCODE '-104', SQLSTATE '42601' and message tokens 'modify|table S_ETL_COSTLST|ADD'.
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 56098: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]An error occurred during implicit system action type '2'. Information returned for the error includes SQLCODE '-104', SQLSTATE '42601' and message tokens 'modify|table S_ETL_COSTLST|ADD'.
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 alter table S_ETL_COSTLST modify
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 CONFLICT_ID default '0'
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 ;
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 writeExecDDL error (UTLDbDdlColModify).
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 Error in MainFunction (UTLDbDdlDbMerge).
SQLDBUtilityLog SQLDBUtilityLog 3 0 2012-11-08 03:25:56 Error in Main function...
GenericLog GenericError 1 0 2012-11-08 03:25:56 (logapi.cpp (167) err=1 sys=126) SBL-GEN-00001: (logapi.cpp: 167) error code = 1, system error = 126, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)