Thursday, October 4, 2012

SBL-RPT-00134: Could not connect to the Reports Server. Server: '%1', Volume: '%2'. Status : '%3'



Applies to:


Siebel Reports - Version: 7.5.3 [16157] and later   [Release: V7 and later ]
Information in this document applies to any platform.

Error Message Area:Reports - RPT

Version:Siebel 7.5.3



Purpose


This document is intended to provide cause and corrective action
information about Siebel Error Message SBL-RPT-00134: Could not connect
to the Report Server. Please contact your administrator. Status : %1





Scope


This document is informational and intended for any user.





SBL-RPT-00134: Could not connect to the Report Server. Please contact your administrator. Status : %1



Explanation


1. When using the Siebel Web client, the Siebel Server cannot access the
Actuate e.Reporting Server machine using the host name or port
specified.



2. The Actuate e.Reporting Server service is not running.



3. When attempting to synchronize a user from the Siebel application to
the Actuate e.Reporting Server, the error displays. Sometimes, this is a
symptom of another root cause; for example, if the Actuate Server
Report Server Host parameter is not set correctly and you attempt to
synchronize user(s), the error displays.



4. The EnableReportServer configuration parameter is not set correctly.



5. The local environmental variable does not have the appropriate locale
with the appropriate character encoding set. NOTE: This is specific to
UNIX platforms.


Corrective Action


1. Verify the Actuate Server Report Server Host parameter. Navigate to
the component parameters of the appropriate object manager. For example,
in Siebel application version 7.7, navigate to Administration - Server
Configuration > Servers > (select server) > Components >
(select object manager) > Parameters. Locate the Actuate Server
Report Server Host parameter and verify the value.



You may also try to ping the machine to verify connection.



NOTE: The case (capitalization) of some parameters related to Actuate
could affect the connection from Siebel to the Actuate e.Reporting
Sever.



For more information, refer to:

- Siebel Bookshelf version 7.7 > Siebel Installation Guide for
(select Microsoft Windows or UNIX): Servers, Mobile Web Clients, Tools
> Installing the Siebel Reports Server > Postinstallation Tasks
for the Siebel Reports Server > Enabling the Siebel Reports Server
with the Siebel Web Client.



- Siebel Bookshelf version 7.5.3 > Siebel Reports Administration
Guide > Installing the Siebel Reports Server for (select Microsoft
Windows or UNIX) > Postinstallation Tasks for the Siebel Reports
Server > Enabling the Siebel Reports Server with the Web Client



2. Verify that the Actuate Process Management Daemon service is started
correctly. In Actuate Management Console, log in to System
Administration with user name Administrator and the password defined
during the installation. Click System and verify that the system is
currently online. In some cases, the system is not online even though
the service is up and running. In this case, re-enter the license key
into the startup parameter and start the service.



3. Re-synchronize the users by navigating to Site Map > Reports
Server > User Administration, select the user and click Synchronize
One. Supply the user name and password.



You may also try to delete the user on the Reports Server, re-create the
user, and then attempt to synchronize the user in the Siebel
application.



For more information, refer to:

-Siebel Bookshelf version 7.7 > Siebel Installation Guide for (select
Microsoft Windows or UNIX): Servers, Mobile Web Clients, Tools >
Installing the Siebel Reports Server > Postinstallation Tasks for the
Siebel Reports Server > Synchronizing Siebel Users to the Reports
Server.



-Siebel Bookshelf version 7.5.3 > Siebel Reports Administration Guide
> Installing the Siebel Reports Server for (select Microsoft Windows
or UNIX) > Postinstallation Tasks for the Siebel Reports Server >
Synchronizing Reports Server Users.



4. Verify the configuration parameter, EnableReportServer, is set to True in the appropriate configuration file.



For more information, refer to:

-Siebel Bookshelf version 7.7 > Siebel Installation Guide for (select
Microsoft Windows or UNIX): Servers, Mobile Web Clients, Tools >
Installing the Siebel Reports Server > Postinstallation Tasks for the
Siebel Reports Server > Enabling the Siebel Reports Server with the
Siebel Dedicated Web Client.



-Siebel Bookshelf version 7.5.3 > Siebel Reports Administration Guide
> Installing the Siebel Reports Server for (select Microsoft Windows
or UNIX) > Postinstallation Tasks for the Siebel Reports Server >
Enabling the Siebel Reports Server with the Dedicated Web Client.



5. Verify the local environmental variable is set with the appropriate character encoding.

Here are two examples of setting the locale on UNIX platforms.



Example 1:

$ export LANG=en_US

$ export LC_ALL=en_US



Example 2:

$ export LANG=fr_FR.UTF-8

