Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database Processing Error

3 posts in General Discussion Last posting was on 2007-10-11 18:18:03.0Z
Loya Posted on 2007-10-11 16:51:46.0Z
Reply-To: "Loya" <lkelso@isprit.com>
From: "Loya" <lkelso@isprit.com>
Newsgroups: ianywhere.public.general
Subject: Database Processing Error
Lines: 18
Organization: Isprit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: adsl-71-156-83-100.dsl.ipltin.sbcglobal.net
X-Original-NNTP-Posting-Host: adsl-71-156-83-100.dsl.ipltin.sbcglobal.net
Message-ID: <470e54a2@forums-1-dub>
Date: 11 Oct 2007 09:51:46 -0700
X-Trace: forums-1-dub 1192121506 71.156.83.100 (11 Oct 2007 09:51:46 -0700)
X-Original-Trace: 11 Oct 2007 09:51:46 -0700, adsl-71-156-83-100.dsl.ipltin.sbcglobal.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6405
Article PK: 4737

Hi,

My client experienced this error message when trying to print multiple
visits that he patient had made to the doctor. I have two questions.

1. What does it mean?
2. Is there somewhere that I can find a list of error codes for future
reference.



DATABASE PROCESSING ERROR
A database problem occurred while your request was
being processed. Here are the details:

-308sqlerrtest:Select Error:SQL State=S1000


Chris Keating (Sybase iAnywhere) Posted on 2007-10-11 18:17:55.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Database Processing Error
References: <470e54a2@forums-1-dub>
In-Reply-To: <470e54a2@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-d620.sybase.com
X-Original-NNTP-Posting-Host: keating-d620.sybase.com
Message-ID: <470e68d3$1@forums-1-dub>
Date: 11 Oct 2007 11:17:55 -0700
X-Trace: forums-1-dub 1192126675 10.25.98.110 (11 Oct 2007 11:17:55 -0700)
X-Original-Trace: 11 Oct 2007 11:17:55 -0700, keating-d620.sybase.com
Lines: 25
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6409
Article PK: 2880

This means that a disconnect occurred. You will need to do more
diagnostics to determine the reason. On the server, add -z.

Need more info about the version of SQL Anywhere but in more recent
versions add LOG=<filespec> to create a client debug log file.

Loya wrote:
> Hi,
>
> My client experienced this error message when trying to print multiple
> visits that he patient had made to the doctor. I have two questions.
>
> 1. What does it mean?
> 2. Is there somewhere that I can find a list of error codes for future
> reference.
>
>
>
> DATABASE PROCESSING ERROR
> A database problem occurred while your request was
> being processed. Here are the details:
>
> -308sqlerrtest:Select Error:SQL State=S1000
>
>


Breck Carter [Team iAnywhere] Posted on 2007-10-11 18:18:03.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Database Processing Error
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <i3qsg39147sbo6k4q7g76pnb9bvur80n2f@4ax.com>
References: <470e54a2@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 11 Oct 2007 11:18:03 -0700
X-Trace: forums-1-dub 1192126683 64.7.134.118 (11 Oct 2007 11:18:03 -0700)
X-Original-Trace: 11 Oct 2007 11:18:03 -0700, bcarter.sentex.ca
Lines: 71
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6410
Article PK: 4740

SQLCODE -308 means the connection was terminated (see below).

You can find SQLCODE values in the Help by using the Index tab to
search on the value such as -308

Breck


=====
SQL Anywhere® 10 - Error Messages > Database Error Messages >
Alphabetic list of error messages

Connection was terminatedItem
Value

Constant
SQLE_CONNECTION_TERMINATED

ODBC 2 State
ERROR

ODBC 3 State
ERROR

Severity
16

SQLCODE
-308

SQLSTATE
40W07

Sybase error code
4224


Probable cause
Your database connection has been terminated and your transaction has
been rolled back. The connection may have been terminated because a
DBA executed a DROP CONNECTION statement, or because the database
server was shut down, or because your network connection to the
database server was interrupted.
=====

On 11 Oct 2007 09:51:46 -0700, "Loya" <lkelso@isprit.com> wrote:

>Hi,
>
>My client experienced this error message when trying to print multiple
>visits that he patient had made to the doctor. I have two questions.
>
>1. What does it mean?
>2. Is there somewhere that I can find a list of error codes for future
>reference.
>
>
>
>DATABASE PROCESSING ERROR
> A database problem occurred while your request was
>being processed. Here are the details:
>
> -308sqlerrtest:Select Error:SQL State=S1000
>

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com