SBL-SVC-00184 Error When Attempting to Add Attachments in Siebel Application

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: SBL-SVC-00184 Error When Attempting to Add Attachments in Siebel Application

Symptoms:
It was reported that end users were not able to add an attachment file or a correspondence model in the Siebel application.

The following error message was displayed:
"Error occurred while creating file in filesystem. Please contact your system administrator.(SBL-SVC-00184)"

A review of the application logs and the following error was seen:
In the database it was found that every data record in S_ACCNT_ATT had FILE_DEFER_FLG set to 'R'. This was found with the following query:
Error Error 1 2005-05-27 10:45:31 SQLError: sqlstate 23502: [IBM][CLI Driver][DB2/NT] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=6, TABLEID=5391, COLNO=9" is not allowed. SQLSTATE=23502

SELECT FILE_NAME, FILE_DEFER_FLG FROM S_ACCNT_ATT



Solution:



Cause
The cause of this was an incorrect specification of the Siebel File System pathname in the Siebel Server.
The Siebel File System pathname had been specified with a RELATIVE path.


1. On the database where the error message occurred, each row of S_ACCNT_ATT has FILE_DEFER_FLG = 'R'. The same values were found on a database where the attachment functionality works.

2. When trying to add an attachment to an account through the user interface the following error occurs:
'Not possible to find the file 'name.doc' in the system file specified (SBL-UIF-00230)'
When querying the record for the new attachment using SQL SELECT on the database the following values are found:

FILE_DEFER_FLG = 'R', but the columns FILE_DATE and FILE_SIZE are empty.
It was also observed that the corresponding compressed .SAF file was not created in the Siebel File System.

Solution
The solution for this behavior is to correct the definition of the Siebel File System pathname in the Siebel Server. This will eliminate the error message and allow attachments to be created by the end users.
The Siebel File System pathname must be specified with the complete absolute pathname.

For more information about defining the Siebel File System pathname please refer to the following documentation:
* Siebel Server Installation Guide for Microsoft Windows (Version 7.5.3 -> 8.1.1) > Preparing for the Installation > Planning Your Siebel Deployment > Creating a File System / Creating the File System
* Siebel Server Administration Guide (Version 7.5.3 -> 8.1.1) > Siebel Server Infrastructure Administration > Administering the Siebel File System >Moving the Siebel File System

References:

SBL-SVC-00184 Error When Attempting to Add Attachments in Siebel Application [ID 493885.1]

Get Oracle Certifications for all Exams
Free Online Exams.com