• State Not Answered
  • Replies replies
    2
  • Subscribers subscribers
    16
  • Views views
    215
  • Users 0 members are here

Cannot disable archive IGA 4.2

Nicolai Glahn
 

Hi,

Just installed IGA 4.2 - Brand new - Did one initial identity collection and publishing

I have tested the connection to the archive db - it said OK.


I tried enable archive, and got this errror in the error column

Error occurred dropping view suser_all_v: ERROR: cannot drop view suser_all_v because other objects depend on it Detail: view role_users_assigned_v depends on view suser_all_v Hint: Use DROP ... CASCADE to drop the dependent objects too..

Then I tried to disable archive, and got (the same error):

Error occurred dropping view suser_all_v: ERROR: cannot drop view suser_all_v because other objects depend on it Detail: view role_users_assigned_v depends on view suser_all_v Hint: Use DROP ... CASCADE to drop the dependent objects too..

Now, when I try do maintenance, I get errors like "Cannot start maintenance. Must be in NORMAL execution mode to start maintenance, and must NOT be in the middle of disabling or enabling archiving."

What can be the problem?

  • 0  

    Hello,

    1) Did you define an archive destination?

    2.a) If yes, what database are your pointing to?
    2.b) If no, what did you set?

    3) What database type are using (MS SQL, Oracle, Postgres)?


    Sincerely,
    Steven Williams
    Principal Enterprise Architect
    OpenText Cybersecurity

  • 0   in reply to   

    Hi Steven,

    Thanks for asking.

    First of all, since this was a brand new install, and I had a snapshot, I reverted and tried again. Then it worked.

    I have no idea what the difference could be.

    But that aside

    1) Yes - I defined a new archive DB

    2) Postgres 15 (installed via SLES15 repos) - I made a new archive DB

    3) I think the question is answered in 3).

    But another question, since it got stuck. It would be nice to know how one can get it unstuck again. There might be scenarios where we cannot just revert the entire system, db and all.

    Is there a way to do that?

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.