siebel-error: SBL-RPT-00107: '%1' is not found, or you do not have permission to access it.

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

Hi

We 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: 
&apos;RQAP_DEMANDE.rox&apos; est introuvable ou vous 
n&apos;avez pas la permission d&apos;y accéder. 
L&apos;erreur est générée par Actuate Report Server lorsque :

1. Le fichier ou dossier .ROX n&apos;existe pas dans l&apos;encyclopédie de Report Server. 

2. L&apos;utilisateur n&apos;a pas les droits d&apos;accès au fichier ou dossier .ROX. 

Demandez à l&apos;administrateur système de vérifier le fichier ou 
dossier .ROX du serveur d&apos;etats. Si ce fichier existe, 
l&apos;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).