Zurück
-
Titel
Database "does not contain a valid SQL PI schema or is not a dedicated database for PI repository" error when attaching a PI database -
Beschreibung
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" -
Ursache
The PI repository database must be dedicated for PI. -
Lösung
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.
-
Fehler-ID
FOGGENERAL-I-194