{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
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.
Error while generating web report: The Sort expression for the table 'shiftDescriptionTable' contains an error: Conversion from string "12:00 a.m." to type 'Date' is not valid.

Goals and Symptoms

Generating any web report will result in the following error being generated:
An error had occurred during report processing.
The Sort expression for the table 'shiftDescriptionTable' contains an error: Conversion from string "12:00 a.m." to type 'Date' is not valid.

  • The time format configured in the regional and language settings is using the AM and PM format
  • Reboot after applying settings does not help
  • Data being displayed in Vista is using this format as well

Facts and Changes

Errors like the follow may be present in the EventException table in the ION_SystemLog database:
System.ApplicationException: Error creating SQL Agent heartbeat. ---> Microsoft.SqlServer.Management.Smo.FailedOperationException: Drop failed for Job '[ION SUBSCRIPTION] - Heartbeat'. ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot perform this operation while SQLServerAgent is starting. Try again later. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) --- End of inner exception stack trace --- at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImplWorker(Urn& urn) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImpl() --- End of inner exception stack trace --- at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImpl() at Microsoft.SqlServer.Management.Smo.Agent.Job.Drop() at PowerMeasurement.Scheduling.SQLAgentScheduler.CreateSQLAgentHeartbeat() at PowerMeasurement.Apps.Services.ReportSubscriptionService.SetupSQLAgentHeartbeat() --- End of inner exception stack trace --- at PowerMeasurement.Apps.Services.ReportSubscriptionService.SetupSQLAgentHeartbeat() at PowerMeasurement.Apps.Services.ReportSubscriptionService.OnStart(String[] args)

Causes and Fixes

The browser version of Internet Explorer is not supported. Version 6 or older is installed. Upgrade to Internet Explorer version 7 or newer and this should resolve this particular issue.


Legacy KB System (APS) Data: RESL201975 V1.0, Originally authored by DaMi on 04/15/2010, Last Edited by DaMi on 04/15/2010
Related ranges: ION Enterprise V6.0

Schneider Electric Vietnam

Explore more
Range:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: