SBL-DAT-00560: An error occurred preparing a SQL object for employee information. See additional error messages for more information

Applies to:

Siebel Tools - Version: 7.7.1 [18306] - Release: V7
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.7.1 [18306] DEU
Database: IBM DB2 8.1 FixPack 3
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Microsoft Windows 2003 Server

This document was previously published as Siebel SR 38-1459241015.

Symptoms

SBL-DAT-00556, SBL-DAT-00546, SBL-DAT-00560

Follow-up from SR 38-1453099441

1. Starting Siebel via web client fails. Please see the attached log-files for error messages.
(For translation see Siebel Error Messages > Siebel 7.7).
SBL-DAT-00560, SBL-DAT-00556, SBL-DAT-00546, SBL-SVC-00208, SBL-DAT-00385

2. Doing a full compile on the extracted local developer database fails:

Displayed error messages:
An error message has occured executing a Sql statement.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)

Internal database error *** ERROR *** Assertion failed: 102300 (8.0.2.4361)
File associated with given page id is invalid or not open -- transaction rolled back

According to SR 38-1371657223 we regenerate db template, extracted db again, initialize it, perform a full get but the error still remains.

Compiling a new SRF connected to the server succeded.

3. The error messages described in the attached log files do not appear using a standard SRF.
We are able to connect successfully via Web Client.

4. We are able to connect successfully using the Siebel Dedicated Web Client. The same error messages are logged in local siebel.log while using compiled new SRF.

5. We renamed the Siebel_Server/bin/diccache.dat, but errors still remain.

Thank you for your quick response.

Henrik

Cause

The cause for the assertion failed error message sometimes occurs when the local db needs to allocate temporary files and does not have enough space.

Solution

Message 1

DESCRIPTION:

Tools stops during full compile on local db.

SYMPTOMS:

Doing a full compile on the extracted local developer database fails:

Displayed error messages:
An error message has occured executing a Sql statement.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)

Internal database error *** ERROR *** Assertion failed: 102300 (8.0.2.4361)
File associated with given page id is invalid or not open -- transaction rolled back

When using the unfinished srf file the following errors are shown in the client log file:

SBL-DAT-00560
SBL-DAT-00556
SBL-DAT-00546
SBL-SVC-00208
SBL-DAT-00385

SOLUTION:

The assertion failed error message sometimes occurs when the local db needs to allocate temporary files. This files are usual stored in the path of the TEMP system variable which usual points to C:\temp. As the temporary files can grow up to 500 MB the C hard disk sometimes has no free space for the temporary files.

In this case the issue has been resolved by deleting the TEMP system variable and recreating it new.


Siebel Technical Support