Question
Self
IN
Last activity: 23 Jul 2023 7:43 EDT
error on page 'pyTempWorkPage' of class X-X-X getMultitenantInstanceVisibility cannot be invoked in a non-multitenant environment
We recently upgraded our environment from 7.4 to 8.7 version, As part of this upgrade when we try to open few pages(section) we are facing the below error. Section 'pzClientDynamicData' execution error on page 'pyTempWorkPage' of class 'XXX-XXX-XXX-Work-XXX'. : getMultitenantInstanceVisibility cannot be invoked in a non-multitenant environment. Has anyone seen this issue?
#section #Harness
Accepted Solution
Updated: 23 Jul 2023 7:43 EDT
Pegasystems Inc.
GB
@AvinashB16644628 This error may be due to presence of pzTenantId column in any of the tables.
If your 8.7 environment is not Multitenant apply the work around to drop the pztenantid column from pr_data_validation_results table. (pegadata schema). Drop this column before and after upgrade. pega=> alter table pegadata.pr_data_validation_results drop column pztenantid;
1. Verify if the pzTenantId column is present in any of the tables. Use the below SQL to determine if the pzTenantId column is present in any of the tables in the database. SELECT TABLE_NAME, COLUMN_NAME FROM all_TAB_COLUMNS WHERE column_name = 'PZTENANTID';
2. Drop the pzTenantId column from all the tables in which it is present (if it is not a multi tenant system).
3. Ensure that multitenant.system=false and automatic.resume=false is set in the setupdatabase.properties.
4. Run the Upgrade script.
If you still run into issues please log a support incident via the MSP.