Kbase P126388: RB. Cannot migrate existing reports from Progress to MS-SQL Server DataServer.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2007 |
|
Status: Unverified
FACT(s) (Environment):
Windows
Progress 8.x
Progress 9.x
SYMPTOM(s):
Cannot migrate existing reports from Progress to MS-SQL Server DataServer.
Cannot open an existing Report Builder library, created with a Progress database, against MS-SQL Server DataServer
Cannot access existing reports with MS-SQL Server 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 MS-SQL Server database using a DataServer.
CAUSE:
Connection to a DataServer requires two DB's, the holder and the logical DB.
FIX:
In this sample:
- The Progress database is named sports.
- The MS-SQL Server database is named msssports
- The ODBC DSN name is dsn_msssports
- The Service name for the _probrkr is mssService
- 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 MS-SQL Server 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 dsn_msssports -dt MSS -ld msssports -S mssService -H hostname -U userid -P password
3) Change the master table, using the one which is stored in the MS-SQL Server 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 MS-SQL Server 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 MS-SQL Server 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 MS-SQL Server 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"