topic Re: Could not drop constraint. Problem when Table moved to QA server in Application Development and Automation Discussions

Could not drop constraint. Problem when Table moved to QA server

Former Member — Fri, 02 Jul 2010 11:39:40 GMT

Dear Experts,

I modified a transparent 'Z' table by adding three fields to it. It was already having four fields as primary keys and it was working fine. I created Lock object for this table as well.

Now the problem is when I moved it to Quality server, It is accepting duplicated entries even though primary keys are already defined to it.

I checked Utilities --> Database Object --> Check in SE11, it showing - 'Unique index 0 does not exist' - means, Primary Key is not got created in Database level (MS SQL).

Then I tried to 'Activate and Adjust Database'' using SE14 (used BASIS userId), then its showing error - 'Constraint <Primay Key name> does not belong to table <Table name>. Could not drop constraint.

Its nothing but an SQL error. How to solve this issue ?

These issues are not showing in Dev. server.

Please help.

John.

Re: Could not drop constraint. Problem when Table moved to QA server

Former Member — Fri, 02 Jul 2010 12:22:49 GMT

Hi,

I think as you added new fields after taht some thing is not get transported in production.

make sure that each field,data element,domain...etc get transpoted correctly.

I am sure it is issue of TRANSPORT REQUEST.

Regards,

Pravin

Re: Could not drop constraint. Problem when Table moved to QA server

Former Member — Fri, 02 Jul 2010 13:08:23 GMT

Thanks Pravin,

But that is not the case here.

Every depended elements have moved along with the table to QA. I checked again.

If it was a transport request problem, it would have given an error message in the 'Transport Log' saying - 'Depended dataelement/domain not generated/activated'. which is not the case here.

John

Re: Could not drop constraint. Problem when Table moved to QA server

Former Member — Sun, 04 Jul 2010 19:19:17 GMT

Hi John,

Can you have a look at the Software Component versions of the Development and Quality Servers? Also, check what are the SP that's been applied on both the systems.

You can try regenerating all the associated objects in the Quality system once more. Else, make a small change in the development system( Like a desc change) and then regenerate all the objects in the dev and lock the same in a transport request. Then release the request and check whether your problem got resolved or not.

Hope this will help.

Thanks,

Samantak.

Re: Could not drop constraint. Problem when Table moved to QA server

Former Member — Tue, 06 Jul 2010 16:11:43 GMT

Dear all,

Thanks for your resopnse.

The problem got solved. It was purly DBA issue. As the error was showing, the primary index was not regenerating/correpted in the Database server. BASIS people has the authority to regenerate the index directly in the DBA system. They hae done it and issue got resolved.

thanks,

John V.