Error while checking/populating WidgetType: com.termalabs.common.JawsException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Products

• Automic Automation Intelligence

Issue/Introduction

Error seen in jaws.log after upgrade to 6.0.0

 

WARN  [JawsDatabaseInitializer] Error while checking/populating WidgetType: com.termalabs.common.JawsException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Environment

Release : 6.0

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

In some environments it may be necessary to grant access to the AAI database user to the new tables/views added during the upgrade.

The list of tables that are added during your upgrade can be found in the upgradeJawsDbTo6.0.0.sql file created during the upgrade process.

Below is an example of what was needed in one environment post upgrade.

grant select on <aai_db-user>.USAGEDATA to <aai_db-user>;

grant select on <aai_db-user>.USAGESKU to <aai_db-user>;

grant select on <aai_db-user>.UIVIEWWIDGET to <aai_db-user>;

grant select on <aai_db-user>.UIWIDGET to <aai_db-user>;

grant select on <aai_db-user>.UIWIDGETTYPE to <aai_db-user>;

grant select on <aai_db-user>.UIVIEW to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.USAGEDATA to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.USAGESKU to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.UIVIEWWIDGET to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.UIWIDGET to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.UIWIDGETTYPE to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.UIVIEW to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.USAGEDATA to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.USAGESKU to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.UIVIEWWIDGET to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.UIWIDGET to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.UIWIDGETTYPE to <aai_db-user>;

grant select,insert,update,delete on <aai_db-user>.UIVIEW to <aai_db-user>;

create synonym <aai_db-user>.USAGEDATA for <aai_db-user>.USAGEDATA;

create synonym <aai_db-user>.USAGESKU for <aai_db-user>.USAGESKU;

create synonym <aai_db-user>.UIVIEWWIDGET for <aai_db-user>.UIVIEWWIDGET;

create synonym <aai_db-user>.UIWIDGET for <aai_db-user>.UIWIDGET;

create synonym <aai_db-user>.UIWIDGETTYPE for <aai_db-user>.UIWIDGETTYPE;

create synonym <aai_db-user>.UIVIEW for <aai_db-user>.UIVIEW;