(SBL-DBC-00111) ORA-01400: cannot insert NULL into ("SIEBEL"."S_ACTIVITY_ATT"."FILE_DEFER FLG")

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: file attachment error
[1] An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the file problem persists (SBL-DBC-00111)
[2] ORA-01400: cannot insert NULL into ("SIEBEL"."S_ACTIVITY_ATT"."FILE_DEFER FLG")

All the folders in the Siebel File System have read, write, execute access.


Symptoms:
Users are using the file menu to select the file. While selecting the file we're getting the same error. No manual typing in file name field.

Log files:
PSCcObjMgr_enu_0039_40894474_vanilla.log
(and this indeed has no custom colums searching for .X_)


SQLParseAndExecute Statement 4 00001a6e4c982962:26299 2010-09-22 11:15:00

INSERT INTO SIEBEL.S_SR_ATT (
CONFLICT_ID,
DB_LAST_UPD_SRC,
DB_LAST_UPD,
LAST_UPD,
CREATED,
LAST_UPD_BY,
CREATED_BY,
MODIFICATION_NUM,
ROW_ID,
PAR_ROW_ID,
FILE_AUTO_UPD_FLG,
FILE_DOCK_REQ_FLG,
FILE_NAME,
FILE_REV_NUM,
FILE_SRC_TYPE)
VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)

SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 1: 0
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 2: User
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 3: 09/22/2010 07:13:46
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 4: 09/22/2010 07:13:46
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 5: 1-38WZS
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 6: 1-38WZS
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 7: 0
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 8: 1-4XPHKH
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 9: 1-2JM67M
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 10: Y
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 11: N
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 12: test
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 13: 0
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 14: FILE
SQLParseAndExecute Execute 5 00001a6e4c982962:26299 2010-09-22 11:15:00 OCIStmtExecute: DML error or affected 0 rows
ObjMgrBusCompLog Error 1 00001a6e4c982962:26299 2010-09-22 11:15:00 (oracon.cpp (3255)) SBL-DBC-00111: An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.
SQLParseAndExecute Execute 5 00001a6e4c982962:26299 2010-09-22 11:15:00 ORA-01400: cannot insert NULL into ("SIEBEL"."S_SR_ATT"."FILE_DEFER_FLG")

ObjMgrSqlLog Detail 4 00001a6e4c982962:26298 2010-09-22 11:15:00
***** SQL Statement Write Time: 0.013 seconds *****



Solution:


The cause of all the error messages was an incorrect specification of the Siebel File System pathname in the Siebel Server. It was specified with a relative pathname.

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

Correcting the definition of the Siebel File System pathname in the Siebel Server will eliminate the error message. 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:

Workaround could be setting a postdefault of "R" for each *FileDeferFlg field in every *attachment business component to assure the required column is always populated

References:

Get Oracle Certifications for all Exams
Free Online Exams.com