Troubleshooting the Integration

This chapter provides information on troubleshooting Siebel CRM Integration to Oracle FLEXCUBE Universal Banking. It contains the following topics:

Siebel CRM Log Files

Within the Siebel CRM environment, logging information is written to log files which can be used to troubleshoot problems. The following log files are available:

Siebel Server log files
Siebel Web server extension log files
Siebel events and event logging files

For information on the log files generated by Siebel CRM, see Siebel System Monitoring and Diagnostics Guide.

How Siebel CRM Handles Errors During Online Data Synchronization

This topic describes how Siebel CRM handles errors that occur during online data synchronization. During online data synchronization, in the event of an error, one of the following occurs:

Error messages are written to a log file.
Error messages are sent to Oracle FLEXCUBE Universal Banking.
Error messages are displayed on the user interface.

The error-handling mechanism that is used depends on the type of Siebel Web service that generates the error, as described in the following table.

Web Service Type	Operation	Error Handling Mechanism
Synchronous	Inbound Create or Query	The error message in the EBM format is transformed using the EAI XSLT Service and is sent to Oracle FLEXCUBE Universal Banking.
Synchronous	Outbound Query	The error message is retrieved from the response message using the FINS Industry XML Query Service, and is displayed to the user.
Fire-and-forget	Outbound Update	If a workflow failure occurs, then the Siebel Server logs the error message.
Fire-and-forget	Inbound Create or Update	An error message is written to a file using the EAI XML Write to File service. For additional information, see Online Data Synchronization Log Files.

Online Data Synchronization Log Files

Log files specific to the online data synchronization process are created if errors occur when inbound fire-and-forget Web services trigger create or update operations. Error messages are written to the files in the siebsrvr\log\ directory where siebsrvr is the Siebel Server installation directory. The name of the log file takes the following format:

		MessageId EBMShortName Operation.xml

where

MessageId is the numeric message identifier
EBMShortName is the abbreviation for the EBM
Operation is either Create or Update

For example:

		9110970000009273DAUpdate.XML

The following table shows the log files created for each integration object if errors occur during create and update operations.

Integration Object	Integration Object Short Name	Log File Name of Fire-and-Forget Service
Deposit Account	DA	MessageIdDAUpdate.XML MessageIdDACreate.XML
Loan Account	LA	MessageIdLAUpdate.XML MessageIdLACreate.XML
Customer Interaction (Activity)	CI	MessageIdCICreate.XML
Sales Opportunity (Lead)	SO	MessageIdSOCreate.XML
Service Request	SR	MessageIdSRUpdate.XML
Customer Party	CP	MessageIdCPUpdate.XML

Siebel Log Files During Batch Data Loading

This topic provides information on the Siebel log files generated during batch data loading using Oracle Data Integrator. After performing the batch data loading, check the following log files for errors:

Log table BIB_ODI_ERROR_LOG
If an error occurs while running the packages for the batch data loads, then the error message is logged in the table BIB_ODI_ERROR_LOG in the Siebel database. This table stores the following information about the error:
- Package name
- Step name
- Step type
- Error code
- Error message
- Created date
EIM log files
During the batch data loading, Oracle Data Integrator loads data from Oracle FLEXCUBE Universal Banking staging tables into Siebel EIM tables. Oracle Data Integrator starts the Siebel EIM jobs, using the Siebel Server Manager utility. If an error occurs in a Siebel EIM job, then a log file is created in the location you specified for the variable FINS_BIB_Log_Path. For additional information, see Configuring Integration Variables.
Check the log files for any errors during the Siebel EIM job processing.

Errors Generated by Oracle FLEXCUBE Universal Banking

For information on troubleshooting online data integration errors that result from problems with the way in which the EBO Direct Build Utility was configured, see the FCUBS EBO Direct Build Utility User Guide, which is provided as part of the Oracle FLEXCUBE Universal Banking documentation set.