Query Subject with Status Invalid (XQE-CON-0006)

[emarshah]

Hi all,

         I have created a new project in framework manager, added a datasource connection (connects successfully). I want to create a query subject item of type data source (Tables and Columns), when i select a table and columns and Validate it . It gives me the following error;

"XQE-CON-0006 Unable to establish connection to XQE"

When I save this object, the Query subject item added is with Invalid Status , so it can't be used in packages and eventually can't be published over Cognos Connection. Any help or guess will be highly appreciated.

BR,
Ammar

[emarshah]

I was going through following post

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014781888

and as mentioned here;

As a first step lets determine whether this is the interaction between IBM Cognos Framework Manager(FM) and the QueryService or whether its the QueryService and its associated components. Please create a new FM model using the compatible query mode(CQM). The model should consist of 1 table imported from the IBM DB2 database that you are going to use. Publish the package using the dyanmic query mode (DQM). Then using IBM Cognos Report Studio, create a simple list report to retrieve data.If this works, then your JDBC setup, lic file and the queryservice is functioning normally and we need to shift focus to the windows FM install.

I created project without selecting Dynamic Query Mode in first and when i tested it worked fine. I am going with this right now for performing my sample tests.

[Grim]

Just FYI...
XQE is the backend engine for DQM.
CQE is the regular non-DQM "Classic Query Engine (aka Cognos Query Engine)".

[emarshah]

Hi Grim,

        Your posts are always informative! Thanks