Can not view/schedule Crystal Reports in new BOE XI 3.0 Installation

[Former Member]

Hello,

I'm having an issue on a brand new installation of BusinessObjects XI 3.0 on AIX 5.2 (using WebSphere 6.0). Installation went smoothly and migration went fine. Can log in, pull up CMC, InfoView (all other apps). But scheduled Crystal Reports (as well as viewing Crystal Report thru InfoView) are failing with the following errors (which to me seem interrelated):

*(1) Error in File ~cec0c55d91e0e015.rpt: The request could not be submitted for background processing*

*(2) Error in Report XXX: Failed to load database information*

*(3) An error occurred while creating a subprocess in the processing server. [RCIRAS0604]*

These three errors indicate to me that the report engines are having issues opening the files, pulling the data and generating the reports. We've checked to make sure that the account that BOE is running under has all the permissions it needs - and it has.

I just turned on tracing (-trace) on the report job processing servers and I'm watching the logs as I retrace my steps...

Any ideas? Would appreciate any feedback...

Thanks,

Will

[Former Member]

Does the suggested resolution work if BOE XI 3.1 is installed on Windows servers? I get this error when I try to preview a Crystal Report developed using the SAP Integration Kit and a BW query published to an iView on the SAP Portal. Report works fine in Infoview but not on the Portal.

[Former Member]

Turns out this is a pretty nasty issue on Unix environments. Being that the BOE application is developed on Windows then ported to Unix environments, the services (daemons) still end up depending on an emulated registry (MainWin) sort of like in a Windows environment.

For some reason (we're still trying to figure this out), the BOE registry entries got corrupted and then started preventing the processing servers (which in the case of CR ultimately depend on CRPE - Crystal Reports Print Engine) from opening up and processing CR files.

We engaged BusinessObjects/SAP support and have been able to resolve this issue on our test AIX system. The resolution included deleting all the mainwin (mw) tmp directories and files in the root temp directory and also in the

/bobje/enterprise120/aix_rs6000/crpe>

directory. Then we stopped all BOE services and reran the MW script to regenerate registry entries. This repair was a pretty intricate multi-step process. The SAP Technical Rep who worked on this case is writing a knowledge base article (an SAP note). Once I get details, I'll update this post.

The good news about this issue is that the upcoming SP1 of XI 3.0 removes the dependency on the mw registries...

Will

[denis_konovalov]

Corruption might happen when App server is running under different account than BOE servers.

XI3 Installation guide recomends running both BOE services and Application server under same account, which was used to install BOE.

[Former Member]

Courtesy of BusinessObjects Support:

How to clean up Mainwin and resolve Crystal page, job and RAS server error:

1. Stop all of the business objects services.

2. Insure that all services are stopped, particularly Xvfb and its children

3. Clean up any shared memory belonging to the XIR3 account using u201Cipcsu201D to view and u201Cipcrm u2013m [shmid]u201D to clean up

4. Remove all objects owned by the XIR3 user account in /tmp

5. Remove all objects from the [BOBJHOME]/tmp directory

6. Source the env.sh located in [BOBJHOME]/setup

7. Navigate to the [BOBJHOME]/enterprise120/aix_rs6000/crpe/mw/bin-aix4_optimized

8. Execute mwcleanup and answer yes to its question

9. Restart all services and test scheduling and viewing on demand

[Former Member]

Willi:

thanks for your steps, it resolved my problem

Thanks

Srini