SBL-DAT-00399: The query expression on field '%1' is not valid. Please revise and try again.

Applies to:

Siebel Tools - Version: 7.5.3 SIA [16157] to 8.1.1.3 SIA[21219] - Release: V7 to V8
Oracle Solaris on SPARC (64-bit)
Database: Oracle 8.1.7.3
Application Server OS: Sun Solaris 8
Database Server OS: HP-UX 11.0

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

Symptoms

SBL-DAT-00399

Issue:  We are facing a problem while trying to do an export on the Order Line Item List applet.
Whenever we select Columns To Export as 'All' we get an error saying "The query expression on field 'Quantity Requested' is not valid. Please revise and try again.(SBL-DAT-00399) " .

Cause

This behavior was caused by another field in the Business Component that was calculating an invalid value.

Solution

A solution for this was for the customer to correct their Calculated Expression in their ‘CG Item Price' field and the export worked as expected.

Applies to:

Siebel Universal Customer Master - Version: 7.8.1.1 [19044] and later   [Release: V7 and later ]
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 7.8.1.1 [19044]
Database: IBM DB2/390 V7
Application Server OS: IBM AIX 5L 5.2
Database Server OS: IBM zOS

This document was previously published as Siebel SR 38-2558448411.
***Checked for relevance on 27-OCT-2010***

Symptoms

When executing the UCM Account Batch Data Management Workflow, the following error was observed:

Error invoking service 'UCM Batch Manager', method 'HandleMatchCase' at step 'Process AutoMatch'.(SBL-BPR-00162)
--
Method 'FieldValue' of business component 'Account' (integration component 'Account') for record with search specification '[Party UId] = "34AB7C0B-45AA-44d8-9E72-DF299E588ECA"' returned the following error:"The query expression on field 'Assessment Value' is not valid. Please revise and try again.(SBL-DAT-00399)"(SBL-EAI-04451)

Cause

Through research and tests, it was found that the reported error was caused by custom integration component field ‘Assessment Star Value’ in Account integration component within CIFAccount integration object. The reason why the reported error occurs was that the Assessment Star Value is a calculated field and the Calculated Value is [Assessment Value]/25. Here, the data type of ‘Assessment Value’ field is DTYPE_TEXT so that it is not allowed to divide string data with numeric value. Then the following errors are caused:

ObjMgrMiscLog Warning 2 0 2005-10-06 15:45:44 (ssdatum.cpp (754)) SBL-DAT-00479: CSSString doesn't support operator '/'

ObjMgrQueryLog Warning 2 0 2005-10-06 15:45:44 (query.cpp (6877)) SBL-DAT-00399: The query expression on field 'Assessment Value' is not valid. Please revise and try again.

Solution

BUG: 12-16EHBFU has been logged to address this incorrect Calculated Value in UCM standard application.

A workaround is to change the Calculated Value for the Assessment Star Value field on Account business component as follows:

From: [Assessment Value]/25
To: 1*[Assessment Value]/25

It is because when a Calculated Value statement references more than one field value and constant, and each field and constant has different data types, the order of the data types can have an effect on the calculation. In other words, the calculated value is left-centric.

References

BUG:12-16EHBFU - CSSSTRING DOESN'T SUPPORT OPERATOR '/' ERROR AT 'PROCESS AUTOMATCH' STEP OF BDM WORKFLOW

Applies to:

Siebel Tools - Version: 7.5.3 SIA [16157] and later   [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3 [16157] SVE Fin Svcs
Database: Oracle 8.1.7.3
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-1487941561.

Symptoms

Hi,

I'm having a error message when attempting to export from events list applets. The error message I get is :

'The query expression on field 'BNPP FI Count All Attended' is not valid. Please revise and try again.'

The field is a calc field on the eEvents Parent Event BC which does a Count on an MVL. The syntax is 'Count ("Attended Total")' and the bizarre thing is that it works perfectly displaying the correct number in all the applets it is in.

Is there something that prevents 'Count' calc fields from being exported ?

Regards

Cause

SBL-DAT-00399

Solution

Description:

I'm having a error message when attempting to export from events list applets. The error message I get is : “The query expression on field 'BNPP FI Count All Attended' is not valid. Please revise and try again”

The syntax is 'Count ("Attended Total")' and the bizarre thing is that it works perfectly displaying the correct number in all the applets it is in.

Is there something that prevents 'Count' calc fields from being exported ?

Resolution:

The problem lay in the way the calculated expression for the 'Cost per Contact' field allowed in certain cases for a figure to be divided by zero.

The expression was:
IIF(([Event Type] = LookupValue (EVENT_TYPE, 'Sponsored Conference')),'0', ([BNPP FI Post Event Cost] / [BNPP FI Count All Attended]))

This allowed the possibility for the figure in 'BNPP FI Post Event Cost' to be divided by zero. While this was acceptable in the applet and would be displayed as a blank field it somehow prevented export. It also prevented those records which were Div/0 from being picked up by Actuate Reports.

The issue has been corrected with a nested IF to only allow non zero figures to enter the formula: IIF(([Event Type] = LookupValue (EVENT_TYPE, 'Sponsored Conference')),'0',(IIF([BNPP FI Count All Attended]="0","",([BNPP FI Post Event Cost] / [BNPP FI Count All Attended]))))