Search This Blog

Feb 13, 2012

Error While Generating a New Database


Error While Generating a New Database

SBL-GDB-00004: Error in Main function.

Error Details:
Executing  “Generate New Database” Job resulted in following error.
SBL-GDB-00004: Error in Main function


Reason:
We increased the log level for Generate New Database Component and analyzed the generated logs. In logs we found the following information

Trace TracingInfo 3 0 2009-04-28 02:37:54 Copying template /siebdir/sieb78/siebsrvr/dbtempl/sse_utf8.dbf
to /siebdir/sieb78/siebsrvr/dbtempl/db42r53.682/sse_utf8.dbf...
GenericLog GenericError 1 0 2009-04-28 02:37:54 Error creating SQL Anywhere database template file (UTLFileCopy szTemplFileName -> szWatcFileName).



Solution:

Further analysis revealed that sse_utf8.dbf file was not present in  /siebsrvr/dbtempl. After going through bookshelf and metalink we came to conclusion that there are two files that should be present in /siebsrvr/dbtempl/ folder

    sse_utf8.dbf
    sse_encr.dbf

We copied these files from other server and exectued “Generate New Database” Job and it ran successfully.

No comments:

Siebel IP 2017 - Web Tool Development Steps

Siebel IP 2017 Development and Deployment Steps : 1. Click on the Workspace Icon in Siebel Web Tools application. 2. Create a New work s...