Message 1 of 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
It has some record is unused on table P3dLineGroup. How to purge P3dLineGroup table?
Dos it need to purge or not?
Solved! Go to Solution.
It has some record is unused on table P3dLineGroup. How to purge P3dLineGroup table?
Dos it need to purge or not?
Solved! Go to Solution.
There is an option to remove the unused linenumbers by means of Plant 3D user intesface. To do this, restart Plant 3D and without any of the project drawing opened (this is the necessary condition in Plant 3D 2013, it may be fixed in the latter versions) run the "_AUDITPROJECT" command. The result of this command is shown in the command line (press 'F2' to view the text window) and it generally includes the Tags of the removed linenumbers. If you check the project database and 'P3dLineGroup' table after running the command and see that there are some of the phantom records present, it means that these linenumbers have existing links in the project database (to Parts or Drawings). So there are some objects in the project drawings on these linenumbers. I strongly do not recommend deleting the records manually from the project databases, as this could result in crushing the project.
Thanks'
I ahve tried it.
There are no errors found.
Auditing project part 'Piping' ...
Checking drawing \\spekh1\PLANT3D_PROJECT\p3d_mmetric\Plant 3D Models\piping_model\P1001-001.dwg...
Checking database record 1 of 346.
Checking database record 50 of 346.
Checking database record 100 of 346.
Checking database record 150 of 346.
Checking database record 200 of 346.
Checking database record 250 of 346.
Checking database record 300 of 346.
Checking database record 346 of 346.
Checking acquisition properties in 'EngineeringItems' table...
Checking acquisition properties in 'P3dConnector' table...
Checking acquisition properties in 'P3dLineGroup' table...
Line number 'P-AA2-001' has been removed.
Line number 'unassigned' has been removed.
Line number '001' has been removed.
Line number '001' has been removed.
Line number 'unassigned' has been removed.
Line number '001' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
Line number '001' has been removed.
Line number '001' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
Line number 'unassigned' has been removed.
366 database records audited.
20 errors found.
Auditing project part 'Iso' ...
0 database records audited.
There are no errors found.
Auditing project part 'Ortho' ...
0 database records audited.
There are no errors found.
Auditing project part 'Misc' ...
0 database records audited.
There are no errors found.