replication failed after restart

Hi..

I've 3 pc that have MS SQL 2000 database installed in it and connected to main server through merge replication.

At first it run fine all the time. But now, it doesn't. It's happen when the pc have to restart every night. When i come to the office and check resplication status it return failed. I try to manually start synchronize but it failed too. I've to restart the pc all over again untill it ok.

I hope some body out there can explain something to me and how to overcome the problem...

If the PC restarts during the initialization then it will fail and you will have to start initialization again.

It would be helpful to know the error messages.

Martin

|||

the error message is

the process could not connect to subscriber

|||

Can you confirm that the subscribers are up and running? After a reboot are the SQL Services all started and the databases available?

|||yes...|||

Instead of restarting the pc, did you try connecting to the subscriber via isqlw, osql.exe or some other client tool with the same credentials that the merge agent uses? If that also fails then it's not replication.

replication failed after restart

Hi..

I've 3 pc that have MS SQL 2000 database installed in it and connected to main server through merge replication.

At first it run fine all the time. But now, it doesn't. It's happen when the pc have to restart every night. When i come to the office and check resplication status it return failed. I try to manually start synchronize but it failed too. I've to restart the pc all over again untill it ok.

I hope some body out there can explain something to me and how to overcome the problem...

If the PC restarts during the initialization then it will fail and you will have to start initialization again.

It would be helpful to know the error messages.

Martin

|||

the error message is

the process could not connect to subscriber

|||

Can you confirm that the subscribers are up and running? After a reboot are the SQL Services all started and the databases available?

|||yes...|||

Instead of restarting the pc, did you try connecting to the subscriber via isqlw, osql.exe or some other client tool with the same credentials that the merge agent uses? If that also fails then it's not replication.

sql

replication failed after restart

Hi..

I've 3 pc that have MS SQL 2000 database installed in it and connected to main server through merge replication.

At first it run fine all the time. But now, it doesn't. It's happen when the pc have to restart every night. When i come to the office and check resplication status it return failed. I try to manually start synchronize but it failed too. I've to restart the pc all over again untill it ok.

I hope some body out there can explain something to me and how to overcome the problem...

If the PC restarts during the initialization then it will fail and you will have to start initialization again.

It would be helpful to know the error messages.

Martin

|||

the error message is

the process could not connect to subscriber

|||

Can you confirm that the subscribers are up and running? After a reboot are the SQL Services all started and the databases available?

|||yes...|||

Instead of restarting the pc, did you try connecting to the subscriber via isqlw, osql.exe or some other client tool with the same credentials that the merge agent uses? If that also fails then it's not replication.

replication failed after restart

Hi..

I've 3 pc that have MS SQL 2000 database installed in it and connected to main server through merge replication.

At first it run fine all the time. But now, it doesn't. It's happen when the pc have to restart every night. When i come to the office and check resplication status it return failed. I try to manually start synchronize but it failed too. I've to restart the pc all over again untill it ok.

I hope some body out there can explain something to me and how to overcome the problem...

If the PC restarts during the initialization then it will fail and you will have to start initialization again.

It would be helpful to know the error messages.

Martin

|||

the error message is

the process could not connect to subscriber

|||

Can you confirm that the subscribers are up and running? After a reboot are the SQL Services all started and the databases available?

|||

yes...|||

Instead of restarting the pc, did you try connecting to the subscriber via isqlw, osql.exe or some other client tool with the same credentials that the merge agent uses? If that also fails then it's not replication.

Replication Error: 4138

If our subcribers try to synchronize the following error occurs. The Upload of the data works but the download failes.

Error messages:
The merge process was unable to perform data validation on
article 'tbl_xTableFieldValue'. Check for SQL Server
errors in the Windows application event log or retry at a
later time. (Source: MSSQL_REPL, Error number:
MSSQL_REPL2147766343)
Get help: http://help/MSSQL_REPL2147766343

Conflicting locking hints are specified for
table "fncReplicationFilterTableFieldValue". This may be
caused by a conflicting hint specified for a view.
(Source: MSSQLServer, Error number: 4138)
Get help: http://help/4138

What does this mean and how can we resolve this?

Best regards,
Markus

This error means that when the merge agent attempted to validate that the replicated data at the Publisher and Subscriber was the same, it was not the same. From the "Validating Replicated Data" topic in SQL Server Books Online:

"Is the fact that validation failed an issue for your application? If the validation failure is an issue, manually update the data so that it is synchronized, or reinitialize the subscription:

"Data can be updated using the tablediff Utility. For more information about using this utility, see How to: Compare Replicated Tables for Differences (Replication Programming).

"For more information about reinitializaton, see Reinitializing a Subscription."

Phillip Garding
Senior Program Manager
Microsoft SQL Server Replication Management Tools

sql

replication error after database update

I have a system where I utilize merge replication between sqlserver2000 and
pocketpc sqlservece 2.0. The setup is very mature, and has been working fine
until I had my customer "refresh" the database with new data. We're still in
the testing phase, and the database I connect to is a copy of their live
one. After the database was restored from a backup of the live database, I
get the following error on the pocketpc when attempting to perform a merge.
Unique indexes and constraints cannot be created on columns that allow null
values
That's as descriptive as the error gets. I have a few questions:
Is there any place either on the server or the pocketpc that I can find a
log with more information. The publication has many articles with many
fields. I can remove one at a time and figure out which one is causing the
problem, but it will take lots of time. I was hoping to find some
information as to which table is causing the problem.
Also I'm having difficulty removing an article from a publication after
subscriptions have been pulled or attempted to be pulled. I've
re-initialized subscriptions, but the articles cannot be removed. What's the
procedure for doing this?
sorry about double post, I got an error message that the first one wasn't
sent!
"mgarner1980" <mgarner@.kbsi.com> wrote in message
news:%23aiSjpAeFHA.3028@.TK2MSFTNGP09.phx.gbl...
> I have a system where I utilize merge replication between sqlserver2000
and
> pocketpc sqlservece 2.0. The setup is very mature, and has been working
fine
> until I had my customer "refresh" the database with new data. We're still
in
> the testing phase, and the database I connect to is a copy of their live
> one. After the database was restored from a backup of the live database, I
> get the following error on the pocketpc when attempting to perform a
merge.
> Unique indexes and constraints cannot be created on columns that allow
null
> values
>
> That's as descriptive as the error gets. I have a few questions:
>
> Is there any place either on the server or the pocketpc that I can find a
> log with more information. The publication has many articles with many
> fields. I can remove one at a time and figure out which one is causing the
> problem, but it will take lots of time. I was hoping to find some
> information as to which table is causing the problem.
>
> Also I'm having difficulty removing an article from a publication after
> subscriptions have been pulled or attempted to be pulled. I've
> re-initialized subscriptions, but the articles cannot be removed. What's
the
> procedure for doing this?
>

Replication Error 28559

We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication).

We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition.

I had a chat with one of the Microsoft online support person and what he said was to close the database before synchronising and also to check if the database on the PDA can be open normally using code when the error occurs. We have tested both scenarios and the error still comes. We do not use emulator in our developments. Any advice/help on this issue would be appreciated.

Moving to SQL Server Mobile forum since it sounds like this isn't really a replication problem. If it is, please assign it back to replication forum.|||

I also see this error sporadically on WM5 devices and also have to reset and reinstall SQL Mobile. Some people have gotten relief from opening a connection to SQL Mobile early in the app (in the Load event of the startup form for example), but that's not always an option if, for example, you are using AddOption.CreateDatabase and merge replicating when your app starts.

I will talk this over with the SQL Mobile team. I get the error on an IMate JasJar, but the only pattern I can see with it is if an initial replication fails, this error occurs the next time the app runs.

Darren

|||

When we were getting the 28559 error, if you changed the internet connection (e.g. if the wireless is off and the device is getting on to the internet using the USB cable, remove the cable and switch on wireless to use GPRS) it managed to do the sync without giving errors most of the time.

We also noticed that an instance of a SqlCeReplication has to be created at the beginning of the application otherwise its likely to get "A SQL Mobile DLL could not be loaded. reinstall SQL Mobile. [DLL Name = ..." error when the BeginSynchronize method was called.

-Samitha

