Rename plant hierarchy

[jain]

We constructed plant hierarchy in SPPID. This hierarchy has used for a long time. Now, we need to rename the plant hierarchy . We don't need to use the method that create new plant hierarchy and import P&ID data to new plant with new hierarchy because this method use a long time to import data. Moreover, it still uses long time to check the data after import. Could you suggest other methods that we can change the plant name in plant level hierarchy? Is the data will be 100% correct after rename with your suggestion method? Is it will have any problem to data after import?

[Patrick_Aps]

I think it can be done much easier

I could advise you to take a look in the database itself, but i need more information before I can be sure if there is a way to do this.
1) What version of SPPID and SP Engineering Manager
2) What version of Oracle
3) Have you been creating your own Hierarcy types ?
4) Do you use a plain "Plant-Area-Unit" hierarchy ? If not, explain in detail.
5) Are the PID drawings only on the Unit level or also on other levels of the Hierarcy ?
6) Is it only a rename action or do you also want to
6a) re-order units to other Area's
6b) merge or split the drawings of one unit to different units.
7) Are you in "as-build" mode, or do you have projects defined in your plant ?
8 ) Are you stand alone or do you have sattelites?
9) Are the names of the Plant, area and/or Unit used in the names of all the Plant Items ?

In the meanwhile Start making a full backup of your plant before doing anything.
I think those questions cover most of the possible hurdles.

[jain]

1) What is the exact version of SPPID and SP Engineering Manager?
SPPID ==> 04.03.25.05
SPEM ==> 04.04.21.06
2) What version of Oracle?
Oracle 10g
3) Have you been creating your own Hierarchy types ?
I have been creating my own hierarchy.
4) Do you use a plain "Plant-Area-Unit" hierarchy ? If not, explain in detail.
No, I use

Plant
Unit

And If I want to do this SR in another plant which has a difference hierarchy, is it able to do by the same method?

5) Are the PID drawings only on the Unit level or also on other levels of the Hierarchy ?
Drawing is on the Unit level only.
6) Is it only a rename action or do you also want to
No, I also want to do
6a) re-order units to other Area's
Some Plant want to re-order unit to other Area.
6b) merge or split the drawings of one unit to different units.
Some Plant want to merge and some Plant want to split.

And I can not delete unit which isn't used in the plant by delete drawing in Drawing Manager then delete unit in SPEM.
Could u suggest me to solve its by another method.

7) Are you in "as-build" mode, or do you have projects defined in your plant ?
In the meanwhile Start making a full backup of your plant before doing anything.
Yes, it is in as-build mode and does not enable project.
I fully backup everyday.
9) Are the names of the Plant, area and/or Unit used in the names of all the Plant Items ?
I use standard naming for Plant Item.
I notice that PipeRun tag is consisted from this(please find the picture1)
and some PipeRun's properties(Field: Item Tag, Plant Group Name, Plant Group Type) is get value from Unit
(please find the picture2)

[Patrick_Aps]

If i understand right, you want to go from a Plant-Unit breakdown structure to a Plant-Area-Unit structure,
while renaming the units and sometimes assign the drawings to another unit.

The big challenge that I see is that I do not know a way to change the Plant Breakdown structure when a structure is already in place.

But I might see one possibility.
I'll make a quick test tomorrow and let you know.

[jain]

hi patrick,

we now mainly focussing on "just changing the plant name only" or rename the plant only. But the point you said is also an issue..

[Patrick_Aps]

Download SQL developer (the version with the Java Runtime) and install it.
Installing is nothing but an unzip in a folder, and the installation of the Java Runtime.

To rename the plant:
Connect to the Oracle Database using the user and PWD you used when you "Created Site"

Be sure you do this when no one else is connected to Engineering Manager (SPEM), Drawing Manager (SPDM) or SPPID.

The Site is in the T_Plantgroup table where Depth = 0
(path is also null)
Just brouwse to the Table, switch to to tab "Data" and change the value inthe name, like you would in excel.
Be sure to press the "commit" button (database with a green check mark")

[Patrick_Aps]

The way to do it would be the following:
Create a new Site in SPEM, With Hierarcy 7
and all the Area's an Units you need.
The Oracle users for this, I call SPEM and SPEMD
Associate SPPID using the same RDB as your original plant.
The Orcale users for this, I call SPPID and SPPIDD
Create all Drawings on their new location in this site.
Backup everything.
Now the trick is to Replace the (almost empty) Oracle tables of SPPID with the (filled) Oracle tables of the original plant and then assosiate the drawings to the right unit.

The connection between unit and drawing is stored in 2 locations in Oracle: once in the SPEM user, once in the SPPID user.As you created all the drawings again, these tables are filled in right with the SPEM user and you do not have to change anything.

The SP_IDs of the Units are in SPEM.T_PLANTGROUP where detph = 2. You can also see th DIR_PATH.
These SP_IDs are the SP_PLANTGROUPID in the SPEM.T_DRAWINGSITE. As you created all the drawings, these tables are filled in right.

With the SPPID user, the settings are stored in T_DRAWING, as SP_PLANTGROUPID and PATH.
As you created all the drawings again, these tables are filled in right .
Export this table to Excel using a simple Right-click menu.

Replace all drawinigs of the SPPID user with the SPPID of your original plant and then change the T_DRAWING table so that you replace all the PATH settings and al the SP_PLANTGROUPID. This is to assign the "existing drawings with content" to their "new unit"

If you have don that,
Commit everything, close SQL developer,
start SPDM, all drawings should be out of date.
make them up to date and the job is done.

As I pointed out: no garantee, you're on your own and do no get support. But, as you are making a complete copy of your plant, what could be the damage ?

[jain]

hi,

i tried the steps as you said to rename the plant . But when i open SPEM it still showing the same old name. please see the picture.

[OZ10]

Hi Jain,

You'll need to connect to your SITE schema and change the 'name' value in the T_Rootitem table. You should then see the new name reflected in EM.
I've never made these changes before so I must warn you these kind of modifications are not support and may have an effect on how EM and SPPID operate.

Also, although it looks like you've already converted from PA to PAU, there is a delivered utility that will do this conversion for you. You can find it under the EM install directory \Program\PU2PAU.exe. Never used it myself but it might be worth bearing in mind for the future.

[Patrick_Aps]

Indeed, there is a 3rd Oracle user, when you created Site.
This has also the SP_ID of the Plants in the table T_ROOTITEM

The PU2PAU_Readme.txt is very interesting indeed
And might just be a part of the solution for this.