|
Home > Archive > SQL Anywhere Mobile > July 2005 > Cannot drop the table '#elbat_yraropmet_ymmud_a_si_siht'
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cannot drop the table '#elbat_yraropmet_ymmud_a_si_siht'
|
|
| Yasir Masood 2005-06-22, 11:24 am |
| Hi Guys,
I am using Mobilink 9.0.1 1922 and Microsoft SQL server 2000
as the
consolidated database. When I run the Synchronization from
my PocketBuilder App (2.0.1 Build 688), I get this error
message in
my log file.
[-10002] ODBC: [Microsoft][ODBC SQL Server Driver][SQL
Server] Cannot drop the table
'#elbat_yraropmet_ym
mud_a_si_siht', because it does not
exist in the system catalog. (ODBC State = 42S02, Native
error code = 3701)
There is no update to the SQL Server and the rows are
deleted from my ASA DB.
I would appreciate your help.
Thanks
| |
| Breck Carter [TeamSybase] 2005-06-22, 8:24 pm |
| That's been fixed, upgrade to a later build or 9.0.2.
BTW, the table name is spelled backwards :)
Breck
On 22 Jun 2005 08:12:06 -0700, Yasir Masood wrote:
>Hi Guys,
>
>I am using Mobilink 9.0.1 1922 and Microsoft SQL server 2000
>as the
>consolidated database. When I run the Synchronization from
>my PocketBuilder App (2.0.1 Build 688), I get this error
>message in
>my log file.
>
>[-10002] ODBC: [Microsoft][ODBC SQL Server Driver][SQL
>Server] Cannot drop the table
> '#elbat_yraropmet_ym
mud_a_si_siht', because it does not
>exist in the system catalog. (ODBC State = 42S02, Native
>error code = 3701)
>
>There is no update to the SQL Server and the rows are
>deleted from my ASA DB.
>
>I would appreciate your help.
>
>Thanks
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Yasir Masood 2005-06-23, 8:24 pm |
| I upgraded to 9.0.2 build 2451 (Developer Edition). But I am
still getting the same error.
Any suggestions.
Thanks.
> That's been fixed, upgrade to a later build or 9.0.2.
>
> BTW, the table name is spelled backwards :)
>
> Breck
>
> On 22 Jun 2005 08:12:06 -0700, Yasir Masood wrote:
>
> 2000 >as the
> from >my PocketBuilder App (2.0.1 Build 688), I get this
> error >message in
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
|
|
| Yasir Masood 2005-06-24, 9:24 am |
| Breck,
I am testing my application on my desktop. So the ASA DB,
MobiLink Server and PocketBuilder is running on the same
machine.
I called the Tech Support to open a new case but since I
don't
have a service contract, they cannot help me.
Any other suggestion? Thanks
> Did you upgrade the software on the machine running the
> MobiLink server as well?
>
> If so, and it still doesn't work, you should probably call
> tech support; see
> http://www.sybase.com/contactus/support#tech
>
> Breck
>
>
> On 23 Jun 2005 12:08:20 -0700, Yasir Masood wrote:
>
> am >still getting the same error.
> server >> 2000 >as the
> this >> error >message in
> not >> >exist in the system catalog. (ODBC State = 42S02,
> Native >> >error code = 3701)
> oad-20 >> bcarter@risingroad.com
> Services >> www.risingroad.com
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| Breck Carter [TeamSybase] 2005-06-26, 9:23 am |
| Try starting a new thread; this thread is very old.
Start with a question "How do I <fix this problem>?" Describe the
whole problem; don't assume anyone has read your earlier messages.
Give the version and build numbers of everything: ASA, MSS, ODBC
driver, etc. Show the exact dbmlsrv9 -v+ log output.
Breck
On 24 Jun 2005 07:01:23 -0700, Yasir Masood wrote:
[color=darkred]
>Breck,
>
>I am testing my application on my desktop. So the ASA DB,
>MobiLink Server and PocketBuilder is running on the same
>machine.
>
>I called the Tech Support to open a new case but since I
>don't
>have a service contract, they cannot help me.
>
>Any other suggestion? Thanks
>
>http://www.amazon.com/exec/obidos/A...7/risingroad-20
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| David Fishburn 2005-06-29, 11:24 am |
| Yasir Masood wrote in news:42b97fc2.21a6.1681692777@sybase.com of
sybase.public.sqlanywhere.mobilink:
I see from a new thread the issue was due to a stored procedure that
performed commits within the upload transaction.
This is just an FYI for anyone reading this thread, you must never do
anything that results in a commit during the upload phase of a MobiLink
synchronization.
In this case, SQL Server was dropping the temporary table after the commit.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -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
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Eric Odom 2005-07-07, 11:24 am |
| I have seen this issue if there was a cascading trigger set on the
synchronized table.
<Yasir Masood> wrote in message news:42b97fc2.21a6.1681692777@sybase.com...
> Hi Guys,
>
> I am using Mobilink 9.0.1 1922 and Microsoft SQL server 2000
> as the
> consolidated database. When I run the Synchronization from
> my PocketBuilder App (2.0.1 Build 688), I get this error
> message in
> my log file.
>
> [-10002] ODBC: [Microsoft][ODBC SQL Server Driver][SQL
> Server] Cannot drop the table
> '#elbat_yraropmet_ym
mud_a_si_siht', because it does not
> exist in the system catalog. (ODBC State = 42S02, Native
> error code = 3701)
>
> There is no update to the SQL Server and the rows are
> deleted from my ASA DB.
>
> I would appreciate your help.
>
> Thanks
|
|
|
|
|