|||

Any updates on this error from SQL mobile team?

-Samitha

|||

Hi Samitha,

I have passed on this question to some of my team folks and waiting for an answer.

Please bear with us.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||Hi Laxmi
what's the status about the solution to this 28599 SSCE_M_OPENDATABASE error?
I receive the error when I'm trying to synchronize my mobile application with merge replication.
I tried to do it like in the http://msdn2.microsoft.com/de-de/library/ms171908.aspx tutorial but I still receive this error.
When I'm changing AddOption.ExistingDatabase to AddOption.CreateDatabase the 28558 SSCE_M_CREATEDATABASE error occurs instead.
I tried to deploy it (from Visual Studio) with the emulator and as well with the device, still the same result.
Well the client agent seems to have a problem to access the database.

What I don't understand:
When I am synchronising manually from the mobile database to the publication database with SQL Server Management Studio it is working perfectly. What is the mobile application trying to do with the gathered data (that's working perfectly as well) by the repl.Synchronize() Command? Does it try to synchronize the data back to the mobileDatabase on that machine, from which i deployed it (according to the SubscriberConnectionString which is C:\foldername\database.sdf) or does it try to contact the Merge Replication Agent for synchronizing directly to the publisher database?

Florian Weber, University of Rapperswil, Switzerland
|||Hi there
hooray I managed to make it work. The problem was, that the path suggested by the Subscription Wizard isn't the one which should be on the mobile device.
Usually the application will have the following SubscriberConnectionString: "\Programs\applicationName\database.sdf"
If you are unsure of the path, look the installation path up in the dataexplorer of dthe mobile device

Florian
|||

Hello Laxmi,

I was just wondering if there was any progress made with regards to this isuue.

Thanks,
Samitha

|||

Hi Samitha,

There were many variants in which you can not open database in REPL/RDA scenarios. We addressed some in VS 2005 SP1 which is going to come out soon. I hope your varinat is also addressed in this.

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

Has anyone found solution to this problem ? I am having the same problem ... I have migrated an application from Pocket PC 2003 to Windows Mobile 5.0 ..I have changed the project and forms' Target platform to Windows Mobile 5.0 ... The application uses Merge Replication... It works fine on Pocket PC with 2003 but when I run it on Windows Mobile 5.0 device, it gives me this error 28559 "SQL Server Mobile encountered problems when opening the database."

If i do the replication in the constructor or load event of the first form/screen... then it works fine..but if call my MergeReplication function after a couple of screens or some processing .. it gives me the same error...

Is there a solution to this problem ?

Regards

|||

Hello Laxmi,

Do you know when we can expect this update? We are seeing this issue more and more since all our new customers are moving to use the Windows mobile 5 devices.

Thanks,
Samitha

|||

This causes me some concern. The company I work for are Gold Partners, and we have used MS technology throughout our application development.

We now have the interests of the likes of the Department of the Environment, Network Rail, to name but a few. They are very keen to see the application in its fully working state. One of the key selling points is that the system uses standard MS technologies, which ought to reassure them of longevity and stability.

I am accountable as the software engineer to my Directors, and I am in a position where I have had to re-compile the codebase to run on Mobile 5 platforms because they are the only platforms now being supplied.

How can I say to my Directors "sorry, but although we have developed this application for 20 months now, we will have to wait for Microsoft to sort out the bugs in their software, so you will have to tell the DoE and the other companies to come back later"?

I don't think they will say "never mind, it's only been a ￡400,000 investment. We can wait."

Please can you help me to sort out this problem urgently - I do not seem to be alone here, and not being able to replicate in a consistent and stable way is not an option for our development, and I am sure it is not an option for others.

|||

Nabeel Farid makes his point very eloquently.I want to add my concern.

I am the MD of the company of which samithad is the chief software architect. Finding a solution to this problem has become a joke, the thread was started on the 5^th of April, nearly 6 months ago! This forum is the main one for resolving technical problems and yet the effort spent on providing support from the Microsoft side has been minimal.Like Nabeel we are a Microsoft Partner heavily committed to using Microsoft technologies and have spent several ￡100k developing a product based on the synchronisation capability of SQL Mobile and it’s predecessor SQL CE.

The problem arrived with the move to SQL Mobile and occurs more with Windows Mobile 5 which is now becoming the norm. I appreciate that as an intermittent fault it is harder to track down, however sound replication is the cornerstone of a reliable synchronisation based product and SQL Mobile is failing in this regard.

No one at Microsoft appears to be putting any effort into solving the problem, the complete lack of any sense of urgency is particularly irksome. We are operating in the commercial world here and 6 months with zero progress is dismal

Jonn Fredericks

|||

Hi I was having the same problem. If i pushed the data back early on in the app everything worked fine. If I pushed it at the end (where I wanted to) I got the 28559 error

You need to scour your code for any and all tableadapters, tablereaders etc. anything at all that accesess the sqlmobile db. Make sure that they are all disposed of before you attempt to push your data back.

Worked for me! Good luck!

Replication Error 28559

We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication).

We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition.

I had a chat with one of the Microsoft online support person and what he said was to close the database before synchronising and also to check if the database on the PDA can be open normally using code when the error occurs. We have tested both scenarios and the error still comes. We do not use emulator in our developments. Any advice/help on this issue would be appreciated.

Moving to SQL Server Mobile forum since it sounds like this isn't really a replication problem. If it is, please assign it back to replication forum.|||

I also see this error sporadically on WM5 devices and also have to reset and reinstall SQL Mobile. Some people have gotten relief from opening a connection to SQL Mobile early in the app (in the Load event of the startup form for example), but that's not always an option if, for example, you are using AddOption.CreateDatabase and merge replicating when your app starts.

I will talk this over with the SQL Mobile team. I get the error on an IMate JasJar, but the only pattern I can see with it is if an initial replication fails, this error occurs the next time the app runs.

Darren

|||

When we were getting the 28559 error, if you changed the internet connection (e.g. if the wireless is off and the device is getting on to the internet using the USB cable, remove the cable and switch on wireless to use GPRS) it managed to do the sync without giving errors most of the time.

We also noticed that an instance of a SqlCeReplication has to be created at the beginning of the application otherwise its likely to get "A SQL Mobile DLL could not be loaded. reinstall SQL Mobile. [DLL Name = ..." error when the BeginSynchronize method was called.

-Samitha

|||

Any updates on this error from SQL mobile team?

-Samitha

|||

Hi Samitha,

I have passed on this question to some of my team folks and waiting for an answer.

Please bear with us.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||Hi Laxmi
what's the status about the solution to this 28599 SSCE_M_OPENDATABASE error?
I receive the error when I'm trying to synchronize my mobile application with merge replication.
I tried to do it like in the http://msdn2.microsoft.com/de-de/library/ms171908.aspx tutorial but I still receive this error.
When I'm changing AddOption.ExistingDatabase to AddOption.CreateDatabase the 28558 SSCE_M_CREATEDATABASE error occurs instead.
I tried to deploy it (from Visual Studio) with the emulator and as well with the device, still the same result.
Well the client agent seems to have a problem to access the database.

