Skip to Content
avatar image
Former Member

Universe refreshing issue

We have issue with universe refreshing. Whenever a table changed in database, we have to refresh the universe to reflect the table changes. After the universe is refreshed, the crystal report based on the universe will not work properly. The mapping of columns from universe and fields in report is lost and we have rebuild the report.

The BOE version is 11.5.

Crystal report version is 11.5

Does anyone know how to resolve this?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 15, 2010 at 04:17 AM

    Hi Xinchao, it depends on what kind of table change you are talking about. If you are adding more fields to the table, refreshing the table structure in the universe will not break the reports. But if you are changing existing fields, especially on field type, or if you are deleting fields, you will break the reports that are using those fields.

    In order to fix your report, you have to go back and find those fields. Check if they are still existing and in what format. You have to fix all the data fields first, then you have to remap them manually. Yes, it is a real pain. And that's why the data team has to work closely with the report development team, and not to make drastic change to the table blindly.

    Hope this helps.

    -


    If you are using the BusinessObjects tool, you should join [ASUG|www.asug.com]

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 14, 2010 at 09:40 PM

    Moved to Universe Designer forum

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 10, 2015 at 08:44 PM

    You can edit your connection to disconnect after each transaction to make sure the correct connection is used.

    In the universe, you can select all tables in the graphic panel, right click and rename,

    this brings up the owner and qualifier. Make sure these are entered correctly then save.

    all tables in the graphic panel should have the same owner qualifier.

    Add comment
    10|10000 characters needed characters exceeded