SBL-SCB-00014 / SBL-NET-01023: All component processes are maxed out

SBL-SCB-00014 All component processes are maxed out
SBL-NET-01023 Peer disconnected

Reason:

Siebel throws ‘SBL-SCB-00014’ error when a server component has more than maximum number of tasks that it can run concurrently on a server. Often error code ‘SBL-SCB-00014’ is followed by another error ‘SBL-NET-01023: Peer disconnected’.

How to Solve:

To fix this issue, you have to increase the number of tasks that the particular server component can handle concurrently on a Siebel Server.

There are 3 parameters for each component that determine maximum number of threads or tasks that can run in parallel.

MaxTasks: This parameter specifies the maximum number of tasks or threads that the component can run concurrently on a particular server.
MaxMTServers: It specifies the maximum number of multi threaded processes that the component can run concurrently.
MinMTServers: It specifies the minimum number of multi threaded processes that the component can run concurrently. For better performance, MaxMTServers and MinMTServers are typically set to same value. Also MaxMTServers value must be greater than or equal to MinMTServers value.

Set values like below to get the best performance:
MaxTasks = Number of targeted users plus anon users
MaxMTServers = MaxTasks / 100*
MinMTServers = MaxMTServers

* Number 100 represents the ratio of concurrent task per multi threaded process. It may vary from one Siebel Server to another. 
Read more about these three parameters in Siebel Bookself –  About MaxTasks, MaxMTServers, and MinMTServers

Steps to fix:

  1. First you find out the Siebel Server component that is causing this error. To do so, open SWSE log file and search for the error code. Component name should be followed by error message.
  2. Copy the component name and login into Siebel application as administrator.
  3. Navigate to Administration – Server Configuration screen > Servers > Components and query for the component
  4. Now on Parameters view tab, search for above 3 parameters and increase values as per your requirement. But before increasing parameters’ values, you need to check the hardware capability of the server also. More tasks you add, more hardware resources you need. It is advisable that you talk to your Siebel Server Maintenance team before updating any parameter value.

If you have faced these errors due to some other reasons, please share with us.

Do you have any question? Please feel free to comment below.

Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Goolge+.

<< SBL-DBC-00105 or ORA-00904                                                 SBL-EAI-04397 and SBL-BPR-00162 >>

SBL-DAT-00500 / SBL-EAI-04451: There were more rows than could be returned

SBL-DAT-00500 and SBL-EAI-04451: There were more rows than could be returned. Please refine your query to bring back fewer rows.

Reason:

By default any business component query with ForwardBackward mode can fetch up to 10000 records at a time. If any query (generated by eScript or Workflow or any other way) returns more than 10000 records, Siebel throws this error ‘There were more rows than could be returned.’

How to fix:

Below we have mentioned 3 solutions to fix this error. You could choose one as per your requirement.

Solution 1: Use ExecuteQuery with ForwardOnly mode

This is the best solution if it fulfills your requirement. Oracle also suggests not to use ‘ForwardBackward’ mode with ExecuteQuery if it is not absolutely required. Instead of ‘ForwardBackword’, use execute query with ‘ForwardOnly’ mode that does not limit on fetching records.

Solution 2: Refine query

If you have to use ‘ForwardBackward’ mode to meet the requirement, try to add few more conditions so that Siebel fetches less than 10000 records at a time.

If there is an absolute need of fetching more than 10000 records using ‘ForwardBackward’ query mode, then only go for solution 3.

Solution 3: Change ‘DSMaxFetchArraySize’ parameter value

DSMaxFetchArraySize is a subsystem parameter that determines the number of records a business component query with ‘ForwardBackword’ mode can fetch at a time. By default, DSMaxFetchArraySize has value ‘0’ that means business component can return only 10000 records in ForwardBackward query mode. It does not restrict the number of records in ForwardOnly execution mode. If you want to get all rows from ForwardBackward query, set DSMaxFetchArraySize parameter value as -1 (negative 1). But you do it only when you don’t have any workaround because setting DSMaxFetchArraySize to -1 has impact on application performance due to large memory use. Even Siebel Object Manager could crash because of memory exhaustion.

To change this parameter value, follow below steps:

  • Login into Siebel application as Administrator
  • Navigate to Administration-Server Configuration > Enterprises
  • Under ‘Profile Configuration’ tab, search for the profile ‘Server Datasource’
  • In the Profile Parameters list, click on ‘Advanced’ button to get all advanced profile parameters
  • Query on Alias field for DSMaxFetchArraySize and set the value to -1
  • Restart Siebel Server services

