Skip to main content
P
ptc-55815001-Visitor
1-Visitor
February 10, 2014
Question

Error when adding constraints

  • February 10, 2014
  • 1 reply
  • 2091 views

When I add a constraint to the source for a CREATE TABLE I am getting errors that the previous constraints already exists.

Also I was able to compile a table with a constraint but was unable to promote the table because the reference table was not in the staging schema/library.

I get a FILE not Found in IMAY04.

HELP Please!

1 reply

D
DawnBlohm12-Amethyst
12-Amethyst
February 10, 2014

Scott,

Can you please contact PTC Implementer Support or log a case online? We're going to need your SCN, version of Implementer and list of patches installed. Unfortunately, this is not a simple answer without gathering additional information.

Thanks!

Dawn Blohm

Implementer Support Manager

P
ptc-55815001-VisitorAuthor
1-Visitor
February 10, 2014

I am not sure about the SCN, I am running a currently updated

Version . . . : 10.3

Is there a suggested process for handling SQL Tables with Constraints?

I am still learning how to use Implementer, but SQL tables and associated tasks are brand new for my current company and we have no working examples.

I have currently been able to create and promote Tables and views, but the addition of constraints is causing me headaches.

Terms & ConditionsAccessibility statement