SBL-EAI-04224: Unable to open file '%1'

Applies to:

Siebel Pharma Call Center - Version: 8.0.0.3 SIA [20416] and later [Release: V8 and later ]

Information in this document applies to any platform.



Symptoms

From time to time it is not possible to create large amount of documents using EAI.



Steps:

---------

The error occurs at customer site when trying to create documents during intensively tests with a few dozen to >100 calls per few minutes. It happens sometimes only.

New documents are created in Siebel by sending inbound webservices from external application to Siebel.



Error:

-------

(filetransport.cpp (344)) SBL-EAI-04224: Cannot open file C:\Siebel\siebsrvr\temp\.tmp and

(eaiobjinst.cpp (3418)) SBL-EAI-04224: Cannot open file



Cause

The cause of this behaivor was due to special characters like brackets [ ... ] or forward slash / being used in document names like this:

new document name like this : Massenmailing [hier nicht klicken]_eBus_POINT Plus_Anmeldung_NK /Signatur_20101028-144045484



Solution

Advise users to avoid special characters in document names being sent to Siebel.



















Applies to:

Siebel CRM - Version: 7.8.2 SIA [19213] to 8.0 SIA [20405] - Release: V7 to V8

Sun Solaris SPARC (64-bit)

Sun Solaris SPARC (32-bit)

Solaris Operating System (SPARC 64-bit)Solaris Operating System (SPARC 32-bit)

Area(s):System Administration, Siebel EAI

Release(s):V7 (Enterprise), V7 (MidMarket), V7 (Professional)

Database(s):All Supported Databases

App Server OS(s):Solaris

Latest release tested against:V7 (Enterprise)

Keywords:fopen, cannot open file, unable to open file, zero, empty



This document was previously published as Siebel Alert 1025.

Description

While running the Siebel server on the Solaris platform, Siebel server components such as the Siebel Object Manager might encounter behaviors when writing or opening files. The Siebel process is attempting to write data to a file, the process will create the file, but the file will be zero bytes in size even though there is enough disk space available on the disk drive.



The root cause of these behaviors is that the Solaris fopen call will only allow a maximum of 256 open files per process. Sun Microsystems has stated they cannot fix this limitation as it will break their backward compatibility guarantee.



Review the following document located on Sun Microsystems "Sunsolve" website for details:



#01406 - Maximum number of open files







Likelihood of Occurrence

This behavior only occurs on a Siebel server running on the Solaris platform. Frequency of occurrence varies depending on the type and frequency of file operations used. This behavior appears randomly or sporadically but is more likely to occur with a higher volume of users.





Possible Symptoms

Symptoms of this behavior may occur in any operation in the Siebel application that reads or writes to a file. These include but are not limited to the tasks listed below:



Invoke the "EAI File Transport" business service.

Invoke the "EAI XML Write to File" or "EAI XML Read from File" business services.

In the Siebel UI, use the File > Export or File > Import utilities.

Use a custom business service with Clib.fopen, Clib.fclose or Clib.fprintf routines.

Open web templates (*.swt files).

Additionally, the following errors have been reported in the Siebel Object Manager log files:



SBL-UIF-00276: Cannot open file: %1

SBL-EAI-04224: Unable to open file '%1'

If the same Siebel process is attempting to write data to a file, it may create the file but the file itself will be empty, or in other words, 0 bytes in size. The Siebel server component's log file may be empty as well.



To look for empty files in a directory, use the find command below:



find . -size 0c







Workaround or Resolution

Below are some workarounds that you can implement to reduce the likelihood of encountering this behavior:



Turn off all extra logging for this Siebel Object Manager component (if possible, back to the default settings). This will reduce the number of log files opened and written by this component.



Decrease the number of tasks for each Siebel Object Manager process by increasing the number of MaxMTServers. For example, if you currently have MaxTasks=600 and MaxMTServers=6, you may want to change those values to MaxTasks=600 and MaxMTServers=10. This will reduce the ratio of tasks from 100 to 60 tasks per Siebel Object Manager process, which in turn will reduce the number of log files opened and written by this process.



NOTE: The numbers listed above are for demonstration purposes and you must adjust your own values based on your Siebel environment. Generally, increasing the number of MTServers per Siebel Object Manager component will result in more memory used by the Siebel server. This workaround should be thoroughly tested in a Test environment before implemented in a Production environment.



For Solaris 10 update 4 or above, the problem can be resolved by performing following steps:



