GeeKs Blogging @ dotCOM

Siebel Assets List view – Performance issue / Cannot display records

by Himanshu Bajpai

---

Assets Screen Load is a major problem in Siebel, and a major pain area for the concerned developer. I am sure many of you would have come across it in one implementation or the other.

If there are more than 10,000 records in Assets screen, vanilla Siebel Application will not load the screen.

Application will hang for some time and after that it will show an error message similar to the following -

“There were more rows returned than can be shown on the screen. Please ask the System Administrator for support.”

 In a typical CRM software, Order Management cycle, we start from an opportunity, and proceed to Quote, Order and finally a billable Asset in that Order. Then Asset to Opportunity, and the cycle repeats itself.

Assets are end results and in all probability, Assets are in million of numbers.

The problem being discussed is that the user has to see All Assets or some cases At least All Asset headers.

Approach 1-

If User can restrict his search, we can go in for a PDQ that return lesser number of records (<10000). This will ensure at least the first load is quick. However, on Blank Query it will again return the same error described above.

Approach 2 (Preferred Approach) -

So, if the developer needs a permanent solution to this problem, he can follow the steps below to show millions of assets without any error-

Login Siebel Tools>

Query for Asset Mgmt – Asset List Applet Applet.

Go To Applet User prop>search for “Disable Buscomp Hierarchy”.If it is set to “FALSE”, make it “TRUE”.  After compilation Assets screen will show millions of records without any error. Voila! Problem solved.

This property would be even more helpful for performance if used to show Asset Headers Only.

 

Please put in your comments. Feel free to add your solution, in case you have come across a different one.

Related posts:

1. Siebel Admin Mode Flag – II – Issue Log In the last post I described about Admin Mode Flag....
2. Siebel – Number of rows displayed in List Applet Siebel Web Client by default shows only the first 7...
3. Siebel – Looping multiple records – Update records Hi, We often come across a requirement where we need...
4. Login Failed in Dedicated Web Client : MVF Issue Recently I have met with the Problem in form of...
5. Siebel – Fetch Active view properties Hi, Working on a typical requirement recently, I came across...
6. Siebel – Fetch Active view properties – II We discussed about fetching the values from the active view...
7. Siebel – Fetch Active view properties – III I will discuss a practical example, and the corresponding Inputs...