Problem:

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.