PME 7.2/8.0: Unable to save tables - "There has been an error while trying to save table"

Issue
Attempting to save tables within PME 7.2.x / 8.x results in the following error:

"There has been an error while trying to save Table: ". Please check all fields and try again.

In this case, the user has verified that a valid name has been assigned to the table, parameters are selected and sources/device are selected correctly.

Product Line
Power Monitoring Expert 7.2.x,
Power Monitoring Expert 8.x

Environment
Web Applications
Internet Explorer 11

Cause
Handling an exception. Exception details: System.InvalidOperationException: User is not authenticated. Real-Time Tables Service require a valid user.
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at SyncInvokeSavePersistenceItem(Object , Object[] , Object[] )
at UI.ApplicationFramework.Web.Services.RealTimeTablesService.SavePersistenceItem(PersistenceItem item)
at UI.ApplicationFramework.Web.Services.RealTimeTablesService.VerifyAuthenticatedUser(

are found in the AppModsServiceTrace.svclog trace log file.

Resolution

1. Enable the Anonymous Authentication and Forms Authentication for the Web and SystemDataService virtual roots in IIS by referring to the steps below:

- Launch the Control Panel, go to 'Administrative Tools', and run "Internet Information Services (IIS) Manager".
- Expand the Server name, Sites, and Default Web Site, and Select "Web". Within the 'IIS' section in the window double-click on 'Forms Authentication' and ensure that the Anonymous Authentication and Forms Authentication are enabled.
- Expand the Server name, Sites, and Default Web Site and Select "SystemDataService". Within the 'IIS' section in the window double-click on 'Forms Authentication' and ensure that the Anonymous Authentication and Forms Authentication are enabled.



2. Restart the applicable server and application services:

• Run the iisreset command from a command prompt window.
• Restart the ION Application Modules Core Services Host, ION Application Modules Data Service Host, and ION Application Modules Provider Engine Host services.

3. Re-attempt to save tables within PME.

If the problem still persists, perform the following steps:
NOTE:  Ensure that a copy of the 'Web.config' file is backed up to a secure location on the server prior to proceeding with the file modifications.

1. Enable Web Tracing the Web RealtimeService by referring to the following KB: FA276441 .
2. Enable the IncludeExceptionDetailInFaults by referring to the steps below where minor modification will be performed to the 'Web.config' file for the Tables web service:

• Stop the ION Application Modules Core Services Host, ION Application Modules Data Service Host, and ION Application Modules Provider Engine Host services.
• Make a backup copy of the Web.config file for the Tables web service, which you can find at the following location:  <PME installation folder>\Applications\ApplicationFramework
  • E.g. C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Applications\ApplicationFramework\Web.config
    
• Add the following section to the Web.config file below the <system.serviceModel> section:
  • <system.diagnostics>
    <sources>
    <source name="System.ServiceModel"
    switchValue="Information, ActivityTracing"
    propagateActivity="true">
    <listeners>
    <add name="traceListener"
    type="System.Diagnostics.XmlWriterTraceListener"
    initializeData= "C:\Log\TablesServiceTrace.svclog" />
    </listeners>
    </source>
    </sources>
    </system.diagnostics>
    
  • Notes:
    • The directory where the trace file is saved on the hard drive may be modified by changing the value for initializeData.
• Perform another modification to the Web.config file in order to include detailed exception information:
  • Find the <behaviors> section underneath <system.serviceModel>
  • Change the includeExceptionDetailInFaults value to "true" as in the following (changes are underlined):
    • <behaviors>
      <serviceBehaviors>
      <behavior name="">
      <serviceMetadata httpGetEnabled="true" />
      <serviceDebug includeExceptionDetailInFaults="true" />
      </behavior>
      <behavior name="metadata">
      <serviceMetadata httpsGetEnabled="true" httpGetEnabled="true" />
      </behavior>
      </serviceBehaviors>
      </behaviors>

3. Ensure that the specific section below matches the one located within "Web.config" file found at the following location:  <PME installation folder>\Applications\ApplicationFramework

• E.g. C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Applications\ApplicationFramework\Web.config

4. Examine the generated trace files for specific errors and submit those to Technical Support.
5. To stop the tracing, restore the backup copy of Web.config

Released for:Schneider Electric Malaysia