7 Replies · Latest reply on Jan 2, 2018 9:36 AM by Dan English

    Project Schedule Export failure

      We are in FUJI and a number of our projects will not export any data into the XML file via the export to project function.

       

      Has anyone else on FUJI have this problem as well when exporting projects to MS Project that the XML has zero byte data?

       

      PRB - PRB670348

       

      Thanks for any information you can share.

       

      Regards

      Michael

        • Re: Project Schedule Export failure
          sergiu.panaite

          Hi Michael,

           

          The PRB you opened shows that you're getting a Java Null Pointer Exception when trying to export those projects. That needs to be investigated further.

           

          Regards,

          Best Regards,
          Sergiu

          Visit my community blog:
          https://community.servicenow.com/people/sergiu.panaite/content

          or personal blog:
          http://bitsofcode.io

          Have a performance issue? Challenge me!

            • Re: Project Schedule Export failure
              Michael deHaas

              Sergiu - thanks for the response.  This problem (PRB - PRB670348) has been open in HI Support for some time and we have yet to get a response and resolution.  We have now upgraded one of our instances and we see this problem in Helsinki as well.

               

              Do you have any more guidance on this problem?

               

              Anyone else having this issue.  it is starting to become urgent.

               

              Thanks!

               

              Michael

            • Re: Project Schedule Export failure
              Michael deHaas

              kellykaufmann - Keith Schaefer seems to own this problem (PRB - PRB670348) that has no updates at all for the last 3 months that it has been opened.  I can't connect to him.  Would you be able to find out more about this problem either through Keith or another engineer?

               

              Thanks kindly Kelly!

               

              Michael

               

              Project Schedule Export failure

              • Re: Project Schedule Export failure
                Tarun Murala

                Hi,

                 

                The expected field(s) for the Microsoft Project Export was Empty/NULL.

                 

                Could you verify the below, for all the task(s) under the project before exporting.

                Most of the cases where the Actual Duration was empty/NULL for the task, where it did consists the Actual Start Date and Actual End Date (For the closed task(s)).

                 

                We did a fallback in the coming release I, where if there the above case is valid, we are calculating actual duration to export MS Project.

                 

                Thanks,

                Tarun.

                • Re: Project Schedule Export failure
                  Michael deHaas

                  tarunmurala thanks for the suggestion.  I have looked at one of the projects that were not exporting and I did find some Actual Duration that was empty when there was a Actual Start Date/End Date available.  I corrected this problem and even there were some tasks with no Actual Start Date when the task was Work-in-Progress.  So as far as I can tell from your direction I have completed the data update.  However, when I test again I still get 0KB and nothing in the file.

                   

                  I have looked at one project that could export and when looking at that data the issue you mention does exist in a few tasks and yet it still exports to XML.  So not sure your theory is correct.  If it is then we are still missing something in those other projects not importing even after updating the Actual Start/End/Duration to be with a date or time.

                   

                  Also in the project that does export when I try to import the XML into MS Project 2016 I get the following error and MS Project Crashes. !

                  MS Import Error.png

                   

                  This is the xml data - I struggle to see why this errors.  I import into Rational Plan Viewer and it "seems" fine.

                  <Task>

                              <UID>217</UID>

                              <ID>218</ID>

                              <Name>Logistical Support</Name>

                              <Type>0</Type>

                              <IsNull>0</IsNull>

                              <WBS>1.6.2</WBS>

                              <OutlineNumber>1.6.2</OutlineNumber>

                              <OutlineLevel>3</OutlineLevel>

                              <Priority>500</Priority>

                              <Start>2016-02-16T01:52:00</Start>

                              <Finish>2017-02-03T00:23:00</Finish>

                              <Duration>PT2023H23M53S</Duration>

                              <DurationFormat>7</DurationFormat>

                              <Work>PT8H0M0S</Work>

                              <Stop>2016-03-15T09:52:00</Stop>

                              <ResumeValid>0</ResumeValid>

                              <EffortDriven>0</EffortDriven>

                              <Recurring>0</Recurring>

                              <OverAllocated>0</OverAllocated>

                              <Estimated>0</Estimated>

                              <Milestone>0</Milestone>

                              <Summary>1</Summary>

                              <Critical>1</Critical>

                              <IsSubproject>0</IsSubproject>

                              <IsSubprojectReadOnly>0</IsSubprojectReadOnly>

                              <ExternalTask>0</ExternalTask>

                              <FixedCostAccrual>3</FixedCostAccrual>

                              <PercentComplete>8</PercentComplete>

                              <PercentWorkComplete>0</PercentWorkComplete>

                              <ActualStart>2016-02-16T01:52:00</ActualStart>

                              <RemainingDuration>PT1861H31M34S</RemainingDuration>

                              <ConstraintType>2</ConstraintType>

                              <CalendarUID>-1</CalendarUID>

                              <LevelAssignments>0</LevelAssignments>

                              <LevelingCanSplit>0</LevelingCanSplit>

                              <IgnoreResourceCalendar>0</IgnoreResourceCalendar>

                              <HideBar>0</HideBar>

                              <Rollup>0</Rollup>

                              <EarnedValueMethod>0</EarnedValueMethod>

                              <Active>1</Active>

                              <Manual>0</Manual>

                          </Task>

                  • Re: Project Schedule Export failure
                    Dan English

                    I had this same problem this morning, and was able to resolve by making sure that all tasks that have planned OR actual start and end dates have a duration populated also.  This solved my issue once I added duration of 0 to my milestone tasks.