Handling Performance issues during CheckIn / CheckOut Process

Lets explore few basic troubleshooting steps required during performance issues related to CheckIn / CheckOut process using Siebel Tools.

1. Check if this problem is happening on all machines or single machine. Also check whether the all developers are affected or single developer. This step helps in isolating the root cause of the performance problem.

2. Check if performance issue occurs with all projects or just a specific project. If the performance issue occurs when user checkouts a table project, such as, Table Organization, Table Person, etc then the reason for slow response times is related to the check-out process with tables that contains a long column defined as a data type.

3. Sometimes slow performance during Checkin – CheckOut is due to Network. Therefore, it is necessary to involve network administrator in order to analyze how the network is utilized during check-out and/or check-in.

4. Depending on the size of the project, the check-in / check-out process might require some time. Do not interrupt the process, as doing so can leave your repository in an unstable state. If for any reason the check-in process is interrupted, perform it again to complete any unfinished tasks and unlock the projects on the server.

5. Check if server is running out of resources. It is a good idea to restart the server and see if that makes any difference in performance.

6. Check ODBC settings: Faulty ODBC settings may cause performance issues. Go to "Configure" on the ODBC settings (Navigate to Start >Programs >Administrative Tools >Data Sources (ODBC)) then test the connection.

For Oracle Database, verify that following ODBC setting in Siebel Tools and Siebel Server is done as per the information documented in the bookshelf

PacketSize = 0
EnableScrollableCursorsEnableScrollableCursors = 0
ColumnsAsChar = 1
ColumnSizeAsCharacterColumnSizeAsCharacter = 1

For details refer Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Installing Siebel Tools > Post installation Tasks for Siebel Tools > Verify Siebel Tools ODBC Data Sources.

7. Check if ODBC tracing has been turned on. If yes, turn off the ODBC tracing. This can be done via ODBC Data Source Administrator > Tracing tab. Re-start Siebel Tools after turning off ODBC tracing and see if there is any performance improvement.

8. Check to make sure that Siebel Server and Siebel Tools are on the same patch level.

9. 3rd Party Software:
Sometimes running Anti-virus software can cause issues with Checkin / Checkout.

10. If check-out/check-in operation is over the WAN then this could cause slow performance. There is no direct solution that can be implemented to increase the speed. Workaround in these cases would be:
-Remove any unused repository from the server database.
-Any project the developers in offshore center need to perform CheckOut/CheckIn constantly, break them up into smaller projects (i.e. by moving the object definitions into separate projects).

11. The number of redundant Siebel repositories in the database, can significantly slow down the performance. Any redundant repositories should be archived off and then deleted using Siebel Tools.  use Siebel Tools to review the 'Repositories' node in the Object Explorer, or run the following SQL:

select count(*) from S_REPOSITORY;

Note: Deleting repositories can take a long time to perform and is very CPU and database intensive. Deleting Siebel repositories directly via SQL is not supported. The only supported method is via Siebel Tools.

12. Missing or corrupt indexes in the database: Verify with the DBA that there is no missing or corrupt index in the database. When the database is imported, it can happen that the repository indexes may not have been created. This can be shown in the install logs, and will be reflected in poor performance for all parts of the application using the same tables. Similarly if any database index is missing or corrupted for any reason, the same will apply. If this is the case then  recreate the indexes.

13. It is extremely important to verify that the environment meets the recommended system requirements. Validate all the components of the Enterprise and confirm they meet all the requirements as documented in: Systems Requirements and Supported Platforms Guide (SRSP). Environment Verification Tool (EVT) is available to assist with this step.  
 

Tags