Siebel Tools >  Local database download error

Local database download error

Error message: The Siebel upgrade wizard was unable to apply this upgrade (database initialization). Please select Yes if you want to repeat the upgrade,
Select No if you want to cancel immediately, and select Cancel if you want to cancel and clean up the failed upgrade attempt.

Select Cancel, this is to delete your old data from the download.

My upload is missing in step 'Loading tables for user data'.


Solution:
Find your Siebel log folder. You can find this value in your system variable SIEBEL_LOG_DIR

 


In this folder search the file 'upgwiz.log'. This is a temporary file and exists only while downloading the database.
The error message was

DBCLog DBCLogError 1 0000000258db0c10:0 2017-03-29 10:11:25 [Sybase][ODBC Driver][Adaptive Server Anywhere]Cannot access file 'S_CAMP_CON.bcp' -- No such file or directory

UpgradeLog UpgradeError 1 0000000258db0c10:0 2017-03-29 10:11:25 [Siebel Database][ODBC Driver][Adaptive Server Anywhere]Cannot access file 'S_CAMP_CON.bcp' -- No such file or directory
UpgradeLog UpgradeError 1 0000000258db0c10:0 2017-03-29 10:11:25 Error opening CFG file (filename=C:\Siebel\8.1\Tools_1\Local\inbox\S_CAMP_CON.bcp)
UpgradeLog UpgradeError 1 0000000258db0c10:0 2017-03-29 10:11:25 Error executing action (Loading tables for user limited data).


Go to folder D:\Siebel\8.1\Tools_1\LOCAL\INBOX
Here's a temporary file called 'limited.sql'. Open this file and search for 'S_CAMP_CON'. Delete all SQLs with this value.
In my case I had deleted these lines


RUN_SQL_400 =
TRUNCATE TABLE S_CAMP_CON
/
RUN_SQL_401 =
LOAD TABLE S_CAMP_CON (ROW_ID, CREATED, CREATED_BY, LAST_UPD, LAST_UPD_BY, DCKING_NUM, MODIFICATION_NUM, CONFLICT_ID, ASGN_USR_EXCLD_FLG, BU_ID, CTRL_GRP_FLG, LOAD_NUM, MARK_FOR_DEL_FLG, PR_REP_DNRM_FLG, PR_REP_MANL_FLG, PR_REP_SYS_FLG, SRC_ID, TARGET_NUM, CON_FST_NAME, CON_LAST_NAME, ACTL_REVN, ACTL_REVN_DT, ASGN_DT, BATCH_NUM, CALL_COMPLETED, CAMP_CON_SCORE, COMPLETED_DT, CONTACTED_DT, DB_LAST_UPD, EXT_SCORE, MSG_OPEN_TS, NUM_DIAL_ATTEMPTS, TGTREV_EXCH_DT, TGT_REVN, ACTL_REVN_CURCY_CD, CAMP_CON_NUM, CAMP_LD_WAVE_ID, CAMP_WAVE_ID, COMMENTS, CON_MID_NAME, CON_PER_ID, CON_PR_DEPT_OU_ID, DB_LAST_UPD_SRC, DCP_ID, DD_USER_KEY_ID, FN_ACCNT_ID, INSERT_CD, KEY_01, KEY_02, KEY_03, KEY_04, KEY_05, KEY_06, KEY_07, LST_DISTR_ID, MSG_BNCD_REASON_CD, MSG_BNCD_STAT_CD, MSG_DLVRY_STAT_CD, OPTY_ID, ORGGRP_ID, OUTCOME_CD, OWNER_PER_ID, PGROUP_ID, POSTN_ID, PRSP_CON_PER_ID, PR_CALL_LST_ID, PR_COMM_ID, REFERREDBY_PRSP_ID, REFERRED_BY_CON_ID, SEGMENT_CODE_1, SEGMENT_CODE_2, SRC_EVT_REG_ID, STAT_CD, TGTREV_CURCY_CD) FROM 'S_CAMP_CON.bcp'
/

After that I clicked retry in the Siebel Tools Popup and there were no Problems.