Siebel SQLs/Error Messages >  Generate New Database Template (GenNewDB) tasks fail with error SBL-GDB-00004 after applying FixPack 8.1.1.4 or later

Generate New Database Template (GenNewDB) tasks fail with error SBL-GDB-00004 after applying FixPack 8.1.1.4 or later

APPLIES TO:
Siebel Remote - Version 8.1.1.4 SIA [21225] and later
Generic UNIX
SYMPTOMS

After applying Fix Packs 8.1.1.4 or later on Unix environments, GenNewDB task could be failing with lines like these observed in detailed logs:

Executing SQL statements...
Executing SQL RUN_SQL_0...
...
SQL Statement:
set option PUBLIC.String_rtruncation='On'
...
Error executing SQL statements (??).
...
Error creating SQL Anywhere database template file (ExecSqlAnywhereStmts).
Error in MainFunction (CreateDbTemplateFile)
(gennewdb.cpp (610) err=524292 sys=0) SBL-GDB-00004: Error in Main function.

or in some other cases, error lines logged could also include:

SQL Statement:
set option PUBLIC.String_rtruncation='On'
[DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased. You can order a license by calling DataDirect Technologies at 800-876-3101 in North America and +44 (0) 1753

CHANGES

CAUSE
Checking the .odbc.ini file contents (in [SIEBEL_ROOT]/sys directory), an extra line can be observed as compared to a standard file contents (numeric value may be different):

"QEWSD=2455714"

That may indicate likely the license file (IVSE.LIC) for Data Direct ODBC driver could be missing or invalid - per details in: "Error An additional wrong string "QEWSD is being appended in the file .odbc.ini" (Document 544072.1).
However, in current case, GenNewDB was the only server component complaining about this file, other components were running fine.

SOLUTION
As a first step, should be verified and confirmed that on affected server the IVSE.LIC file is present in "siebsrvr" directory.

If that file exists - apply the following workaround:

A. [For environments running on 8.1.1.6 Fix Pack or later]

* Stop Siebel Server and Gateway services

* cd to SIEBEL_ROOT - i.e. $ cd /opt/siebelsia

* Ensure these previous files or soft links are removed:

$ rm siebsrvr/IVODBC.LIC

$ rm gtwysrvr/IVODBC.LIC

* Copy the IVSE.LIC as IVODBC.LIC:

$ cp siebsrvr/IVSE.LIC siebsrvr/IVODBC.LIC

$ cp gtwysrvr/IVSE.LIC gtwysrvr/IVODBC.LIC

* Start the Siebel servers.

Then retry GenNewDB now after the services' restart.

(Note that after applying this workaround, one may still see in GenNewDB task logs same license warning - but as long as task would cary on and complete fine, those could be ignored.)

B. [For environments running earlier releases than 8.1.1.6 Fix Pack]

Edit .odbc.ini file (make a backup copy before) to remove that QEWSD line, save it and retry running GenNewDB.
That may allow task to complete, but the line would be placed back in file. (If that is the case, before running GenNewDB again.