Siebel SQLs/Error Messages >  SBL-GDB-00004 Error in Main function

SBL-GDB-00004 Error in Main function

Siebel Remote : Generate New Database throws Error SBL-DBX-00083 and SBL-GDB-00004

APPLIES TO:
Siebel Remote - Version 7.5.3 [100] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.3.3 [16172] ESN Pub Sect
Database: Oracle 9.2.0.4
Application Server OS: Sun Solaris 8
Database Server OS: Sun Solaris 8

SYMPTOMS

Customer Experiencing multiple errors on Solaris Platform while generating New Database

SBL-DBX-00083:Unable to start due to incorrect system preference setting when trying to GenNewDb
SBL-GDB-00004: Error in main Function and IM003: Specified driver could not be loaded in the GenNewDb log file

CAUSE
Docking:Transaction Logging=FALSE

LD_LIBRARY_PATH

SOLUTION
Message 1
For the benefit of others:

The customer was getting Error 500083 - SBL-DBX-00083:Unable to start due to incorrect system preference setting when trying to GenNewDb

Resolution :

After setting Docking:Transaction Logging=TRUE GenNewDb worked on the Windows Platform. Please refer to
- "Database Extract 7.x and 8.x Failures (Doc ID 477173.1)"

The customer then received the following errors on their Solaris Platform SBL-GDB-00004: Error in main Function and IM003: Specified driver could not be loaded in the GenNewDb log file

Resolution:

It was found that the LD_LIBRARY_PATH for the SQLAnywhere driver was not set in their siebenv.sh. This path is normally added during installation to the LD_LIBRARY_PATH defined in siebenv.sh.

Adding this path to siebenv.sh resolved this behaviour:
LD_LIBRARY_PATH=${SQLANY}/lib:${LD_LIBRARY_PATH}
export LD_LIBRARY_PATH
(Please also ensure the SQLAANY path is set correctly in siebenv.sh)