Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Primary Key Transport Problem

Go to solution
Former Member

‎2014 Apr 29 4:48 PM

0 Likes
1,310

Dear Gurus,

I had a requirement wherein I had to make an existing non-key field of a Z-table as a Primary Key field, so I moved that non key field next to the existing primary key fields & made it as a key field by going se14 'Adjust and Activate' functionality.

Now, when the requested was imported to quality it showed error and no changes were seen.. What should I do now, there are lot of programs dependent to that Z table.. Should I ask to activate and adjust in the Quality too?... Then how about Production??

Thank you for your kind perusal.

1 ACCEPTED SOLUTION
Read only

Go to solution
RaymondGiuseppi
Active Contributor

‎2014 Apr 30 7:37 AM

0 Likes
1,230

Yes database should be adjusted. For production note that SE14 can be scheduled for execution in background, so schedule transport and adjustment out of peak hours.

Regards,

Raymond

Dear Gurus,

I had a requirement wherein I had to make an existing non-key field of a Z-table as a Primary Key field, so I moved that non key field next to the existing primary key fields & made it as a key field by going se14 'Adjust and Activate' functionality.

Now, when the requested was imported to quality it showed error and no changes were seen.. What should I do now, there are lot of programs dependent to that Z table.. Should I ask to activate and adjust in the Quality too?... Then how about Production??

Thank you for your kind perusal.

Reply
6 REPLIES 6
Read only

Go to solution
former_member194739
Active Participant

‎2014 Apr 29 8:10 PM

0 Likes
1,230

Dear Hari,

Adjust individual landscape.

Regards,

Abbas.

Read only

Go to solution
Former Member

‎2014 Apr 30 5:00 AM

0 Likes
1,230

Hi Hari,

Can you shows us the error log?

Also, check if you have table maintenance generator then delete it and create the new table maintenance generator.

Regards,

Sudeesh Soni

Read only

Go to solution
yogendra_bhaskar
Contributor

‎2014 Apr 30 7:24 AM

0 Likes
1,230

Hi Hari ,

Yes , you have to repeat the same " se14 'Adjust and Activate' functionality. " on quality and PRD server.

Regards,

Yogendra Bhaskar

Read only

Go to solution
Former Member

‎2014 Apr 30 7:29 AM

0 Likes
1,230

Hi Hari,

Delete the Table maintenence generator and create new.It will work

Regards,

Ankit

Read only

Go to solution
RaymondGiuseppi
Active Contributor

‎2014 Apr 30 7:37 AM

0 Likes
1,231

Yes database should be adjusted. For production note that SE14 can be scheduled for execution in background, so schedule transport and adjustment out of peak hours.

Regards,

Raymond

Read only

Go to solution
Former Member

‎2014 Apr 30 8:23 AM

0 Likes
1,230

Hi Hari,

As per my past experience, you dont need to activate and adjust the database manually in Production.

Check the same with basis team.

Also, i will advise you to take table backup before deploying transports to Production because there are chances of reduction in table entries if any duplicate record will be identified for your new primary key fields combination.

Regards,

Sudeesh Soni