U0003590 DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-02289: sequence does not exist'
Log into the Oracle database using the Automic database user and use this command to determine if the Automic user has the right to create a SEQUENCE:
CREATE SEQUENCE SQ_UCDUMMY
INCREMENT BY 1 START WITH 1 MAXVALUE 999999999
MINVALUE 1 CYCLE CACHE 1000 NOORDER;
If the command fails, see solution below.
If the command is successful, use this command to delete the test data that was created:
DROP SEQUENCE SQ_UCDUMMY;?
If the command fails, the database user for Automic does not have CREATE SEQUENCE authorization.
The Automic database user needs to be granted the right to create a SEQUENCE (i.e.: CREATE SEQUENCE).
If the sequence are still not getting created and the error message is received after the authorization has been granted, it may be necessary to perform one or both of these additional steps:
1. Truncate the MQSRV table
2. Reload the InitialData?