What I don't understand:
When I am synchronising manually from the mobile database to the publication database with SQL Server Management Studio it is working perfectly. What is the mobile application trying to do with the gathered data (that's working perfectly as well) by the repl.Synchronize() Command? Does it try to synchronize the data back to the mobileDatabase on that machine, from which i deployed it (according to the SubscriberConnectionString which is C:\foldername\database.sdf) or does it try to contact the Merge Replication Agent for synchronizing directly to the publisher database?

Florian Weber, University of Rapperswil, Switzerland
|||Hi there
hooray I managed to make it work. The problem was, that the path suggested by the Subscription Wizard isn't the one which should be on the mobile device.
Usually the application will have the following SubscriberConnectionString: "\Programs\applicationName\database.sdf"
If you are unsure of the path, look the installation path up in the dataexplorer of dthe mobile device

Florian
|||

Hello Laxmi,

I was just wondering if there was any progress made with regards to this isuue.

Thanks,
Samitha

|||

Hi Samitha,

There were many variants in which you can not open database in REPL/RDA scenarios. We addressed some in VS 2005 SP1 which is going to come out soon. I hope your varinat is also addressed in this.

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

Has anyone found solution to this problem ? I am having the same problem ... I have migrated an application from Pocket PC 2003 to Windows Mobile 5.0 ..I have changed the project and forms' Target platform to Windows Mobile 5.0 ... The application uses Merge Replication... It works fine on Pocket PC with 2003 but when I run it on Windows Mobile 5.0 device, it gives me this error 28559 "SQL Server Mobile encountered problems when opening the database."

If i do the replication in the constructor or load event of the first form/screen... then it works fine..but if call my MergeReplication function after a couple of screens or some processing .. it gives me the same error...

Is there a solution to this problem ?

Regards

|||

Hello Laxmi,

Do you know when we can expect this update? We are seeing this issue more and more since all our new customers are moving to use the Windows mobile 5 devices.

Thanks,
Samitha

|||

This causes me some concern. The company I work for are Gold Partners, and we have used MS technology throughout our application development.

We now have the interests of the likes of the Department of the Environment, Network Rail, to name but a few. They are very keen to see the application in its fully working state. One of the key selling points is that the system uses standard MS technologies, which ought to reassure them of longevity and stability.

I am accountable as the software engineer to my Directors, and I am in a position where I have had to re-compile the codebase to run on Mobile 5 platforms because they are the only platforms now being supplied.

How can I say to my Directors "sorry, but although we have developed this application for 20 months now, we will have to wait for Microsoft to sort out the bugs in their software, so you will have to tell the DoE and the other companies to come back later"?

I don't think they will say "never mind, it's only been a ￡400,000 investment. We can wait."

Please can you help me to sort out this problem urgently - I do not seem to be alone here, and not being able to replicate in a consistent and stable way is not an option for our development, and I am sure it is not an option for others.

|||

Nabeel Farid makes his point very eloquently.I want to add my concern.

I am the MD of the company of which samithad is the chief software architect. Finding a solution to this problem has become a joke, the thread was started on the 5^th of April, nearly 6 months ago! This forum is the main one for resolving technical problems and yet the effort spent on providing support from the Microsoft side has been minimal.Like Nabeel we are a Microsoft Partner heavily committed to using Microsoft technologies and have spent several ￡100k developing a product based on the synchronisation capability of SQL Mobile and it’s predecessor SQL CE.

The problem arrived with the move to SQL Mobile and occurs more with Windows Mobile 5 which is now becoming the norm. I appreciate that as an intermittent fault it is harder to track down, however sound replication is the cornerstone of a reliable synchronisation based product and SQL Mobile is failing in this regard.

No one at Microsoft appears to be putting any effort into solving the problem, the complete lack of any sense of urgency is particularly irksome. We are operating in the commercial world here and 6 months with zero progress is dismal

Jonn Fredericks

|||

Hi I was having the same problem. If i pushed the data back early on in the app everything worked fine. If I pushed it at the end (where I wanted to) I got the 28559 error

You need to scour your code for any and all tableadapters, tablereaders etc. anything at all that accesess the sqlmobile db. Make sure that they are all disposed of before you attempt to push your data back.

Worked for me! Good luck!

sql

Replication Error 28559

We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication).

We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition.

I had a chat with one of the Microsoft online support person and what he said was to close the database before synchronising and also to check if the database on the PDA can be open normally using code when the error occurs. We have tested both scenarios and the error still comes. We do not use emulator in our developments. Any advice/help on this issue would be appreciated.

Moving to SQL Server Mobile forum since it sounds like this isn't really a replication problem. If it is, please assign it back to replication forum.|||

I also see this error sporadically on WM5 devices and also have to reset and reinstall SQL Mobile. Some people have gotten relief from opening a connection to SQL Mobile early in the app (in the Load event of the startup form for example), but that's not always an option if, for example, you are using AddOption.CreateDatabase and merge replicating when your app starts.

I will talk this over with the SQL Mobile team. I get the error on an IMate JasJar, but the only pattern I can see with it is if an initial replication fails, this error occurs the next time the app runs.

Darren

|||

When we were getting the 28559 error, if you changed the internet connection (e.g. if the wireless is off and the device is getting on to the internet using the USB cable, remove the cable and switch on wireless to use GPRS) it managed to do the sync without giving errors most of the time.

We also noticed that an instance of a SqlCeReplication has to be created at the beginning of the application otherwise its likely to get "A SQL Mobile DLL could not be loaded. reinstall SQL Mobile. [DLL Name = ..." error when the BeginSynchronize method was called.

-Samitha

|||

Any updates on this error from SQL mobile team?

-Samitha

|||

Hi Samitha,

I have passed on this question to some of my team folks and waiting for an answer.

Please bear with us.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||Hi Laxmi
what's the status about the solution to this 28599 SSCE_M_OPENDATABASE error?
I receive the error when I'm trying to synchronize my mobile application with merge replication.
I tried to do it like in the http://msdn2.microsoft.com/de-de/library/ms171908.aspx tutorial but I still receive this error.
When I'm changing AddOption.ExistingDatabase to AddOption.CreateDatabase the 28558 SSCE_M_CREATEDATABASE error occurs instead.
I tried to deploy it (from Visual Studio) with the emulator and as well with the device, still the same result.
Well the client agent seems to have a problem to access the database.

What I don't understand:
When I am synchronising manually from the mobile database to the publication database with SQL Server Management Studio it is working perfectly. What is the mobile application trying to do with the gathered data (that's working perfectly as well) by the repl.Synchronize() Command? Does it try to synchronize the data back to the mobileDatabase on that machine, from which i deployed it (according to the SubscriberConnectionString which is C:\foldername\database.sdf) or does it try to contact the Merge Replication Agent for synchronizing directly to the publisher database?

Florian Weber, University of Rapperswil, Switzerland
|||Hi there
hooray I managed to make it work. The problem was, that the path suggested by the Subscription Wizard isn't the one which should be on the mobile device.
Usually the application will have the following SubscriberConnectionString: "\Programs\applicationName\database.sdf"
If you are unsure of the path, look the installation path up in the dataexplorer of dthe mobile device

Florian|||

Hello Laxmi,

I was just wondering if there was any progress made with regards to this isuue.

Thanks,
Samitha

|||

Hi Samitha,

There were many variants in which you can not open database in REPL/RDA scenarios. We addressed some in VS 2005 SP1 which is going to come out soon. I hope your varinat is also addressed in this.

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

Has anyone found solution to this problem ? I am having the same problem ... I have migrated an application from Pocket PC 2003 to Windows Mobile 5.0 ..I have changed the project and forms' Target platform to Windows Mobile 5.0 ... The application uses Merge Replication... It works fine on Pocket PC with 2003 but when I run it on Windows Mobile 5.0 device, it gives me this error 28559 "SQL Server Mobile encountered problems when opening the database."

If i do the replication in the constructor or load event of the first form/screen... then it works fine..but if call my MergeReplication function after a couple of screens or some processing .. it gives me the same error...

Is there a solution to this problem ?

Regards

|||

Hello Laxmi,

Do you know when we can expect this update? We are seeing this issue more and more since all our new customers are moving to use the Windows mobile 5 devices.

Thanks,
Samitha

|||

This causes me some concern. The company I work for are Gold Partners, and we have used MS technology throughout our application development.

We now have the interests of the likes of the Department of the Environment, Network Rail, to name but a few. They are very keen to see the application in its fully working state. One of the key selling points is that the system uses standard MS technologies, which ought to reassure them of longevity and stability.

I am accountable as the software engineer to my Directors, and I am in a position where I have had to re-compile the codebase to run on Mobile 5 platforms because they are the only platforms now being supplied.

How can I say to my Directors "sorry, but although we have developed this application for 20 months now, we will have to wait for Microsoft to sort out the bugs in their software, so you will have to tell the DoE and the other companies to come back later"?

I don't think they will say "never mind, it's only been a ￡400,000 investment. We can wait."

Please can you help me to sort out this problem urgently - I do not seem to be alone here, and not being able to replicate in a consistent and stable way is not an option for our development, and I am sure it is not an option for others.

|||

Nabeel Farid makes his point very eloquently.I want to add my concern.

I am the MD of the company of which samithad is the chief software architect. Finding a solution to this problem has become a joke, the thread was started on the 5^th of April, nearly 6 months ago! This forum is the main one for resolving technical problems and yet the effort spent on providing support from the Microsoft side has been minimal.Like Nabeel we are a Microsoft Partner heavily committed to using Microsoft technologies and have spent several ￡100k developing a product based on the synchronisation capability of SQL Mobile and it’s predecessor SQL CE.

The problem arrived with the move to SQL Mobile and occurs more with Windows Mobile 5 which is now becoming the norm. I appreciate that as an intermittent fault it is harder to track down, however sound replication is the cornerstone of a reliable synchronisation based product and SQL Mobile is failing in this regard.

No one at Microsoft appears to be putting any effort into solving the problem, the complete lack of any sense of urgency is particularly irksome. We are operating in the commercial world here and 6 months with zero progress is dismal

Jonn Fredericks

|||

Hi I was having the same problem. If i pushed the data back early on in the app everything worked fine. If I pushed it at the end (where I wanted to) I got the 28559 error

You need to scour your code for any and all tableadapters, tablereaders etc. anything at all that accesess the sqlmobile db. Make sure that they are all disposed of before you attempt to push your data back.

Worked for me! Good luck!

Replication Error 28559

We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication).

