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)
