SBL-SVC-00254

Applies to:

Siebel CRM - Version 8.1 [21039] and later
Information in this document applies to any platform.

Goal

After creating the content object and the integration object for the
custom data type the ADM deployment filter [Screen Name]='Accounts'
returns error SBL-SVC-00254.



Why does this error occur?

Fix

Error: Field 'Screen Name' not supported by CSSBCVSRF.(SBL-SVC-00146)



From the log files it can be seen that the business component "SRF Vlink
Screen" is used to retrieve the screen names from the SRF file. However
this fails because the VBC does not support the field "Sreen Name".



Using the field "Name" in the deployment filter results in error:
Business Components configured on SRF data structures can not be used
for complex queries (SBL-SVC-00143).



Using a deployment filter for View Links is not possible because the
field information is retrieved from the SRF file through a VBC and this
can not be used for a search that is needed when using a deployment
filter.



To resolve this problem please alternatively use a full deployment of
all View Links in upsert mode independently on the screen with an empty
deployment filter.

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'

Applies to:

Siebel CRM - Version: 8.1.1 [21112] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Symptoms

Using a PDQ with less than 250 characters to define the Deployment Filter of Deployment Project, the following error displays:



Data value for field 'Deployment Filter' is larger than the limit 250
defined in the database. Please type in less information to ensure that
your data is committed to the database.(SBL-DAT-00362)

Steps to Reproduce:



1. In Site Map > Administration - Application > Views:
    Create a new view named 'Wireless Voice Main Package'.



2. Create a PDQ in Site Map > Administration - Application > Views :

'Karen Testing 1' OR 'Karen Testing 11' OR 'Karen Testing
111' OR 'Karen Testing 1111' OR 'Karen Test' OR 'Wireless Voice Main
Package' OR 'Individual Plans (*ROAMING)' OR 'Individual Voice Plans
Bundle (*ROAMING)' OR 'SMS Options (*ROAMING)'

The Word Count for this PDQ, including spaces, is 246 characters.

3. In Site Map > Application Deployment Manager > Deployment Projects:

3a.  Create a project
3b.  Choose the Data Type Name = View
3c.  In Deployment Filter, click on the button to bring up the list of PDQs saved for Views
3d.  Choose the PDQ created in Step 2.

4. Step off the record by clicking on the upper applet, the error displays.

Cause

The saved PDQ string is longer than the 246 characters:

'Feature Access'.Search = "[Name] = ""'Karen Testing 1'"" OR
[Name] = ""'Karen Testing 11'"" OR [Name] = ""'Karen Testing 111'"" OR
[Name] = ""'Karen Testing 1111'"" OR [Name] = ""'Karen Test'"" OR [Name]
= ""Wireless Voice Main Package"" OR [Name] LIKE ""Individual Plans
(*ROAMING)"" OR [Name] LIKE ""Individual Voice Plans Bundle (*ROAMING)""
OR [Name] LIKE ""SMS Options (*ROAMING)"""

The Word Count, including spaces, is 388, which is greater than 250 characters.



The ADM PDQ prefixes the [field name] and operator to each condition,
making the string longer than PDQ's conditions. In this case, '[Name] = ' or '[Name] LIKE ' is added to each condition.

Solution

Bug:10578290 was raised to address this issue. Currently, there is no patch yet.


Workaround:

Break the one filter record into multiple records.

If the Name field in the filter record is unique, then the filter record will be created successfully.

For example, the following exceeds 250 characters:

[Name] =
"Karen Testing 1" OR [Name] = "Karen Testing 11" OR [Name] = "Karen
Testing 111" OR [Name] = "Karen Testing 1111" OR [Name] = "Karen Test"
OR [Name] = "Wireless Voice Main Package" OR [Name] LIKE "Individual
Plans (*ROAMING)" OR [Name] LIKE "Individual Voice Plans Bundle
(*ROAMING)" OR [Name] LIKE "SMS Options (*ROAMING)" OR [Name] = "Karen
Account List View - FS CE"

Break this one filter into two rows:



Data Type Name: View

Active: checked

Name: View

Deployment Mode: Synchronize

Deployment Filter:

[Name] = "Karen Testing 1" OR [Name] = "Karen Testing 11" OR [Name] =
"Karen Testing 111" OR [Name] = "Karen Testing 1111" OR [Name] = "Karen
Test" OR [Name] = "Wireless Voice Main Package"



Data Type Name: View

Active: checked

Name: View2

Deployment Mode: Synchronize

Deployment Filter:

[Name] LIKE "Individual Plans (*ROAMING)" OR [Name] LIKE "Individual
Voice Plans Bundle (*ROAMING)" OR [Name] LIKE "SMS Options (*ROAMING)*"
OR [Name] = "Karen Account List View - FS CE"



Note: For each filter condition row, since the conditions are OR'ed
together, at least one of the conditions must be met (i.e., at least one
view name meets the condition). If not, the Validate filter on that
row will fail with the error:

The Deployment Filter(s) for "View2" returns no rows and will not allow any data to be deployed to the target system.

Please revise the Deployment Filter.(SBL-SVC-00254)

The deploy session will export data and generate the following files:

1. An .ini file with the list of .xml data filenames generated.

2. Each filter condition generates two files:
    2a. *_des.xml has the view names exported
    2b. *.xml has the view data exported.

In the above example, five files are generated.