Applies to:
Siebel Reports - Version: 7.7.2 [18325] and later [Release: V7 and later ]z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Professional)
Version: 7.7.2 [18325]
Database: Oracle 9i
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: HP-UX 11i
This document was previously published as Siebel SR 38-1594415341.
Symptoms
SBL-RPT-00107, SBL-EAI-04308We have a workflow that runs in the WfProcMgr which calls the Reports Business Service to run and download a report to the server. We have set the Actuate parameters for the WfProcMgr correctly to use the FinsObjMgr for report generation through the connect string parameter. When we initially deploy the solution, everything worked correctly. However after time we started getting the following error:Siebel Error Message SBL-RPT-00107: '%1' is not found,
or you do not have permission to access it. This error is triggered by the Actuate Reports Server
in the following cases:
1. The .ROX file or folder does not exist in the Reports Server
Encyclopedia or;
2. User does not have privileges to access the .ROX file or folder. Please
have the system administrator check the Reports Server for the .ROX file or folder. If it is
found, then administrator should check the privilege settings.I have logged into the thin client as sadmin (who the WfProcMgr runs as) and I can run the report with no problem by selecting it from the reports drop down so I know the report is there and that the privileges are set correctly. The communication between the WfProcMgr and Actuate stops working and does not start working again until we restart the Siebel Server that is running the WfProcMgr component.
Solution
It was found that the error was because the Actuate "Authid" is expiring after 24 hours. After bouncing Workflow Process Manager this behavior disappeared.Through investigation by enabling the workflow and EAI logging level, we can see the similar error error in the workflow log file:-
"SBL-EAI-04308:
Operation 'getFileDetails' of Web Service
'http://schemas.actuate.com/actuate7/wsdl.ActuateAPI' at port
'ActuateSoapPort' failed with the following explanation: "Soap Client
error".
ObjMgrBusServiceLog Error 1 0 2004-11-16
10:19:32 (outdisp.cpp (189)) SBL-EAI-04308: Operation
'getFileDetails' of Web Service
'http://schemas.actuate.com/actuate7/wsdl.ActuateAPI' at port
'ActuateSoapPort' failed with the following explanation: "Soap Client
error."
ObjMgrBusServiceLog Error 1 0 2004-11-16
10:19:32 (reportservices.cpp (4128)) SBL-RPT-00107:
'CNTKnowYourCust.rox' is not found, or you do not have permission to
access it.
Also we can see the "login session has expired. Please login again" message with error 6035 code, indicating that that Actuate authid has expired.
Instead of calling the Workflow Process Manager to invoke the report business service, the workaround will be as follows :
1) Continue to use the workflow process manager by setting the AuthIdExpires to a large value and recycle the process when the limit is reached. The value is controlled by ""AuthIdExpires"" parameter in the \Server\etc\acmetadescription.xml file which has a default value of 24.
2) The second more elegant solution is to use the users session within an OM to execute and run the report business service. This will ensure that as long as the user session is active in the Siebel application they will be able to run reports
The behavior was eventually resolved by :
1. running the Reports Business Services in the FINS Object Manager downloading that file and then creating an attachment record tied to an activity record with this report file.
2. Then call the WPM to run a workflow passing it the row id of the action record.
3. Then WF then queries for the action record and downloads the attachment to the WPM server.
4. Then creates the email with this file as an attachment.
Thank you.
Applies to:
Siebel Reports - Version: 7.7.2 SIA [18325] and later [Release: V7 and later ]Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.7.2 [18325] Com/Med
Database: Oracle 9.2.0.4
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9
This document was previously published as Siebel SR 38-1813637701.
Symptoms
SBL-RPT-00107HI,We are currently not able to get a specific set of automatic Reports generated on the Production Environment.
The Reports need to be demonstrated and need to be working on the Production Environment.
There are 2 Report categories namely KCI2 & KCI345 which are trigerred using a Workflow Process.
The expected functionality is as follows:-
1) Create an Order with a specific set of Field values populated.
2) Order gets stamped with specific Product Cell values based on the transition of certain fields.
3) A Report is triggered in the Background using a Workflow Process & the Report PDF file should be created & stored in the File system on the Server.
4) An activity should be created for that Order to indicate success or failure for created Report.
5) Report should be attached to Activity.
6) Activity also involves sending E-mail to a particular email id with status of the Report Creation & the report attachment in case of success.
Solution
When running Actuate report from Workflow Process Manager (WPM) through Report Business Service after one day of running reports following error would show up in the WPM log files:(outdisp.cpp
(189)) SBL-EAI-04308: Operation 'getFileDetails' of Web Service
'http://schemas.actuate.com/actuate7/wsdl.ActuateAPI' at port
'ActuateSoapPort' failed with the following explanation: "Soap Client
error.".
(reportservices.cpp (4128)) SBL-RPT-00107: 'BlueCellKCI2.rox' is not found, or you do not have permission to access it.After this error reports could not be executed until WPM server component or Actuate services would be restarted.
After some research it was established that cause of this behavior is the “AuthIdExpires" parameter in acmetadescription.xml on the actuate server. Default value for this parameter is 24 (hours).
To resolve this behavior please set “AuthIdExpires" in acmetadescription.xml on the actuate server to high number (for example 6 months 180x24hours).
Also change request number 12-VS3X2J has been logged to address this behavior.
Applies to:
Siebel Reports - Version: 7.7.2.4 SIA [18365] and later [Release: V7 and later ]z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.7.2.4 [18365] FRA Pub Sect
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Microsoft Windows 2003 Server SP1
This document was previously published as Siebel SR 38-2729911481.
Symptoms
HiWe have a particular error with our Workflow Process Batch Manager. It seems that the WfProcBatchMgr stops communicating with the report server. We get the following errors in the error logs :
ObjMgrBusServiceLog Error 1 0 2005-12-12
10:12:26 (outdisp.cpp (189)) SBL-EAI-04308: Echec de l'opération
'getFileDetails' du service Web
'http://schemas.actuate.com/actuate7/wsdl.ActuateAPI' sur le port
'ActuateSoapPort' pour les raisons suivantes : "Soap Client error.".
ObjMgrBusServiceLog Error 1 0 2005-12-12
10:12:26 (outdisp.cpp (189)) SBL-EAI-04308: Echec de l'opération
'getFileDetails' du service Web
'http://schemas.actuate.com/actuate7/wsdl.ActuateAPI' sur le port
'ActuateSoapPort' pour les raisons suivantes : "Soap Client error.".
ObjMgrBusServiceLog Error 1 0 2005-12-12
10:12:26 (reportservices.cpp (4114)) SBL-RPT-00107:
'RQAP_DEMANDE.rox' est introuvable ou vous
n'avez pas la permission d'y accéder.
L'erreur est générée par Actuate Report Server lorsque :
1. Le fichier ou dossier .ROX n'existe pas dans l'encyclopédie de Report Server.
2. L'utilisateur n'a pas les droits d'accès au fichier ou dossier .ROX.
Demandez à l'administrateur système de vérifier le fichier ou
dossier .ROX du serveur d'etats. Si ce fichier existe,
l'administrateur doit en vérifier les droits.
ObjMgrLog Error 1 0 2005-12-12 10:12:26 (stepexec.cpp
(768)) SBL-BPR-00162: Erreur de mise en œuvre du service 'Report
Business Service', méthode 'ExecuteReport' à l"étape 'Execute Report'.
ObjMgrLog Error 1 0 2005-12-12 10:12:26 (stepexec.cpp
(741)) SBL-BPR-00183: Erreur d'exécution de sous-processus 'Create
demande pdf attachment' à l'étape 'create pdf'.
ObjMgrLog Error 1 0 2005-12-12 10:12:26 (stepexec.cpp
(768)) SBL-BPR-00162: Erreur de mise en œuvre du service 'Workflow
Process Manager', méthode 'RunProcess' à l"étape 'Run WF'.
To resolve this problem, we shutdown and restart the WfProcBatchMgr
Solution
The behavior that you are experiencing is being caused because the Actuate authid has expired after 24 hours. After getting the error, the user won't be able to run a report through the Workflow Process Batch Manager. The report can only be run again once a restart of the Workflow Process Batch Manager or Siebel Server has been performed. A Change Request #12-VS3X2J has been raised for this behavior.This authid expiration is controlled by a parameter called “AuthIdExpires" parameter in acmetadescription.xml on the Actuate server. Default value for this parameter is 24 (hours). To resolve this, please set “AuthIdExpires" in acmetadescription.xml on the actuate server to high number (for example 6 months 180x24hours
Applies to:
Siebel Reports - Version: 7.8.2 [19213] and later [Release: V7 and later ]z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Professional)
Version: 7.8.2.3 [19221] DEU
Database: Microsoft SQL Server 2000
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Microsoft Windows 2003 Server SP1
This document was previously published as Siebel SR 38-3099876411.
Symptoms
We have the problem, that some reports work and some not.If I call a report in the activities, it is well created.
If I call a Contact list report I only get a gray window an find the following error in the Object manager log file:
2021
2006-07-24 11:57:40 0000-00-00 00:00:00 +0200 00000000 001 003f 0001 09
SSEObjMgr_deu 23996 1500 3856
D:\sea78\siebsrvr\log\SSEObjMgr_deu_23996.log 7.8.2.3 [19221] DEU
ObjMgrBusServiceLog Error 1 0 2006-07-24
11:57:40 (outdisp.cpp (192)) SBL-EAI-04308: Operation
'getFileDetails' von Web-Service
'http://schemas.actuate.com/actuate7/wsdl.ActuateAPI' an Port
'ActuateSoapPort' ist mit folgender Erkl�rung fehlgeschlagen: "Soap
Server error.".
ObjMgrBusServiceLog Error 1 0 2006-07-24
11:57:40 (outdisp.cpp (192)) SBL-EAI-04308: Operation
'getFileDetails' von Web-Service
'http://schemas.actuate.com/actuate7/wsdl.ActuateAPI' an Port
'ActuateSoapPort' ist mit folgender Erkl�rung fehlgeschlagen: "Soap
Server error.".
ObjMgrBusCompLog Error 1 0 2006-07-24
11:57:40 (bcvrptexturl.cpp (629)) SBL-RPT-00107: 'ACLIST.rox' wurde
nicht gefunden, oder Sie haben keine Zugriffsberechtigungen. Dieser
Fehler wird vom Actuate Reports Server in folgenden Situationen
ausgel�st:
1. Die ROX-Datei bzw. -Ordner ist nicht in der
Berichtsserver-Enzyklop�die vorhanden oder; 2. Der Benutzer hat keine
Zugriffsberechtigungen auf die ROX-Datei bzw. -Ordner.
Wenden Sie sich an den Systemadministrator, damit er pr�ft, ob die ROX-Datei bzw. -Ordner auf dem Berichtsserver vorhanden ist.
Sollte dies der Fall sein, sollte der Administrator die Berechtigungseinstellungen �berpr�fen.
ProcessRequest ProcessRequestError 1 0 2006-07-24
11:57:40 (Symbolic URL: ReportsServerImmediateJob) to retrieve field
'Executable Name' from buscomp 'RS Immediate Job', the error message is
''ACLIST.rox' wurde nicht gefunden, oder Sie haben keine
Zugriffsberechtigungen. Dieser Fehler wird vom Actuate Reports Server in
folgenden Situationen ausgel�st:Solution
For the benefit of other readers,The customer has installed a non-ENU environment (DEU) and the default setting for the report parameters under user preferences was set to ENU. After changing the appropriate parameters to DEU the report generation works fine.
Enhancement request 12-1FEVOP6 was filed to set the parameters to the installed language (in case there is only one installed).
No comments:
Post a Comment