Issue
ION_Data Archive database upgrade fails in PME using database manager
Product Line
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Environment
Database Manager
Cause
User has ION_Data archive that was created from previous versions of the software and may have been copied and moved to location on 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.
Repeat this procedure for the archive Log file (.ldf).
ION_Data Archive database upgrade fails in PME using database manager
Product Line
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Environment
Database Manager
Cause
User has ION_Data archive that was created from previous versions of the software and may have been copied and moved to location on 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 clicking 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).
Publicado para: Schneider Electric Portugal
Precisa de ajuda?
Comece aqui!
Encontre respostas agora. Procure uma solução sozinho ou entre em contacto com um dos nossos especialistas.
Contactar a assistência
Contacte a nossa equipa de atendimento ao cliente para receber mais informações, assistência técnica, assistência com reclamações e muito mais.
Onde adquirir?
Encontre facilmente o distribuidor mais próximo da Schneider Electric perto de si.
Consulte as perguntas frequentes (FAQ)
Obtenha as respostas de que necessita explorando as perguntas frequentes (FAQ) relacionadas com tópicos.
Contactar o departamento de vendas
Inicie o seu pedido de contacto online e um especialista irá contactá-lo.