$ export LC_ALL=fr_FR.UTF-8








Applies to:


Siebel Reports - Version: 7.5.3 [16157] and later   [Release: V7 and later ]
IBM AIX on POWER Systems (64-bit)

Product Release: V7 (Enterprise)

Version: 7.5.3 [16157] ESN

Database: Oracle 9.2.0.4

Application Server OS: IBM AIX 5L 5.1

Database Server OS: IBM AIX 5L 5.1



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



Symptoms


SBL-RPT-00134We still have problems trying to run reports from Web Client (but it works from Dedicated
Client). We get the errror: Could not connect to the Report Server. Please contact your
administrator. Status:<?> SBL-RPT-00134

We have seen SR 38-1087004561 where it says
that the problem was due to a Locale issue, Could you tell us the correct settings for locales?do
we need to change (or export) some parameter on AIX where Report Server is running?

Thanks
in advance.






Cause


Configuration/ Setup


Solution



Message 1


For the benefit of other readers.



Customer found on SupportWeb SR 38-1087004561 where it says that the
problem was due to local environmental variables that were not set
correctly on their Sun Solaris environment and wanted to know if this
also apply to AIX environment.



It was found that the error message was also due to the same behavior on
AIX where the Local variables were not set correctly on the two
machines used.



One machine was hosting the Siebel Server and the other one was hosting the Report Server.



The behavior was resolved after installing UTF filesets on both machines
and establishing LANG and LC_ALL variables to ES_ES.UTF-8



Thank you and regards,










Applies to:


