The Viewer could not Process an event. Failed to open the Connection - Error Code:0 [CRWEB00000119]

book

Article ID: 36844

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

After Installing and Integrating CABI 4.1 with Spectrum 10.X, you may get an Error while generating Reports:

"The viewer could not process an event. Failed to open the connection. Current Assets: All[] ---- Error code:0 [CRWEB00000119]

<Please see attached file for image>

eRROR.png

Cause

This happens if the ODBC drivers are not configured properly during the Integration / Post Installation phase. You will have to perform an update content that CA Spectrum installs on Business Objects.

Environment

Spectrum 10.2 or below integrated with CABI 4.1 SP3 or below

Resolution

-> On the machine where SRM is installed, Navigate to "<SPECROOT>\Install-Tools\SRM-Tools\BIAR" folder and move all the files to another backup folder.

-> Make sure the "BIAR" folder is empty and does not have any files inside it.

-> Navigate to Spectrum One click Administration page and Access the Spectrum Report Manager Admin Tools.

-> Click on Administration -> Report Manger Tab to get the Report Manager Admin Tools option.

-> Select the Manage Business Objects Content option.

-> Click Update Content to update the existing content installed by CA Spectrum in Business Objects. Once complete, all Spectrum Report Manager content is re-imported.

<Please see attached file for image>

Update.png

 

Important! Wait for the process to complete. Do not navigate away from the page or cancel the process. You should see a message "Successfully Imported SPECTRUM content to BOXI".
 
-> Now move all the BIAR files which we made a copy back to "<SPECROOT>\Install-Tools\SRM-Tools\BIAR" Folder.
 
Launch Business Objects and now you should able to run the reports without any issues.
 

 

 

 

 

Attachments

1558686703223000036844_sktwi1f5rjvs16f1t.png get_app
1558686701193000036844_sktwi1f5rjvs16f1s.png get_app
1558686699128000036844_sktwi1f5rjvs16f1r.png get_app
1558686696236000036844_sktwi1f5rjvs16f1q.png get_app