Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Nikolay Salnikov (SalnikovN)
LANIT
System Architect
LANIT
RU
SalnikovN Member since 2013 5 posts
LANIT
Posted: Jan 30, 2017
Last activity: Feb 3, 2017
Posted: 30 Jan 2017 2:28 EST
Last activity: 3 Feb 2017 10:58 EST
Closed
Solved

Import from a multitenant evironment to non-multitenant one.

Hi

I faced a problem while importing data table with instances from a multitenant evironment to non-multitenant one. The error is:

Show More

Hi

I faced a problem while importing data table with instances from a multitenant evironment to non-multitenant one. The error is:

java.lang.IllegalStateException: getMultitenantInstanceVisibility cannot be invoked in a non-multitenant environment.
	at com.pega.pegarules.data.internal.dictionary.ClassDefinitionImpl.getMultitenantInstanceVisibility(ClassDefinitionImpl.java:1779)
	at com.pega.pegarules.data.internal.access.rdb.SQLParser.directive(SQLParser.java:592)
	at com.pega.pegarules.data.internal.access.rdb.SQLParser.sql(SQLParser.java:464)
	at com.pega.pegarules.data.internal.access.rdb.SQLParser.parse(SQLParser.java:224)
	at com.pega.pegarules.data.internal.access.RDBListSpecificationImpl.parseAndSetValues(RDBListSpecificationImpl.java:97)
	at com.pega.pegarules.data.internal.access.ReportDefinitionListSpecification.<init>(ReportDefinitionListSpecification.java:398)
	at com.pega.pegarules.data.internal.access.ReportDefinitionListSpecification.<init>(ReportDefinitionListSpecification.java:350)
	at com.pega.pegarules.data.internal.access.ReportDefinitionListSpecification.<init>(ReportDefinitionListSpecification.java:341)
	at com.pega.pegarules.data.internal.access.RDBListSpecificationImpl.<init>(RDBListSpecificationImpl.java:77)
	at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6592)
	at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6569)
	at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6550)
	at com.pegarules.generated.activity.ra_action_onbeforedisplay_fcc84513f8d09b1f7b3f30d9c9e5f4a4.step1_circum0(ra_action_onbeforedisplay_fcc84513f8d09b1f7b3f30d9c9e5f4a4.java:254)
	at com.pegarules.generated.activity.ra_action_onbeforedisplay_fcc84513f8d09b1f7b3f30d9c9e5f4a4.perform(ra_action_onbeforedisplay_fcc84513f8d09b1f7b3f30d9c9e5f4a4.java:69)
	at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
	at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
	at com.pegarules.generated.activity.ra_action_wbopen_636ddc8d3c8d3933fb470ef82428b1d6.step24_circum0(ra_action_wbopen_636ddc8d3c8d3933fb470ef82428b1d6.java:2225)
	at com.pegarules.generated.activity.ra_action_wbopen_636ddc8d3c8d3933fb470ef82428b1d6.perform(ra_action_wbopen_636ddc8d3c8d3933fb470ef82428b1d6.java:537)
	at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
	at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)
	at com.pegarules.generated.activity.ra_action_douiaction_3438e1b79be3fba9725d7cc6be896f92.step26_circum0(ra_action_douiaction_3438e1b79be3fba9725d7cc6be896f92.java:2641)
	at com.pegarules.generated.activity.ra_action_douiaction_3438e1b79be3fba9725d7cc6be896f92.perform(ra_action_douiaction_3438e1b79be3fba9725d7cc6be896f92.java:492)
	at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
	at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
	... 59 more

So I have a question: is such import supported? If not, is there a workaround?

***Updated by moderator: Lochan to update Categories***


Show Less
To see attachments, please log in.
Data Integration
System Administration

Accepted Solution

Posted: 7 years ago
Posted: 30 Jan 2017 18:07 EST
Arun Kumar Mahanty (Arun_Mahanty)
Pegasystems Inc.
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hello Salnikov,

You can go through below link

https://community.pega.com/support-articles/exception-while-running-updatebat

Now in your case identify the tables where you have values for PZTENANTID columns ,drop those columns .

Follow the export process and try to import it again .

Thanks,

Arun

 

 

 

 

 

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 31 Jan 2017 2:18 EST
Nikolay Salnikov (SalnikovN)
LANIT
System Architect
LANIT
RU

Hello Arun,

Thanks for the help.

I tried the steps but after removing all the PZTENANTID columns import performs with errors anyway. Errors on data instances, which couldn't be saved. Also the data class definition can't be opened after the import, the same error arrives.

To see attachments, please log in.
Posted: 7 years ago
Posted: 31 Jan 2017 6:59 EST
Arun Kumar Mahanty (Arun_Mahanty)
Pegasystems Inc.
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hello Salnikov,

Can you please share the import logs so that i will have a look into the issue .

Thanks,

Arun

 

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 31 Jan 2017 9:28 EST
Mahesh Midthuru (Mahesh Midthuru)
PEGA
Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Salnikov,

Are you using the data table wizard or Import wizard for the import of data table?

Regards

Mahesh

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice