Add Fields and Model Names

To be able to control the order and width for components sharing the same rack slot, you need to add four fields to the fiber object tables that Wavepoint supports in the rack view. The four fields are not part of the standard sample data, which is why you need to add them before you can configure multiple components sharing a slot.

The four tables to update are:

F_ActiveDevice (in case your company changed the table name, it is the object table assigned the ACTIVEDEVICE class model name)
F_Device (or, the object table assigned the ENDDEVICE class model name)
F_PassiveDevice (or, the object table assigned the PASSIVEDEVICE class model name)
F_PatchPanel (or, the object table assigned the PATCHPANEL class model name)

TIP: You only need to configure the fiber tables you actually populate and use in your system. For example, if you do not utilize the F_ActiveDevice table, you do not need to configure it.

The four fields and model names to add to the tables are:

Field Name	Field Type	Field Model Name	Notes
WavepointLayoutMode	Short Integer	WAVEPOINTLAYOUTMODE	Determines the unit (inches, millimeters, or rack units) to use for the child devices’ widths.
WavepointOrder	Short Integer	WAVEPOINTORDER	Determines the objects’ position order within the slot from left to right.
WavepointWidth	Double	WAVEPOINTWIDTH	Determines the width of the child fiber object, respecting the unit chosen in the layout mode.
WavepointHeight	Double	WAVEPOINTHEIGHT	Not currently used, and is reserved for future use. To change height, configure the columns of the fiber object as described in Populate Rack, Device, and Port Fields.

The following steps demonstrate how to accomplish this using the F_PatchPanel as its example.

IMPORTANT: Because this is a schema change, you need to sign into the geodatabase as the owner of the fiber object tables. Further, there cannot be locks on the schema during this process, which means other users need to exit the geodatabase before you begin. Now, you can disconnect everybody from the geodatabase right before you begin, but ensure you inform other users before doing so, as they lose unsaved changes when they are disconnected.

In ArcCatalog, sign into the geodatabase as the owner of the fiber object tables.
In the Catalog Tree, locate the F_PatchPanel table.
Right-click F_PatchPanel and choose Properties.
On the Fields tab, scroll to the bottom of the field list until you find the first empty row.

IMPORTANT: If you do not see an empty row, it means you are either not signed in as the schema owner, or there are other users in the geodatabase causing the schema to be locked. Ensure you are signed in as the owner and that you have full ownership of the geodatabase while attempting to modify the schema.
Add the following fields to the table:
- WavepointHeight - Double
- WavepointLayoutMode - Short Integer
- WavepointOrder - Short Integer
- WavepointWidth - Double
Click OK.
Still in the Catalog Tree, right-click F_PatchPanel again and choose ArcFM Properties Manager.
On the Field Model Names tab, assign the following field model names:
- WavepointHeight - WAVEPOINTHEIGHT
- WavepointLayoutMode - WAVEPOINTLAYOUTMODE
- WavepointOrder - WAVEPOINTORDER
- WavepointWidth - WAVEPOINTWIDTH
Click OK.
Repeat the steps above for the F_ActiveDevice, F_Device, and F_PassiveDevice tables.

IMPORTANT:
Because this is a schema change, you need to restart your ArcGIS Server and also restart your IIS Server on the server machine before overwriting your published service. If you attempt to re-publish your service without restarting ArcGIS Server and IIS Server, you receive the following message:

To correct this, restart ArcGIS Server and IIS Server, then overwrite the published service.