We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition.

I had a chat with one of the Microsoft online support person and what he said was to close the database before synchronising and also to check if the database on the PDA can be open normally using code when the error occurs. We have tested both scenarios and the error still comes. We do not use emulator in our developments. Any advice/help on this issue would be appreciated.

Moving to SQL Server Mobile forum since it sounds like this isn't really a replication problem. If it is, please assign it back to replication forum.|||

I also see this error sporadically on WM5 devices and also have to reset and reinstall SQL Mobile. Some people have gotten relief from opening a connection to SQL Mobile early in the app (in the Load event of the startup form for example), but that's not always an option if, for example, you are using AddOption.CreateDatabase and merge replicating when your app starts.

I will talk this over with the SQL Mobile team. I get the error on an IMate JasJar, but the only pattern I can see with it is if an initial replication fails, this error occurs the next time the app runs.

Darren

|||

When we were getting the 28559 error, if you changed the internet connection (e.g. if the wireless is off and the device is getting on to the internet using the USB cable, remove the cable and switch on wireless to use GPRS) it managed to do the sync without giving errors most of the time.

We also noticed that an instance of a SqlCeReplication has to be created at the beginning of the application otherwise its likely to get"A SQL Mobile DLL could not be loaded. reinstall SQL Mobile. [DLL Name = ..." error when the BeginSynchronize method was called.

-Samitha

|||

Any updates on this error from SQL mobile team?

-Samitha

|||

Hi Samitha,

I have passed on this question to some of my team folks and waiting for an answer.

Please bear with us.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||Hi Laxmi
what's the status about the solution to this 28599SSCE_M_OPENDATABASE error?
I receive the error when I'm trying to synchronize my mobile application with merge replication.
I tried to do it like in the http://msdn2.microsoft.com/de-de/library/ms171908.aspx tutorial but I still receive this error.
When I'm changing AddOption.ExistingDatabase to AddOption.CreateDatabase the28558 SSCE_M_CREATEDATABASE error occurs instead.
I tried to deploy it (from Visual Studio) with the emulator and as well with the device, still the same result.
Well the client agent seems to have a problem to access the database.

What I don't understand:
When I am synchronising manually from the mobile database to the publication database with SQL Server Management Studio it is working perfectly. What is the mobile application trying to do with the gathered data (that's working perfectly as well) by the repl.Synchronize() Command? Does it try to synchronize the data back to the mobileDatabase on that machine, from which i deployed it (according to the SubscriberConnectionString which is C:\foldername\database.sdf) or does it try to contact the Merge Replication Agent for synchronizing directly to the publisher database?

Florian Weber, University of Rapperswil, Switzerland
|||Hi there
hooray I managed to make it work. The problem was, that the path suggested by the Subscription Wizard isn't the one which should be on the mobile device.
Usually the application will have the following SubscriberConnectionString: "\Programs\applicationName\database.sdf"
If you are unsure of the path, look the installation path up in the dataexplorer of dthe mobile device

Florian
|||

Hello Laxmi,

I was just wondering if there was any progress made with regards to this isuue.

Thanks,
Samitha

|||

Hi Samitha,

There were many variants in which you can not open database in REPL/RDA scenarios. We addressed some in VS 2005 SP1 which is going to come out soon. I hope your varinat is also addressed in this.

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

Has anyone found solution to this problem ? I am having the same problem ... I have migrated an application from Pocket PC 2003 to Windows Mobile 5.0 ..I have changed the project and forms' Target platform to Windows Mobile 5.0 ... The application uses Merge Replication... It works fine on Pocket PC with 2003 but when I run it on Windows Mobile 5.0 device, it gives me this error 28559 "SQL Server Mobile encountered problems when opening the database."

If i do the replication in the constructor or load event of the first form/screen... then it works fine..but if call my MergeReplication function after a couple of screens or some processing .. it gives me the same error...

Is there a solution to this problem ?

Regards

|||

Hello Laxmi,

Do you know when we can expect this update? We are seeing this issue more and more since all our new customers are moving to use the Windows mobile 5 devices.

Thanks,
Samitha

|||

This causes me some concern. The company I work for are Gold Partners, and we have used MS technology throughout our application development.

We now have the interests of the likes of the Department of the Environment, Network Rail, to name but a few. They are very keen to see the application in its fully working state. One of the key selling points is that the system uses standard MS technologies, which ought to reassure them of longevity and stability.

I am accountable as the software engineer to my Directors, and I am in a position where I have had to re-compile the codebase to run on Mobile 5 platforms because they are the only platforms now being supplied.

How can I say to my Directors "sorry, but although we have developed this application for 20 months now, we will have to wait for Microsoft to sort out the bugs in their software, so you will have to tell the DoE and the other companies to come back later"?

I don't think they will say "never mind, it's only been a ￡400,000 investment. We can wait."

Please can you help me to sort out this problem urgently - I do not seem to be alone here, and not being able to replicate in a consistent and stable way is not an option for our development, and I am sure it is not an option for others.

|||

Nabeel Farid makes his point very eloquently.I want to add my concern.

I am the MD of the company of which samithad is the chief software architect. Finding a solution to this problem has become a joke, the thread was started on the 5^th of April, nearly 6 months ago! This forum is the main one for resolving technical problems and yet the effort spent on providing support from the Microsoft side has been minimal.Like Nabeel we are a Microsoft Partner heavily committed to using Microsoft technologies and have spent several ￡100k developing a product based on the synchronisation capability of SQL Mobile and it’s predecessor SQL CE.

The problem arrived with the move to SQL Mobile and occurs more with Windows Mobile 5 which is now becoming the norm. I appreciate that as an intermittent fault it is harder to track down, however sound replication is the cornerstone of a reliable synchronisation based product and SQL Mobile is failing in this regard.

No one at Microsoft appears to be putting any effort into solving the problem, the complete lack of any sense of urgency is particularly irksome. We are operating in the commercial world here and 6 months with zero progress is dismal

Jonn Fredericks

|||

Hi I was having the same problem. If i pushed the data back early on in the app everything worked fine. If I pushed it at the end (where I wanted to) I got the 28559 error

You need to scour your code for any and all tableadapters, tablereaders etc. anything at all that accesess the sqlmobile db. Make sure that they are all disposed of before you attempt to push your data back.

Worked for me! Good luck!

Replication Error 28559

We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication).

We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition.

I had a chat with one of the Microsoft online support person and what he said was to close the database before synchronising and also to check if the database on the PDA can be open normally using code when the error occurs. We have tested both scenarios and the error still comes. We do not use emulator in our developments. Any advice/help on this issue would be appreciated.

Moving to SQL Server Mobile forum since it sounds like this isn't really a replication problem. If it is, please assign it back to replication forum.|||

I also see this error sporadically on WM5 devices and also have to reset and reinstall SQL Mobile. Some people have gotten relief from opening a connection to SQL Mobile early in the app (in the Load event of the startup form for example), but that's not always an option if, for example, you are using AddOption.CreateDatabase and merge replicating when your app starts.

