Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Could not find the configured template or scope in the database. Please ensure that the database is provisioned using the SyncSvcUtil tool. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I used diagnostic to see what happen with my service and see that error.

    I don't know how to fix, because I used SyncSvcUtil tool to provision database,

    I tried deprovision and provision again, but it's not effect.

    When I select table schema_info, scope_config, scope_info they have one record on that (each table).

    What can I do to fix this issue.

    Thank you.

    Wednesday, November 24, 2010 3:21 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you.

    I think have somebody should report this issues so I didn't mark as answer this question.

    And you report this issue, so I close this question.

    Thank you

    • Marked as answer by BruceDo Thursday, November 25, 2010 1:46 AM
    Thursday, November 25, 2010 1:46 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Did you use the same config file to generate your service code and to provision your database? How many tables do you have in your scope? Did you change any of the generated code on the service side?
    Wednesday, November 24, 2010 4:02 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I used SyncSvcUtilHelper to generate config file, and use this file to provison database and generate server code. I changed some server code (config database, EnableDiagnosticPage, UseVerboseErrors, SetEnableScope, SetSyncObjectSchema). I think there no nay problem with that.

    I just have only 4 table in my DB.

    I notice have one difference is I didn't use default database schema (dbo). So I try to create a new database with same table structure (change schema to dbo)  and it worked fine.

    So, I don't know if have any limitation of Sync with DB schema, or any limitation with length of table name, database name ....

    Until now, I don't know know how to fix this issue because I can not change DB schema as example.

    Thank you.

    Wednesday, November 24, 2010 4:56 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I found the problem.

    The problem is when I create a  config file (use SyncSvcUtilHelper), I input into text-box Schema Name (step 3), ex: ABC. So when I use this file to provision database, Sync will create tables schema_info, scope_config, scope_info, scope_parameters, scope_templates with schema (example: ABC.schema_info, ABC.scope_config,..... ).

    So, when run diagnostic I received error above.

    I try to create other config file with empty Schema Name and it work file.

    Do you think this is a Sync Framework provision issue?

    Wednesday, November 24, 2010 9:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi BruceDo,

    This is a bug in the diagnostic page where it does not report the correct status when scopes are provisioned under a non-dbo schema. The database should be provisioned correctly as long as the SyncSvcUtilHelper did not report any errors. We will fix this error in the diag page in the next release.

    Thanks

    SDE, Sync Framework - http://www.giyer.com
    • Proposed as answer by Ganeshan Wednesday, November 24, 2010 6:26 PM
    • Marked as answer by BruceDo Thursday, November 25, 2010 1:44 AM
    • Unmarked as answer by BruceDo Thursday, November 25, 2010 1:44 AM
    Wednesday, November 24, 2010 6:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you.

    I think have somebody should report this issues so I didn't mark as answer this question.

    And you report this issue, so I close this question.

    Thank you

    • Marked as answer by BruceDo Thursday, November 25, 2010 1:46 AM
    Thursday, November 25, 2010 1:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    That could be something wrong with the dbserver, try to get another dbserver, hopefully solve it.
    Tuesday, February 14, 2012 10:50 PM