-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Jepp. Det ser mye bedre ut n?. Eventengine er n? i ferd med ? t?mmes...
- - odd arne
- -----Original Message-----
From: Kristian Eide [mailto:kreide@online.no]
Sent: Sun 05-Sep-04 20:26
To: Hauge Odd Arne
Cc: nav-users(a)itea.ntnu.no
Subject: Re: [Nav-users] Nav3 fanger ikke opp at boks er neder
- -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Det er en melding som g?r igjen:
> SQLException for update statement: INSERT INTO alertq
> (alertqid,source,deviceid,netboxid,subid,time,eventtypeid,alerttypeid,state
>,value,severity) VALUES ('3849580','pping','93','84',null,'2004-09-01
> 18:43:59','boxState',(SELECT alerttypeid FROM alerttype WHERE
> alerttype='boxDownWarning'),'x','1','50') java.sql.SQLException: ERROR:
> More than one tuple returned by a subselect used as an expression.
Aha, det forklarer nok saken. Jeg vil tro at det som settes inn i
alerttype-tabellen fra manage.sql p? en eller annen m?te har blitt kj?rt
dobbelt hos deg, slik at innholdet i alettype-tabellen har kommet inn flere
ganger. Det enkleste er nok ? ta en 'DELETE FROM alerttype' og s? kj?re alle
'INSERT INTO alerttype ...' linjene du finner i manage.sql.
Restart s? eventEngine. L?ser det problemet?
- - --
Kristian
- -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFBO1pBRBuET7ul/ccRAjkIAJwMFE3LgcLOTeUEAA/QWTF7nVJfkACfWAYv
2OeqLIStbzcVt2/a9ommxtE=
=dEbc
- -----END PGP SIGNATURE-----
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFBO3G9RBuET7ul/ccRAkBZAJwKO6Ktvfmy60ya+VW2yVkSPnN2mQCeL4j0
9GgtqoBeuTKYJ/BbNONqQC8=
=Wip5
-----END PGP SIGNATURE-----