[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

RDA Push error 29025

Posted on 2010-04-05
1
Medium Priority
?
439 Views
Last Modified: 2013-12-27
Hi,

I´m developing a Windows Mobile application and have a Pull() of 5 tables with tracking on and index, and have more about 15 tables with tracking off.

So in other place I have an event that do a Push() of this 5 tracked tables. All was ok with this Push() unil now, but I don´t know why I´m gettiing the error 29025 SSCE_M_VF_MISSINGSERVERPKCOLUMN that mean: "The push operation cannot find a primary key column on the SQL Server table."

The problem is that I checked many times if the 5 tables at server have the same primary key than SQL CE and YES, the tables schema are exactly the same. Then I deleted the SDF database and made a compelte Pull to ensure database schema... and I get the same problem 29025.

Any ideas about why this can happen? SQL Server is 2008, SQL CE is 3.1, the SQL CE native of Windows Mobile 6.0 with native netcf 2.0. Server agent is sqlcesa35.dll.

As I remember, NOTHING was changed at SQL Server since last time I see Push running ok. And the only thing changed at Windows Mobile is that AFTER the 5 tables Push now I have some another mobile database data processing.

I can´t find NOTHING about SSCE_M_VF_MISSINGSERVERPKCOLUMN at google, except MSDN page about error range...
0
Comment
Question by:Eternal_Bard
1 Comment
 

Accepted Solution

by:
Eternal_Bard earned 0 total points
ID: 29931614
I found the problem. It´s all about schema miss managed by RDA.

At server, I have 2 tables Schema1.Table1 and Schema2.Table1, so RDA Pull Table1 from schema1, because SQL userid used by RDA is an userId that has access just to Schema1, and is it´s default Schema.

But when RDA makes a Push, using SQL Profile I found that 2 procedures are executed:

EXECUTE sp_columns_rowset N'Table1',NULL,NULL
EXECUTE sp_primary_keys_rowset N'Table1',NULL

Parameter 2, that is NULL, is the SchemaName. So RDA could have schema parameter but hasn´t. And pass NULL instead. SQL Server then returns rows of columns and primary keys from both Table1, from Schema1 and Schema2 and this causes the error 29025 (SSCE_M_VF_MISSINGSERVERPKCOLUMN).

I checked for constraint PK names to be different between Schema1.Table1 and Schama2.Table1 and do not solved.

Then I changed the names of tables from Schema2, and the problem was workarounded.
Creation os Synonym wasn´t useful too. Just change table names to make them unic for the procedures sp_columns_rowset and sp_primary_keys_rowset that accept schema name but RDA don´t know how to manage schemas and pass it to procedure.

RDA could store schema at ce local system tables, it has fields for it. Or RDA could accept to pass schema with table name or as a new parameter. But that is: Do not use tables with same names of another table from anoter schema. Use always unique names between differente schemas for sync with RDA.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
If you have a smartphone, I'm sure you've noticed that web applications are changing. Yet, are you aware of how these changes are going to impact your organization or company?
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question