Issues in Generating Crystal Report from Application Server

[Former Member]

Hi All,

We are facing issue while generating the crystal report,only a blank screen can be seen while generating the report. We checked all the infra < web/app/db and all connectivity b/w all ) and found everything fine. No network packets drops . We tried to generate the report from the crystal server and found some issue while generating the report. Later we figured out that the oracle client should be 32bit instead 64 bit was installed. We tried installing Oracle Client 32bit and found the connectivity from oracle client  to the DB. Also, we were able to generate the report from the crystal report. Tried to generate the report from app server but the issue persisted. Checked the app server manage server logs and found the below error :

Caused by: com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$AllServersDown: All the servers with CMS <ip>, cluster  and kind cms are down or disabled

Restarted the app and crystal report services still no go and the same error is reported in the app server logs. After further checking we found that the possible cause is the cluster name  and/or mismatch. Tired to change the cluster name to different possible options but still the same.

We tried assigning a specified port rather than auto assign, still see the same issue. We are using the weblogic as Application server on Solaris and Crystal report in windows server. There is firewall between this, and we open the ports raging from 6400-65535.

Please share your thoughts.

Thanks,

Sandhya

[Former Member]

update the host file entries and also disable the firewall temporarily. redeploy the crystalreportviewer app in weblogic. Hope you have checked the functioning of report in other web application (try with tomcat 6 / 7).

additionally, please let us know whether you are using 4.1 SP1 / SP2 along with weblogic 10.3.6. One of our SCN colleagues had a similar problem. If yes, raise this to support. Issue can possibly be related with weblogic version compatibility with bi 4.1

GOOD LUCK!!

[Former Member]

When you say a blank screen, do you mean you get a Crystal Report viewer page with no content at all, where the report data should be? Or do you see the table for the report, but no data?

Also do you have the sample reports deployed? Can you see those?

Have you tried with different browsers (IE, Firefox, Chrome)?