Has your question already been answered?

Get a quicker response; before you post, why not search to see if it has already been answered

RISK TYPE Data in exported file

5 replies [Last post]
Solamon T Varghese
User offline. Last seen 6 days 15 hours ago. Offline
Joined: 21 May 2011
Posts: 8
Groups: None

Any one can help me with removing RISK TYPE Data from exported file as it is taking long time while importing back and file size also increased.

- I tried delete it in Note but it is giving error while importing back.

Plz help.....

Replies

Solamon T Varghese
User offline. Last seen 6 days 15 hours ago. Offline
Joined: 21 May 2011
Posts: 8
Groups: None

Thank you So much for your support. definetly i will look into it.

Greg Horsfall
User offline. Last seen 1 week 4 days ago. Offline
Joined: 6 Dec 2004
Posts: 11
Groups: None
XER Manager Professional will safely remove Risk Categories (RISKTYPE) and handle referential integrity. www.executiveportlets.com
Steven Auld
User offline. Last seen 2 weeks 7 hours ago. Offline
Joined: 13 Sep 2017
Posts: 62
If you download the xer file parser from:
http://www.consultaegis.com/software/
This should allow you to open the full XER file in excel & remove the risk data you don’t want & re-create the XER file from there, however this may also take a while to open the file initially.
If removing the full risk data, make sure to search the full workbook to remove all references to the risk data to avoid issues later on.
This version should work with the current erosions of excel.
Steven
Solamon T Varghese
User offline. Last seen 6 days 15 hours ago. Offline
Joined: 21 May 2011
Posts: 8
Groups: None
Thank you Steven for your valuable comment.. while importing, the file size has increased and became a huge file... and it is taking a lot of time to upload it back to P6. Sometime the file size is more than 15mb after I delete POBS also... I’m using 8.3 version... we are not using or updating risk sections in primavera, so I thought deleting it will reduce size and file will be easy to handle....
Steven Auld
User offline. Last seen 2 weeks 7 hours ago. Offline
Joined: 13 Sep 2017
Posts: 62

If you are only deleting the RISKTYPE in Note then you have only deleted the Risk Categories & not the actual risks that the data is held in.

The Risk information is held in the PROJRISK table in the XER file, which is likely where the large amount of Data is held - the RISKTYPE table only holds a small amount of Data.

Please note that there are a number of different tables that use the Risk Data stored in the PROJRISK table, so deleting this may also affect other areas as well - this can vary depending on what version of Primavera you are importing which may give additional errors.

If you were just to delete the PROKRISK table completely then you will likely have the same issue with errors that you have now or, if it does import, you may end up with Database corruption issues later on.

Trying to fully remove this information in Note would quite likely take longer than importing the file, as the columns are not aligned under the column headers.

How have you identified the RISKTYPE table as being the issue during Import?

Steven