An Error Occurred In A Triggered Sql Statement In Trigger
Contents |
in trigger "MAXIMO.MAXSESSION_T". Information returned for the error sqlcode sqlstate "22001" includes SQLCODE "-359", SQLSTATE "23522" TPAEDATABASE; DB2; MAXIMO.MAXSESSION_T; maxseq; MAXSESSION Technote (troubleshooting) Problem(Abstract)
Sqlcode 803 Sqlstate 23505
Unable to access application due to error on DB2 while the server is added to the MAXSESSION object / table db2 sqlcode because of MAXSESSION_T trigger. Symptom Cannot log in to Maximo. After starting up system and trying to log in you will see in the logs the following error message (sample): [17/03/13 03:40:43:625 EST] 00000018 SystemOut O 17 Mar 2013 03:40:43:625 [ERROR] BMXAA6424E - The server was not added to the Maxsession table: MXServer com.ibm.db2.jcc.b.SqlException: An error occurred in a triggered SQL statement in trigger "MAXIMO.MAXSESSION_T". Information returned for the error includes SQLCODE "-359", SQLSTATE "23522" and message tokens "".. SQLCODE=-723, SQLSTATE=09000, DRIVER=3.53.70 at com.ibm.db2.jcc.b.bd.a(bd.java:679) at com.ibm.db2.jcc.b.bd.a(bd.java:60) at com.ibm.db2.jcc.b.bd.a(bd.java:127) at com.ibm.db2.jcc.b.fm.b(fm.java:2132) at com.ibm.db2.jcc.b.fm.c(fm.java:2115) at com.ibm.db2.jcc.t4.db.k(db.java:353) at com.ibm.db2.jcc.t4.db.a(db.java:59) at com.ibm.db2.jcc.t4.t.a(t.java:50) at com.ibm.db2.jcc.t4.tb.b(tb.java:200) at com.ibm.db2.jcc.b.gm.Zb(gm.java:2445) at com.ibm.db2.jcc.b.gm.e(gm.java:3287) at com.ibm.db2.jcc.b.gm.Rb(gm.java:612) at com.ibm.db2.jcc.b.gm.executeUpdate(gm.java:595) at psdi.server.MaxSession.addServerToMaxSession(MaxSession.java:72) at psdi.server.MXServer.start(MXServer.java:3095) at psdi.servlet.MAXIMOStartupServlet.init(MAXIMOStartupServlet.java:63) Cause DB2 SQL error code -359 will tell us the following: THE RANGE OF VALUES FOR THE IDENTITY COLUMN OR SEQUENCE IS EXHAUSTED Explanation DB2 attempted to generate a value for an identity column or a sequence object. However, all allowable values have already been assigned. *** NOTE: Reference: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2Fsrc%2
visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: Trigger error: duplicate rows for those columns Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-06-09,05:20 #1 grofaty View Profile View Forum Posts Registered User Join Date Jan 2003 Posts 1,605 Unanswered: Trigger error: duplicate rows for those columns http://www-01.ibm.com/support/docview.wss?uid=swg21628869 Hi, I would like to insert one new record to table after each insert with default value 1000. I tried the following: 1. clean up whole table (for test purpose) DELETE FROM ADMIN.TEST @ 2. drop trigger if exists DROP TRIGGER ADMIN.TEST_I@ 3. create trigger: CREATE TRIGGER ADMIN.TEST_I AFTER INSERT ON ADMIN.TEST REFERENCING NEW AS NEW FOR EACH ROW BEGIN ATOMIC INSERT INTO ADMIN.TEST VALUES (NEW.ID, 1000, NEW.ONOFF); END @ 4. testing insert http://www.dbforums.com/showthread.php?1640676-Trigger-error-duplicate-rows-for-those-columns statement INSERT INTO ADMIN.TEST VALUES (1, 1, '1')@ Above command retuns error: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0723N An error occurred in a triggered SQL statement in trigger "IZPIS.DOSTOP_I". Information returned for the error includes SQLCODE "-803", SQLSTATE "23505" and message tokens "1|IZPIS.DOSTOP". SQLSTATE=09000 SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "
start with 'SYS' a nodegroup name cannot start with 'SYS' or 'IBM' Action: Select a name that does https://www.columbia.edu/sec/acis/db2/db2m0/sql0700.htm not start with a reserved prefix. sqlcode: -707 sqlstate: 42939 SQL0713N The replacement value for "