Database "does not contain a valid SQL PI schema or is not a dedicated database for PI repository" error when attaching a PI database (4226280)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

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
Weitere Informationen

Is the external table is part of the model database template than it will be created with each new database creation.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Foglight Cloud
Hosted; Foglight
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5; Foglight Evolve
7.1.0, 6.3.0, 6.1.0, 6.0.0, 9.3, 9.2; Foglight for Databases
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.7, 5.9.5

Titel