We are converting all JD Edwards table to SQL Server. The following are the steps we are doing.

1) Load the JD Edwards tables to SqlServer 2008

2) Create Metadata against SQLServer

3) Create JDEdwards connection in WebFocus server

4) Refresh Metadata Repository using JDEdwards adapter

5) Converting Master Files using JDEdwards adapter


The issue I have is, after I converted the master file it creates lot of define fields. For example if I have 5 fields in a table, it creates another 5 define fields. The problem is when we run the report, the JOIN doesn't recognize those defined key field and it hangs. Once I commented the key field in master file and then run the report, it works.

Did anybody faced this issue? Am I missing anything here. Please let me know your suggestions and thoughts.

This message has been edited. Last edited by: Kerry,

Opened a case with IBI and found that this is the issue with the 7.7.03 version. IBI working on the patch.