Database "does not contain a valid SQL PI schema or is not a dedicated database for PI repository" error when attaching a PI database
说明
When reattaching a PI repository agent back to an existing database, or adding a new database that has PI repository tables, a popup appears that non-PI tables (such as sysdiagrams) can be found in the PI repository.
"Database DBNAME does not contain valid SQL PI schema or is not a dedicated database for PI repository"
"The repository contains the following tables which PI does not need: TABLENAME1,TABLENAME2"
原因
The PI repository database must be dedicated for PI.
解决办法
WORKAROUND
Delete the tables and then reattach the PI repository.
STATUS
Enhancement Request FOGGENERAL-I-194 has been logged to allow non-Foglight PI tables to be present in a SQL Server PI repository database.
缺陷ID
FOGGENERAL-I-194
其他信息
Is the external table is part of the model database template than it will be created with each new database creation.
