cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Error when adding constraints

Highlighted
Newbie

Error when adding constraints

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!

2 REPLIES 2
Highlighted

Re: Error when adding constraints

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

Highlighted

Re: Error when adding constraints

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.

Announcements