Getting error message when trying to validate relationship in FM

[danii64]

Happy Tuesday Guys,

I'm working on a new model where I imported bunch of tables and went through the properties to define their usage and now I'm creating relationship between them, it validates the relationship and when I click on the relationship SQL, where the SQL is generated but when I click on the "Test" button to get some data from both tables' it  gets hung up there and after about 5 minutes or even longer gives me the follow error message: XQE-GEN-0002 An Unexpected  exception occurred. No other details are given.

I have made the the datatype for both keys are the and and the the cardinality is 1:1.
Also, when i validated tables individually and ran for the test sample data, they all returned data.

Any help is greatly appreciated!

[the6campbells]

look at the most recently updated log in  <cognos>\logs\xqe. high probability of a Java exception being thrown.