SWT MIGRATION Errors during Upgphys of Siebel IP2015 Upgrade

(Doc ID 2081665.1)

Last updated on JANUARY 11, 2016

Applies to:

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

Symptoms

The SWT Migration step run during UPGPHYS for upgrading to Siebel CRM version 15.4 may end successfully but contains errors inside the swt_mig.log

ERROR 1
-----------------------

015-11-12 15:07:21 : Generating SQL file for Web Template Item and Property Records :
2015-11-12 15:07:21 : Exceed default no of rows. Generating new row ids again
2015-11-12 15:07:21 : Running SQL
2015-11-12 15:07:21 : SELECT s_sequence_s.nextval  FROM dual
2015-11-12 15:07:21 : command :sqlplus -s SIEBEL/SIEBELCRM@CRMDEV @/oraclesiebel/siebsrvr/log/upgphys_dev_811sia/output/SWTMigration/Log/SQL/newrow1.sql
2015-11-12 15:07:21 : command :sqlplus -s SIEBEL/SIEBELCRM@CRMDEV @/oraclesiebel/siebsrvr/log/upgphys_dev_811sia/output/SWTMigration/Log/SQL/NewRow.sql
2015-11-12 15:07:22 : Exceed default no of rows. Generating new row ids again
2015-11-12 15:07:22 : Running SQL
2015-11-12 15:07:22 : SELECT s_sequence_s.nextval  FROM dual
2015-11-12 15:07:22 : command :sqlplus -s SIEBEL/SIEBELCRM@CRMDEV @/oraclesiebel/siebsrvr/log/upgphys_dev_811sia/output/SWTMigration/Log/SQL/newrow1.sql
2015-11-12 15:07:22 : command :sqlplus -s SIEBEL/SIEBELCRM@CRMDEV @/oraclesiebel/siebsrvr/log/upgphys_dev_811sia/output/SWTMigration/Log/SQL/NewRow.sql
2015-11-12 15:07:23 : Exceed default no of rows. Generating new row ids again

 

ERROR 2
-----------------------

2015-11-12 15:02:26 : Generating XML Version of File :/oraclesiebel/siebsrvr/webtempl/ouiwebtempl/custom/CCSmartScriptPlayerApplet.swt
2015-11-12 15:02:27 : Error in converting for-each loop. Possible reason is count element contains non numeric charcaters
2015-11-12 15:02:27 : File :/oraclesiebel/siebsrvr/webtempl/ouiwebtempl/custom/CCSmartScriptPlayerApplet.swt contains non numeric values in for-each element. This file will not be parsed

ERROR 3
-----------------------


2015-11-12 15:02:26 : Generating XML Version of File :/oraclesiebel/siebsrvr/webtempl/custom/dCCAppletFormItemDetail.swt
2015-11-12 15:02:26 : File CCeTAFProdSearchApplet.swt not found in Directories : /oraclesiebel/siebsrvr/webtempl/ouiwebtempl/custom/ and /oraclesiebel/siebsrvr/webtempl/custom/


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run DB config Wizard > upgphys step

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