RE: Errors with 7.4 Beta

[john doed]

Holger,

Here is my knldiag.err file:

--------------------------------------------------------------------------------
Date Time TID(hex) Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2003-01-10 10:07:54 --- Starting GMT 2003-01-10 10:07:54 7.4.3 Build 007-000-155-373
2003-01-10 10:08:10 0xE3C ERR 54111 MOVE VGG04.8: 54[32768]->1[1024] len:-8
2003-01-10 10:08:10 0xE3C ERR 51080 SYSERROR -9111 error: Move error羝

From: "Becker, Holger" <[EMAIL PROTECTED]>
To: "'john doed'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: Errors with 7.4 Beta
Date: Fri, 10 Jan 2003 12:01:22 +0100

john doed wrote:

> 1)
> This SELECT produces a -9111 System Error - Move Error
> --
> SELECT * FROM FOOTPRINTS_ONLINE WHERE  (updated>'2003-01-10
> 00:29:00.061')
> AND (fpo_id IN (SELECT fpo_id FROM OPS_FPO_WORKLOAD WHERE op_id=1 AND
> master_id=1)) ORDER BY created ASC
> --
> As you can see I am using 2 WHERE conditions.  If I only have
> 1 condition
> (it doesnt matter which one) it will work.  If I substitute
> one condition
> with ANY other field in that table it will work.  But having
> those exact two
> conditions causes this error.  Why?

Could you please post the knldiag.err file of the database
because it will tell us more about the problem.
You will find it in the rundirectory of the database.

> 2)
> When executing my app, it's first session with the SAPDB produces
> SQLExceptions errors (this is normal because the SQL has not
> been converted
> from Postgresql), however the 2nd attempt by my App will give me a
> "connection refused error".  I have to restart the database
> before I can try
> again.
>
> Now I have commented out my code so I only produce 1
> Exception, and I dont
> have to restart the database.

I'm not sure if I understand your problem but perhaps your user is
defined as an exclusive user. For more information see
http://www.sapdb.org/htmhelp/48/f0daa5225811d3a97d00a0c9449261/frameset.htm.

HTH.

Kind regards,
Holger
SAP Labs Berlin

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general