Hi,

I have done a fresh installation of 4.1 CABI and when am trying run servicedesk reports, am getting below error. please

HI Khalid,

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

Hi,

when I try to restart the services, it shows like " Running with errors" and status " Disbaled"

Hi,

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" <

Hi,

Am getting below error after applying the patch.

HTTP Status 500 - while trying to invoke the method java.util.Properties.entrySet() of a null object loaded from local variable 'globalProperties'

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.

exception

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.

Apache Tomcat/7.0.55

Hi Khalid,

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

Hi,

Now am able to login in BI, but error persists as mentioned in earlier posts.

Hi Khalid,

Could you test the ODBC connection as below from command line -

C:\Windows>pdm_isql

.....................................

. 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>

Cont> ;

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

_dt last_mod_by

500 5 1 NULL 0 LOW Priority NULL NULL

501 4-Low 2 NULL 0 LOW Priority 2015-04-09 10:42:18

10F1CCDFC9914D43

502 3-Medium 3 NULL 0 MEDIUM Priority 2015-04-09 10:41

:56 10F1CCDFC9914D43

503 2-High 4 NULL 0 HIGH Priority 2015-04-09 10:41:11

10F1CCDFC9914D43

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.

ISQL>

Let me know you get the same results as above.

hi,

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?

Hi,

password is typed over there, but it will not be visible...

Someone may pls help.

On 27 Aug 2015 18:15, "kusma07" <communityadmin@communities-mail.ca.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...

_R

Hi Raghu,

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.

Thx

_R