You are currently viewing the content available in Vietnam. If you are looking for information for another region, please select the correct country from the top-left dropdown in the page and 'Navigate to Browse FAQs' in the Support menu.
Issue
When upgrading SPM 7.0.1 to PME 7.2.2 or PME 8.0...the installer fails on step "Verify Databases" with the message "The ION_Network table was not upgraded" or "An error has occurred during the ION_Network database deployment"
When opening the ION_Network.log ( located in the <install directory>\diagnostic folder), at the bottom of the file the error message reads:
"You do not have permission to use the bulk load statement"
Product Line
PME 7.2.2
PME 8.0
Environment
Upgrade to PME 7.2.2 from SPM 7.0.1
Upgrade to PME 8.0 from PME 7.2.2
Cause
The "ION" sql account does not have "sysadmin" privileges
Resolution
To provide sysadmin privileges to the "ION" Sql account, follow the below steps:
1. Open SQL Server Management Studio and log in to the instance of SQL being used by PME 7.2.x or PME 8.0, using the appropriate administrator credentials.
2. Expand the instance of SQL being used and the folder "security" followed by the folder "Logins"
3. Right click on the user "ION" and select "properties"
4. Click on the tab "server roles" and select the checkbox for "sysadmin"
5. Click "ok" on the login properties window and rerun the installer.
When upgrading SPM 7.0.1 to PME 7.2.2 or PME 8.0...the installer fails on step "Verify Databases" with the message "The ION_Network table was not upgraded" or "An error has occurred during the ION_Network database deployment"
When opening the ION_Network.log ( located in the <install directory>\diagnostic folder), at the bottom of the file the error message reads:
"You do not have permission to use the bulk load statement"
Product Line
PME 7.2.2
PME 8.0
Environment
Upgrade to PME 7.2.2 from SPM 7.0.1
Upgrade to PME 8.0 from PME 7.2.2
Cause
The "ION" sql account does not have "sysadmin" privileges
Resolution
To provide sysadmin privileges to the "ION" Sql account, follow the below steps:
1. Open SQL Server Management Studio and log in to the instance of SQL being used by PME 7.2.x or PME 8.0, using the appropriate administrator credentials.
2. Expand the instance of SQL being used and the folder "security" followed by the folder "Logins"
3. Right click on the user "ION" and select "properties"
4. Click on the tab "server roles" and select the checkbox for "sysadmin"
5. Click "ok" on the login properties window and rerun the installer.
Released for: Schneider Electric Vietnam
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales enquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Centre
Find support resources for all your needs, in one place.
