Siebel Installations >  Siebel Remote : Generate New Database Crash

Siebel Remote : Generate New Database Crash

APPLIES TO:
Siebel CRM - Version 8.1.1.6 [21233] and later
Information in this document applies to any platform.
SYMPTOMS
Generate New Database Component crash with the following call stack

/apps/siebelTH/cimb/ses_oneview/siebsrvr/lib/libsslcosd.so:0x4b344
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbtasks9_r.so.1:0x48dc
/lib/libc.so.1:0xcafec
/lib/libc.so.1:0xbf69c
/lib/libc.so.1:0xbf884
/lib/libc.so.1:__lwp_kill+0x8 [ Signal 6 (ABRT)]
/lib/libc.so.1:abort+0xd0
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0xdae3c
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0xd7ae4
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0x8e328
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0x71f4c
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0x5d0a4
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0x58324
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0x58064
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0x26c18
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0x30cc8
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:0x311b4
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9_r.so:SQLConnect+0x28
/apps/siebelTH/cimb/ses_oneview/siebsrvr/SYBSsa90/lib/libdbodbc9.so:SQLConnect+0xf0
The corresponding Gennewdb*.log has the following errors

SQLError Statement 0 00000006581030ff:0 2016-10-27 04:06:32 SQL Statement:

SELECT *
FROM SIEBEL.S_REPOSITORY
WHERE NAME = 'Siebel Repository'
DBCLog DBCLogError 1 00000006581030ff:0 2016-10-27 04:06:32 [DataDirect][ODBC Oracle driver][Oracle]ORA-03135: connection lost contact
Process ID: 16830
Session ID: 483 Serial number: 8737

GenericLog GenericError 1 00000006581030ff:0 2016-10-27 04:06:32 SQL Message, 08S01: [DataDirect][ODBC Oracle driver][Oracle]ORA-03135: connection lost contact
Process ID: 16830
Session ID: 483 Serial number: 8737

GenericLog GenericDetail 4 00000006581030ff:0 2016-10-27 04:06:32 Release exclusive write lock for /apps/siebelTH/cimb/ses_oneview/siebsrvr/dbtempl/db45r19.146/siebel.ddl in Gennewdb
GenericLog GenericError 1 00000006581030ff:0 2016-10-27 04:06:32 Error creating and/or reading DDL file (UTLDataExportSql)
GenericLog GenericError 1 00000006581030ff:0 2016-10-27 04:06:32 Error in MainFunction (ReadAndCreateDDLFile)
GenericLog GenericError 1 00000006581030ff:0 2016-10-27 04:06:34 (gennewdb.cpp (610) err=524292 sys=2) SBL-GDB-00004: Error in Main function.

CAUSE
The cause of the issue is permission access

23605: 52312.2059 mkdir("/var/run/tmp", 0777) Err#13 EACCES [ALL]
23605: 52312.2073 write(2, " * * * ", 4) = 4
23605: 52312.2092 write(2, 0xFEE2E790, 17) = 17
23605: A s s e r t i o n F a i l u r e
23605: 52312.2111 write(2, " * * *\n", 5) = 5
23605: 52312.2131 write(2, 0xFFBFEB30, 128) = 128
23605: F a i l e d t o c r e a t e d i r e c t o r y ' / v a r23605: / r u n / t m p ' : P e r m i s s i o n d e n i e d\n F i l
23605: e ' u t i l s / u n i x / u n i x m i s c _ r o o t . c ' a
23605: t l i n e # 7 3\n A b o r t i n g e x e c u t i o n . . .

SOLUTION
Make sure /var/run has a write access and user should able to create the directory.