I will talk this over with the SQL Mobile team. I get the error on an IMate JasJar, but the only pattern I can see with it is if an initial replication fails, this error occurs the next time the app runs.

Darren

|||

When we were getting the 28559 error, if you changed the internet connection (e.g. if the wireless is off and the device is getting on to the internet using the USB cable, remove the cable and switch on wireless to use GPRS) it managed to do the sync without giving errors most of the time.

We also noticed that an instance of a SqlCeReplication has to be created at the beginning of the application otherwise its likely to get "A SQL Mobile DLL could not be loaded. reinstall SQL Mobile. [DLL Name = ..." error when the BeginSynchronize method was called.

-Samitha

|||

Any updates on this error from SQL mobile team?

-Samitha

|||

Hi Samitha,

I have passed on this question to some of my team folks and waiting for an answer.

Please bear with us.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||Hi Laxmi
what's the status about the solution to this 28599 SSCE_M_OPENDATABASE error?
I receive the error when I'm trying to synchronize my mobile application with merge replication.
I tried to do it like in the http://msdn2.microsoft.com/de-de/library/ms171908.aspx tutorial but I still receive this error.
When I'm changing AddOption.ExistingDatabase to AddOption.CreateDatabase the 28558 SSCE_M_CREATEDATABASE error occurs instead.
I tried to deploy it (from Visual Studio) with the emulator and as well with the device, still the same result.
Well the client agent seems to have a problem to access the database.

What I don't understand:
When I am synchronising manually from the mobile database to the publication database with SQL Server Management Studio it is working perfectly. What is the mobile application trying to do with the gathered data (that's working perfectly as well) by the repl.Synchronize() Command? Does it try to synchronize the data back to the mobileDatabase on that machine, from which i deployed it (according to the SubscriberConnectionString which is C:\foldername\database.sdf) or does it try to contact the Merge Replication Agent for synchronizing directly to the publisher database?

Florian Weber, University of Rapperswil, Switzerland
|||Hi there
hooray I managed to make it work. The problem was, that the path suggested by the Subscription Wizard isn't the one which should be on the mobile device.
Usually the application will have the following SubscriberConnectionString: "\Programs\applicationName\database.sdf"
If you are unsure of the path, look the installation path up in the dataexplorer of dthe mobile device

Florian|||

Hello Laxmi,

I was just wondering if there was any progress made with regards to this isuue.

Thanks,
Samitha

|||

Hi Samitha,

There were many variants in which you can not open database in REPL/RDA scenarios. We addressed some in VS 2005 SP1 which is going to come out soon. I hope your varinat is also addressed in this.

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

Has anyone found solution to this problem ? I am having the same problem ... I have migrated an application from Pocket PC 2003 to Windows Mobile 5.0 ..I have changed the project and forms' Target platform to Windows Mobile 5.0 ... The application uses Merge Replication... It works fine on Pocket PC with 2003 but when I run it on Windows Mobile 5.0 device, it gives me this error 28559 "SQL Server Mobile encountered problems when opening the database."

If i do the replication in the constructor or load event of the first form/screen... then it works fine..but if call my MergeReplication function after a couple of screens or some processing .. it gives me the same error...

Is there a solution to this problem ?

Regards

|||

Hello Laxmi,

Do you know when we can expect this update? We are seeing this issue more and more since all our new customers are moving to use the Windows mobile 5 devices.

Thanks,
Samitha

|||

This causes me some concern. The company I work for are Gold Partners, and we have used MS technology throughout our application development.

We now have the interests of the likes of the Department of the Environment, Network Rail, to name but a few. They are very keen to see the application in its fully working state. One of the key selling points is that the system uses standard MS technologies, which ought to reassure them of longevity and stability.

I am accountable as the software engineer to my Directors, and I am in a position where I have had to re-compile the codebase to run on Mobile 5 platforms because they are the only platforms now being supplied.

How can I say to my Directors "sorry, but although we have developed this application for 20 months now, we will have to wait for Microsoft to sort out the bugs in their software, so you will have to tell the DoE and the other companies to come back later"?

I don't think they will say "never mind, it's only been a ￡400,000 investment. We can wait."

Please can you help me to sort out this problem urgently - I do not seem to be alone here, and not being able to replicate in a consistent and stable way is not an option for our development, and I am sure it is not an option for others.

|||

Nabeel Farid makes his point very eloquently.I want to add my concern.

I am the MD of the company of which samithad is the chief software architect. Finding a solution to this problem has become a joke, the thread was started on the 5^th of April, nearly 6 months ago! This forum is the main one for resolving technical problems and yet the effort spent on providing support from the Microsoft side has been minimal.Like Nabeel we are a Microsoft Partner heavily committed to using Microsoft technologies and have spent several ￡100k developing a product based on the synchronisation capability of SQL Mobile and it’s predecessor SQL CE.

The problem arrived with the move to SQL Mobile and occurs more with Windows Mobile 5 which is now becoming the norm. I appreciate that as an intermittent fault it is harder to track down, however sound replication is the cornerstone of a reliable synchronisation based product and SQL Mobile is failing in this regard.

No one at Microsoft appears to be putting any effort into solving the problem, the complete lack of any sense of urgency is particularly irksome. We are operating in the commercial world here and 6 months with zero progress is dismal

Jonn Fredericks

|||

Hi I was having the same problem. If i pushed the data back early on in the app everything worked fine. If I pushed it at the end (where I wanted to) I got the 28559 error

You need to scour your code for any and all tableadapters, tablereaders etc. anything at all that accesess the sqlmobile db. Make sure that they are all disposed of before you attempt to push your data back.

Worked for me! Good luck!

Replication Error 28559

We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication).

We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition.

I had a chat with one of the Microsoft online support person and what he said was to close the database before synchronising and also to check if the database on the PDA can be open normally using code when the error occurs. We have tested both scenarios and the error still comes. We do not use emulator in our developments. Any advice/help on this issue would be appreciated.

Moving to SQL Server Mobile forum since it sounds like this isn't really a replication problem. If it is, please assign it back to replication forum.|||

I also see this error sporadically on WM5 devices and also have to reset and reinstall SQL Mobile. Some people have gotten relief from opening a connection to SQL Mobile early in the app (in the Load event of the startup form for example), but that's not always an option if, for example, you are using AddOption.CreateDatabase and merge replicating when your app starts.

I will talk this over with the SQL Mobile team. I get the error on an IMate JasJar, but the only pattern I can see with it is if an initial replication fails, this error occurs the next time the app runs.

Darren

|||

When we were getting the 28559 error, if you changed the internet connection (e.g. if the wireless is off and the device is getting on to the internet using the USB cable, remove the cable and switch on wireless to use GPRS) it managed to do the sync without giving errors most of the time.

We also noticed that an instance of a SqlCeReplication has to be created at the beginning of the application otherwise its likely to get "A SQL Mobile DLL could not be loaded. reinstall SQL Mobile. [DLL Name = ..." error when the BeginSynchronize method was called.

-Samitha

|||

Any updates on this error from SQL mobile team?

-Samitha

|||

Hi Samitha,

I have passed on this question to some of my team folks and waiting for an answer.

Please bear with us.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||Hi Laxmi
what's the status about the solution to this 28599 SSCE_M_OPENDATABASE error?
I receive the error when I'm trying to synchronize my mobile application with merge replication.
I tried to do it like in the http://msdn2.microsoft.com/de-de/library/ms171908.aspx tutorial but I still receive this error.
When I'm changing AddOption.ExistingDatabase to AddOption.CreateDatabase the 28558 SSCE_M_CREATEDATABASE error occurs instead.
I tried to deploy it (from Visual Studio) with the emulator and as well with the device, still the same result.
Well the client agent seems to have a problem to access the database.

