Hi, I'm using Sap DB 7.4.3 Build 010-000-035-462.
Using JDBC driver SAP AG, 7.4.4 Build 003-000-002-502 I know the database version is pretty old, however it's a mission critical server and I don't upgrade Unless I really have it (ie, its going to fix a bug). Is this a known issue with this/older releases? This problem has only JUST started happening, with a query I've been using for quite a while. Regards Michael Andrewes -----Original Message----- From: Becker, Holger [mailto:[EMAIL PROTECTED] Sent: Friday, 8 April 2005 7:11 PM To: Michael Andrewes Subject: RE: [-602]: System error: Move error Hi, what version of MaxDB are you using? Kind regards Holger > -----Original Message----- > From: Michael Andrewes [mailto:[EMAIL PROTECTED] > Sent: Freitag, 8. April 2005 02:13 > To: 'Michael Andrewes'; 'SAP DB mailing list' > Subject: RE: [-602]: System error: Move error > > Hi, > > This is the error from the DB log. > > 2005-04-08 07:09:21 836 ERR 51080 SYSERROR error: Move error > 2005-04-08 07:12:14 804 ERR 54111 MOVE VGG04.8: > 0[32768]->1[1024] > len:5 > 2005-04-08 07:12:14 804 ERR 51080 SYSERROR error: Move error > 2005-04-08 07:12:34 804 ERR 54111 MOVE VGG04.8: > 0[32768]->1[1024] > len:5 > 2005-04-08 07:12:34 804 ERR 51080 SYSERROR error: Move error > 2005-04-08 07:13:37 804 ERR 54111 MOVE VGG04.8: > 0[32768]->1[1024] > len:5 > 2005-04-08 07:13:37 804 ERR 51080 SYSERROR error: Move error > 2005-04-08 07:14:20 804 ERR 54111 MOVE VGG04.8: > 0[32768]->1[1024] > len:5 > 2005-04-08 07:14:20 804 ERR 51080 SYSERROR error: Move error > 2005-04-08 07:15:18 804 ERR 54111 MOVE VGG04.8: > 0[32768]->1[1024] > len:5 > 2005-04-08 07:15:18 804 ERR 51080 SYSERROR error: Move error > 2005-04-08 07:18:16 804 ERR 54111 MOVE VGG04.8: > 0[32768]->1[1024] > len:5 > 2005-04-08 07:18:16 804 ERR 51080 SYSERROR error: Move error > 2005-04-08 07:25:32 699 ERR 54111 MOVE VGG04.8: > 0[32768]->1[1024] > len:5 > 2005-04-08 07:25:32 699 ERR 51080 SYSERROR error: Move error > > > I found something on google relating to a move error and exceeding > page size with large queries and complex views, however am not sure if > it applies. > > Am I exceeding max packet/page size? > > The query can potentiall have 70 numerics in the in() clause, however > regularly has and causes no problem. > When this happened, there was only 8 or so conditions within the in() > clause. > > > Regards > Michael Andrewes > > -----Original Message----- > From: Michael Andrewes [mailto:[EMAIL PROTECTED] > Sent: Friday, 8 April 2005 9:24 AM > To: 'SAP DB mailing list' > Subject: [-602]: System error: Move error > > Hi, > > I got this error this morning with a statement similar to > > Select field1,field2,field3...field15 from table_name where > field1 in ( > 1,2,3,4,5,5,5,5,5,5,5 ) > > Where field1 is PK > > The repetition of the final number in the in() clause is due to data > being fed in, and I'm actually going to make sure that that duplicates > are removed from here on in. > > My question is, what is -602? This error is pretty hard to reproduce, > I am trying to get a vtrace. > > > regards > Michael Andrewes > > COMMUNICATOR INTERACTIVE > > www.communicator.com.au > > P +612 9256 0912 F +612 9256 0922 M +61 410 677 458 PAGE +612 > 9214 8752 > > Level 8, 9-13 Young Street, Circular Quay, Sydney. 2000 > > Copyright Communicator Interactive Marketing Pty Limited 2005 > > CONFIDENTIAL INFORMATION owned exclusively by Communicator Interactive > Marketing Pty Limited. The information in this email and any > attachments is privileged and confidential, intended only for the use > of the recipient or the intended recipient. If you are not the > intended recipient, any use of the information is strictly prohibited. > If you have received this communication in error, please inform us > immediately and delete the message and any attachments. > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
