Kbase P32137: Cannot Open Report Builder Report After Database Schema Chan
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/07/2003 |
|
Status: Unverified
SYMPTOM(s):
Cannot Open Report Builder Report After Database Schema Changes
New table contains the field <field> that field name is already in use
Cannot find related table <table>. Re-select table?
Using calculated fields in report with the same name as the new fields in the database
CHANGE:
Adjustments to database schema; new fields added etc.
CAUSE:
There are 2 fields with the same name not in the schema table or database but in the report itself.
FIX:
Use the following steps to resolve this issue:
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.