Siebel Reports - Version: 7.5.2.7 [15058] and later   [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000

Product Release: V7 (Enterprise)

Version: 7.5.2.7 [15058]

Database: Microsoft SQL Server 2000 SP 2

Application Server OS: Microsoft Windows 2000 Server SP 3

Database Server OS: Microsoft Windows 2000 Server SP 3



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



Symptoms


SBL-RPT-00134We just upgraded this development environment to version 7.5.2.200 and installed Actuate 6.0
SP1. I am trying to synchronize the Reports Administrator, but am getting connection errors as
described in the attached document.






Cause


Configuration/ Setup


Solution



Message 1


For benefit of other readers:



Customer tried to synchronize the Reports Administrator, but he received the following error message:

“Could not connect to the Report Server. Please contact your administrator. Status: ERROR_UNKNOWN_ERROR”



Reviewing his Object Manager parameters related to Report Server it was
found that the Actuate Server Report Server Host was not set correctly
according to Bookshelf > Siebel Reports Administration Guide >
Installing the Siebel Reports Server for Microsoft Windows >
Postinstallation Tasks for the Siebel Reports Server.



It was set as followed:

Actuate Server Report Server Host = DEV-SRS.qa.uone.shippers.com:8000 whereas it should be set

Actuate Server Report Server Host = DEV-SRS:8000

as the.qa.uone.shippers.com is the domain name from Actuate Report Cast Domain parameter.



In some testing it was also found that the case of some parameters
(related to Actuate) could affect the capability to connect from Siebel
to the Report Sever.



From customer’s files, the installation had in some places capital
letters (Actuate Report Server Host for example) and lower case in some
others (volume name or FQDN in eapps.cfg)



Changing the installation to have consistent case enabled customer to resolve the behavior.



Thank you,

Siebel Technical Support


Message 2


Search Keywords: Synchronize One, Actuate connection, Report Administrator








Applies to:


Siebel Reports - Version: 7.7.2 [18325] and later   [Release: V7 and later ]
Oracle Solaris on SPARC (64-bit)

Product Release: V7 (Enterprise)

Version: 7.7.2 [18325]

Database: Oracle 9.2

Application Server OS: Sun Solaris 8

Database Server OS: HP-UX 11i



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






Symptoms


SBL-RPT-00134Error message in the UI is as follows





Could not connect to Report Server. Server:<our
server>, Volume<our server>. Status:'<?>'. Please contact your system
administrator.(SBL-RPT-00134).


The following error messages are being generated from the
Actuate Server logs:

****0000000079*acsoapmessage.cpp*03043*08000*2005JUN07*11:44:36
Unsupported HTTP version:
****0000000079*acsoapworker.cpp*00317*08000*2005JUN07*11:44:36
AcSoapWorker::ProcessSoapError() Connection closed to the client, Soap HTTP exception



We
believe this may be related to changes that were made to the HTTP Protocol Business Service over
the weekend. Please refer to SR#38-2010964841 under our account.







Solution


For benefit of other Users:



To close the EAI HTTP Transport connection after every usage, customer
wrote a script on the PreInvokeMethod of 'EAI HTTP Transport' business
service by setting HDR.Connection= "close" as an input property.



This caused the Actuate reports to fail with the message as :

"Could
not connect to Report Server. Server:<our server>, Volume<our
server>. Status:'<?>'. Please contact your system
administrator.(SBL-RPT-00134)."



For reports we invoke "EAI HTTP Transport" each time we sent a SOAP
message to Actuate. So it is suggested that changes not be made in the
"EAI HTTP Transport" business service.



Customer removed the script changes in the "EAI HTTP Transport" business service and reports worked fine after that.








Applies to:


Siebel Reports - Version: 7.7.1 [18306] and later   [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000

Product Release: V7 (Enterprise)

Version: 7.7.1 [18306]

Database: Oracle 9.2.0.4

Application Server OS: Microsoft Windows 2000 Server SP 4

Database Server OS: Microsoft Windows 2000 Server SP 4



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



Symptoms


SBL-RPT-00134Hello,

I am facing some serious problems with our Actuate deployment here.

We are
running a multilingual system. Installed LEPs are ENU and DEU.
If I try to synchronize users
with actuate in the DEU Client. I get an error message.

Error code: SBL-RPT-00134
Which
states that a connection to the report server was not possible.

When I tried the sync in
the ENU client everything works well.
After the users are synchronized with Actuate I can
create reports in the ENU client but not in the DEU Client (Same Error Message). I face the same
behaviour on our merged development system too

I searched knowledgebase for this error and
got 2 hits. Both articles where about localisation issues. But unfortunately on Unix based
servers.

Here is a detailed description of the Server configuration. I will also attache
log files shortly.

OS: Win2k Srvr Sp4 ENU
Regional Setting: English(US)
Time Zone:
GMT+1 Berlin

Siebel Vanilla installation with both LEPs on all Components
(GTWY;DBSRVR,SRVR;RPRTSRVR)
Imported Sample Database over ODBC

Default language for
actuate: german
Time zone: GMT+1

Please understand that this configuration will be
pretty much the same on the production servers. The application will be hosted in germany. Most
users will be german speaking. its mandatory to have a english operation system for security
reasons. All parts of the application inclusive reports have to be available in german and
english.

Further more the actuate HTTP service did not start after I patched the
reportserver. I managed to get it running again after i deployed a backuped server.xml file in
the apache/tomact conf folder.

Any suggestions?
Please provide me with a general
aproach on how to configure reportserver in such an environment.

I am looking forward to
your answer and advice






Cause


Configuration/ Setup


Solution


For the benefit of other users:



Customer was running Siebel environment with two languages English and German.

Also customer was trying to execute reports through Actuate Server.



Reports were successfully executed every time on English object manager
but when run through German object manager following error would appear
in the object manager log file:



ObjMgrLog    Error    1    0    2004-07-22 15:43:34    (port.cpp (107))
SBL-EAI-04297: Protocol '' for port 'ActuateSoapPort' is not supported.

ObjMgrLog    Error    1    0    2004-07-22 15:43:34    (wservice.cpp
(146)) SBL-EAI-04307: No ports were initialized for Web Service named
'ActuateAPI' having namespace value
'http://schemas.actuate.com/actuate7/wsdl'.



After executing following SQL statement :



SELECT *

   FROM

       S_LST_OF_VAL T1

   WHERE

      T1.NAME LIKE 'SOAP_DOC_LITERAL'

   ORDER BY

      T1.TYPE, T1.ORDER_BY, T1.VAL

It was discovered that German seed data was missing from the database.
After importing German seed data, reports could be executed from both
object managers.



Thank you,










Applies to:


Siebel Reports - Version: 7.7.2.2 SIA [18356] and later   [Release: V7 and later ]
IBM AIX on POWER Systems (64-bit)

Product Release: V7 (Enterprise)

Version: 7.7.2.2 [18356] FRA Travel

Database: Oracle 9.2.0.6

Application Server OS: IBM AIX 5L 5.2

Database Server OS: IBM AIX 5L 5.2



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






Symptoms


We have finished to install and configure our Siebel Report Server but we have the
following error when we try to synchronize our reports users :

"Connexion impossible au serveur
de rapports. Serveur : 'ibm_infia.fnac.dom', Volume : 'infia.fnac.dom'. Statut :
'<?>'.Veuillez contacter l'administrateur.(SBL-RPT-00134)".


In spite of this error, it's
possible to connect to the Actuate Management Console.
After some research on My Oracle Support, we have found some solutions for this problem but they are not applicable in our
case.

Could you help me to solve our problem?

Below, we can find some information
about our environment configuration:
    * Actuate Server host name (with
component Actuate Active Portal, Actuate Server and Actuate Management Console) :
xxxxxxxx
    * Actuate Volume name :
xxxxxxxx
    * We can find on the
ActuateParameters_for_LoyObjMgr_FRA.xls file the Actuate parameter defined on our object
manager
    * We can find on the SymbolicURL_Host.xls file the definition
on our host in our environment
   
Best regards.







Solution


For the benefit of other readers:



This customer reported that they received the following errors when
trying to synchronize Siebel Users on the Actuate Report Server: -

“SBL-RPT-00134: Could not connect to the Report Server”



On further investigation, the following errors where found in the Object Manager Log file: -

“SBL-UIF-00335:
Nous ne sommes pas en mesure de traiter votre demande. Ceci est dû
probablement au fait que vous avez utilisé le bouton ARRIERE ou
RAFRAICHIR du navigateur pour atteindre cette page.”
“SBL-EAI-08027: Il n'y a pas de service Web sortant actif nommé “http://schemas.actuate.com/actuate7/wsdl:ActuateAPI'.”

“SBL-RPT-00134:
Connexion impossible au serveur de rapports. Serveur :
'xxxxx.xxxx.xxx', Volume : 'xxxxx.xxxx.xxx'. Statut :
'<?>'.Veuillez contacter l'administrateur.”



This indicated that the Web Services were not activated for Actuate.



We asked the customer to complete the following steps: -



1) Login into Siebel and navigate to Site Map >> Administration - Web Services >> Outbound Web Services

2) In the “Namespace” column query for “'http://schemas.actuate.com/actuate7/wsdl” and check if the status is “Active”.

