The message "No data is available" appears in the SQL PI screens when using a SQL Server based PI repository.
The following error appears in the SPI repository log file:
RESOLUTION 1
Reduce the amount of transaction logs retained or reduce the size of transaction logs.
Enable Autogrowth and Unrestricted File Growth both enabled for the log file
Users can edit these via SSMS in "Database Properties | Files"
Please review Microsoft KB article 873325
RESOLUTION 2
Put the databases in SIMPLE recovery model. This does not require transaction log backups, but if there’s corruption, an accidental delete, or any problem, Users lose all data since the last full or differential backup. Users do not have the ability to restore to a point in time.
RESOLUTION 3
Start taking transaction log backups
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center