SAP Knowledge Base Article - Public

1217461 - Error: "Failed to open a rowset" after saving input parameter in OLEDB query

Symptom

  • An input parameter is added (or edited) to a hierarchical OLEDB query (chaptered rowset).
  • Attempt to save the parameterized hierarchical query.
  • Error: "Failed to open a rowset."

Cause

This known issue has been assigned Track ID ADAPT00287971, and affects the following:
  • Crystal Enterprise (CE) 10
  • Crystal Reports (CR) 10
  • Crystal Enterprise Report Application Server (CE RAS) 9
  • Crystal Reports (CR) 9

To determine if this issue is also addressed in a Monthly Hot Fix or Service Pack for your Crystal product, search the readme file for Track ID ADAPT00287971 in the latest Monthly Hot Fix or Service Pack.

Resolution

Hot Fixes or Service Packs address this issue as indicated below. With the update(s), parameter(s) can now be added to a hierarchical OLEDB query when using Crystal Reports and OLE DB providers (for example, Lawson OLEDB Query Builder).

Known limitations: When saving the query and returning to the Database Expert, initialize all parameter default values so the initial query produces a non-empty rowset. Crystal Reports requires a non-empty parent rowset to build child rowset schema information for the hierarchical query. An empty result set while editing will still result in the error "Failed to open rowset".

Unless indicated otherwise, Weekly Hot Fix updates from the FTP site have only been tested with English versions of our products.

CAUTION

Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, refer to the OEM PRoduct Warning.
Crystal Reports 10

For Crystal Reports 10 for Windows, the latest update for this issue is available in the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • Crqe.dll, version 10.0.5.873, dated 8/6/2004
  • Crqe.pdb, dated 8/6/2004
  • Crqe_res_en.dll, version 10.0.5.872, dated 8/5/2004
Crystal Enterprise 10
This issue is addressed in the following components (and later versions):
  • Crqe.dll, version 10.0.5.873, dated 8/6/2004
  • Crqe.pdb, dated 8/6/2004
  • Crqe_res_en.dll, version 10.0.5.872, dated 8/5/2004
Crystal Reports 9

For Crystal Reports 9, the update for this issue is included in the CR 9 Developer Program Files and the CR 9 Main Program Files Weekly Hot Fixes (WHF). These are available in English only in the Downloads area of our web site.

This issue is addressed in the following components (and later versions):
  • Crqe.dll, version 9.2.1.622, dated 5/24/2004
Crystal Enterprise Report Application Server 9

For Crystal Enterprise Report Application Server (CE RAS) 9, the update for this issue is included in the Report Application Server (RAS) 9 Weekly Hot Fix (WHF). This is available in English only in the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • Crqe.dll, version 9.2.1.622, dated 5/24/2004

See Also

Monthly Hot Fixes and Service Packs for Crystal products are found in the Downloads area of our web site.
For more information on the issues addressed in the Hot Fix or Service Pack, view the readme PDF or text file included in the ZIP or TAR file.
For more information on the different update types, refer to our Hot Fix and Service Pack FAQ.

Keywords

CR WHF 287971 PARAMETER QUERY FAILED TO OPEN ROWSET Crystal Reports Hierarchical OLEDB query Error Message , c2015670 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports 9.0