Date Parameter in DRS

dshivnani
edited August 15, 2012 in Documentum #1

I have report created using crystal reports which has two date parameters, it runs fine CR client but when I import it into Webtop and run it , it throughs java.lang.NullPointerException with below error.

Somehow the date parameter as taken as NULL while there is no issue with String parameter.

We are using Documentum 6.6

DfException:: THREAD: http-8080-8; MSG: [DM_QUERY_E_SYNTAX]error:  "A Parser Error (syntax error) has occurred in the vicinity of:

at com.documentum.fc.client.impl.docbase.DocbaseExceptionMapper.newException(DocbaseExceptionMapper.java:57)

at com.documentum.fc.client.impl.connection.docbase.MessageEntry.getException(MessageEntry.java:39)

at com.documentum.fc.client.impl.connection.docbase.DocbaseMessageManager.getException(DocbaseMessageManager.java:137)

at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.checkForMessages(NetwiseDocbaseRpcClient.java:305)

at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.applyForCollection(NetwiseDocbaseRpcClient.java:429)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection$3.evaluate(DocbaseConnection.java:1183)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.evaluateRpc(DocbaseConnection.java:1054)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.applyForCollection(DocbaseConnection.java:1171)

at com.documentum.fc.client.impl.docbase.DocbaseApi.exec(DocbaseApi.java:83)

at com.documentum.fc.client.impl.session.Session.query(Session.java:3281)

at com.documentum.fc.client.impl.session.SessionHandle.query(SessionHandle.java:2249)

at com.documentum.fc.client.DfQuery.runQuery(DfQuery.java:164)

at com.documentum.fc.client.DfQuery.execute(DfQuery.java:208)

at com.documentum.oca.jdbc.jdbc20.ext.DjdbcStatementExt.executeQuery(DjdbcStatementExt.java:96)

at com.documentum.oca.jdbc.jdbc20.DjdbcStatement.execute(DjdbcStatement.java:408)

at com.crystaldecisions.reports.queryengine.driverImpl.jdbc.JDBCQueryDefinition.Execute(Unknown Source)

at com.crystaldecisions.reports.queryengine.driverImpl.jdbc.JDBCQueryDefinition.Execute(Unknown Source)

at com.crystaldecisions.reports.queryengine.Connecti on.bf(SourceFile:2954)

at com.crystaldecisions.reports.queryengine.Rowset.z3(SourceFile:944)

at com.crystaldecisions.reports.queryengine.Rowset.bL(SourceFile:533)

at com.crystaldecisions.reports.queryengine.Rowset.zM(SourceFile:245)

at com.crystaldecisions.reports.queryengine.Connection.a(SourceFile:776)

at com.crystaldecisions.reports.queryengine.Table.a(SourceFile:2234)

at com.crystaldecisions.reports.queryengine.Table.if(SourceFile:2161)

Comments

  • Jubedus
    edited August 15, 2012 #2

    Hi dshivnani,

       Usually, DM_QUERY_E_SYNTAX error is followed by the part of the query that caused the error. There is no query mentioned in your stack trace.

        Could you post the query here?

       If you're having problems using a date in the query then you may try filtering the results using Select Expert in CR.