Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Error ORA-01792 after migration

davidk46719882
Level 3
Level 3

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

1 Accepted Solution
Vapsy
Correct answer by
Employee
Employee

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 .

View solution in original post

1 Reply
Vapsy
Correct answer by
Employee
Employee

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 .

View solution in original post