SAP Knowledge Basis Article - Preview

2167712 - Migrated Crystal Reports based on Business views fail with connection error on refresh.

Symptom

  • Migrated Crystal Reports which are based on BVs fail when freshed (BI LaunchPad or Crystal Reports 2013 desktop app) or schedules.  The error message if refreshing is "The viewer could not process and event. Failed until opened the connection <Report Title>"
  • This Intelligence Connection causes no problems in the source XI 3.1 system. The problematic behavior is observed in BI 4.1 when an Economic Viewing (and dependent repository objects) will brought into BI 4.1 via UMT is through manual export and import of XML using the Business Review Senior your application.  How to create a Business View using Business View Manager
  • Crystal reports are emigrated after XI 3.1 SP04 Patch 2 to BI 4.1 SP05 & above using the UMT and the UMT CSV/logs reported no errors.
  • Error on report refresh :  Logon to underlying user failed [] Error code:0 [CRWEB00000119]".
  • While scheduled, which failure message is "Failed to free the connection. <random rpt file name>. Details: "Logon to underlying database failed".
  • The my may does dynamic prompts. Data Relationship since BV passes all tests.
  • while we can 'browse data' efficiently in Intelligence Connection and Data Foundation from within BVM. But we cannot 'browse data' from tables in CR2013. Creating a view from within Crystal bericht - Business Objects ...
  • Ensured that everyone has proper rights to Data Connection within BVM. 
  • The issue cannot be fixed by Re-saving moved Data Connectors, Product Foundation, Work Elements, and Business Views.  or Re-saving report since within CR2013.
  • The Crystal reports based-on on direct database connections have cannot refresh or scheduling problems


Read more...

Environment

  • XI 3.1 SP4 patch 2  / Clear Report 2013 on Solaris 9 (Source system)
  • BI4.1 SP4.x & SP5.x  / Crystal Mitteilungen 2008 on Solaris 10 (Target System)
  • How Management Tool (UMT) , Business View Manager (BVM)
  • Data Connections are bases on an Oracle 11G schema.
  • XXX 3.1 your application 32-bit Oracle 11.1.0.6.0 teamsters.
  • BI 4.1 server uses 64- & 32-bit 11.2.0.1.0 drivers.

 

Product

SAP BusinessObjects Business Intelligence platform 4.1

Accesses

KBA , BI-BIP-UMT , Upgrade management tool , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this cover

This is an preview of a SAP Know-how Base Article. Mouse more in access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notebook both KBA Search.