SBL-DAT-00128: SQLError

Applies to:

Siebel Tools - Version: 7.5.3.4 SIA [16180] and later   [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.4 [16180] ITA Cons Sec
Database: Microsoft SQL Server 2000
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: Microsoft Windows 2000 Server SP 4
Reviewed for relevance September 22,2010

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

Symptoms

SBL-DAT-00128

Hallo,

We installed SIebel 7.5.3.4 SIA using a SQL Server DB.

When we install SIebel Tools on a client machine, we can succesfully get all project, although it takes approx 6 hours.
But if we try then to check out a project, we get the foolowing errors in sequence:

22005 (0): [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
UTLOdbcExecDirect update lock

This happens on all client machines.

Can you help?

Thank you in advance for your support,
Lorenzo Marietti

Cause

The cause of the behavior was determined to be a product defect.

Solution

Message 1

For the benefit of other readers:

During check out the following error message has been shown:


22005 (0): [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
UTLOdbcExecDirect update lock


INVESTIGATIONS:

After increasing the SIEBEL_LOG_EVENTS to All it has been found that the Tools client tries to update a date field with the following value: “2004-03-22 09.04.03”
The format for the time value can not be stored correct in the database.
CAUSE OF THE ERROR:
The wrong time format has been caused by setting the regional settings to Italian.
As the regional settings should not affect the Tools client change request 12-K8KNJX has been logged: Can not check out project when regional settings is Italian.

SOLUTION:

After setting the regional settings to English-American the error went away.

Thank you

Siebel Technical Support

Additional keywords:
Check out , ODBC , time format

Applies to:

Siebel Tools - Version: 7.8.2.3 [19221] - Release: V7
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.8.2.3 [19221]
Database: Oracle 10.2.0.1
Application Server OS: Microsoft Windows 2000 Server SP 2
Database Server OS: IBM AIX 4.3.2
Checked for Relevance on 02-Feb-2010

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

Symptoms

After enabling the   Enable ST Script Engine

The following code gives a compilation error where it doe give error if the ST Script egine is not enable.

Script compilation failed at line 12 in procedure 'fnNotifyFlag':
Syntax error at Line 12 position 88:Expected '}'
(SBL-SCR-00128)

function fnNotifyFlag (FieldName)
{
    // Service Request.fnNotifyFlag()
    // Copy: CL 010917 R5-01 SR Attachment notification flags. /EBB 011005 R5-19     
    // **********************************************************
    switch (FieldName)
    {
        case 'Attachments Notify Flg':
            // BC Service Request Attachment
            if (null == (var boServiceRequest = TheApplication().GetBusObject('Service Request')))
            {
                return (CancelOperation);
            }
            if (null == (var bcSRAttach = boServiceRequest.GetBusComp('Service Request Attachment')))
            {
                return (CancelOperation);
            }
            var iSRId = this.GetFieldValue('Id');
            var iAttParentId;
            bcSRAttach.ClearToQuery();
            bcSRAttach.ActivateField('Activity Id');
            bcSRAttach.SetSearchSpec('Activity Id', iSRId);
            bcSRAttach.ExecuteQuery(ForwardOnly);

            if (bcSRAttach.FirstRecord())
            {
                this.SetFieldValue('Attachments Notify Flg','Y');
            }
            else
            {
                this.SetFieldValue('Attachments Notify Flg','N');
            }
        default:
            return (ContinueOperation);
    }

    return (ContinueOperation);
}

What could be the issue ?

Solution

Message 1

For the benefit fo other users:

I tested this issue at my place with enabling ST eScript engine and with old T script engine.
There is no error in old T script engine and error happens on ST eScript engine caused by syntax error ("SBL-DAT-00128").

Change Request #12-1J1WYC7 has been logged as Product Defect in ST eScript Engine.

Related

---

Products

---

Siebel > Customer Relationship Management > CRM - Enterprise Edition > Siebel Tools

SBL-DAT-00128; SBL-SCR-00128