What I don't understand:
When I am synchronising manually from the mobile database to the publication database with SQL Server Management Studio it is working perfectly. What is the mobile application trying to do with the gathered data (that's working perfectly as well) by the repl.Synchronize() Command? Does it try to synchronize the data back to the mobileDatabase on that machine, from which i deployed it (according to the SubscriberConnectionString which is C:\foldername\database.sdf) or does it try to contact the Merge Replication Agent for synchronizing directly to the publisher database?

Florian Weber, University of Rapperswil, Switzerland
|||Hi there
hooray I managed to make it work. The problem was, that the path suggested by the Subscription Wizard isn't the one which should be on the mobile device.
Usually the application will have the following SubscriberConnectionString: "\Programs\applicationName\database.sdf"
If you are unsure of the path, look the installation path up in the dataexplorer of dthe mobile device

Florian|||

Hello Laxmi,

I was just wondering if there was any progress made with regards to this isuue.

Thanks,
Samitha

|||

Hi Samitha,

There were many variants in which you can not open database in REPL/RDA scenarios. We addressed some in VS 2005 SP1 which is going to come out soon. I hope your varinat is also addressed in this.

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

Has anyone found solution to this problem ? I am having the same problem ... I have migrated an application from Pocket PC 2003 to Windows Mobile 5.0 ..I have changed the project and forms' Target platform to Windows Mobile 5.0 ... The application uses Merge Replication... It works fine on Pocket PC with 2003 but when I run it on Windows Mobile 5.0 device, it gives me this error 28559 "SQL Server Mobile encountered problems when opening the database."

If i do the replication in the constructor or load event of the first form/screen... then it works fine..but if call my MergeReplication function after a couple of screens or some processing .. it gives me the same error...

Is there a solution to this problem ?

Regards

|||

Hello Laxmi,

Do you know when we can expect this update? We are seeing this issue more and more since all our new customers are moving to use the Windows mobile 5 devices.

Thanks,
Samitha

|||

This causes me some concern. The company I work for are Gold Partners, and we have used MS technology throughout our application development.

We now have the interests of the likes of the Department of the Environment, Network Rail, to name but a few. They are very keen to see the application in its fully working state. One of the key selling points is that the system uses standard MS technologies, which ought to reassure them of longevity and stability.

I am accountable as the software engineer to my Directors, and I am in a position where I have had to re-compile the codebase to run on Mobile 5 platforms because they are the only platforms now being supplied.

How can I say to my Directors "sorry, but although we have developed this application for 20 months now, we will have to wait for Microsoft to sort out the bugs in their software, so you will have to tell the DoE and the other companies to come back later"?

I don't think they will say "never mind, it's only been a ￡400,000 investment. We can wait."

Please can you help me to sort out this problem urgently - I do not seem to be alone here, and not being able to replicate in a consistent and stable way is not an option for our development, and I am sure it is not an option for others.

|||

Nabeel Farid makes his point very eloquently.I want to add my concern.

I am the MD of the company of which samithad is the chief software architect. Finding a solution to this problem has become a joke, the thread was started on the 5^th of April, nearly 6 months ago! This forum is the main one for resolving technical problems and yet the effort spent on providing support from the Microsoft side has been minimal.Like Nabeel we are a Microsoft Partner heavily committed to using Microsoft technologies and have spent several ￡100k developing a product based on the synchronisation capability of SQL Mobile and it’s predecessor SQL CE.

The problem arrived with the move to SQL Mobile and occurs more with Windows Mobile 5 which is now becoming the norm. I appreciate that as an intermittent fault it is harder to track down, however sound replication is the cornerstone of a reliable synchronisation based product and SQL Mobile is failing in this regard.

No one at Microsoft appears to be putting any effort into solving the problem, the complete lack of any sense of urgency is particularly irksome. We are operating in the commercial world here and 6 months with zero progress is dismal

Jonn Fredericks

|||

Hi I was having the same problem. If i pushed the data back early on in the app everything worked fine. If I pushed it at the end (where I wanted to) I got the 28559 error

You need to scour your code for any and all tableadapters, tablereaders etc. anything at all that accesess the sqlmobile db. Make sure that they are all disposed of before you attempt to push your data back.

Worked for me! Good luck!

Replication Error 28559

We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication).

We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition.

I had a chat with one of the Microsoft online support person and what he said was to close the database before synchronising and also to check if the database on the PDA can be open normally using code when the error occurs. We have tested both scenarios and the error still comes. We do not use emulator in our developments. Any advice/help on this issue would be appreciated.

Moving to SQL Server Mobile forum since it sounds like this isn't really a replication problem. If it is, please assign it back to replication forum.|||

I also see this error sporadically on WM5 devices and also have to reset and reinstall SQL Mobile. Some people have gotten relief from opening a connection to SQL Mobile early in the app (in the Load event of the startup form for example), but that's not always an option if, for example, you are using AddOption.CreateDatabase and merge replicating when your app starts.

I will talk this over with the SQL Mobile team. I get the error on an IMate JasJar, but the only pattern I can see with it is if an initial replication fails, this error occurs the next time the app runs.

Darren

|||

When we were getting the 28559 error, if you changed the internet connection (e.g. if the wireless is off and the device is getting on to the internet using the USB cable, remove the cable and switch on wireless to use GPRS) it managed to do the sync without giving errors most of the time.

We also noticed that an instance of a SqlCeReplication has to be created at the beginning of the application otherwise its likely to get "A SQL Mobile DLL could not be loaded. reinstall SQL Mobile. [DLL Name = ..." error when the BeginSynchronize method was called.

-Samitha

|||

Any updates on this error from SQL mobile team?

-Samitha

|||

Hi Samitha,

I have passed on this question to some of my team folks and waiting for an answer.

Please bear with us.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||Hi Laxmi
what's the status about the solution to this 28599 SSCE_M_OPENDATABASE error?
I receive the error when I'm trying to synchronize my mobile application with merge replication.
I tried to do it like in the http://msdn2.microsoft.com/de-de/library/ms171908.aspx tutorial but I still receive this error.
When I'm changing AddOption.ExistingDatabase to AddOption.CreateDatabase the 28558 SSCE_M_CREATEDATABASE error occurs instead.
I tried to deploy it (from Visual Studio) with the emulator and as well with the device, still the same result.
Well the client agent seems to have a problem to access the database.

What I don't understand:
When I am synchronising manually from the mobile database to the publication database with SQL Server Management Studio it is working perfectly. What is the mobile application trying to do with the gathered data (that's working perfectly as well) by the repl.Synchronize() Command? Does it try to synchronize the data back to the mobileDatabase on that machine, from which i deployed it (according to the SubscriberConnectionString which is C:\foldername\database.sdf) or does it try to contact the Merge Replication Agent for synchronizing directly to the publisher database?

Florian Weber, University of Rapperswil, Switzerland
|||Hi there
hooray I managed to make it work. The problem was, that the path suggested by the Subscription Wizard isn't the one which should be on the mobile device.
Usually the application will have the following SubscriberConnectionString: "\Programs\applicationName\database.sdf"
If you are unsure of the path, look the installation path up in the dataexplorer of dthe mobile device

Florian|||

Hello Laxmi,

I was just wondering if there was any progress made with regards to this isuue.

Thanks,
Samitha

|||

Hi Samitha,

There were many variants in which you can not open database in REPL/RDA scenarios. We addressed some in VS 2005 SP1 which is going to come out soon. I hope your varinat is also addressed in this.

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

Has anyone found solution to this problem ? I am having the same problem ... I have migrated an application from Pocket PC 2003 to Windows Mobile 5.0 ..I have changed the project and forms' Target platform to Windows Mobile 5.0 ... The application uses Merge Replication... It works fine on Pocket PC with 2003 but when I run it on Windows Mobile 5.0 device, it gives me this error 28559 "SQL Server Mobile encountered problems when opening the database."

If i do the replication in the constructor or load event of the first form/screen... then it works fine..but if call my MergeReplication function after a couple of screens or some processing .. it gives me the same error...

Is there a solution to this problem ?

Regards

|||

Hello Laxmi,

Do you know when we can expect this update? We are seeing this issue more and more since all our new customers are moving to use the Windows mobile 5 devices.

Thanks,
Samitha

|||

This causes me some concern. The company I work for are Gold Partners, and we have used MS technology throughout our application development.

We now have the interests of the likes of the Department of the Environment, Network Rail, to name but a few. They are very keen to see the application in its fully working state. One of the key selling points is that the system uses standard MS technologies, which ought to reassure them of longevity and stability.

I am accountable as the software engineer to my Directors, and I am in a position where I have had to re-compile the codebase to run on Mobile 5 platforms because they are the only platforms now being supplied.

How can I say to my Directors "sorry, but although we have developed this application for 20 months now, we will have to wait for Microsoft to sort out the bugs in their software, so you will have to tell the DoE and the other companies to come back later"?

I don't think they will say "never mind, it's only been a ￡400,000 investment. We can wait."

Please can you help me to sort out this problem urgently - I do not seem to be alone here, and not being able to replicate in a consistent and stable way is not an option for our development, and I am sure it is not an option for others.

|||

Nabeel Farid makes his point very eloquently.I want to add my concern.

I am the MD of the company of which samithad is the chief software architect. Finding a solution to this problem has become a joke, the thread was started on the 5^th of April, nearly 6 months ago! This forum is the main one for resolving technical problems and yet the effort spent on providing support from the Microsoft side has been minimal.Like Nabeel we are a Microsoft Partner heavily committed to using Microsoft technologies and have spent several ￡100k developing a product based on the synchronisation capability of SQL Mobile and it’s predecessor SQL CE.

The problem arrived with the move to SQL Mobile and occurs more with Windows Mobile 5 which is now becoming the norm. I appreciate that as an intermittent fault it is harder to track down, however sound replication is the cornerstone of a reliable synchronisation based product and SQL Mobile is failing in this regard.

No one at Microsoft appears to be putting any effort into solving the problem, the complete lack of any sense of urgency is particularly irksome. We are operating in the commercial world here and 6 months with zero progress is dismal

Jonn Fredericks

|||

Hi I was having the same problem. If i pushed the data back early on in the app everything worked fine. If I pushed it at the end (where I wanted to) I got the 28559 error

You need to scour your code for any and all tableadapters, tablereaders etc. anything at all that accesess the sqlmobile db. Make sure that they are all disposed of before you attempt to push your data back.

Worked for me! Good luck!

sql

Replication Error 28559

We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication).