Beside ‘DSMaxFetchArraySize’, you check ‘Maximum Cursor Size’ property at Business Component level also. This property also restricts the number of records that Siebel CRM can fetch from server. If ‘Maximum Cursor Size’ property contains any value, it overrides MaxCursorSize parameter, defined in the configuration file. This parameter is applicable only on Oracle or DB2 database.

– Set ‘Maximum Cursor Size’ property value to -1 if you want records until Siebel encounters an end of file
– Set it to ‘0’ to get 10000 records
– If you set any number greater than 0, Siebel fetches that many number of records

Same as DSMaxFetchArraySize, this property also has performance impact. So before setting this property value to -1, check all other possibilities to avoid it.

If your Siebel application is using IBM DB2, then you need to check another two parameters – DSPreFetchSize and DSMaxCursorSize.

Do you have any question? Please feel free to comment below.

Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Goolge+.

<< The method IsPortableUIMode is not supported            Error has occurred executing a Sql >>

SBL-DAT-00323: The method IsPortableUIMode is not supported

The method IsPortableUIMode is not supported on Business Service ‘Web Engine State Properties’ (SBL-DAT-00323).

Reason:

This error pops up when users try to login into Siebel Open UI application without setting parameters properly.

How to fix:

To fix this issue, you set ‘EnableOpenUI’ and ‘HighInteractivity’ parameters’ values to TRUE.

Steps to set parameter values:

  1. Login into Siebel application as an Administrator
  2. Navigate to Application-Server Configuration and select the server on Servers view
  3. Query for the Application Object Manager (AOM) component on Component view for which you want to enable Siebel Open UI
  4. In the Component Parameter view tab, query below two parameters and set values as ‘TRUE’
    EnableOpenUI = TRUE
    HighInteractivity = TRUE
    For dedicated client, set these two parameters in the client cfg file.
  5. Logout from the application and restart the Siebel Server

Now you should be able to login into Siebel Open UI application with out any error.

If you still face the same error, please let us know.

Do you have any question? Please feel free to comment below.

Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Goolge+.

<< SBL-DAT-00500 and SBL-EAI-04451                        Siebel High Interactivity Framework for IE >>

SBL-EDC-00190: Error occurred in creating the draft document

Error Message: Error occurred in creating the draft document.(SBL-EDC-00190)
Error Description: This error may occur when you are trying to generate documents in Siebel using ‘Auto Document’ button
Reason: The reason behind this error is that Siebel is not able to locate the file in file system to generate the document.

Solution: Perform below steps to fix this issue
1) Copy the template name that is throwing error
2) Go to  Administration-Document > Proposal templates and query for the template with category

3) If the template does not exist, create a new template with proper template file else upload the file once again for the column ‘Template File Name’.

For more updates, follow ‘TechOneStop‘ on Facebook/Twitter/LinkedIn or Join our website as Follower.
<< Error: SBL-EDC-00196 / SBL-DAT-00472                                                                                     Error: SBL-EAI-08032 >>

SBL-EDC-00196 / SBL-DAT-00472: Error occurred in generating the document structure

Error Message: 
         Error occurred in generating the document structure.(SBL-EDC-00196)
         Generic SSA NOTOK error message.(SBL-DAT-00472)
Error description: You face this issue when generating documents in Siebel using ‘Auto Document’ and ‘Generate Draft’ buttons.
Reason: The reason behind this error is that you don’t have any template, set as default of that category. For example, when you generate document from ‘Agreement’ using ‘Auto Document’ button, then there should be one default template in Admin-Document>Proposal template with category ‘Agreement’. If you do it from ‘Quote’, then category will be ‘Quote’.



Solution: Perform below steps to fix this issue
1) Decide the template which one you want to set as default template of that category
2) Goto Admin-Document > Proposal templates and query for the template with category
3) Check the ‘Default’ is true for the template


Now when you try to generate document, default template will come up first.
For more updates, follow ‘TechOneStop‘ on Facebook/Twitter/LinkedIn.
<< Error: SBL-EAI-04262                                                                                                                 Error: SBL-EDC-00190 >>

SBL-EAI-04262: Error writing XML to file

Error Description: Error writing XML to file ‘\TESTLogResponse.xml’ (SBL-EAI-04262)
Reason: This error comes up when \TESTLOG folder is not accessible from Siebel, either the folder is not added as parameter value for  ‘EAI File Transport Folder List’ or it is not shared properly.
Solution: Perform below steps to fix this issue

1) Go to Admin-Server configuration > Components and query for the parameter ‘EAI File Transport Folder List’, add the folder path under the column ‘Value on Restart’ (For expmple: \TESTLog) and restart the component.
2) Check the folder is shard or not, if not, then share the folder so that Siebel can access it


<< Error: SBL-EAI-50228                                                                                    Error: SBL-EDC-00196 / SBL-DAT-00472 >>