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

Question

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.

Answer 1

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?

Answer 2

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.

Answer 3

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?

Answer 4

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

Answer 5

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

Answer 6

That could be something wrong with the dbserver, try to get another dbserver, hopefully solve it.