3) If not, set the Status to Active and then try and synchronize the
user.The customer found that the Outbound Web Service for Actuate was
not active and when this was enabled the Siebel Users synchronized as
expected.



Further information on Outbound Web Services can be found in the section
'Outbound Web Services' of Chapter 'Web Services' of the 'Integration
Platform Technologies: Siebel eBusiness Application Integration Volume
II' document in Bookshelf.








Applies to:


Siebel Reports - Version: 7.7.2.3 SIA [18361] and later   [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows Server 2003

Product Release: V7 (Enterprise)

Version: 7.7.2.3 [18361] NLD Fin Svcs

Database: Oracle 8.1.7.4

Application Server OS: Microsoft Windows 2003 Server

Database Server OS: HP-UX 11.0



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






Symptoms


SBL-RPT-00134, SBL-EAI-04005Dear support,

After installing the report server, I cannot synch the users.

Tried
it from both dedicated and web client.

Attached the log file of our FINS NLD object
manager.

Please advice.

Best regards,






Solution


For the benefit of other users:



Error message in English is :

“Could
not connect to the Reports Server. Server: 'zl9b', Volume: ' ZL9B'.
Status : '<?>’. Please contact your administrator. SBL-RPT-00134”



To troubleshoot this issue, further information was required as follows:



1) Could customer login to the Report Volume named 'ZL9B' (in this case) via Actuate Management Console?

2) Had customer restarted the Siebel Server after setting parameters to enable the Report Server in Web Clients?

3) Can customer attach all Actuate logs located at Actuate7\Server\log
directory as well as an export of the Object Manager parameters of which
Actuate parameters have been set?



After checking this information: we recommended

1) Customer to only use CAPITALS for report server parameter values like:

ReportServerHost        = ZL9B

Instead of ReportServerHost        = zl9b



2) to make sure the error occurs when attempting to synchronize a user, by conducting the following test:



a) Stop Actuate Services and move all Actuate logs to another directory.

b) Start Actuate Services and take a look at encycsrvr7* logs if the above error is logged.

c) Login to a Web Client and try to synchronize a user to the Report Server and then check encycsrvr7* logs again for the error.



3) To check if the host name ' ZL9B ' is recognizable in network, please
do ping test with the host name only from the Siebel Server machine as
follows:



ping ZL9B



If the ping test fails, I would like to suggest consulting your network administrator for the host name in DNS configuration.



By looking at the log file the following error message was also found:

“Bad input for '%1': '%2' (SBL-EAI-04005)”



We request customer to try the following: -



1) Login into Siebel and navigate to Site Map >> Administration - Web Services >> Outbound Web Services

2) In the “Namespace” column query for “'http://schemas.actuate.com/actuate7/wsdl” and check if the status is “Active”.

3) If not, set the Status to Active and then try and synchronize the user.





But in fact the test that helps resolving the issue was to test
synchronization in the dedicated client using the standard srf, as in
this case it works.



Later on customer removed some custom script and it resolved the issue












No comments:

Post a Comment