Hi
I am getting exception for r_creation_date attribute in query form.
can anybody specify a query for DATE type in D2 Query Form to search results in predetermined date format.
Regards
Mayur Mitkari
The query which is specified in query form is
select * from te_agreement_doc where te_agreement_type like '%$value(te_agreement_type)%' and (any te_internal_parties in($repeatingvalue(te_internal_parties))or $count(te_internal_parties) = 0) and (any te_external_parties in($repeatingvalue(te_external_parties)) or $count(te_external_parties) = 0) and te_expiration_date <= DATE('$value(te_expiration_date)','mm/dd/yyyy') and te_alert_date <= DATE('$value(te_alert_date)','mm/dd/yyyy')
When i am executing this query form using D2 Client , The Date passed in $ value is in this format "Sat Sep 27 00:00:00 GMT+530 2014"
and this is throwing following error
2014-09-26 10:14:27 [ERROR] - com.emc.common.dctm.queries.D2Query : [DM_QUERY_E_DATE_FORMAT]error: "The specified date literal (Sat Sep 27 00:00:00 GMT+530 2014) is not in a recognized format, or is out of the valid date range." (Error string not propagated with exception - security)2014-09-26 10:14:27 [ERROR] - c.e.d.dctm.aspects.InjectSessionAspect : {}com.emc.d2.api.exceptions.D2GeneralQueryException: A query did not execute successfully. at com.emc.common.dctm.queries.D2Query.execute(D2Query.java:125) [D2-API-4.2.0.jar:na] at com.emc.d2fs.dctm.doclist.ContentBuilder.getListItem(ContentBuilder.java:204) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.content.D2cQueryDqlContent.getContent(D2cQueryDqlContent.java:84) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.content.NodeLastSearchContent.getContent(NodeLastSearchContent.java:61) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.web.services.content.D2ContentService.getContent_aroundBody0(D2ContentService.java:119) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.web.services.content.D2ContentService$AjcClosure1.run(D2ContentService.java:1) [D2FS4DCTM-WEB-4.2.0.jar:na] at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:221) [aspectjrt-1.6.11.jar:na] at com.emc.d2fs.dctm.aspects.InjectSessionAspect.process(InjectSessionAspect.java:92) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.web.services.content.D2ContentService.getContent(D2ContentService.java:106) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.tieto.pocplugin.webfs.services.content.D2ContentServicePlugin.getContent(D2ContentServicePlugin.java:46) [Tieto-POCPlugin.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_31] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [na:1.6.0_31] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [na:1.6.0_31] at java.lang.reflect.Method.invoke(Unknown Source) [na:1.6.0_31] at com.emc.d2fs.dctm.aspects.InjectSessionAspect.callPlugin(InjectSessionAspect.java:272) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.aspects.InjectSessionAspect.ajc$inlineAccessMethod$com_emc_d2fs_dctm_aspects_InjectSessionAspect$com_emc_d2fs_dctm_aspects_InjectSessionAspect$callPlugin(InjectSessionAspect.java:1) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.aspects.InjectSessionAspect.process(InjectSessionAspect.java:134) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.web.services.content.D2ContentService.getContent(D2ContentService.java:106) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.x3.server.services.RpcDoclistServiceImpl.getLastSearchDocListItem(RpcDoclistServiceImpl.java:65) [X3-Doclist-4.2.0.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_31] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [na:1.6.0_31] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [na:1.6.0_31] at java.lang.reflect.Method.invoke(Unknown Source) [na:1.6.0_31] at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561) [gwt-servlet-2.5.1.jar:na] at com.emc.x3.server.GuiceRemoteServiceServlet.processCall(GuiceRemoteServiceServlet.java:105) [X3-Common-4.2.0.jar:na] at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.5.1.jar:na] at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.5.1.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) [servlet-api.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) [servlet-api.jar:na] at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:na] at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:359) [shiro-web-1.1.0.jar:na] at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:275) [shiro-web-1.1.0.jar:na] at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) [shiro-core-1.1.0.jar:1.1.0] at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) [shiro-core-1.1.0.jar:1.1.0] at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:344) [shiro-core-1.1.0.jar:1.1.0] at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:272) [shiro-web-1.1.0.jar:na] at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:81) [shiro-web-1.1.0.jar:na] at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.40] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.40] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) [catalina.jar:7.0.40] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) [catalina.jar:7.0.40] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.40] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) [catalina.jar:7.0.40] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) [catalina.jar:7.0.40] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) [catalina.jar:7.0.40] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.40] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) [catalina.jar:7.0.40] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008) [tomcat-coyote.jar:7.0.40] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) [tomcat-coyote.jar:7.0.40] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) [tomcat-coyote.jar:7.0.40] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_31] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_31] at java.lang.Thread.run(Unknown Source) [na:1.6.0_31]2014-09-26 10:14:27 [ERROR] - c.e.x.s.services.RpcDoclistServiceImpl : {}com.emc.d2fs.exceptions.D2fsException: A query did not execute successfully. at com.emc.d2fs.dctm.aspects.InjectSessionAspect.process(InjectSessionAspect.java:152) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.web.services.content.D2ContentService.getContent(D2ContentService.java:106) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.x3.server.services.RpcDoclistServiceImpl.getLastSearchDocListItem(RpcDoclistServiceImpl.java:65) [X3-Doclist-4.2.0.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_31] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [na:1.6.0_31] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [na:1.6.0_31] at java.lang.reflect.Method.invoke(Unknown Source) [na:1.6.0_31] at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561) [gwt-servlet-2.5.1.jar:na] at com.emc.x3.server.GuiceRemoteServiceServlet.processCall(GuiceRemoteServiceServlet.java:105) [X3-Common-4.2.0.jar:na] at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.5.1.jar:na] at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.5.1.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) [servlet-api.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) [servlet-api.jar:na] at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:na] at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:359) [shiro-web-1.1.0.jar:na] at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:275) [shiro-web-1.1.0.jar:na] at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) [shiro-core-1.1.0.jar:1.1.0] at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) [shiro-core-1.1.0.jar:1.1.0] at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:344) [shiro-core-1.1.0.jar:1.1.0] at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:272) [shiro-web-1.1.0.jar:na] at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:81) [shiro-web-1.1.0.jar:na] at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:na] at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.40] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.40] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) [catalina.jar:7.0.40] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) [catalina.jar:7.0.40] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.40] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) [catalina.jar:7.0.40] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) [catalina.jar:7.0.40] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) [catalina.jar:7.0.40] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.40] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) [catalina.jar:7.0.40] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008) [tomcat-coyote.jar:7.0.40] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) [tomcat-coyote.jar:7.0.40] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) [tomcat-coyote.jar:7.0.40] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_31] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_31] at java.lang.Thread.run(Unknown Source) [na:1.6.0_31]Caused by: com.emc.d2.api.exceptions.D2GeneralQueryException: A query did not execute successfully. at com.emc.common.dctm.queries.D2Query.execute(D2Query.java:125) [D2-API-4.2.0.jar:na] at com.emc.d2fs.dctm.doclist.ContentBuilder.getListItem(ContentBuilder.java:204) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.content.D2cQueryDqlContent.getContent(D2cQueryDqlContent.java:84) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.content.NodeLastSearchContent.getContent(NodeLastSearchContent.java:61) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.web.services.content.D2ContentService.getContent_aroundBody0(D2ContentService.java:119) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.web.services.content.D2ContentService$AjcClosure1.run(D2ContentService.java:1) [D2FS4DCTM-WEB-4.2.0.jar:na] at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:221) [aspectjrt-1.6.11.jar:na] at com.emc.d2fs.dctm.aspects.InjectSessionAspect.process(InjectSessionAspect.java:92) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.web.services.content.D2ContentService.getContent(D2ContentService.java:106) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.tieto.pocplugin.webfs.services.content.D2ContentServicePlugin.getContent(D2ContentServicePlugin.java:46) [Tieto-POCPlugin.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_31] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [na:1.6.0_31] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [na:1.6.0_31] at java.lang.reflect.Method.invoke(Unknown Source) [na:1.6.0_31] at com.emc.d2fs.dctm.aspects.InjectSessionAspect.callPlugin(InjectSessionAspect.java:272) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.aspects.InjectSessionAspect.ajc$inlineAccessMethod$com_emc_d2fs_dctm_aspects_InjectSessionAspect$com_emc_d2fs_dctm_aspects_InjectSessionAspect$callPlugin(InjectSessionAspect.java:1) [D2FS4DCTM-WEB-4.2.0.jar:na] at com.emc.d2fs.dctm.aspects.InjectSessionAspect.process(InjectSessionAspect.java:134) [D2FS4DCTM-WEB-4.2.0.jar:na] ... 47 common frames omitted
and in D2 we are getting messaged as "Query did not execute successfully ". This is not parsable date format in documentum.
What will be solution to this .
From where does D2 picks up a date format , I tried changing Content Server as well as Application server date format but nothing works , The date passed from Query form in D2 is Still in same format "Sat Sep 27 00:00:00 GMT+530 2014",
How to change this format.
Hi,
You can use something like "(date_valid <= DATE('$value(date_valid)')". you can have default D2 format as MM/DD/YYYY. You can use $today or $now for todays date. you can use default value template as well for providing default values or UI for Query form.
Thanks,
Amit
Hello, please provide eaxmple for: "you can use default value template as well for providing default values or UI for Query form".