1. Update .profile on Siebel Application Server as follows:



ulimit -n 2048



export LD_PRELOAD_32=/usr/lib/extendedFILE.so.1:$LD_PRELOAD_32



2. Restart Siebel Servers



The extendedFILE.so.1 is not a library but an enabler of the extended FILE facility. Preloading extendedFILE.so.1 is the right solution for the 32-bit file descriptors limitation. Please check the following technical article for detailed information: http://developers.sun.com/solaris/articles/stdio_256.html.



Once extendedFILE library is preloaded, the number of OM processes can be reduced to 10.























Applies to:

Product Release: V7 (Professional)

Version: 7.8.2.4 [19224] FRA

Database: Oracle 10.2.0.1

Application Server OS: IBM AIX 5L 5.3

Database Server OS: IBM AIX 5L 5.3



This document was previously published as Siebel SR 38-3336702721.



Symptoms

Hi,



I'm trying to import admin data (PDQ, views, state-models) with the ADM. But I get the following errors.



(filetransport.cpp (461)) SBL-EAI-04224: Impossible d'ouvrir le fichier '/script/siebint3/livraison/rt-data/ADM/1-1TQBO_LOV.xml

SBL-EAI-04261: Erreur lors de l'obtention XML du fichier '/script/siebint3/livraison/rt-data/ADM/1-1TQBO_LOV.xml

(stepexec.cpp (803)) SBL-BPR-00162: Erreur de mise en œuvre du service 'EAI XML Read from File', méthode 'ReadXMLHier' à l"étape 'Read from File'.

Erreur de mise en œuvre du service 'EAI XML Read from File', méthode 'ReadXMLHier' à l"étape 'Read from File'.(SBL-BPR-00162)

(stepexec.cpp (803)) SBL-BPR-00162: Erreur de mise en œuvre du service 'UDA Service', méthode 'Import File' à l"étape 'Import File'.

Erreur resignalisée depuis le gestionnaire d'objets: ([1] Erreur lors de l'obtention XML du fichier '/script/siebint3/livraison/rt-data/ADM/1-1TQBO_LOV.xml'.(SBL-EAI-04261) (IDS_EAI_ERR_XMLPRT_FILE_READ_ERR))

Erreur resignalisée depuis le gestionnaire d'objets: ([2] Impossible d'ouvrir le fichier '/script/siebint3/livraison/rt-data/ADM/1-1TQBO_LOV.xml

'(SBL-EAI-04224) (0x8085))

( (0) err=4300107 sys=32901) SBL-OMS-00107: Erreur resignalisée depuis le gestionnaire d'objets: ([2] Impossible d'ouvrir le fichier '/script/siebint3/livraison/rt-data/ADM/1-1TQBO_LOV.xml

'(SBL-EAI-04224) (0x8085))

( (0) err=4300107 sys=33405) SBL-OMS-00107: Erreur resignalisée depuis le gestionnaire d'objets: ([1] Erreur lors de l'obtention XML du fichier '/script/siebint3/livraison/rt-data/ADM/1-1TQBO_LOV.xml

'.(SBL-EAI-04261) (IDS_EAI_ERR_XMLPRT_FILE_READ_ERR))

( (0) err=4300107 sys=32984) SBL-OMS-00107: Erreur resignalisée depuis le gestionnaire d'objets: ([0] Erreur de mise en œuvre du service 'EAI XML Read from File', méthode 'ReadXMLHier' à l"étape 'Read from File'.(SBL-BPR-00162) (0x80d8))

(bsvcmgr.cpp (364) err=4300203 sys=0) SBL-OMS-00203: Erreur 32984 d'appel de la méthode "RunProcess" pour le service commercial "Wor...



Solution

Message 1

Customer was imporgting data with ADM but was encountering various errors indicating file access issues..

Such as

SBL-EAI-04224, SBL-EAI-0426, SBL-BPR-00162



Customer found hat the issue was caused due to control character " ^M" at the end of of lines in the .ini files. Typically occurs when transfer files from windows to unix







keywords:

SBL-EAI-04224, SBL-EAI-0426, SBL-BPR-00162,filetransport.cpp,ADM,import,unix,control,character

תגובות

פוסטים פופולריים מהבלוג הזה

Profile Attributes and Open UI

SBL-BPR-00191: The rowId of the active row of the primary buscomp '%1', '%2', does not match the Primary Id

SBL-SVC-00150