Error ORA-01792 after migration | Community
Skip to main content
davidk46719882
Level 2
May 24, 2017
Solved

Error ORA-01792 after migration

  • May 24, 2017
  • 1 reply
  • 1628 views

Hi all,

I'm doing a migration from v6.1.0 build 8161 to v6.1.1 build 8770 and after completing the migration, I have an error when i'm trying to open deliveries or to see deliveries dashboard.

Can you help on that?

Thanks

David

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by vraghav

Dis you also move to Oracle 12c?

It is a bug for Oracle, please see 

https://community.oracle.com/message/12970776#12970776


As suggested by Oracle experts, it can be resolved by


Turning  OFF the FIX_CONTROL will resolve the issue


The workaround is to set "_fix_control"='17376322:OFF'
SQL> alter session set "_fix_control"='17376322:OFF';
or at system level :
SQL> alter system set "_fix_control"='17376322:OFF';


OR


Apply Patch 19509982 if available for your DB Version and Platform 
https://support.oracle.com/rs?type=patch&id=19509982


Can you please contact your DBA for making these changes and see if the problem is resolved .

1 reply

vraghav
Adobe Employee
vraghavAdobe EmployeeAccepted solution
Adobe Employee
May 25, 2017

Dis you also move to Oracle 12c?

It is a bug for Oracle, please see 

https://community.oracle.com/message/12970776#12970776


As suggested by Oracle experts, it can be resolved by


Turning  OFF the FIX_CONTROL will resolve the issue


The workaround is to set "_fix_control"='17376322:OFF'
SQL> alter session set "_fix_control"='17376322:OFF';
or at system level :
SQL> alter system set "_fix_control"='17376322:OFF';


OR


Apply Patch 19509982 if available for your DB Version and Platform 
https://support.oracle.com/rs?type=patch&id=19509982


Can you please contact your DBA for making these changes and see if the problem is resolved .