Project and Portfolio Management Practitioners Forum
cancel

Time sheet data importer issue

Highlighted
roxor
Honored Contributor.

Time sheet data importer issue

Hello everybody,

 

I am using kTMDataConvrsion.sh script. I have created some timehseets without any issues on our PPM 8.03. Then I found that this script is also availible in our PPM 7.5 so I was happy that I can probably use it.

 

So I have created time sheet in PPM 7.5 (unsubmitted because I wanted to make some changes later) without problems and without errors. Time sheet seems to be OK, I can open it. But I can't save it:)

 

I get only this when I click on save button:

 

java.lang.IllegalArgumentException:Cannot instantiate a TMWorkUnitBean from a NULL tmWorkUnit.
com.mercury.itg.tm.service.vo.TMWorkUnitBean.(TMWorkUnitBean.java:47)
com.mercury.itg.tm.service.impl.TimeSheetLineImpl.(TimeSheetLineImpl.java:97)
com.mercury.itg.tm.service.impl.TimeSheetImpl.(TimeSheetImpl.java:124)
com.mercury.itg.tm.service.impl.TMServiceFactory.getServiceTimeSheet(TMServiceFactory.java:170)
com.mercury.itg.tm.web.SaveTimeSheetAction.doUpdate(SaveTimeSheetAction.java:227)
com.mercury.itg.tm.web.SaveTimeSheetAction.doUpdate(SaveTimeSheetAction.java:195)
com.mercury.itg.tm.web.SaveTimeSheetAction.doSave(SaveTimeSheetAction.java:137)
com.mercury.itg.tm.web.SaveTimeSheetAction.doExecute(SaveTimeSheetAction.java:81)
com.mercury.itg.common.web.BaseAction.execute(BaseAction.java:146)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.portals.bridges.struts.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:50)
com.mercury.itg.common.web.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:47)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:34)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:77)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:93)
com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:66)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:733)
com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1143)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:79)
com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
com.kintana.core.web.filter.I18nFilter.applyFilter(I18nFilter.java:44)
com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:43)
com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:53)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:662)

Anyone is using this script to make time sheets in version 7.5? Where could be the problem?

 

Thank you very much.

 

Kind regards,

r.

3 REPLIES
cotocald
Respected Contributor.

Re: Time sheet data importer issue

There is a PMTM Sync tool that will alleviate the issue. I have attached a guide.

Best regards,

Oscar

-- Remember to give Kudos to answers! (click the KUDOS star)
roxor
Honored Contributor.

Re: Time sheet data importer issue

Hello Oscar,

thanks for suggestion but I unfortunately didn't get how to use this PMTMSync tool in my case - when I have time sheet which was created by kTMDataConversion.sh and this time sheet can't be saved.

As I see, this PMTMSync tool is working with projects. In my time sheet I have many projects should I set all of them to NEEDS_TM_SYNC?

Moreover, PMTMSync makes sense only if time sheet is approved. My time sheet is unsubmitted because I needed to make some changes and updates but therse are not possible because of my save problem.

Thanks,
r.
penoles
Super Contributor.

Re: Time sheet data importer issue

As I know, timesheet data importer from xml  was introduced since PPM8.