ARForm report broken after upgrade from 10.1.600 to 10.2.400

Epicor ERP 10
21

How did you handle doing step #3 “Added all the tables and relationships to the RDDv2”? What is the best way to do this? Did you do a side by side comparison between the custom RDDv1 with the new generic RDDv2?

When I did this, RDDv1 already had all the tables and relationships but is still erroring out in the system monitor with “query execution failed for dataset arform”. Do I need to drill down into the calc fields to compare also and manually add those or is that part of step #9?

What’s the difference between step #3 and Step #9? I can’t run it to get the Database GUID.

22

Did you have to add the new calc fields also or just the data soucre tables?

23

#3, Documentation helps. I also compared the old to the new.

You have to start with the Base RDD replicated first.

After careful examining each error, you can then add the missing columns from the table relations or linked tables.

24

Where are you reviewing the error? In report builder?

25

Task Monitor.

26

From what I’ve seen, it only gives you a generic error ‘query executionf ailed for the dataset ARForm’. The first error I fixed and added the specific field indicated in the task monitor but once I added that calc field, it then gave me the generic query execution error with no specific field?

27

You have to examine the formula used for the calculated field in the old vs. new report. Is this a custom calc field?

28

No, it is a standard calc field in the original RDD. Calc_TotalAdvBillCred.

29

Check the out of the box RDD, make sure the Calc field is present under the Calculated Fields tab for the target table. Be sure the RDDv2 has the Calc field as well.