data missing on server

Discussion in 'microsoft.public.sqlserver.ce' started by gregor rovan, Jul 30, 2009.

  1. gregor rovan

    gregor rovan Guest

    Hi,

    We have problem with merge replication from PocketPC device. We are using
    SQL CE 3.1 on mobile devices with SQL Server 2000.

    Sometimes happened that some updates done on the mobile device are not
    updated on server database after successfull synchronization.

    Can anyone help please?

    Gregor
     
    gregor rovan, Jul 30, 2009
    #1
    1. Advertisements

  2. Have you looked if there were some conflicts?

    --

    Alberto Silva
    http://www.moving2u.pt - R&D Manager
    http://msmvps.com/AlbertoSilva - Blog
    Microsoft MVP - Device Application Development


    __________ Information from ESET NOD32 Antivirus, version of virus signature database 4292 (20090730) __________

    The message was checked by ESET NOD32 Antivirus.

    http://www.eset.com
     
    Alberto Silva, MVP, Jul 30, 2009
    #2
    1. Advertisements

  3. gregor rovan

    gregor rovan Guest

    Yes, there are no conflicts. So far we noticed that in one table one field
    is not being updated on the server, but not always. For sure, it is correct
    value in database on device.
     
    gregor rovan, Jul 30, 2009
    #3
  4. I've already seen such an issue, where a single table did not always upload
    its changes, but never found why... I can ask a colleague who was taking
    care of it at the time if he remembers if the issue was fixed and how.

    --

    Alberto Silva
    http://www.moving2u.pt - R&D Manager
    http://msmvps.com/AlbertoSilva - Blog
    Microsoft MVP - Device Application Development


    __________ Information from ESET NOD32 Antivirus, version of virus signature database 4292 (20090730) __________

    The message was checked by ESET NOD32 Antivirus.

    http://www.eset.com
     
    Alberto Silva, MVP, Jul 30, 2009
    #4
  5. gregor rovan

    gregor rovan Guest

    Please ask if you can, because I really don't know what to do.

    Thank you.
     
    gregor rovan, Jul 31, 2009
    #5
  6. gregor rovan

    gregor rovan Guest

    It seems that data is missing when synchronization failed at least once,
    before it completed successfully. As it would flag rows with changes as
    synhronized already but are not...
     
    gregor rovan, Jul 31, 2009
    #6
  7. gregor rovan

    Brian Guest

    Alberto,
    We are experiencing this exact issue and are also very eager to hear
    what you have to say about it.
    Using Merge replication from a SqlCe 3.1 DB up to Sql Server 2000, we
    have a table that, on occasion, just refuses to send records up.
    Everything appears to have succeeded, but the records only exist on
    the sqlce client database.
     
    Brian, Jul 31, 2009
    #7
  8. According to my colleague, the issue is no longer reported by the customer,
    and we haven't done anything specific to fix it. As far as I remember, they
    have moved later from SQL Server 2000 to 2005 or 2008 (not sure) and maybe
    that did the trick.

    Sorry for not being more helpful.

    --

    Alberto Silva
    http://www.moving2u.pt - R&D Manager
    http://msmvps.com/AlbertoSilva - Blog
    Microsoft MVP - Device Application Development


    __________ Information from ESET NOD32 Antivirus, version of virus signature database 4302 (20090803) __________

    The message was checked by ESET NOD32 Antivirus.

    http://www.eset.com
     
    Alberto Silva, MVP, Aug 3, 2009
    #8
  9. gregor rovan

    gregor rovan Guest

    Is it possible that the problem is because the data is stored on SD card??
    Did someone report losing data when database is located on memory card?
     
    gregor rovan, Aug 13, 2009
    #9
  10. gregor rovan

    Brian Guest

    Hey Greg,

    I guess anything is possible, but that certainly wouldn't be my first
    guess. At this point I'm leaning more towards an incompatibility
    between the 3.1 replication engine and Sql Server 2000. I think there
    is a bug, and MS isn't terribly interested in researching it because
    Sql Server 2000 is nearly out the door support-wise. Which is
    unfortunate, because we absolutely cannot upgrade our server at this
    time...we need to fix or work around this issue.

    I'll post here if I figure something out.
     
    Brian, Aug 14, 2009
    #10
  11. gregor rovan

    Brian Guest

    Oh, and in addition - our Sql CE 3.1 database being used in a desktop
    app, not on a mobile device. We are not storing it on an SD card and
    we are seeing this issue as well.
     
    Brian, Aug 14, 2009
    #11
  12. There are some reports of database corruption on SD cards, namely when the
    device goes to stand-by, but it is not the case of the subject of this
    thread, because the issue is not about corruption but selective data being
    reported as missed on the server.

    --

    Alberto Silva
    http://www.moving2u.pt - R&D Manager
    http://msmvps.com/AlbertoSilva - Blog
    Microsoft MVP - Device Application Development


    __________ Information from ESET NOD32 Antivirus, version of virus signature database 4341 (20090817) __________

    The message was checked by ESET NOD32 Antivirus.

    http://www.eset.com
     
    Alberto Silva, MVP, Aug 18, 2009
    #12
  13. gregor rovan

    gregor rovan Guest

    Hi,

    Are there any know issues also with SQL Mobile 2005 version? This is version
    3.0.3600.0 of System.Data.SqlServerCe.dll file.

    Do you think I would solve the problem if I go back and use this version? Or
    do you think the only solution is to go back to SQL CE 2.0? But that also
    mean that application can not be on CF .NET 3.5, right?

    Thanks.
     
    gregor rovan, Aug 21, 2009
    #13
  14. Hi Gregor,
    I may be missing something from your previous messages, so if you are using
    ..NET CF 3.5, why aren't you using the latest SQL Server Compact 3.5SP1,
    because of the lack of support for SQL Server 2000? Can you give it a try in
    development environment?

    --

    Alberto Silva
    http://www.moving2u.pt - R&D Manager
    http://msmvps.com/AlbertoSilva - Blog
    Microsoft MVP - Device Application Development


    __________ Information from ESET NOD32 Antivirus, version of virus signature database 4362 (20090824) __________

    The message was checked by ESET NOD32 Antivirus.

    http://www.eset.com




    __________ Information from ESET NOD32 Antivirus, version of virus signature database 4363 (20090824) __________

    The message was checked by ESET NOD32 Antivirus.

    http://www.eset.com
     
    Alberto Silva, MVP, Aug 24, 2009
    #14
  15. gregor rovan

    gregor rovan Guest

    I tried with SP1 but then I couldn't synchronize to SQL Server 2000 :(
     
    gregor rovan, Aug 25, 2009
    #15
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.