Apex 5.1 downgrade to 5.0

Hi Jason

Thank you.

I have run the downgrade scripts, and rerun the apex_rest_config.sql scripts and rerun the database config scripts for ORDS, but I am now getting an ORA-01031 error as soon as try access the builder.

If I try access an application directly:

Running the following as SYS in sqlplus, apex_util.set_security_group_id(p_security_group_id => c1.workspace_id); gets below error

ERROR at line 1:

ORA-01031: insufficient privileges

ORA-06512: at "SYS.DBMS_SESSION", line 122

ORA-06512: at "APEX_050000.WWV_FLOW_SESSION_CONTEXT", line 30

ORA-06512: at "APEX_050000.WWV_FLOW_SECURITY", line 2728

ORA-06512: at "APEX_050000.WWV_FLOW_SECURITY", line 2770

ORA-06512: at "APEX_050000.HTMLDB_UTIL", line 2973

ORA-06512: at line 11

Which at the end is executing this is WWV_FLOW_SESSION_CONTEXT ->

PROCEDURE SET_WORKSPACE_ID (

    P_WORKSPACE_ID IN NUMBER )

IS

BEGIN

    WWV_FLOW_DEBUG.ENTER (

        'set_workspace_id',

        'p_workspace_id', P_WORKSPACE_ID );

    SYS.DBMS_SESSION.SET_CONTEXT (

        NAMESPACE => C_CONTEXT,

        ATTRIBUTE => 'WORKSPACE_ID',

        VALUE     => P_WORKSPACE_ID );

END SET_WORKSPACE_ID;

Thank you in advance for your help.

Regards,

Hi

Found the fix. After running the above scripts, login as SYS and run the following:

drop context APEX$SESSION;

create context APEX$SESSION using APEX_050000.WWV_FLOW_SESSION_CONTEXT;

Regards,

Shaun