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.
Defect 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.
