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!
look at the most recently updated log in <cognos>\logs\xqe. high probability of a Java exception being thrown.