Not able to get all fields using mongodb jdbc sql query in TIBCO 7.1

[varun_5]

Following is the quuery that I am running in the dataset query tab: 

SELECT * FROM "database"."table"  
WHERE "duration"=201680

 

Following is stack trace: 

 

net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query:

SELECT * FROM "database"."table"  
WHERE "duration"=201680

    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:528)
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:297)
    at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFieldsProvider.java:68)
    at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(JDBCDataAdapterDescriptor.java:70)
    at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGetFields(DataQueryAdapters.java:487)
    at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQueryDesignerContainer.java:49)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
Caused by: java.sql.SQLSyntaxErrorException: [TibcoSoftware][MongoDB JDBC Driver][MongoDB]syntax error or access rule violation: column not found: DURATION
    at tibcosoftware.jdbc.mongodbbase.ddcl.b(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddcl.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddck.b(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddck.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbcloud.ddq.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbcloud.ddu.d(Unknown Source)
    at tibcosoftware.jdbc.mongodbcloud.ddu.g(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.dddc.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.dddt.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddez.b(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.dddt.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddt.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.BaseConnection.prepareStatement(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.BaseConnection.prepareStatement(Unknown Source)
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:384)
    ... 6 more
Caused by: tibcosoftware.mongodbcloud.sql.ddai: syntax error or access rule violation: column not found: DURATION
    at tibcosoftware.mongodbcloud.sql.error.dda.a(Unknown Source)
    at tibcosoftware.mongodbcloud.sql.ddbm.a(Unknown Source)
    ... 16 more

[varun_5]

There is duration key which is there in that table , but I never see it when I get  fields after writing the query