Actions and Events Fix

If you experience a "Constraint violation" when adding a Action, use the following fix:

Run the following SQL statements from operations navigator or other SQL entry utility:

CHANGE THE LIBRARY pjuserxx to the name of the current WOW metadata library you are using:

The first statement will delete the table with the issue. The 2nd statement will recreate the actionEvent file with corrected column attributes.

1.

DROP TABLE PJUSERxx.actionevent

2.

CREATE TABLE PJUSERxx.actionevent (AID INTEGER GENERATED ALWAYS AS IDENTITY, OWNERID INTEGER, "TYPE" char(10) NOT NULL DEFAULT 'ACTION', SUBTYPE char(10) NOT NULL, ACTIVE char(1) NOT NULL DEFAULT 'Y', DESCRIPTION varchar(100), SRCOPID INTEGER, SRCAPPID INTEGER, SRCFDID INTEGER, TRGTOPID INTEGER, JAVACLASS varchar(100), AENAME varchar(50) NOT NULL, DLBOTLEFT char(1) NOT NULL DEFAULT 'N', DLBOTRIGHT char(1) NOT NULL DEFAULT 'N', DLTOPLEFT char(1) NOT NULL DEFAULT 'N', DLTOPRIGHT char(1) NOT NULL DEFAULT 'N', DLTOOLBAR char(1) NOT NULL DEFAULT 'N', DLSRCHLEFT char(1) NOT NULL DEFAULT 'N', DLSRCHRIGHT char(1) NOT NULL DEFAULT 'N', DLINLINE char(1) NOT NULL DEFAULT 'N', DLNONE char(1) NOT NULL DEFAULT 'N', DLBUTNLEFT char(1) NOT NULL DEFAULT 'N', DLBUTNRIGHT char(1) NOT NULL DEFAULT 'N', DLRIGHTCLK char(1) NOT NULL DEFAULT 'N', DLFLDLEFT char(1) NOT NULL DEFAULT 'N', DLFLDRIGHT char(1) NOT NULL DEFAULT 'N', DLHEADER char(1) NOT NULL DEFAULT 'N', DLDROPDOWN CHAR(1) NOT NULL default 'N', DLLOC12 char(1) NOT NULL DEFAULT 'N', DLLOC13 char(1) NOT NULL DEFAULT 'N', DLLOC14 char(1) NOT NULL DEFAULT 'N', DLLOC15 char(1) NOT NULL DEFAULT 'N', DLLOC16 char(1) NOT NULL DEFAULT 'N', DLLOC17 char(1) NOT NULL DEFAULT 'N', DLLOC18 char(1) NOT NULL DEFAULT 'N', DLLOC19 char(1) NOT NULL DEFAULT 'N', DLLOC20 char(1) NOT NULL DEFAULT 'N', PRIMAGE varchar(100), PRDSPTYPE char(10), PRGROUP char(10), PRDSPORDER int NOT NULL DEFAULT 0, PRSTYLE varchar(100), PRLABEL varchar(45), PRPLSWAIT varchar(100), PRTARGET varchar(30), PRNAVGRPST char(1) DEFAULT 'N', PRNAVGRPED char(1) DEFAULT 'N', PRNEWWINDW varchar(200), PRDTLMODE char(6), PRNOSELERR varchar(100), PRCNFRMTXT varchar(100), PRDTLMDINS char(1) NOT NULL DEFAULT 'N', PRDTLMDEDT char(1) NOT NULL DEFAULT 'N', PRDTLMDCPY char(1) NOT NULL DEFAULT 'N', PRDTLMDVW char(1) NOT NULL DEFAULT 'N', PRDTLMDDLT char(1) NOT NULL DEFAULT 'N', AUTHTYPE INTEGER NOT NULL DEFAULT 0, AUTHLEVEL INTEGER NOT NULL DEFAULT 0, AUTHOPID INTEGER, CRTTMSP timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, CRTUSER varchar(50), UPDTTMSP timestamp NOT NULL, UPDTUSER varchar(50), COMPMSG varchar(100), VALIDATE char(1) NOT NULL DEFAULT 'N', ACTNEVTF1 varchar(45), ACTNEVTF2 varchar(45), ACTNEVTF3 INTEGER, ENVIRONMENT char(10) CCSID 65535 NOT NULL DEFAULT '',

PRIMARY KEY (AID), UNIQUE (OWNERID,"TYPE",SUBTYPE,SRCOPID,SRCAPPID,AENAME))