로그인
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Could not find the configured template or scope in the database. Please ensure that the database is provisioned using the SyncSvcUtil tool.

已答复 Could not find the configured template or scope in the database. Please ensure that the database is provisioned using the SyncSvcUtil tool.

  • 2010년 11월 24일 수요일 오전 3:21
     
     
    로그인하여 투표
    0

    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.

     

모든 응답

  • 2010년 11월 24일 수요일 오전 4:02
    소유자
     
     
    로그인하여 투표
    0
    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?
     
  • 2010년 11월 24일 수요일 오전 4:56
     
     
    로그인하여 투표
    0

    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.

     
  • 2010년 11월 24일 수요일 오전 9:41
     
     
    로그인하여 투표
    0

    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?

     
  • 2010년 11월 24일 수요일 오후 6:26
    중재자
     
     제안된 답변
    로그인하여 투표
    0

    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
    • 답변으로 제안됨 GaneshanMicrosoft Employee, Moderator 2010년 11월 24일 수요일 오후 6:26
    • 답변으로 표시됨 BruceDo 2010년 11월 25일 목요일 오전 1:44
    • 답변으로 표시 취소됨 BruceDo 2010년 11월 25일 목요일 오전 1:44
    •  
     
  • 2010년 11월 25일 목요일 오전 1:46
     
     답변됨
    로그인하여 투표
    0

    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

    • 답변으로 표시됨 BruceDo 2010년 11월 25일 목요일 오전 1:46
    •  
     
  • 2012년 2월 14일 화요일 오후 10:50
     
     
    로그인하여 투표
    0
    That could be something wrong with the dbserver, try to get another dbserver, hopefully solve it.