Article - CS155414
Edit activity with error in MethodServer "Nested exception is: java.sql.SQLDataException: ORA-01861: literal does not match format string" in Windchill ProjectLink
Modified: 05-Sep-2023
Applies To
- Windchill ProjectLink 10.1 to 11.0
Description
- Edit an Activity (Task Type is Fixed Units) with a Resource assigned , and change its Resource Units to 0. Then the page will keep loading and there is error message in MethodServer log
- Remove activity causes Method Server fail in the loop with error ORA-01861: literal does not match format string
- The errors message is
INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - wt.calendar.CalendarException: A persistence error occurred. INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - Nested exception is: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows: INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "SELECT 'wt.calendar.CalendarComponent',A0.delegateIsNull,A0.classnamekeyA4,A0.idA3A4,TO_CHAR(A0.end_date,'dd mm yyyy hh24:mi:ss'),TO_CHAR(A0.start_date,'dd mm yyyy hh24:mi:ss'),TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0.workingDay FROM CalendarComponent A0,ComponentLink A1 WHERE ((A0.idA2A2 IN (SELECT MIN(A0.idA2A2) FROM CalendarComponent A0 WHERE ((A0.start_date BETWEEN TO_DATE(?,?) AND TO_DATE(?,?) )) GROUP BY A0.start_date,A0.end_date,A0.workingDay,A0.idA3A4,A0.updateStampA2))) AND ((A1.idA3A5 = A0.idA2A2) AND (A1.idA3B5 = ?)); Bind Parameters=[292268268:10:01:00:00:00, YYYY:MM:DD:HH24:MI:SS, 292268268:10:31:23:59:59, YYYY:MM:DD:HH24:MI:SS, 189]". Database system message follows: INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - Nested exception is: java.sql.SQLDataException: ORA-01861: literal does not match format string INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:518) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:687) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.pds.SQLDatabasePds.expandLink(SQLDatabasePds.java:2786) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.pds.SQLDatabasePds.expand(SQLDatabasePds.java:559) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.pom.PersistentObjectManager.expand(PersistentObjectManager.java:1463) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.fc.StandardPersistenceManager.expand(StandardPersistenceManager.java:2949) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.fc.StandardPersistenceManager.expand(StandardPersistenceManager.java:1038) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.calendar.LocalCAP.getComponents(LocalCAP.java:1333) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.calendar.LocalCAP.readComponents(LocalCAP.java:862) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.calendar.StandardCalendarService.getCalendarMonth(StandardCalendarService.java:393) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.GeneratedMethodAccessor1392.invoke(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at java.lang.reflect.Method.invoke(Method.java:597) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.sun.proxy.$Proxy182.getCalendarMonth(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.projmgmt.util.CalendarHelper.isNonWorking(CalendarHelper.java:451) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.projectmanagement.plannable.ScheduleUtils.isWorkingTime(ScheduleUtils.java:83) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.projectmanagement.plannable.ScheduleUtils.calculateWorkingDuration(ScheduleUtils.java:340) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.projectmanagement.plan.ilog.PlanWorkingHourHandler.calculateWorkingDuration(PlanWorkingHourHandler.java:117) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.windchill.gantt2.common.GanttActivity.computeTimeIntervalFromChildren(GanttActivity.java:143) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at ilog.views.gantt.model.IlvSimpleActivity.a(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at ilog.views.gantt.model.IlvSimpleActivity.a(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at ilog.views.gantt.model.IlvSimpleActivity$ChildEventHandler.a(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at ilog.views.gantt.model.IlvSimpleActivity$ChildEventHandler.activitiesInserted(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at ilog.views.gantt.model.IlvAbstractGanttModel.fireActivitiesInserted(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at ilog.views.gantt.model.IlvAbstractGanttModel.fireActivityInserted(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at ilog.views.gantt.model.IlvDefaultGanttModel.addActivity(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at ilog.views.gantt.model.IlvAbstractGanttModel.addActivity(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.windchill.gantt2.server.StandardGanttDataService.buildActivityNodeRecursively(StandardGanttDataService.java:261) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.windchill.gantt2.server.StandardGanttDataService.buildActivityNodeRecursively(StandardGanttDataService.java:275) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.windchill.gantt2.server.StandardGanttDataService.buildActivityNodeRecursively(StandardGanttDataService.java:275) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.windchill.gantt2.server.StandardGanttDataService.getILogGanttModel(StandardGanttDataService.java:661) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at java.lang.reflect.Method.invoke(Method.java:597) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.sun.proxy.$Proxy180.getILogGanttModel(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.projectmanagement.ilog.StandardILogService.createGanttModel(StandardILogService.java:288) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at java.lang.reflect.Method.invoke(Method.java:597) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.sun.proxy.$Proxy179.createGanttModel(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.projectmanagement.ilog.gantt.GanttModelUtility.createGanttModel(GanttModelUtility.java:82) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.projectmanagement.plannable.StandardPlannableService.propagateSchedule(StandardPlannableService.java:648) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at java.lang.reflect.Method.invoke(Method.java:597) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.sun.proxy.$Proxy164.propagateSchedule(Unknown Source) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.projectmanagement.plan.processors.CreateActivityFormProcessor.doOperation(CreateActivityFormProcessor.java:498) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.core.components.forms.DefaultFormProcessorController.executeDoOperation(DefaultFormProcessorController.java:526) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.core.components.forms.DefaultFormProcessorController.performExecuteDoOperationAndPostProcess(DefaultFormProcessorController.java:330) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.core.components.forms.DefaultFormProcessorController.execute(DefaultFormProcessorController.java:262) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.core.components.forms.FormDispatcher.callControllerExecute(FormDispatcher.java:146) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.core.components.forms.FormDispatcher.callFormProcessorController(FormDispatcher.java:116) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.core.components.forms.FormDispatcher.execute(FormDispatcher.java:93) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at java.lang.reflect.Method.invoke(Method.java:597) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.netmarkets.util.beans.NmCommandBean.execute(NmCommandBean.java:2323) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.jca.mvc.controllers.ActionController.executeWizardAction(ActionController.java:187) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at com.ptc.jca.mvc.controllers.ActionController.processRequest(ActionController.java:109) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at java.lang.reflect.Method.invoke(Method.java:597) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.httpgw.filter.WTContextBeanFilter.doWithWtContextBeanHandler(WTContextBeanFilter.java:98) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.httpgw.filter.WTContextBeanFilter.doFilter(WTContextBeanFilter.java:58) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.servlet.CompressionFilter.doFilter(CompressionFilter.java:248) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.servlet.RequestInterrupter.doFilter(RequestInterrupter.java:327) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.servlet.ServletRequestMonitor.doFilter(ServletRequestMonitor.java:1594) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at wt.servlet.ServletRequestMonitorFilter.doFilter(ServletRequestMonitorFilter.java:56) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at java.lang.Thread.run(Thread.java:662) INFO [ajp-bio-8010-exec-1] wt.system.out wcadmin - at org.apache.tomcat.util.threads.TaskThread.run(TaskThread.java:77)
This is a printer-friendly version of Article 155414 and may be out of date. For the latest version click CS155414