How can we help you today?

Report Login Not Created When Creating New ION_Data Database

Product Line
Power Monitoring Expert 7.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Issue
An attempt to use Reporter to run a report against an ION_Data database fails because the Report login does not exist.

Cause
The root cause is that a new ION_Data database was started by detaching the old database, making a copy of the ION_Data database from the ..\system\etc directory, and then re-attaching the ION_DATA database. This workflow is incorrect.

To start a new ION_Data database, use the Create ION database task that Database Manager provides. There are a few possible variations on this root cause, depending on how the new database was attached:

1. Database Manager was used to attach the new database.
2. Enterprise Manager was used to attach the new database, and ION (the default) was accepted as the database owner.
3. Enterprise Manager was used to attach the new database, and SA was specified as the database owner. The upgrade was not run and thus, the ION and Report users were not added.

The possible workarounds are dependent on the possibilities listed above.

Resolution

If you need a new ION_Data database, you can use the New ION Database task from the Database Manager application, which you launch from the Management Console. This approach creates the required users and logins.

Solutions:

Solution for cause 1 above:

1. Use the SQL Editor in the Database Manager to run the following SQL against ION_Data: EXEC sp_changedbowner sa

2. Use the Upgrade Database task to upgrade the database and add the required users and logins.

Solution for cause 2 above:

1. Use Enterprise Manager to detach the database.
2. Re-attach the database and specify SA as the database owner.
3. Use the Upgrade Database task in Database Manager to upgrade the database.

Solution for cause 3 above:

1. Use the Upgrade Database task in Database Manager to upgrade the database.
2. To add the Report login, Use Database Manager and run the Upgrade Database task against the ION_Data database.



More Information

If the New ION Database task in the Database Manager is used to start a new ION_Data database, then this problem will not occur. The alternate workflow (detach, copy a blank database file from the etc directory, attach) will work, but only if the newly created database is attached using Enterprise Manager, sa is specified as the database owner, and the database is upgraded using the Database Manager before it is used.

ION Enterprise 5.5 SP1 introduces some changes. When Upgrade is run, even if the database owner has been specified as ION, it will correctly add the required users and logins. The Database Manager has been changed to attach databases using sa as the database owner and correctly adding users and logins.

Schneider Electric Singapore

Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
  • Product Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Contact Support
  • Find our Offices
  • Get a Quote
  • Where to buy
  • Schneider Electric Community
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Legal Information
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings
  • Preference Centre