The original message was rejected because of the size. Pascal, did you receive the vtrace?
Cheers robert ---------- Forwarded message ---------- From: Robert Klemme <[EMAIL PROTECTED]> Date: 18.10.2005 15:27 Subject: Re: DELETE fails from sqlcli but not from SQL Studio To: "Paskamp, Marco" <[EMAIL PROTECTED]>, maxdb <[email protected]> Hi, sorry for the delay. There was other important business to do... 2005/10/17, Paskamp, Marco <[EMAIL PROTECTED]>: > Hi, > I think the difference between SQLStudio and sqlcli is that sqlcli uses > prepared statements per default to handle dbprocedures. You can prevent > sqlcli from doing it with the option -r. Apparently not: sqlcli 7.5.0 doesn't accept this option. :-} 15:20:43 [MaxDB]: sqlcli -v SQLCLI version 7.5.0 BUILD 018-123-079-776, the MaxDB interactive terminal. Copyright 2000-2004 by SAP AG. > Since the error comes from the database kernel a kernel trace > (http://sapdb.2scale.net/moin.cgi/VTrace) would be interesting. Is attached. The error shows up in line 3211. I've also attached the SQL in case you need to align trace output with executed statements. The SQL is not complete though as DDL for the tables is missing. One additional info: if those tables referenced by the view and ag_url are empty no error shows up. Instead of * -108: Table or index dropped or content deleted SQLSTATE: I0108 I see this line: * 0: There was nothing unusual in knldiag so I exclude it here. Anything else that I can provide? Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
