Please Help me:SQL statement failed: (-301) Internal database error ??? -- transaction rolled back SQL statement failed: (-101) Not connected to a database

Hi all,

I am using Adaptive Server Anywhere 8  version 8.0.2.4239. I am able to
sync successfully between 2 desktops with the same version.
When I am trying to sync with my pocket pc device version 8.0.4122,
Towards the end of Synchronization (nearly 95% completed) ,I am getting this
error
    "E. 05/29 19:28:31. SQL statement failed: (-301) Internal database error
??? -- transaction rolled back
     E. 05/29 19:28:31. SQL statement failed: (-101) Not connected to a
database"


The log file contains

E. 05/29 19:28:31. SQL statement failed: (-301) Internal database error
??? -- transaction rolled back
E. 05/29 19:28:31. SQL statement failed: (-101) Not connected to a database
I. 05/29 19:28:31. ROLLBACK
E. 05/29 19:28:31. Download stream processing failed
I. 05/29 19:28:31. Sending a failure status to the MobiLink server.
I. 05/29 19:28:32. End synchronizing 'SyncPublication' for MobiLink user
'4G18DW3160LY'
I. 05/29 19:28:32. Disconnecting from MobiLink server
I. 05/29 19:28:32. Synchronization completed
E. 05/29 19:28:32. SQL statement failed: (-101) Not connected to a database
I. 05/29 19:28:33. Disconnecting from remote database



Please advise me.....,

Thanks in advance
srinivas



0
chandhu
5/31/2003 5:07:14 AM
sybase.sqlanywhere.mobilink 5254 articles. 0 followers. Follow

4 Replies
1964 Views

Similar Articles

[PageSpeed] 46

"chandhu" <chandrasekhars@i-vantage.com> wrote in
news:#0jiAKzJDHA.218@forums-2-dub: 

> Hi all,
> 
> I am using Adaptive Server Anywhere 8  version 8.0.2.4239. I am able
> to sync successfully between 2 desktops with the same version.

There is a newer EBF available for CE, please try it.

