Reduce the XER file size

Submitted by Jason LI on
Oracle Primavera - PM6

Member for

16 years 3 months
Member for 16 years 4 months
Submitted by Zoltan Palffy on Mon, 2019-05-20 14:18
Permalink

thast only 1/2 the solution you must clean your database

Member for

8 years 7 months
Member for 8 years 7 months
Submitted by Joel Roberts on Mon, 2019-05-20 09:08
Permalink

Hi Jason,

You can use ScheduleCleaner to erase POBS and reduce the file size of your XER file.

The tool can also help you with the following:

  • Remove other data such as costs, units, rates
  • Anonymyze/mask data such as resource names and simmilar
  • Convert Global to Project Data - Activity Codes and Calendars

 Regards,

Member for

20 years 6 months
Member for 20 years 7 months
Submitted by Santosh Bhat on Sat, 2019-05-18 13:53
Permalink

If you have a P6 R18 database, the POBS issue will not happen within the Database, but if you are importing XER files from other databases, you will need to check and cleanse POBS data out of these.

Member for

16 years 3 months
Member for 16 years 4 months
Submitted by Zoltan Palffy on Tue, 2017-05-02 14:12
Permalink

celaning the xer file is only 1/2 of the solution you have to clean your database also that is creating the large files.

here is a link to a free cleaner 

http://scheduleanalyzer.com/PurgePOBS.exe

Now make sure that you clean EVRY xer that you get from ANYONE.

next you will have to clean your existing database here is how 

Go to Start Programs Microsoft SQL server 2005, SQL Management Express Studio

the sever name is the name of the computer

Authentication is SQL Server Authentication

User name is sa

password is Prima123Vera then click connect

Expand the databases highlight pmdb$primavera

Up top select new query

then type delete POBS;  then right click and select execute

now close sql

done

Member for

13 years 8 months
Member for 13 years 8 months
Submitted by vocian on Mon, 2017-05-01 14:23
Permalink

Best thing you can do is upgrade your P6.

Primavera (and now oracle) acknowledged the existance of POBS bug in version 8.3 and released a bug fix for it. Unfortunately that bug fix only works for version 8.3 and some more recent versions have their own bug fixes. In the latest version 16.1 the bug is fully fixed and a seperate patch is no longer needed. This bug fix prevents P6 from importing or exporting POBS and stops spreading POBS records.

So why not only delete the POBS records in the database? You can delete pobs in the database, but as soon as you import one of the old POBS infected files it will start again. You can always check each XER for POBS and delete the form manually or with a software but for me it is a lot of work and as my company pays for P6 license it doesn't make sence to me or my company to spend couple of minutes extra for each schedule import forever!

 

If you are still interested to delete your POBS field in the P6 database follow the procedure in this link:

https://www.planacademy.com/clean-p6-pobs-table/

Be careful! Backup your database or/and your p6 schedules and do it at your own risk! If you follow exactly those steps you should be fine.

Member for

17 years 10 months
Member for 17 years 10 months
Submitted by Jason LI on Mon, 2017-05-01 05:48
Permalink

Thanks Emad,

And are there a way to cleaning the P6 database, so the exported xer file in the future will no long have the garbage. my P6 is standalone version. 7.0.

Thanks.

 

Member for

13 years 8 months
Member for 13 years 8 months
Submitted by vocian on Mon, 2017-05-01 04:53
Permalink

you don't really need POB eraser. 

open XER file in notepad and delete it manually