Overview

On a Linux machine, you are trying to run setupSBM but it gets stuck after the below-mentioned statement:

Dropping process data views with name {PT_NAME}_VIEW or {PT_NAME}_WSV or {PT_NAME}_view or {PT_NAME}_wsv

If you try it multiple times, you notice that in the previous run the tables were deleted and on the second run it gives an exception when executed again. But that is expected if tables were successfully deleted. The exception on the second run is:

ORA-00942: table or view does not exist

Solution

The issue is related to the views: the script is not able to remove the views.

The issue might be caused when the DB user used by the Aurea Process does not have create view right.

1. Request your DBA to execute the below GRANT permissions to the DB user of the Aurea Process (replace <user_name> with the DB user name):

   GRANT create session, create table, create sequence, create view, create procedure To <user_name>;

2. Before repeating the setupSBM command request your DBA to drop the views and the data in the tables.
3. Repeat the setupSBM command. It should execute successfully.

Back to the top