SBL-DAT-00489: Cannot evaluate query node for identifier '%1' while not in the context of a business component.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3.5 [16183] Com/Med
Database: Oracle 9.2.0.2
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: Sun Solaris 5.8

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

Symptoms

SBL-DAT-00489

Hello,

This is to bring in to your notice, the error which we are facing while the user logs in to eCustomer application.
The error message says "Cannot evaluate query node for identifier 'Item Line Total' while not in the context of a business component (SBL-DAT-00489)"
Please find the attachment.
When a newly created user logs in for the first time he doesn't gets the error, but for all subsequent logs in the error is poping up

Also we face difficulty in view "Current Quote View (eSales)", there is a possibility for both the errors are connected.
In this view the following applets controlled by Applet personalization, is not triggering properly.
1.Quote Empty Form Applet (eSales)
**GetProfileAttr("CartItemCount") IS NULL OR GetProfileAttr("CartItemCount") = '0'**

2. Quote Item List Applet (eSales)
**GetProfileAttr("CartItemCount") IS NOT NULL AND GetProfileAttr("CartItemCount") <> '0'**

Although the Modify work flow (CUT eSales-Modify products and Services process) identifies the Active quote, We always gets the Quote Empty Form Applet(eSales) messaging, "Your Shopping Cart is Empty".


With thanks and regards

Solution

Message 1

For the benefit of other users:

Where this error has occurred before, it was a result of having upgraded from 7.0.4 to 7.5.2. In the 7.0.4 definition of the Quote business component, there were a number of user properties called ‘BusComp Evaluate Field’. The one we are particularly interested in is:

Name: BusComp Evaluate Field 3
Value: Current Quote Total Net Price

The user property does not exist in the fresh 7.5.2 installation - instead it seems that the BC user property has been replaced with 'Item Total Field 7' with a value of '"Current Quote Total Net Price", "Calculated Line Total UI"'. This is discussed in Service Request 38-842409351 on SupportWeb entitled : 'Discount Amount on Order Business Comp',available on SupportWeb, indicates that

"Actually, whatever the formula, this field always showed the same information due to the following.

Name: Item Total Field 7
Value: "Current Order Total Net Price", "Calculated Line Total UI"
"

This SR also indicates that the BC User Property 'BusComp Evaluate Field x' is utilized to provide caching at the BC level when calculating calculated fields. For this reason the end result will be the same, except without BC level caching for this field.

Once this business component user property was inactivated, and the Quote business component compile, the error message no longer occurred.

Keywords: SBL-DAT-00489

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.2 [16007] Cons Sec
Database: Oracle 8.1.7.4
Application Server OS: Microsoft Windows 2000 Advanced Server SP 2
Database Server OS: IBM AIX 4.3.3

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

Symptoms

SBL-DAT-00489

To Whom It May Concern:

I have finish uprading from Siebel 7.0.4 to Siebel 7.5.3. I am trying to create a new Opportunity and I am receiving the following error:   '' is a required field. Please enter a value for the field (SBL-DAT-00489) after I try to save the record.

Regards,
Cedric Barnett
818.977.8382

Solution

Message 1

For the benefit of other readers,


Siebel Support reviewed the customers configuration of the "Opportunity" business component and found that customer had created a field named "Created" mapping to the "CREATED" Column. The root cause of the error " '' is a required field. Please enter a value for the field (SBL-DAT-00489) after I try to save the record." was because of this "Created" field.

After Inactivating the "Created" field , the customer was able to sucessfully create a new opportunity record without the error message.

Please note that "Created" is a System Field which is predefined in the repository by default and it should not be redefined again in the business component.