I have done a fresh installation of 4.1 CABI and when am trying run servicedesk reports, am getting below error. please
Could you please attach the screenshot of the business objects services?
For the reports to run, the servers must be started and enabled?
Crystal Reports servers are not in the expected/required status. The servers must all be State=Running, Enabled=Enable is the Error messages reading in this case.
From the latest screenshot I checked that there are more than couple of services that are disabled. This needs to be Enabled for the previous to be removed.
It seems to be indicating that the Crystal cache server is not running. Please log into CMC, ensure that the Crystal Reports Servers have State=Running and Enabled=Enabled, and then retry running the report.
Let us know the results
when I try to restart the services, it shows like " Running with errors" and status " Disbaled"
this link have some solution: http://scn.sap.com/thread/3293233
some one may please help..
Have you tried to apply the latest CABI 4.1 SP5 Service Pack - ftp://ftp.ca.com/caproducts/CABI/CABI-4.x/SP5/Windows/
No, Let me try and get back to u.. Thanks a lot
On 21 Aug 2015 00:59, "Paul_Coccimiglio" <
Am getting below error after applying the patch.
type Exception report
message while trying to invoke the method java.util.Properties.entrySet() of a null object loaded from local variable 'globalProperties'
description The server encountered an internal error that prevented it from fulfilling this request.
java.lang.NullPointerException: while trying to invoke the method java.util.Properties.entrySet() of a null object loaded from local variable 'globalProperties' com.businessobjects.servletbridge.customconfig.Config.<init>(Config.java:37) com.businessobjects.servletbridge.customconfig.ConfigReader.getConfig(ConfigReader.java:370) com.businessobjects.pinger.TimeoutManagerFilter.getSessionState(TimeoutManagerFilter.java:203) com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:82)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.55 logs.
A probable Solution might be:
Remove or rename and backup Tomcat web directory when Tomcat is stopped. Then start Tomcat, wait 15 minutes until all stuff get redeployed to WORKDIR and CMC, BI Launchpad should work normally.
For example path: C:\Program Files (x86)\CA\SC\CommonReporting3\Tomcat7\work\Catalina\localhost
Let me know if this helps
could you please explain a little more on how to achieve this..
- Stop Tomcat
- Rename the LocalHost folder to something else in C:\Program Files (x86)\CA\SC\CommonReporting4\tomcat\work\Catalina
- Start Tomcat
Now am able to login in BI, but error persists as mentioned in earlier posts.
Could you test the ODBC connection as below from command line -
. CA Service Desk Manager Interactive SQL
. Start with command: connect userid*"password"@casd_<Servername>
Note: casd_<Servername> is the ODBC that has been created during the installation process either on 32-bit or 63-bit as per your environment
. Then standard SQL SELECT statements terminated with a semicolon
DataDirect OpenAccess SDK Interactive SQL (ODBC) Version 7.2
(c) Copyright 1995-2013 Progress Software Corporation. All rights reserved.
Program Locale: <Local locale>
ISQL> connect ServiceDesk*xxxxxxxxxxx!@casd_<Servername>
You are not connected to any database
Cannot execute the SQL statement
Elapsed time 7 ms.
Elapsed time: Prepare 0 ms. Execute 0 ms. Fetch results 0 ms.
ISQL> connect ServiceDesk*"************"@casd_<Servername>;
SQL: connecting to database: casd_<Servername>...
Elapsed time 52 ms.
ISQL> select* from pri;
id sym enum service_type delete_flag description last_mod
500 5 1 NULL 0 LOW Priority NULL NULL
501 4-Low 2 NULL 0 LOW Priority 2015-04-09 10:42:18
502 3-Medium 3 NULL 0 MEDIUM Priority 2015-04-09 10:41
503 2-High 4 NULL 0 HIGH Priority 2015-04-09 10:41:11
504 1-Critical 5 NULL 0 Critical Priority 2015-04-
09 10:40:45 10F1CCDFC9914D43
505 None 0 NULL 0 Priority unassigned NULL NULL
Rows selected = 6
SQL: Operation successful.
Elapsed time 15 ms.
Elapsed time: Prepare 3 ms. Execute 0 ms. Fetch results 5 ms.
Let me know you get the same results as above.
It is giving error like" command not recognized".. please help..
But am able to connect through sqlplus
There is no password defined in this case? I am referring to the screenshot provided and I don't see any password input.
Let me know how is the authentication performed?
password is typed over there, but it will not be visible...
Someone may pls help.
On 27 Aug 2015 18:15, "kusma07" <email@example.com>
Going back to the first suggestion - CMC -> Servers, do you see any servers there still in Disabled/Stopped state?
Is there any firewall on the system, maybe its blocking some of the connections into itself...
yes.. crystal cache server, is running but disabled state,
I checked into SAP knowledge base on this matter, and it appears that there are couple of reasons behind this behavior -
1) firewall blocking connectivity (assuming you have a firewall, maybe this is an item you could check)
2) license keys are invalid - Navigate to CMC > License Keys check if you have any specified there. If none, raise a CA Support ticket, we will supply one for you.
Retrieving data ...