Certain AutoPLANT tables are not created when creating new project from current.


Problem:

Database Types: Oracle, SQL Server

Software Version: AutoPLANT XM, V8i SS1 and SS2

When creating a new project from a current project certain tables do not get creating or copied.  This problem also can manifest itself when using Project Packager on this current project.  This is caused by these tables having a datatype of VARCHAR(MAX).

Solution:

Modify columns in these tables so that they are not VARCHAR(MAX).  Set the datatype to properly match the amount of data that will be in the column.  The AutoPLANT software does not support VARCHAR(MAX) columns.