Kbase P15825: RB. Cannot migrate existing reports from Progress to Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/28/2003 |
|
Status: Verified
SYMPTOM(s):
Cannot migrate existing reports from Progress to Oracle DataServer.
Cannot open an existing Report Builder library, created with a Progress database, against Oracle dataserver
Cannot access existing reports with Oracle DataServer.
Trying to open a Report
** Table _FILE does not exist or cannot be accessed. (962)
Report Builder.
CHANGE:
The Report has been developed on a Progress database. Now want to use against an Oracle database using a DataServer.
CAUSE:
The exact cause is unknown at the time of this writing.
FIX:
In this sample:
- The Progress database is named sports.
- The Oracle database is named orasports
- The Schema Holder is named shsports.
0) Choose, in report builder preference, the option "database connection on report open : prompt always"
1) Open the report, connect it to the progress database, but with the logical name: sports2
2) Now, add a connection to the oracle schema holder by pressing:
Report - Database connection - New Connection
use the parameters:
physical name : shsports
logical name: shsports
other parameters:
-S service -H hostname -db orasports -dt ORACLE -S oracleService -H hostname -U userid -P password
3) Change the master table, using the one which is stored in the oracle database by pressing:
Database- Master table
4) Save the report, and close it.
5) Open the report, but change the connection order:
5.1) The schema holder shsports, with same parameters than step 2
5.2) If you use some joins to some other tables (else than the master table) then connect to progress database sports with the logical name sports2.
5.3) The oracle database with default parameters.
If you DON'T use some joins to some other tables (else than the master table), go to point 8.
If you do use other tables, continue with the following steps.
6) Report builder tells you that it cannot find the tables used in the report. Give it the tables in the Oracle database.
7) Disconnect the progress database (sports, logical name: sports2)
8) Save the report.
Please note that when report has the multiple joins, you need to delete all the join pairs and then you will be able to choose the appropriate tables from the Oracle database by clicking the down arrow key under 'join to table' and create New Field pair.
After all the new joins are created, Disconnect the progress database. In this way all the fields will be there in the report as it was before.
9) After everything is done, you may want to be asked for database connection only when necessary. Choose, in report builder preference, the option "database connection on report open : prompt when necessary"