Skip to main content
Ex Libris Knowledge Center

xxx30 util/a/17/6/1 120/127 triggers not displaying in a/17/6/4

  • Article Type: General
  • Product: Aleph
  • Product Version: 20

Problem Symptoms:
Section 8.3 "Course Reading" of the "Upgrade Express 18-19 User Guide," step #7 (p.84), indicates "Run util/a/17/6/1 to create the z120/z127 triggers." Following the instructions in database XXX30, the menu leads to a sub-menu for either creating "all" triggers or "specific" triggers. Specific triggers was specified, but, when XXX30 util/A/17/6/4 to "show trigger status" is run, no triggers are listed.

Cause:
Uncertain.

Resolution:
These are the four triggers which need to be created for xxx30:

TRI z127_trigger
TRI z127_trigger_1
TRI z127_trigger_2
TRI z13_trigger_1


util a/17/6/1/1 ("Create/Recreate ALL Library Triggers") *can* be used to create these four triggers.

See Additional information, below, for the sample creation of a specific trigger....

Additional Information

Util a.17.6. Manage Triggers in XXX30

1. Create/Recreate Library Triggers
2. Enable Trigger
3. Disable Trigger
4. Show Trigger Status
Please select [exit]: 1

A.17.6.1 Create/Recreate Triggers in XXX30

1. Create/Recreate ALL Library Triggers
2. Create/Recreate specific Library Trigger
Please select [exit]: 2
Enter trigger name:z127_trigger
XXX30 trigger z127_trigger <-------------- Note entry of "z127_trigger".

SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 7 21:11:11 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Trigger created.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Enter to continue

A.17.6.1 Create/Recreate Triggers in XXX30

1. Create/Recreate ALL Library Triggers
2. Create/Recreate specific Library Trigger
Please select [exit]:

A.17.6. Manage Triggers in XXX30

1. Create/Recreate Library Triggers
2. Enable Trigger
3. Disable Trigger
4. Show Trigger Status
Please select [exit]: 4


SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 7 21:11:29 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

aleph_admin@ALEPH21> aleph_admin@ALEPH21> aleph_admin@ALEPH21> 2 3 4
TRIGGER_NAME TABLE_NAME STATUS
------------------------------ ------------------------------ --------
Z127_TRIGGER Z120 ENABLED
aleph_admin@ALEPH21> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Press CR to continue


  • Article last edited: 12/5/2013