Hi All,
We have migrating from Documentum 5.3 sp5 to Documentum 6.5 sp3,In Dql update statement working fine in 5.3 environment
String strQuery = "update dbo.rt_chapter_subchapter " +
" set last_update = DATE('" + formatter.format(date) + "', 'dd/MM/yyyy hh:mi:ss') " +
" where roman_representation = '" + bibleNumber.chapter +"' " ;
its working fine in 5.3 environment ,after migrating to 6.5 its giving error here i am giving stack trace.
Tue Jul 20 16:43:43 IST 2010 (Sreedhar M) INFO - Updating the last update time stamp for this treaty..
Tue Jul 20 16:43:43 IST 2010 (Sreedhar M) ERROR - Counld not update timestamp...
DfTypedObjectException:: THREAD: http-8080-1; MSG: [DM_API_E_BADATTRNAME]error: "Bad attribute name 'DQL_STMT'
at com.documentum.fc.client.impl.typeddata.LiteType.getAttr(LiteType.java:170)
at com.documentum.fc.client.impl.typeddata.LiteType.getAttrIndex(LiteType.java:225)
at com.documentum.fc.client.impl.typeddata.AbstractTypedData.getAttrIndex(AbstractTypedData.java:699)
at com.documentum.fc.client.impl.typeddata.AbstractTypedData.get(AbstractTypedData.java:130)
at com.documentum.fc.client.impl.typeddata.AbstractTypedData.getString(AbstractTypedData.java:160)
at com.documentum.fc.client.DfTypedObject.getStringRaw(DfTypedObject.java:652)
at com.documentum.fc.client.DfTypedObject.doGetString(DfTypedObject.java:620)
at com.documentum.fc.client.impl.collection.TypedDataCollection.doGetString(TypedDataCollection.java:91)
at com.documentum.fc.client.DfTypedObject.getString(DfTypedObject.java:594)
at com.documentum.fc.client.impl.collection.CollectionHandle.getString(CollectionHandle.java:152)
at com.documentum.fc.client.impl.dql.DqlUpdate.loadOperations(DqlUpdate.java:95)
at com.documentum.fc.client.impl.dql.DqlUpdate.processUpdate(DqlUpdate.java:466)
at com.documentum.fc.client.DfQuery.runQuery(DfQuery.java:176)
at com.documentum.fc.client.DfQuery.execute(DfQuery.java:213)
at com.un.tips.bo.publication.MTDSG.createPublicationDoc(MTDSG.java:431)....................in 431 line the code is qry.execute(session, DfQuery.DF_EXEC_QUERY);
at com.un.tips.mtdsg.GenerateMTDSG.createPropAttr(GenerateMTDSG.java:175)
at com.un.tips.mtdsg.GenerateMTDSG.onRunSearch(GenerateMTDSG.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.documentum.web.form.FormProcessor.invokeMethod(FormProcessor.java:1633)
at com.documentum.web.form.FormProcessor.invokeMethod(FormProcessor.java:1487)
at com.documentum.web.form.FormProcessor.fireActionEvent(FormProcessor.java:1303)
at com.documentum.web.form.RecallOperation.execute(RecallOperation.java:101)
at com.documentum.web.form.FormProcessor.processAction(FormProcessor.java:113)
at com.documentum.web.form.FormAction.processAction(FormAction.java:107)
at com.documentum.web.env.WDKController.doStartRequest(WDKController.java:191)
at com.documentum.web.env.WDKController.processRequest(WDKController.java:92)
at com.documentum.web.env.WDKController.doFilter(WDKController.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
advance thanks please let me know if any one having any idea about the problem.
Sreedhar.m
