SIEBEL ERROR CODES: SBL-DAT-00394: Could not evaluate expression '%1' for field '%2' in business component '%3'.

Applies to:

Siebel Tools - Version: 7.5.3.7 [16190] and later [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.4 [16180]
Database: Oracle 9.2.0.4
Application Server OS: Microsoft Windows 2000 Advanced Server SP 4
Database Server OS: Microsoft Windows 2000 Advanced Server SP 4

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

""Checked for Relevance on 21-May-2010""

Symptoms

We get an error when I click on the "New" button on the Opportunity applet. The error message is attached. The error message is:

"An Error Occurred calculating the Default value for Field "Opportunity Close Date" in business component 'Opportunity-SalesRep-VisMvgSqlBcDef (SBL-DAT-00412)."

I have checked the application and there is no BC with "VisMvgSqlBcDef". Please let me know the reason for this error. I have looked up the SupportWeb but could not find anything helpful to our situation.

We get this error in a new Dev environment (Dev 5) which has Patch 11 installed. We do not get this error in the Dev 3 environment. The only difference between the two environments is the Patch 11.

Cause

Solution

The behavior described by the customer is reproducible with a standard Siebel environment version 7.5.3.7 or higher by performing the steps below:

# Using Tools:

1. Change the pre-default value of field 'Opportunity Close Date' in Business Component (BC) 'Position' to:

Expr: "IIf ( ParentBCName () = 'Opportunity' , IfNull(ParentFieldValue ('Default Close Date') , Today ()), Today () )"

2. Add the following calculated field in BC 'Opportunity':

Name: Default Close Date
Calculated Value: Today() +2 (For example)
Link Specification: TRUE

# Using Siebel application:

1. Navigate to "My Opportunities" view
2. Create a new record:
> The following errors will occur:
- - -
[1] An error occurred calculating the default value for field 'Opportunity Close Date' in business component 'Opportunity-SalesRep-VisMvgSqlBcDef'.(SBL-DAT-00412).
[2] Could not evaluate expression 'Expr: "IIf ( ParentBCName () = 'Opportunity' , IfNull(ParentFieldValue ('Default Close Date') , Today()), Today() )"'' for field 'Opportunity Close Date' in business component 'Opportunity - Sales Rep - VisMvgSqlBCDef'.(SBL-DAT-00394)
[3] Unable to find value for parent field 'Opportunity.Default Close Date'. Make sure LinkSpec = TRUE is used on the parent field.(SBL-DAT-00467)
- - -

This issue is not reproducible with version 7.5.3.6 or below and with version 7.7 either.

Bug 12-VS5MUH has been logged to address this product defect.

Note that the issue occurs only if you try to use the ParentFieldValue function to pre-default an intersection field in a child BC with the value of a field in the parent BC. In the customer case the field 'Opportunity Close Date' in BC 'Position' is indeed based on column FCST_CLS_DT in table S_OPTY_POSTN. This table is an intersection table used by the M:M link between BC 'Opportunity' and BC 'Position'.

Moreover it occurs only when a child record is also created at the same time as the parent record. In the customer case the child position record is automatically created because of the visibility settings of BC 'Opportunity'. This BC has indeed the following BusComp View Mode:
- - -
Name: Sales Rep
Owner Type: Position
Visibility MVField: Sales Rep
Visibility MVLink: Position
- - -

For the customer the suggestion to pre-default the field 'Opportunity Close Date' using the value of a field in BC 'Opportunity' was to use scripting in the BusComp_NewRecord event of BC 'Opportunity'. The steps are the following:

(a) Instantiate the MVG BC associated to the MVF 'Sales Rep' in the current BC.
(b) Query the MVG BC to retrieve the position record automatically created.
(c) Set the value of field 'Opportunity Close Date' with the value wished (e.g. the value of the field 'Default Close Date' in the current BC.
(d) Destroy the instance of the MVG BC.

For further information about the programming possibilities and Siebel interface events and methods, please refer to the Bookshelf:

# Siebel Object Interfaces Reference
- Programming
- Interfaces Reference

# Siebel VB Language Reference
# Siebel eScript Language Reference

References

BUG:12-VS5MUH - ISSUE WHEN PARENTFIELDVALUE FUNCTION IS USED TO PRE-DEFAULT A FIELD BASED ON AN INTERSECTION COLUMN

Applies to:

Siebel System Software - Version: 7.8.2.5 SIA [19227] and later [Release: V7 and later ]
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.8.2.5 [19227] Com/Med
Database: Oracle 9.2.0.7
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 8

This document was previously published as Siebel SR 38-3407020681.
""""Checked for relevance on 16-NOV-2010""""

Symptoms

While invoking a custom web service via the SOAP UI and the username/password is contained within the URL the web service executes successfully :

http://acilf465.alltel.com:8114/eai_enu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&UserName=INT_WBI&Password=INT_WBI

While invoking the same custom web service via the SOAP UI and the username/password is not contained within the URL but contained in the soap header:

http://acilf465.alltel.com:8115/eai_enu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&WSSOAP=1

   <soapenv:Header>
    <UsernameToken
  xmlns="http://siebel.com/webservices">INT_WBI</UsernameToken>
    <PasswordText
  xmlns="http://siebel.com/webservices">INT_WBI</PasswordText>
    <SessionType
  xmlns="http://siebel.com/webservices">None</SessionType>
   </soapenv:Header>

the web service errors out. The error messages below are displayed.


<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
   <SOAP-ENV:Body>
      <SOAP-ENV:Fault>
        <faultcode>SOAP-ENV:Server</faultcode>
        <faultstring>Error invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Upsert Order IO'.(SBL-BPR-00162)</faultstring>
        <detail>
            <siebelf:errorstack xmlns:siebelf="http://www.siebel.com/ws/fault">
               <siebelf:error>
                  <siebelf:errorsymbol/>
                  <siebelf:errormsg>Error invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Upsert Order IO'.(SBL-BPR-00162)</siebelf:errormsg>
               </siebelf:error>
               <siebelf:error>
                  <siebelf:errorsymbol/>
                  <siebelf:errormsg>Method 'WriteRecord' of business component 'ALLTEL - Integration - Order Entry - Orders' (integration component 'ALLTEL - Integration - Order Entry - Orders') for record with search specification '[Id] = "2-RL824"' returned the following error:"An error occurred calculating the default value ...

Cause

The described behavior has been reproduced and change request 12-1KILXUB has been logged to address this.

Solution

Based on our testing, it appears that if any user Id (other than SADMIN), say "WEBSERVICE" is used for logging in in web service, the "an error occurred calculating the default value for field 'Price List' in business component" message will be seen if I use "Siebel Authentication and Session Management SOAP headers". If the user is specified in the URL, the order record will be created successfully. However, if "SADMIN" user is used for both instances, the record will be created successfully.

From the object manager log file, it appears that there is an error on evaluating the following expression for "Price List" field:

(sqlobj.cpp (17616)) SBL-DAT-00394: Could not evaluate expression 'Expr: "Preference (""Quote"", ""PriceList"")"' for field 'Price List' in business component 'Order Entry - Orders'.

As a workaround, customer has removed the value in "Pre Default Value" and "Post Default Value" properties for "Price List" field.

References

BUG:12-1KILXUB - SESSION MANAGEMENT IN WEB SERVICE TO CREATE ORDER GIVES AN ERROR

Applies to:

Product Release: V7 (Enterprise)
Version: 7.7.1 [18306]
Database: Oracle 9i
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Sun Solaris 8

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

Symptoms

SBL-CSR-00418, SBL-UIF-00335, SBL-UIF-00401, SBL-DAT-00394, SBL-DAT-00412

We are seeing lot of applet errors in the object manager log file. It is not impacting our ability to go to server admin screens. If you take the example of:

SBL-UIF-00401: View: Server Server/Component/State Value View does not contain applet: Server Component Instance Form Applet.

Server Component Instance Form Applet is not tied to the above view in tools.

This is a vanilla repository and we have compiled the SRF after the 7.7.1 patch. There are other errors like :

SBL-UIF-00401: View: Home Page View (WCC) does not contain applet: .

SBL-DAT-00394: Could not evaluate expression 'Field: 'Id'' for field 'CSN' in business component 'Account Home Add Virtual'.

Please see the attachment file.

Thanks

Solution

Message 1

For the benefit of other users:

The customer was seeing lot of applet errors in the object manager log file. It was not impacting his ability to go to Server Administration screens. Among these errors were:

ObjMgrLog    Error    1    0    2004-07-09 12:35:58    (cscfg.cpp (163)) SBL-CSR-00418: Communication: User is not associated with any communication configuration in the database.

ObjMgrLog    Error    1    0    2004-07-09 12:36:10    (sweview.cpp (1152)) SBL-UIF-00401: View: Home Page View (WCC) does not contain applet: .

ObjMgrLog    Error    1    0    2004-07-09 12:36:10    (cthd.cpp (3017)) SBL-UIF-00335: We are unable to process your request. This is most likely because you used the browser BACK or REFRESH button to get to this point.

ObjMgrLog    Error    1    0    2004-07-09 12:37:04    (sweview.cpp (1152)) SBL-UIF-00401: View: Server Server/Component/State Value View does not contain applet: Server Component Instance Form Applet.

ObjMgrLog    Error    1    0    2004-07-09 12:39:22    (sqlobj.cpp (17009)) SBL-DAT-00394: Could not evaluate expression 'Field: 'Id'' for field 'CSN' in business component 'Account Home Add Virtual'.

ObjMgrLog    Error    1    0    2004-07-09 12:39:22    (fields.cpp (1535)) SBL-DAT-00412: An error occurred calculating the default value for field 'CSN' in business component 'Account Home Add Virtual'.

CONTINUED...

Message 2

CONTINUATION:

The customer was using a standard (vanilla) repository and he has compiled the SRF file after applying the 7.7.1 patch.
Because the customer did not encounter any errors in GUI and the behavior was not impacting his ability to go to Server Administration screens it was suggested ignoring these errors.

Change Request 12-N21DE3 - Errors in the Object manager log file was logged to address this matter. It should be documented that the errors are benign and could be ignored.

Siebel Technical Support

Keywords: Object Manager, log file, error messages, benign, standard repository, wrong applet names

Applies to:

Product Release: V7 (Enterprise)
Version: 7.8.2.1 [19216] Cons Goods
Database: Microsoft SQL Server 2000 SP4
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Microsoft Windows 2000 Server SP 4

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

Symptoms

SBL-DAT-00394

Hello Tech Support,

We have encountered an error in Consumer Sector object manager's log file. The error is reproducible with vanilla SRF, as follows:

(1) Go to Promotions screen
(2) Click Promotion List category hyperlink
(3) Drill down on any existing record's Promotion hyperlink
(4) You should now have arrived at CS CG Promotion Baseline View
(5) On the UI there are no errors, but in the log there is an entry:

(sqlobj.cpp (17537)) SBL-DAT-00394: Could not evaluate expression 'Field: 'Currency Code'' for field '' in business component 'CS CG Plan Account Promotion Category'.

We have looked at SR 38-2683395011. Can you please
(a) Confirm if our issue is the same issue as that SR?
(b) Confirm that the error we are getting is benign?
(c) Provide a workaround to fix the cause of the error?

I'm attaching a sample log file.

Thank you.

Solution

Message 1

For the benefit of other users,

The behavior seen by customer is reproduced in standard siebel environment connecting to sample db.
The error SBL-DAT-00394: Could not evaluate expression 'Field: 'Currency Code'' for field '' in business component 'CS CG Plan Account Promotion Category' in the log file is benign and can be ignored.
The error message seen in the log file is based on OM code and currently we cannot configure it.
Currently there is no workaround to suppress this error message in the log file. Please ignore this error message.

Change Request 12-1EB5OLF is raised to suppress this error message in the log file as it leads to confusion.

Thank you,
Siebel Technical Support

Applies to:

Product Release: V7 (Enterprise)
Version: 7.8.2 [19213]
Database: Oracle 9.2.0.7
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: HP 9000 Series HP-UX

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

Symptoms

SBL-DAT-00394, SBL-DAT-00398

The All Revenue Analysis View hangs the appliocation.

Screen: Opportunities Screen

View: All Revenue Analysis View

Business Object: Revenue

Applets: Applet[0]: Revenue Analysis List Applet; Applet[1]: Revenue Analysis Form Applet;

Business Components: BusComp[0]: Revenue; BusComp[1]: Revenue;

Note that when we run the query from spool in sql, it runs within seconds.

Please find the spool attached.
REV_spool.txt

Urusa

Solution

Message 1

For the benefit of other readers:

The standard
All Revenue Analysis View
has a list Applet
Revenue Analysis List Applet
which displays Totals for Revenue, Cost and other list columns by default.

As the customer had 160000 opportunities meeting the search specification here,
all 160000 records needed to be read to display the totals, and that took so long that the application seemed to be hanging.

As the customer did not need the totals in that view,
in Siebel Tools for the "Revenue Analysis List Applet"'s
List Object
they changed the properties
Total Displayed
from TRUE to FALSE
and also
Total Required
from TRUE to FALSE

This made performance acceptable again. Adding an index to support custom fields from the current search spec and generating database statistics further improved performance.

The error message
SBL-DAT-00394: Could not evaluate expression 'Field: 'Currency Code'' for field '' in business component 'Revenue'.
did have some performance impact, but only when it was logged for each of the 160000 records, no longer with totals disabled.

In the course of this service request, the following three change requests were logged to address defects and missing documentation:

Change request 12-1E8ZSC2:
Standard List Column settings wrong in "Revenue Analysis List Applet", causing SBL-DAT-00394 Revenue

... to be continued ...

Message 2

... continued:

If you want to keep totaling on the
Revenue Analysis List Applet

in Siebel Tools
Applet: Revenue Analysis List Applet+
List, List Column

change all
Total Currency Code Expression
that currently are
Field: 'Currency Code'
to
Parent: 'Opportunity.Currency Code'

to stop the error
SBL-DAT-00394: Could not evaluate expression 'Field: 'Currency Code'' for field '' in business component 'Revenue'.

Change Request 12-1E908EH:
Document ALL valid "Total Currency Code Expression" formats

Change Request 12-1E9Z1BP:
Poor error SBL-DAT-00394: Could not evaluate expression 'Field: 'Currency Code'' for field '' in BC

Regards,

SIEBEL ERROR CODES

Search This Blog

SBL-DAT-00394: Could not evaluate expression '%1' for field '%2' in business component '%3'.

Applies to:

Symptoms

Cause

Solution

References

Applies to:

Symptoms

Cause

Solution

References

Applies to:

Symptoms

Solution

Message 1

Message 2

Applies to:

Symptoms

Solution

Message 1

Applies to:

Symptoms

Solution

Message 1

Message 2

No comments:

Post a Comment