Archive database upgrade fails in database manager
Issue:
ION_Data Archive database upgrade fails in PME using database manager
Product Line:
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024
Environment:
Database Manager
Cause:
The user has an ION_Data archive that was created from previous versions of the software and may have been copied and moved to a location on an external or network drive. Before this archive can be used in PME it must be attached to SQL server with Database Manager and upgraded.
Resolution:
Attaching the ION_Data archive database may fail with the following error message: Attached database failed for server .
When you click OK to the error dialog box and try attaching the second time, a new error will reveal more information that will be helpful.
The file permissions changed when the archive database was copied or moved to different locations. To resolve this issue change the permissions to allow "Full control" for the user.
- Right-click on the archive database file (.mdf) and select ->Properties->Security Tab -> Edit button.
- Click the add button and add the current user
- Select the new user and check the box under Allow for the row "Full control"
Repeat this procedure for the archive Log file (.ldf).
Recommendation:
If you are using an older version of PME, consider upgrading to the latest version for improved protocol support and security. For assistance with integration or upgrades, contact Schneider Electric Technical Support at: pmo-psup@se.com
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.