We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition.

I had a chat with one of the Microsoft online support person and what he said was to close the database before synchronising and also to check if the database on the PDA can be open normally using code when the error occurs. We have tested both scenarios and the error still comes. We do not use emulator in our developments. Any advice/help on this issue would be appreciated.

Moving to SQL Server Mobile forum since it sounds like this isn't really a replication problem. If it is, please assign it back to replication forum.|||

I also see this error sporadically on WM5 devices and also have to reset and reinstall SQL Mobile. Some people have gotten relief from opening a connection to SQL Mobile early in the app (in the Load event of the startup form for example), but that's not always an option if, for example, you are using AddOption.CreateDatabase and merge replicating when your app starts.

I will talk this over with the SQL Mobile team. I get the error on an IMate JasJar, but the only pattern I can see with it is if an initial replication fails, this error occurs the next time the app runs.

Darren

|||

When we were getting the 28559 error, if you changed the internet connection (e.g. if the wireless is off and the device is getting on to the internet using the USB cable, remove the cable and switch on wireless to use GPRS) it managed to do the sync without giving errors most of the time.

We also noticed that an instance of a SqlCeReplication has to be created at the beginning of the application otherwise its likely to get "A SQL Mobile DLL could not be loaded. reinstall SQL Mobile. [DLL Name = ..." error when the BeginSynchronize method was called.

-Samitha

|||

Any updates on this error from SQL mobile team?

-Samitha

|||

Hi Samitha,

I have passed on this question to some of my team folks and waiting for an answer.

Please bear with us.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||Hi Laxmi
what's the status about the solution to this 28599 SSCE_M_OPENDATABASE error?
I receive the error when I'm trying to synchronize my mobile application with merge replication.
I tried to do it like in the http://msdn2.microsoft.com/de-de/library/ms171908.aspx tutorial but I still receive this error.
When I'm changing AddOption.ExistingDatabase to AddOption.CreateDatabase the 28558 SSCE_M_CREATEDATABASE error occurs instead.
I tried to deploy it (from Visual Studio) with the emulator and as well with the device, still the same result.
Well the client agent seems to have a problem to access the database.

What I don't understand:
When I am synchronising manually from the mobile database to the publication database with SQL Server Management Studio it is working perfectly. What is the mobile application trying to do with the gathered data (that's working perfectly as well) by the repl.Synchronize() Command? Does it try to synchronize the data back to the mobileDatabase on that machine, from which i deployed it (according to the SubscriberConnectionString which is C:\foldername\database.sdf) or does it try to contact the Merge Replication Agent for synchronizing directly to the publisher database?

Florian Weber, University of Rapperswil, Switzerland
|||Hi there
hooray I managed to make it work. The problem was, that the path suggested by the Subscription Wizard isn't the one which should be on the mobile device.
Usually the application will have the following SubscriberConnectionString: "\Programs\applicationName\database.sdf"
If you are unsure of the path, look the installation path up in the dataexplorer of dthe mobile device

Florian
|||

Hello Laxmi,

I was just wondering if there was any progress made with regards to this isuue.

Thanks,
Samitha

|||

Hi Samitha,

There were many variants in which you can not open database in REPL/RDA scenarios. We addressed some in VS 2005 SP1 which is going to come out soon. I hope your varinat is also addressed in this.

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

Has anyone found solution to this problem ? I am having the same problem ... I have migrated an application from Pocket PC 2003 to Windows Mobile 5.0 ..I have changed the project and forms' Target platform to Windows Mobile 5.0 ... The application uses Merge Replication... It works fine on Pocket PC with 2003 but when I run it on Windows Mobile 5.0 device, it gives me this error 28559 "SQL Server Mobile encountered problems when opening the database."

If i do the replication in the constructor or load event of the first form/screen... then it works fine..but if call my MergeReplication function after a couple of screens or some processing .. it gives me the same error...

Is there a solution to this problem ?

Regards

|||

Hello Laxmi,

Do you know when we can expect this update? We are seeing this issue more and more since all our new customers are moving to use the Windows mobile 5 devices.

Thanks,
Samitha

|||

This causes me some concern. The company I work for are Gold Partners, and we have used MS technology throughout our application development.

We now have the interests of the likes of the Department of the Environment, Network Rail, to name but a few. They are very keen to see the application in its fully working state. One of the key selling points is that the system uses standard MS technologies, which ought to reassure them of longevity and stability.

I am accountable as the software engineer to my Directors, and I am in a position where I have had to re-compile the codebase to run on Mobile 5 platforms because they are the only platforms now being supplied.

How can I say to my Directors "sorry, but although we have developed this application for 20 months now, we will have to wait for Microsoft to sort out the bugs in their software, so you will have to tell the DoE and the other companies to come back later"?

I don't think they will say "never mind, it's only been a ￡400,000 investment. We can wait."

Please can you help me to sort out this problem urgently - I do not seem to be alone here, and not being able to replicate in a consistent and stable way is not an option for our development, and I am sure it is not an option for others.

|||

Nabeel Farid makes his point very eloquently.I want to add my concern.

I am the MD of the company of which samithad is the chief software architect. Finding a solution to this problem has become a joke, the thread was started on the 5^th of April, nearly 6 months ago! This forum is the main one for resolving technical problems and yet the effort spent on providing support from the Microsoft side has been minimal.Like Nabeel we are a Microsoft Partner heavily committed to using Microsoft technologies and have spent several ￡100k developing a product based on the synchronisation capability of SQL Mobile and it’s predecessor SQL CE.

The problem arrived with the move to SQL Mobile and occurs more with Windows Mobile 5 which is now becoming the norm. I appreciate that as an intermittent fault it is harder to track down, however sound replication is the cornerstone of a reliable synchronisation based product and SQL Mobile is failing in this regard.

No one at Microsoft appears to be putting any effort into solving the problem, the complete lack of any sense of urgency is particularly irksome. We are operating in the commercial world here and 6 months with zero progress is dismal

Jonn Fredericks

|||

Hi I was having the same problem. If i pushed the data back early on in the app everything worked fine. If I pushed it at the end (where I wanted to) I got the 28559 error

You need to scour your code for any and all tableadapters, tablereaders etc. anything at all that accesess the sqlmobile db. Make sure that they are all disposed of before you attempt to push your data back.

Worked for me! Good luck!

Replication Error 28559

We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication).

