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]
