August 9, 2015 at 10:01 pm
Hi All,
We are importing xer formats through the wizard to sqlserver database and It takes upto 35-45 mins for each import (single project), Can you please let us know if any option to reduce the time.Is they any other import options - which can give us faster results.
Thank you in advance.
--Sai
August 10, 2015 at 1:26 am
Following is the analysis i did please let me know if they is any other option:
A) Rather than use the XER File Format, try the XML format that P6 supports instead.
The XML format functions much like the XER File format. There are some differences, but the project will come across regardless. If the XML file imports quickly, then there’s a problem with the XER file. Please refer below link for the same.
https://msdn.microsoft.com/en-us/library/ms191184.aspx
B) Remove the POBS Data from the XER File.
Every Primavera P6 database has a POBS table. Looking at the Primavera P6 database schema docs, POBS stands for Performing Organizational Breakdown Structure. The POBS data isn’t used (yet) by Primavera P6 Professional or Primavera P6 EPPM. Here’s what an Oracle Support doc titled “What is the POBS Table Used for and What Data is Stored in POBS? (Doc ID 1959228.1)” had to say:
?"Functions related to table POBS have not been implemented yet so the table has not been put to use. The table may be removed in a future release.?If there is data in this table, then it’s probably present in the sample database and not inserted during operations performed in the application."
That doc says it applies to Primavera P6 EPPM v7.0.3.0 or later.
Thanks
Sai
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply