Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Report Builder

Report Builder Runtime Engine fails to generate the report

Using the Report Builder Table Interface

Using the MS SQL DataServer

RBREPORT table is located in the Microsoft SQL Server database

Using the -rbtabledb parameter indicate to the Report Builder Runtime Engine the database where the RBREPORT table is located

Errors generated vary depending on the value contained in the RB-DB-CONNECTION field in the RBREPORT table on the MS SQL Server

RB-DB-CONNECTION = <Null>:
Invalid database override parameter

RB-DB-CONNECTION = empty string:
Invalid value in RB-REPORT-LIBRARY
Invalid value in RB-REPORT-NAME
Invalid value in RB-PRINT-DESTINATION
Invalid value in RB-PRINTER-NAME
Cannot open library file <path>\reports.prl

RB-DB-CONNECTION = database override string (for example, "sqlholder => sqlholder~nsports2000 => sports2000"):
Report Database override to non existent Command-line database

Removing the -rbtabledb parameter results in the expected error:
Cannot open control file RBREPORT

Records can be written to and read from the RBREPORT table

Using the -rbtabledb parameter against an Oracle or AS-400 database works properly i.e. the RBREPORT table is located in the foreign database, -rbtabledb parameter is specified, and Report Builder generates the report as intended

FACT(s) (Environment):

Progress 9.1x
OpenEdge 10.0x
MS SQL DataServer

CAUSE:

Bug# OE00115779

FIX:

Option #1
Place the RBREPORT table in a separate Progress database

Option #2
Load the RBREPORT table in to the Schema Holder