Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Unable to create client database for tables aspnet_Paths, aspnet_PersonalizationPerUser, aspnet_Roles, and aspnet_Users RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am working on a client project that wants to incorporate offline sync from their database, which has ASP.Net Membership tables.  When I am attempting to create the Local Data Cache object, I select all the tables, each set to get new or incremental changes.  When I hit Ok to create the sync I get the following error:

    Synchronizing the database failed with the message: 'Unable to initialize the client database, because the schema for table 'aspnet_Paths, aspnet_PersonalizationPerUser, aspnet_Roles, aspnet_Users' could not be retrieved by the GetSchema() method of DbServerSyncProvider.  Make sure that you can establish a connection to the client database and that either the SelectIncrementalInsertsCommand property or the SelectIncrementalUpdatesCommand property of the SyncAdapter is specified correctly.'

    I obviously am able to connect to the client database, and the Insert and Update command options are disabled for all tables when I am adding them to the cache selection.

    Any ideas how to fix this?  Otherwise I'm going to have to create a custom membership and profile provider just to work around this, and that is very undesirable.

    Wednesday, March 7, 2012 9:40 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    what version of SQL Server are you using?
    Thursday, March 8, 2012 2:07 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    2008 R2
    Thursday, March 8, 2012 3:13 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    out of curiousity, when you right click on the database in SSMS, click on Properties, do you see ChangeTracking there? try setting it to true yourself.
    Thursday, March 8, 2012 3:56 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes, Change Tracking is turned on.  I am able to build the sync against all the other tables in the database, but when the aspnet_ tables are added I get the above error.  And I am including all the aspnet_ tables, it is just the 4 listed above that it does not like.

    Since I am working against a database provided by a client, I thought they might have tweaked something with those tables that was causing it, so I just created a brand new database, ran then aspnet_reg tool to create the tables, and then tried creating a new sync against that fresh database, and got the same error.

    Thursday, March 8, 2012 1:07 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    interesting...one of my clients was adding aspnet stuff as well this morning and i ran the wizard against it and it ran perfectly although not including the aspnet_paths and the aspnet_personalizationperuser.

    can you try reordering the way you add the tables so that parent tables is in the list first? (e.g., aspnet_users before aspnet_path, etc...)

    Thursday, March 8, 2012 4:01 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    No luck.  I added aspnet_Applications, aspnet_Membership, aspnet_Profile, aspnet_SchemaVersions, and aspnet_WebEvent_Events during the initial cache creation and they synced fine.  I then attempted to add aspnet_Users and it gave me the same "schema for table 'aspnet_Users' could not be retrieved by the GetSchema() method"
    Thursday, March 8, 2012 4:11 PM