Update Graph_tmp table customized scripts - HxGN SDx - Update 60 - Installation & Upgrade

HxGN SDx Upgrade

Language
English
Product
HxGN SDx
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
10

The scripts that drop and recreate the Graph_tmp table when configuring HxGN SDx have updated columns from HxGN SDx Update 38.

If you have any customized scripts that are related to the Graph_tmp table, such as ensuring the table is empty, you must ensure the scripts are updated with these changes before upgrading HxGN SDx.

If you use a memory optimized temp table, the script you used to optimize the table also needs to be updated with these changes and reapplied after the upgrade.

The column changes are as follows:

SQL Server

Existing column value changes:

[SOURCEOBJDOMAIN] [nvarchar](40)

[RELDOMAIN] [nvarchar](40)

[OBJDOMAIN] [nvarchar](40)

Additional new column:

[ROWNUMBER] [bigint]

Oracle Server

Existing column value changes:

OBJDOMAIN VARCHAR2(40 CHAR)

RELDOMAIN VARCHAR2(40 CHAR)

SOURCEOBJDOMAIN VARCHAR2(40 CHAR)

Additional new column:

ROWNUMBER NUMBER(20,0)