Discussion

3
Replies
194
Views
Close popover
surendra donthu (Surendra Donthu)
incessant

incessant
AU
Surendra Donthu Member since 2013 6 posts
incessant
Posted: July 16, 2015
Last activity: April 6, 2018
Closed

During Pega 7.1.8 upgrade adding Multitenant column, pzTenantID

Hi ,

As part of pega 7.1.8 upgrade ,

SQL databases do not allow the addition of a non-null column to an existing table unless the table is
empty; upgrading systems on those databases displays an error "Table must be empty to add column".

These Pega 7 tables do not include the required pzTenantID columns:
pc_schedule_task
pr_index_schedule_task

So Pega is asking us to truncate this tables . But this tables already contains the schdule reports and subscribed operator details for reports.If we truncate this table is pega automatically creates these values again through upgrade script ?

If not , I am trying to take back up of this existing data and tries to insert again I don't know what is the exact value to be in pzTenantID column.

Can any one help me quickly on this as I am in middle of upgradation.

Regards,

Surendra.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.