SQL Anywhere Studio - Express Bug Fix, Update of 8.0.2 to build 4251
--
David Fishburn
NEW - Certified ASA Developer Version 8
Sybase - iAnywhere Solutions
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with EACH
post (dbeng8 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm 

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com


0
David
6/2/2003 1:29:40 PM
Hi,
Thanks for the reply.

We have also tried with the latest EBF Update of 8.0.2 to build 4251, but it
failed when using it too. Both the the Pocket PC and the Desktop run the
same versions - ASA 8.0.2.4251. The error reported is as follows:

============================================================================
==
E. 06/01 00:41:20. SQL statement failed: (-301) Internal database error ***
ERROR *** Assertion failed: 201847 (8.0.2.4251)
Checkpoint log: write t
E. 06/01 00:41:20. SQL statement failed: (-101) Not connected to a database
I. 06/01 00:41:21. ROLLBACK
E. 06/01 00:41:21. Download stream processing failed
I. 06/01 00:41:21. Sending a failure status to the MobiLink server.
I. 06/01 00:41:21. End synchronizing 'SyncPublication' for MobiLink user
'4G18DW3160LY'
I. 06/01 00:41:21. Disconnecting from MobiLink server
I. 06/01 00:41:22. Synchronization completed
E. 06/01 00:41:22. SQL statement failed: (-101) Not connected to a database
I. 06/01 00:41:22. Disconnecting from remote database
============================================================================
===

Thanks in advance
Srinivas

----- Original Message -----
From: "David Fishburn" <fishburn_spam_off@sybase.com>
Newsgroups: sybase.public.sqlanywhere.mobilink
Sent: Monday, June 02, 2003 6:59 PM
Subject: Re: Please Help me:SQL statement failed: (-301) Internal database
error ??? -- transaction rolled back SQL statement failed: (-101) Not
connected to a database


> "chandhu" <chandrasekhars@i-vantage.com> wrote in
> news:#0jiAKzJDHA.218@forums-2-dub:
>
> > Hi all,
> >
> > I am using Adaptive Server Anywhere 8  version 8.0.2.4239. I am able
> > to sync successfully between 2 desktops with the same version.
>
> There is a newer EBF available for CE, please try it.
>
> SQL Anywhere Studio - Express Bug Fix, Update of 8.0.2 to build 4251
> --
> David Fishburn
> NEW - Certified ASA Developer Version 8
> Sybase - iAnywhere Solutions
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD number with EACH
> post (dbeng8 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
>


0
chandhu
6/2/2003 1:52:52 PM
Hi,
Thanks for the reply.

We have also tried with the latest EBF Update of 8.0.2 to build 4251, but it
failed when using it too. Both the the Pocket PC and the Desktop run the
same versions - ASA 8.0.2.4251. The error reported is as follows:

============================================================================
==
E. 06/01 00:41:20. SQL statement failed: (-301) Internal database error ***
ERROR *** Assertion failed: 201847 (8.0.2.4251)
Checkpoint log: write t
E. 06/01 00:41:20. SQL statement failed: (-101) Not connected to a database
I. 06/01 00:41:21. ROLLBACK
E. 06/01 00:41:21. Download stream processing failed
I. 06/01 00:41:21. Sending a failure status to the MobiLink server.
I. 06/01 00:41:21. End synchronizing 'SyncPublication' for MobiLink user
'4G18DW3160LY'
I. 06/01 00:41:21. Disconnecting from MobiLink server
I. 06/01 00:41:22. Synchronization completed
E. 06/01 00:41:22. SQL statement failed: (-101) Not connected to a database
I. 06/01 00:41:22. Disconnecting from remote database
============================================================================
===

Thanks in advance
Srinivas

----- Original Message -----
From: "David Fishburn" <fishburn_spam_off@sybase.com>
Newsgroups: sybase.public.sqlanywhere.mobilink
Sent: Monday, June 02, 2003 6:59 PM
Subject: Re: Please Help me:SQL statement failed: (-301) Internal database
error ??? -- transaction rolled back SQL statement failed: (-101) Not
connected to a database


> "chandhu" <chandrasekhars@i-vantage.com> wrote in
> news:#0jiAKzJDHA.218@forums-2-dub:
>
> > Hi all,
> >
> > I am using Adaptive Server Anywhere 8  version 8.0.2.4239. I am able
> > to sync successfully between 2 desktops with the same version.
>
> There is a newer EBF available for CE, please try it.
>
> SQL Anywhere Studio - Express Bug Fix, Update of 8.0.2 to build 4251
> --
> David Fishburn
> NEW - Certified ASA Developer Version 8
> Sybase - iAnywhere Solutions
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD number with EACH
> post (dbeng8 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
>


0
chandhu
6/2/2003 1:55:49 PM
"chandhu" <chandrasekhars@i-vantage.com> wrote in
news:ur7o94QKDHA.221@forums-1-dub: 

> We have also tried with the latest EBF Update of 8.0.2 to build 4251,
> but it failed when using it too. Both the the Pocket PC and the
> Desktop run the same versions - ASA 8.0.2.4251. The error reported is
> as follows: 
> 
> =======================================================================
> ===== ==
> E. 06/01 00:41:20. SQL statement failed: (-301) Internal database
> error *** ERROR *** Assertion failed: 201847 (8.0.2.4251)
> Checkpoint log: write t

I am not sure why the above is cut off, but the full message is 
"Checkpoint log: write to %s failed with status %d: filesystem may be 
full".

Which I believes gives you a bit more to go on :-)

The full message would also provide the OS error code reported.  
Although, given the filesystem is full, I am not sure where you would 
write the log to.

How did you get the above output, was it from the -o file_name for the 
dbeng8 process on the CE device?

--
David Fishburn
0
David
6/2/2003 2:47:17 PM
Reply:

Similar Artilces:

New errors access MS SQL Server Database on (CREATE DATABASE and Batch SQL Statement)
------=_NextPart_000_002B_01C2F2CB.0C201FF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm running ActiveState perl 5.8.0 on a WIN2K box with MS SQL Server = 2000. Recently I updated DBD-ODBC to v1.05 and DBI to v1.35 Now I get the following errors executing some sql commands CREATE SQLSTMT:[CREATE DATABASE POMS_SER ON (NAME =3D 'POMS_SER_DAT', = FILENAME =3D 'd:\Database\POMS\POMS_SER_Data.MDF', SIZE =3D 10MB) LOG ON = ( NAME =3D 'POMS_SER_LOG', FILENAME =3D = 'd:\Database\POMS\POMS_S...

stored procedures fails if a sql statement fails internal to
This is a multi-part message in MIME format. ---=_forums-1-dub4bf2f8e2 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit We are using 8.0.3 5002. we have a stored procedure and it calls another procedure toward the end to complete the needed steps. We have placed several print statements to follow the flow. It appears that after the 10th print 'Inside delete block 3.\x0A' statement we see in code the record must not exist or something. Sometimes all these records may not exist but if they do we need to delete or fall through to ...

SQL statement failed: (-305) I/O error Fatal error: A disk read from file "SomeDatabase.db" failed with error code: (38)
SQL Anywhere 10.0.1.3831 E. 2009-09-11 21:55:41. SQL statement failed: (-305) I/O error Fatal error: A disk read from file "D:\FHMSL\iFHMS\Data\Feedlot111.db" failed with error code: (38) -- transaction rolled back E. 2009-09-11 21:55:41. Error while executing hook procedure sp_hook_dbmlsync_end. Received this error while running a proc during sync. Tried to validate the db in Sybase Central resulting in the same error. I saw the post at http://groups.google.com/group/sybase.public.sqlanywhere.general/browse_thread/thread/b5d958904160e576?fwc=1 and am wondering if th...

Cannot update database using sql statement... help please
Hi All,  I have watched one of the video tutorials under SQL Server section called "Connecting your web application to SQL server 2005 express edition" (number 8). It was about creating a database with single table and then updating it by inserting new records in a text box an clicking on submit button. In code section there is a sql insert statement and connection string is via configurationManager (name of the connection string is taken from web.config and is spelled properly) Anyway, my problem is that updating that database by filling the textbox and clicking submi...

SQL statement failed: (-300) run time SQL error -- double request
Running Sybase 5.5.04 getting the above error message after dbremote has received and applied its messages. Using the Send every method setting for every 12 hours. Here is a snip it of the output messages. Any ideas would be greatly appreciated! Thanks -Matt Sybase SQL Remote Message Agent Version 5.5.04 Build #1956 Copyright by Sybase, Inc., and its subsidiaries, 1988, 1998. All rights reserved. Sybase is a trademark of Sybase, Inc. Incoming messages from directory \\mspexp04\exprepl$\transfer\CTG\RMGMF01 Received message from "Consolidated" (5-0434534311-0) Appl...

dbremote SQL statement failed: (-100) Database server not running Execution completed
Hello everybody, I'm using an old Sybase SQL Remote Message Agent Version 6.0.4.3800. it was working with no problem until some day last week. The replication suddenly stopped saying E. 03/13 19:11:54. SQL statement failed: (-100) Database server not running I. 03/13 19:11:55. Execution completed It is very strange, because nobody did anything to the database and the server. If I stop dbsrv6, it gives me almost the same error: E. 03/13 19:29:57. SQL statement failed: (-100) Database server not running E. 03/13 19:29:58. Error connecting to database Any other utilities like...

What causes "SQL statement failed: (-81) invalid database engine" with DBREMOTE
This is a multi-part message in MIME format. ------=_NextPart_000_0032_01BF8FFE.91631C40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If I try to start DBREMOTE from the command line using the command: D:\EXP50\EXP50SRV\DBREMOTE.EXE -c = "uid=3DDBA;pwd=3DSQL;eng=3DEXP50SRV;DBN=3Dexp50" -x -v -o = d:\exp50\exp50srv\EXP50SRV.txt d:\exp50\exp50srv\database It works fine. If I try to use it (DBREMOTE) as a service, it gives the following = error: "SQL statement failed: (-81) invalid database engine"...

Inserting SQL statements into a SQL Server 2000 database
Hi all Am attempting to create an audit table that will allow me to keep tracke of who is doing what where and when. On thing that i want to insert into this table, is the actual command that was executed, however when i look at the data that i inserted all that i get is "System.Data.SqlClient.SqlCommand" in the field. Any suggestion on how to overcome this problem. Mike55 Hello Mike55 if I understand you right, you like to record each request to have the possibility to control who do what and when. I think a good possibility is to create a httphandler to record all...

SQL statement error
Greetings! I have two tables in my access database; (1) PatientDemographics and (2)AppointmentRequest. I can succesfully insert the data into the table AppointmentRequest. The issue started when I try to tell my SQL statement that the data I'm inserting into the AppointmentRequest table has to belong to the PatientID from the PatientDemographics table. In addition, I have created the relationship in the database and it looks fine (one to many). This is the code I wrote:string AppCommand = "INSERT INTO AppointmentRequest (AppointmentNum...

SQL statement failed: (-305) I/O error Fatal error: No such file or directory
Hi, I have sybase 9.0.2.3586 on the remote DB on PDA. We are trying to sync it to the SQL Server 2005 on the server. It is successful for all our clients except in one case we are getting this following error. E. 05/22 11:09:08. SQL statement failed: (-305) I/O error Fatal error: No such file or directory -- transaction rolled back E. 05/22 11:09:08. SQL statement failed: (-101) Not connected to a database E. 05/22 11:09:08. SQL statement failed: (-101) Not connected to a database E. 05/22 11:09:08. SQL statement failed: (-101) Not connected to a database Please reply if ...

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'WinFM SQL PFS'. Login fails.
HiASP pages were properly connecting to SQL DB until I restored from a backup DB.  As soon as I finished restoring from the backup DB, I am getting the following error message.   I did not make any changes on ASP side.  IIS Server and SQL 2K Server is running on a WIN2K Server Box.Please help.Thank you.HTTP 500.100 - Internal Server Error - ASP errorInternet Information ServicesTechnical Information (for support personnel)Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login...

SQL statement failed: (-85) Communication error
I'm getting the following error in the log file for BOTH sqlRemote Sessions (occur at same time) - what does it mean ? E. 05/29 17:01:22. SQL statement failed: (-85) Communication error E. 05/29 17:01:22. Communication error (-85) Mark ASA 8.02.4089 SQL Remote lost it's connection to the database engine. If dbremote talks over the network the database engine, it's possible that you're network was having trouble at the time. -- Reg Domaratzki, Sybase iAnywhere Solutions Sybase Certified Professional - Sybase ASA Developer Version 8 Please reply only to...

Update SQL Statement -- Error. Please Help
I have an update statement that looks llike this: updateSQL = "Update Painting Set PaintStatus = 2, BuyerID = '"+ mBuyerID +"' where Painting.PaintID='"+ paintID +"'"; Here the mBuyerID is hard coded (Integer), paintID is hard coded (Integer). In the database where the update will take place BuyerId is an autonumber and paintID is a number. The process of update that I am using is as follows: OleDbCommand objCommand = null; String connect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("database.mdb"); ...

SQL Server 2005 error when trying to connect to sql server 2000 database
Hi all.I am working on asp.net 2.0 with back end as sqlserver 2000. but when trying to connect to the database i am getting the following error displayed An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Description: An unhandled exception occurred during the execution of the current web request. Please review the...

Failing SQL statements
Hello, I have run into a problem when running SQL remote. after I initiate it on the remote site (which runs unattended BTW), it begins reading messages, and then it hits a message that causes dbremote to exit. Here is an excerpt from the end of the log file being generated: Received message from "KIOSKMASTER" (2-0096781052-0) SQL statement failed: (-260) variable 'CheckingTime' not found SQL statement failed: (-140) userid '' does not exist SQL statement failed: (-108) connection not found SQL statement failed: (-140) userid '' does not exist ...

Web resources about - Please Help me:SQL statement failed: (-301) Internal database error ??? -- transaction rolled back SQL statement failed: (-101) Not connected to a database - sybase.sqlanywhere.mobilink

Transaction cost - Wikipedia, the free encyclopedia
Bargaining costs are the costs required to come to an acceptable agreement with the other party to the transaction, drawing up an appropriate ...

Sheryl Sandberg, Peter Thiel, Mail.ru Group Involved In Notable Facebook Stock Transactions
Facebook shares were involved in some large transactions in recent days, with moves by Chief Operating Officer Sheryl Sandberg , board member ...

Twitter’s Site Upgrade Reveals New Social, Transaction Possibilities for Third Parties
Twitter has launched the biggest redesign in its company history, introducing a new interface for Twitter.com that makes it easier to share and ...

Transaction Network Services - LinkedIn
Learn about working at Transaction Network Services. Join LinkedIn today for free. See who you know at Transaction Network Services, leverage ...

DocuSign Transaction Rooms (formerly Cartavi) on the App Store on iTunes
Get DocuSign Transaction Rooms (formerly Cartavi) on the App Store. See screenshots and ratings, and read customer reviews.

Banks playing key role in reporting transactions with suspected terrorism links, Austrac says
Australia's financial intelligence agency Austrac is monitoring the financial DNA of those Australians likely to transfer money to fund Islamic ...

IDG Contributor Network: Avoiding ginormous transaction logs with SharePoint databases
There isn’t a week that goes by that I don’t hear or read about an organization seeing ginormous transaction log (.ldf) files, while the associated ...

After asking UAE bank for $3 million ransom, hacker dumps tens of thousands of customers' transactions ...
He calls himself Hacker Buba, and he's shared tens of thousands of customers' complete financial information.

Check your credit card transactions: 54 Starwood hotels hit by malware
Third-party forensic experts have discovered that the point-of-sale systems in 54 Starwood hotels across the US and Canada were infected with ...

Tender Armor Adding New Layer of Security to Credit Card Transactions
The startup's CvvPlus fraud prevention technology provides another layer of authentication via a randomly generated CVV number sent to the credit ...

Resources last updated: 1/6/2016 1:09:23 AM