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:holger.becker@xxxxxxx]
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:mandrewes@xxxxxxxxxxxxxxxxxxx]
> 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:mandrewes@xxxxxxxxxxxxxxxxxxx]
> 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/maxdb?unsub=mandrewes@xxxxxxxxxxxxxxxxxxx
>
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/maxdb?unsub=holger.becker@xxxxxxx
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx
|
