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'

תגובות

פוסטים פופולריים מהבלוג הזה

FINS Data Transfer Utilities

SBL-BPR-00191: The rowId of the active row of the primary buscomp '%1', '%2', does not match the Primary Id

Profile Attributes and Open UI