ERROR in Local DB Initialization

Issue: Local DB Initialization erroring out.

Error Message:

DBCLog DBCLogError 1 000000024d621250:0 2011-02-21 09:36:28 [Sybase][ODBC Driver][Adaptive Server Anywhere]Procedure 'exrate' not foundUpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:28 [Siebel Database][ODBC Driver][Adaptive Server Anywhere]Procedure 'exrate' not foundUpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:31 Unable to read row 1 from export file (cbVal (8) /SSCHAR_SIZE + 1 > bufSize (2)).UpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:31 Unable to import table "S_REPOSITORY" (UTLDataRowRead).UpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:31 Unable to process data file dicrepos.dat.UpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:31 Import DML action failed.UpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:32 Error executing action ().

Analysis:

The jobs "Generate New Database" and "Database Extract" ran successfully without any issues. However when the user tried to Initialize Local using Tools it ran fine till "Initializing User Accounts" and errored out with above error.

To resolve this issue create the following entries in registry of System DSN created on Siebel Application Server and the local client.



Open registry(start --> Run --> regedit) and click on:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<odbc name> and add the following as String values:

Name: ColumnsAsChar
Value: 1
Name: ColumnSizeAsCharacter
Value: 1
Name: PacketSize
Value: 0
EnableScrollableCursors (Might require modification as the value would already exist)
Value: 0

After adding these values, run the DBxtract job again. Once the job completes start the local extraction using Siebel Tools and it should work fine.