Error ORA-01792 after migration

davidk46719882

24-05-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Vapsy

Employee

24-05-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 .

Answers (0)