[SAP DB]RE: Error -904 when selecting without result

[Stephen Gutknecht (SAPDB)]

Yey!

This is one of our production server problem that we had not found a easily
reproducable case before.

I am running Windows 2000 Service Pack 2, ODBC driver 7.03.00.00, KERNEL
7.3.0 BUILD 008-000-054-008.

Windows Scripting Host sample, run with CSCRIPT.EXE ...
  ================================================

Set cnnTest = CreateObject("ADODB.Connection")
cnnTest.Open
"UID=TEST;PWD=TEST;ServerDB=TST;ServerNode=localhost;DRIVER={SAP DB 7.3};"

Set rstTest = cnnTest.Execute("drop table TESTA")

Set rstTest = cnnTest.Execute("create table TESTA (ID INTEGER NOT NULL,
PRIMARY KEY(ID))")

Set rstTest = cnnTest.Execute("insert into TESTA (ID) VALUES (1)")

Set rstTest = cnnTest.Execute("delete from TESTA where ID=1")

loopCount = 0

Do While 1=1
   loopCount = loopCount + 1
   Set rstTest = cnnTest.Execute("select ID from TESTA where ID=1")
   If rstTest.EOF Then
      WScript.Echo LoopCount & ": No results."
   Else
      WScript.Echo LoopCount & ": Some results!"
   End If
Loop

'-- yes, I know this never executes :)
cnnTest.Close
Set cnnTest = Nothing

  ===============================================

For my development system, using the default test database, it fails for me
after 1970 executions.

How soon can we get a fix, this is causing us serious production problems
where we use the database as a queue...

Any chance this leak is related to the -907 errors that forces us to
stop/start sapdb every few days?

Thank you.

  Stephen Gutknecht


-----Original Message-----
From: schoen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 1:44 AM
To: [EMAIL PROTECTED]
Subject: Error -904 when selecting without result


Hi,

I have a application that sometimes get error -904.
It does a lot of selects which returns no result set
and I think that is the reason.

My system is an Intel box with Redhat 7.2, SAP DB 7.3.0.18, DBI 1.201,
DBD::ODBC 0.32.

This script does not eat Temp Space (select return one row):

#!/usr/bin/perl
use DBI;
$dbh=DBI->connect('dbi:ODBC:TST', 'TEST', 'TEST');
$dbh->do("create table TESTA (ID INTEGER NOT NULL, PRIMARY KEY(ID))");
$dbh->do("insert into TESTA (ID) VALUES (1)");
while (1)
{
        $x=$dbh->selectall_arrayref("select ID from TESTA where ID=1");
}

This scipt eats Temp Space (the select returns no rows):

#!/usr/bin/perl
use DBI;
$dbh=DBI->connect('dbi:ODBC:TST', 'TEST', 'TEST');
$dbh->do("create table TESTA (ID INTEGER NOT NULL, PRIMARY KEY(ID))");
$dbh->do("delete from TESTA where ID=1");
while (1)
{
        $x=$dbh->selectall_arrayref("select ID from TESTA where ID=1");
}

Is this a known bug in the SAP DB server?

There are other postings to this list with people getting -904 after the
application
have been running for a while. Does those applications also do selects which
sometimes does not return any result set?

# schoen


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