Closed ebessan closed 1 year ago
リマインダーが動かない。。。
os centos7 db postgres12 ver ver.1.3.20.0
エラーメッセージ: 22008: 日付時刻のフィールドが範囲外です: "10/15/2022 12:00:00 AM"
POSITION: 463 エラースタックトレース: at Npgsql.Internal.NpgsqlConnector.gReadMessageLong|211_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Implem.PostgreSql.PostgreSqlDataAdapter.Fill(DataTable dataTable) in C:\Implem\Pleasanter.NetCore\Rds\Implem.PostgreSql\PostgreSqlDataAdapter.cs:line 105 at Implem.Libraries.DataSources.SqlServer.SqlIo.Try(ISqlObjectFactory factory, Action action) in C:\Implem\Pleasanter.NetCore\Implem.Libraries\DataSources\SqlServer\SqlIo.cs:line 287 at Implem.Libraries.DataSources.SqlServer.SqlIo.ExecuteTable(ISqlObjectFactory factory, IDbTransaction dbTransaction, IDbConnection dbConnection) in C:\Implem\Pleasanter.NetCore\Implem.Libraries\DataSources\SqlServer\SqlIo.cs:line 185 at Implem.Pleasanter.Libraries.DataSources.Rds.ExecuteTable(Context context, IDbTransaction dbTransaction, IDbConnection dbConnection, String connectionString, Boolean transactional, Boolean writeSqlToDebugLog, SqlStatement[] statements) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Rds.cs:line 292 at Implem.Pleasanter.Libraries.DataSources.Repository.<>c__DisplayClass10_0.b0(IDbTransaction transaction, IDbConnection connection) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Repository.cs:line 326 at Implem.Pleasanter.Libraries.DataSources.Rds.ExecuteScalar[T](Context context, String connectionString, Boolean transactional, Func3 func) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Rds.cs:line 255 at Implem.Pleasanter.Libraries.DataSources.Repository.ExecuteTable(Context context, String connectionString, Boolean transactional, SqlStatement[] statements) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Repository.cs:line 328 at Implem.Pleasanter.Libraries.Settings.Reminder.GetDataTable(Context context, SiteSettings ss, List1 toColumns, List1 subjectColumns, List1 bodyColumns, DateTime scheduledTime) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\Settings\Reminder.cs:line 586 at Implem.Pleasanter.Libraries.Settings.Reminder.Remind(Context context, SiteSettings ss, DateTime scheduledTime, Boolean test) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\Settings\Reminder.cs:line 183
3 func) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Rds.cs:line 255 at Implem.Pleasanter.Libraries.DataSources.Repository.ExecuteTable(Context context, String connectionString, Boolean transactional, SqlStatement[] statements) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Repository.cs:line 328 at Implem.Pleasanter.Libraries.Settings.Reminder.GetDataTable(Context context, SiteSettings ss, List
1 subjectColumns, List
This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 7 days.
This issue was closed because it has been stalled for 7 days with no activity.
リマインダーが動かない。。。
os centos7 db postgres12 ver ver.1.3.20.0
エラーメッセージ: 22008: 日付時刻のフィールドが範囲外です: "10/15/2022 12:00:00 AM"
POSITION: 463 エラースタックトレース: at Npgsql.Internal.NpgsqlConnector.gReadMessageLong|211_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
at Npgsql.NpgsqlDataReader.NextResult()
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Implem.PostgreSql.PostgreSqlDataAdapter.Fill(DataTable dataTable) in C:\Implem\Pleasanter.NetCore\Rds\Implem.PostgreSql\PostgreSqlDataAdapter.cs:line 105
at Implem.Libraries.DataSources.SqlServer.SqlIo.Try(ISqlObjectFactory factory, Action action) in C:\Implem\Pleasanter.NetCore\Implem.Libraries\DataSources\SqlServer\SqlIo.cs:line 287
at Implem.Libraries.DataSources.SqlServer.SqlIo.ExecuteTable(ISqlObjectFactory factory, IDbTransaction dbTransaction, IDbConnection dbConnection) in C:\Implem\Pleasanter.NetCore\Implem.Libraries\DataSources\SqlServer\SqlIo.cs:line 185
at Implem.Pleasanter.Libraries.DataSources.Rds.ExecuteTable(Context context, IDbTransaction dbTransaction, IDbConnection dbConnection, String connectionString, Boolean transactional, Boolean writeSqlToDebugLog, SqlStatement[] statements) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Rds.cs:line 292
at Implem.Pleasanter.Libraries.DataSources.Repository.<>c__DisplayClass10_0.b 0(IDbTransaction transaction, IDbConnection connection) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Repository.cs:line 326
at Implem.Pleasanter.Libraries.DataSources.Rds.ExecuteScalar[T](Context context, String connectionString, Boolean transactional, Func
3 func) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Rds.cs:line 255 at Implem.Pleasanter.Libraries.DataSources.Repository.ExecuteTable(Context context, String connectionString, Boolean transactional, SqlStatement[] statements) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\DataSources\Repository.cs:line 328 at Implem.Pleasanter.Libraries.Settings.Reminder.GetDataTable(Context context, SiteSettings ss, List
1 toColumns, List1 subjectColumns, List
1 bodyColumns, DateTime scheduledTime) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\Settings\Reminder.cs:line 586 at Implem.Pleasanter.Libraries.Settings.Reminder.Remind(Context context, SiteSettings ss, DateTime scheduledTime, Boolean test) in C:\Implem\Pleasanter.NetCore\Implem.Pleasanter\Libraries\Settings\Reminder.cs:line 183