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

For this particular case 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.

A Special Character generally refers to any character that is not a letter or a number. In this instance the special character that was used was ( and ).

Here is an exampled of the resolution used in context:

1. Special characters 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.

The above script can be altered to suit the instance in your situation where a special character has been used.

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

Released for: Schneider Electric Australia