SBL-SVC-00253

Applies to:

Siebel Sales Enterprise - Version: 8.0.0.4 [20417] to 8.1 [21039] - Release: V8 to V8
Information in this document applies to any platform.

Goal

When creating a deployment filter using PDQ for LOV it is created with a "dot" that cannot be validated correctly.

By removing the "dot" from the deployment filter, the filter validates works fine. However, no rows are returned in the deployment file.

Also,  as soon as you remove the dot from the filter the PDQ disappears and its necessary to identify how ADM works with LOVs.

Solution

PDQ retrieved from application UI is:

[.Description] LIKE "LOV*" AND [.Type] LIKE "FIN_ACCOUNT_STATUS*"

Click on Validate button under Deployment Filter, get this error:

[1] The Filter 'Data Filter' is invalid. Please review the filter syntax and/or Field name.(SBL-SVC-00253)
[2] Information about integration component "not found. Check query specification and output integration object definition.(SBL-EAI-04176)

Remove the "." from the above, so it becomes:
[Description] LIKE "LOV*" AND [Type] LIKE "FIN_ACCOUNT_STATUS*"

Click on Validate button under Deployment Filter, no more error but got this message which can't be used as a filter because it retrieves 0 row:

The Deployment filter(s) for "LOV" returns no rows and will not allow any data to be deployed to the target system. Please revise the Deployment Filter.(SBL-SVC-00254)

Description and Type are valid fields, they are validated against "List Of Values Parent (UDA)" integration component of "UDA List Of Values" integration object, which is the primary business component of the IO. 

For the Deployment filter to work correctly to return the equivalent results as the application UI, it has to be modified to be as the following:

[List Of Values Child (UDA).Description] LIKE "LOV*" AND [Value] LIKE "FIN_ACCOUNT_STATUS*"

or

[List Of Values Child (UDA).Description] = 'LOV' AND [Value] = 'FIN_ACCOUNT_STATUS'

The Documentation Enhancement Request Bug# 10557771 has been entered to document the above in Siebel Application Deployment Manager Guide.

Applies to:

Siebel eCommunications - Version: 8.1.1.1 SIA [21211] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Goal

Unable to created ADM project for PDQ's. The following error is encountered when using the deployment filter [Name]='xyz':

[1] The Filter 'Data Filter' is invalid. Please review the filter syntax and/or Field name.(SBL-SVC-00253)
[2] Information about integration component field 'Name' not found.  Check query specification and fields defined for integration component 'Query List' (SBL-EAI-04177)

How can we resolve this problem?

Solution

The deployment filter is wrong. The integration component "Query List" does not have a "Name" field. The field is called "Description". Please change your deployment filter as follows to resolve the error message:

[Description]='xyz'