Issue

When trying to run a majority of predefined reports some will work, but others will return the following error:

"An unexpected error has occurred. Your request cannot be processed at this time. If the problem persists, contact the Webpage administrator".

Resolution

Upon investigation in the ION Database it was noticed that there was a special character used which caused the error to be thrown up as it could not be processed and a report generated.

Here is an exampled of the resolution used in context:

1. Special character was present in Measurements names "Cumulative Usage ( )" and "Demand Last (No Units)" in [ION_Network].[dbo].[MM_MeasurementMap].

2. Open Windows Services and stop all the ION Services.

3. Run the below script to delete the special characters (The ID of the characters will differ outside of this example)

--To Delete the Invalid character of Cumulative Usage ( ) which refers to ID 11226

--To Delete the Invalid character of Demand Last (No Units) which refers to ID 11225

USE ION_Network

GO

Delete from [ION_Network].[dbo].[MM_MeasurementMap]

where ID IN (11226)

Delete from [ION_Network].[dbo].[MM_MeasurementMap]

where ID IN (11225)

GO

4. Open a windows command prompt (cmd.exe) and run IISRESET

5. Open Windows Services again and start all the ION Services.

6. Refresh the web browser and check the reports.

It is always recommended to take a backup before modifying the ION Database.

Released for:Schneider Electric New Zealand