Discover our Clipsal Smart Home packages as seen on the Block

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    ION_Network Database upgrade fails with error FOREIGN KEY constraint "FK_SRC_Source_SRC_Namespace" conflict

    Issue
    User is unable to upgrade the SPM 7.0 database to PME 7.2

    Product
    StruxureWare Power monitoring 7.0
    Power Monitoring Expert 7.2

    Environment
    Upgrading SPM 7.0.1 to PME 7.2 fails.
    The file C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\diagnostic\ION_Network.log contains the following error

    Msg 547, Level 16, State 1, Server
    \ION, Line 308
    The MERGE statement conflicted with the FOREIGN KEY constraint "FK_SRC_Source_SRC_Namespace". The conflict occurred in database "ION_Network", table "dbo.SRC_Namespace", column 'NamespaceID'.

    Cause
    In the ION_Network database the tables SRC_Namespace does not have an entry for the IONEnterprise namespace with an ID of 1.

    Resolution
    *Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

    1. Open SQL Server Management Studio
    2. Connect to the SPM/PME SQL instance with a user that can edit the ION_Network database
    3. Start a new query  and execute the following command against the ION_Network Database to reseed the table
         DBCC CHECKIDENT('ION_Network.dbo.SRC_Namespace', RESEED, 0)
    4. Expand SQL instance -> Databases->ION_Network->Tables
    5. Right click on SRC_Namespace and select edit top 200 rows
    6. Change the 'IONEnterprise' to 'IONEnterprises'
    7. In a new row, add IONEneteprise - you don't have to add the ID. It will automatically go to 1 because of the reseeding above
    8. Execute the following command
        UPDATE SRC_Source SET NamespaceID = 1 WHERE NamespaceID = 2
    9. Delete the row from SRC_Namespace with ID 2
    10. Re-run the installer to upgrade the ION_Network Database.

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance