{}

Our Brands

Welcome to the Schneider Electric Website

Welcome to our website.
How can we help you today?
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 Nigeria

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 Nigeria

Explore more
Range:
Explore more
Range:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
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:
Explore more
Range:
move-arrow-top
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.