Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Triggers - checking via util menu not working

    Triggers - checking via util menu not working

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    I am attempting to check on the status of triggers. When I run util a/17/6/4, I get dropped from the database. How can I determine what is going on with this? I need to determine if I have an Oracle problem (I did make some changes to the listener) or some other problem. How do I track this one down?

    Resolution:
    As shown by the following SQL, there are no Oracle triggers for any ABC01, ABC50, etc., tables:

    SQL-ABC50> select owner, trigger_name from all_triggers where owner like 'ABC%';

    no rows selected

    The USM tables have one trigger:

    SQL-ABC50> select owner, trigger_name from all_triggers where owner like 'USM%';
    **** Hit return to continue ****

    OWNER TRIGGER_NAME
    ------------------------------ ------------------------------
    USM50 Z1003_TRIGGER

    <end SQL>

    When you say you get dropped from the database, are you referring to the "Disconnected from Oracle Database" message? If so, that is normal, that's what you always see at the end of a util a/17/6.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • trigger 'xxx50.Z105H_TRIGGER' is invalid and failed re-vali
      • trimiterea unui email din webOPAC emailul primit de 2 ori
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved