Kbase 21985: Cannot Open Report Builder Report After DB Schema Changes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/19/2002 |
|
SUMMARY:
When there are existing reports built in Report Builder and there is a need to make changes to the schema of the database, the reports should be re-opened and saved so that the tables used will be recognized.
Otherwise, trying to open a report will bring the message:
"New table contains the field <field> that field name is already in
use."
Followed by the message:
Cannot find related table <table>. Re-select table?
If you choose YES the list of database tables will appear.
If you select the table that is not being recognized, the first message will be repeated.
EXPLANATION:
This problem is due to the fact that there are 2 fields with the same name not in the schema table or database but in the report itself. There is a Calculated field with the same name as one of the fields added on the schema changes.
SOLUTION:
1) Create a separate temporary database with the table definitions of
the current one (with no data, just definitions).
2) Change the name of the field in the schema of the table that is
shown in the error message.
3) Open the report, change the connection information to the temporary
database.
4) Change the name of the calculated field and make sure that no other
calculated field is using it, otherwise there will be syntax errors
on those. Save and close the report.
5) Now test the report against the production database that still has
the field mentioned in the message. You should be able to open the
report and save it.
6) Test the applications that use this report.
7) Delete the temporary database.