Problem :
Msdxwdevkit.Sql fails when upgrading from 11.5.10.2 to 12.1.1
Error :
<code lang=”sql”>ERROR at line 1:
ORA-33292: Insufficient permissions to access analytic workspace APPS.XWDEVKIT
using the specified access mode.
ORA-06512: at “SYS.DBMS_AW”, line 67
ORA-06512: at “SYS.DBMS_AW”, line 131
ORA-06512: at “SYS.DBMS_AW”, line 960
ORA-06512: at line 9</code>
Solution :
Grant olap_user role to apps use
<code lang=”sql”>SQL> Grant olap_user to APPS;</code>
Restart the failed worker using adctrl
