Discussion
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.
Hi Dhev,
We are upgrading from pega 7.1.6 to pega 7.1.8 , I think 7.1.6 is not multitenant environment.
Regards,
Surendra.
if 7.1.6 is not multitenant environment then it should not create this columns.
Can you make sure that "multitenant.system=false" set in the setupdatebase.properties file before you trigger and upgrade.
Thanks,
Dhev
Hi Surendra,
is your environment is already a Multi Tenant Environment? Are you upgrading from Pega 7.x Multi Tenant environment to Pega 7.1.8. Please confirm.
If you are upgrading from any PRPC 5.x and PRPC 6.x to Pega 7.1.8 then this column should not be added unless and until you have selected multitent option in the property file.
Thanks,
Dhev