We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition.

I had a chat with one of the Microsoft online support person and what he said was to close the database before synchronising and also to check if the database on the PDA can be open normally using code when the error occurs. We have tested both scenarios and the error still comes. We do not use emulator in our developments. Any advice/help on this issue would be appreciated.

Moving to SQL Server Mobile forum since it sounds like this isn't really a replication problem. If it is, please assign it back to replication forum.|||

I also see this error sporadically on WM5 devices and also have to reset and reinstall SQL Mobile. Some people have gotten relief from opening a connection to SQL Mobile early in the app (in the Load event of the startup form for example), but that's not always an option if, for example, you are using AddOption.CreateDatabase and merge replicating when your app starts.

I will talk this over with the SQL Mobile team. I get the error on an IMate JasJar, but the only pattern I can see with it is if an initial replication fails, this error occurs the next time the app runs.

Darren

|||

When we were getting the 28559 error, if you changed the internet connection (e.g. if the wireless is off and the device is getting on to the internet using the USB cable, remove the cable and switch on wireless to use GPRS) it managed to do the sync without giving errors most of the time.

We also noticed that an instance of a SqlCeReplication has to be created at the beginning of the application otherwise its likely to get "A SQL Mobile DLL could not be loaded. reinstall SQL Mobile. [DLL Name = ..." error when the BeginSynchronize method was called.

-Samitha

|||

Any updates on this error from SQL mobile team?

-Samitha

|||

Hi Samitha,

I have passed on this question to some of my team folks and waiting for an answer.

Please bear with us.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||Hi Laxmi
what's the status about the solution to this 28599 SSCE_M_OPENDATABASE error?
I receive the error when I'm trying to synchronize my mobile application with merge replication.
I tried to do it like in the http://msdn2.microsoft.com/de-de/library/ms171908.aspx tutorial but I still receive this error.
When I'm changing AddOption.ExistingDatabase to AddOption.CreateDatabase the 28558 SSCE_M_CREATEDATABASE error occurs instead.
I tried to deploy it (from Visual Studio) with the emulator and as well with the device, still the same result.
Well the client agent seems to have a problem to access the database.

What I don't understand:
When I am synchronising manually from the mobile database to the publication database with SQL Server Management Studio it is working perfectly. What is the mobile application trying to do with the gathered data (that's working perfectly as well) by the repl.Synchronize() Command? Does it try to synchronize the data back to the mobileDatabase on that machine, from which i deployed it (according to the SubscriberConnectionString which is C:\foldername\database.sdf) or does it try to contact the Merge Replication Agent for synchronizing directly to the publisher database?

Florian Weber, University of Rapperswil, Switzerland
|||Hi there
hooray I managed to make it work. The problem was, that the path suggested by the Subscription Wizard isn't the one which should be on the mobile device.
Usually the application will have the following SubscriberConnectionString: "\Programs\applicationName\database.sdf"
If you are unsure of the path, look the installation path up in the dataexplorer of dthe mobile device

Florian|||

Hello Laxmi,

I was just wondering if there was any progress made with regards to this isuue.

Thanks,
Samitha

|||

Hi Samitha,

There were many variants in which you can not open database in REPL/RDA scenarios. We addressed some in VS 2005 SP1 which is going to come out soon. I hope your varinat is also addressed in this.

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

Has anyone found solution to this problem ? I am having the same problem ... I have migrated an application from Pocket PC 2003 to Windows Mobile 5.0 ..I have changed the project and forms' Target platform to Windows Mobile 5.0 ... The application uses Merge Replication... It works fine on Pocket PC with 2003 but when I run it on Windows Mobile 5.0 device, it gives me this error 28559 "SQL Server Mobile encountered problems when opening the database."

If i do the replication in the constructor or load event of the first form/screen... then it works fine..but if call my MergeReplication function after a couple of screens or some processing .. it gives me the same error...

Is there a solution to this problem ?

Regards

|||

Hello Laxmi,

Do you know when we can expect this update? We are seeing this issue more and more since all our new customers are moving to use the Windows mobile 5 devices.

Thanks,
Samitha

|||

This causes me some concern. The company I work for are Gold Partners, and we have used MS technology throughout our application development.

We now have the interests of the likes of the Department of the Environment, Network Rail, to name but a few. They are very keen to see the application in its fully working state. One of the key selling points is that the system uses standard MS technologies, which ought to reassure them of longevity and stability.

I am accountable as the software engineer to my Directors, and I am in a position where I have had to re-compile the codebase to run on Mobile 5 platforms because they are the only platforms now being supplied.

How can I say to my Directors "sorry, but although we have developed this application for 20 months now, we will have to wait for Microsoft to sort out the bugs in their software, so you will have to tell the DoE and the other companies to come back later"?

I don't think they will say "never mind, it's only been a ￡400,000 investment. We can wait."

Please can you help me to sort out this problem urgently - I do not seem to be alone here, and not being able to replicate in a consistent and stable way is not an option for our development, and I am sure it is not an option for others.

|||

Nabeel Farid makes his point very eloquently.I want to add my concern.

I am the MD of the company of which samithad is the chief software architect. Finding a solution to this problem has become a joke, the thread was started on the 5^th of April, nearly 6 months ago! This forum is the main one for resolving technical problems and yet the effort spent on providing support from the Microsoft side has been minimal.Like Nabeel we are a Microsoft Partner heavily committed to using Microsoft technologies and have spent several ￡100k developing a product based on the synchronisation capability of SQL Mobile and it’s predecessor SQL CE.

The problem arrived with the move to SQL Mobile and occurs more with Windows Mobile 5 which is now becoming the norm. I appreciate that as an intermittent fault it is harder to track down, however sound replication is the cornerstone of a reliable synchronisation based product and SQL Mobile is failing in this regard.

No one at Microsoft appears to be putting any effort into solving the problem, the complete lack of any sense of urgency is particularly irksome. We are operating in the commercial world here and 6 months with zero progress is dismal

Jonn Fredericks

|||

Hi I was having the same problem. If i pushed the data back early on in the app everything worked fine. If I pushed it at the end (where I wanted to) I got the 28559 error

You need to scour your code for any and all tableadapters, tablereaders etc. anything at all that accesess the sqlmobile db. Make sure that they are all disposed of before you attempt to push your data back.

Worked for me! Good luck!

Replication error 28037

I am using merge replication between SQL Server 2000 sp3a running on windows
2000 server sp4 and sql server ce 2.0 over gprs.
First time when I synchronize is working fine, but when I add or modify data
in sql server ce database and try to replicate over gprs I get error 28037
(A request to send data to the computer running IIS has failed), during this
time my pocket pc is connected with the server (it respond to ping from the
computer running sql server, and pocket ie shows SQL Server CE Server
Agent ).
I tried to test replication on another database on only one table, it works
ok first time but when I modify many records on pocket pc database (100) and
replication fails with error 28037. If I modify the same amount of records
on server replication is working.
When I get this error I can not longer replicate over gprs but with cradle
it works. After I replicate on cradle and there is not data modified if I
replicate over gprs it works.
I believed that the amount of data uploaded from pocket pc to sql server is
to much so I created a new default merge agent profile with
downloadgenerationsperbatch set to 10 and uploadgenerationsperbatch set to 1
and recreated the publication, but nothing changed.
Any suggestion is welcome
thanks
Marius
Marius,
I am having exactly the same problem...did you manage to find out any solution?
Are we the only two people in the worldusing merge replication over GPRS? I hope not!
Cheers,
Nick
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||Hi Nick,
Till now I did not found any solution, we contacted microsoft support but
the problem still persist although I tried a hot fix and defined custom
merge agents. When we lead to a conclusion I'll let you know.
The strange thing is that the problem appears over GPRS with RDA also if
application try to pull a table that contains more then 20 changes (updates,
inserts, deletes), this number may vary but in small bounds.

> Marius,
> I am having exactly the same problem...did you manage to find out any
solution?
> Are we the only two people in the worldusing merge replication over GPRS?
I hope not!
> Cheers,
> Nick
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.