Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CAP初始化错误---> 从字符串转换日期和/或时间时,转换失败。 #139

Closed
fayuanliu opened this issue Jun 6, 2018 · 3 comments

Comments

@fayuanliu
Copy link

commented Jun 6, 2018

数据库,表结构已经生成,表示数据库连接 没有问题。
详细问题如图:
image

@fayuanliu

This comment has been minimized.

Copy link
Author

commented Jun 6, 2018

Task<IEnumerable> GetPublishedMessagesOfNeedRetry()
var fourMinsAgo = DateTime.Now.AddMinutes(-4);
取出的时间包含了 中文:2018/6/6 下午 05:57:43
导致sql 出错:
SELECT TOP (200) * FROM [Cap].[Published] WITH (readpast) WHERE Retries<50 AND Added<'2018/6/6 下午 05:57:43' AND (StatusName = 'Failed' OR StatusName = 'Scheduled')
希望可以对datetime进行格式化

@yang-xiaodong yang-xiaodong added the bug label Jun 7, 2018

@yang-xiaodong

This comment has been minimized.

Copy link
Member

commented Jun 7, 2018

是的,此处应该进行格式化处理,防止地域影响下的格式化的错误。 谢谢反馈

yang-xiaodong added a commit that referenced this issue Jun 7, 2018

@yang-xiaodong yang-xiaodong added the fixed label Jun 7, 2018

@yang-xiaodong

This comment has been minimized.

Copy link
Member

commented Jun 7, 2018

Fixed in version 2.2.5-preview-45139132

@fayuanliu fayuanliu closed this Jun 8, 2018

yang-xiaodong added a commit that referenced this issue Jun 12, 2018
yang-xiaodong added a commit that referenced this issue Jul 19, 2018
Release 2.2.5 (#162)
* update version to 2.2.4

* Fixed Incorrect local IP address judgment of IPv6. (#140)

* Fixed DateTime localization format conversion error to sql.(#139)

* update version to 2.2.5

* remove unused constructor.

* Fixed DateTime localization format conversion error to sql.(#139)

* Improved logging

* support RabbitMQ cluster configuration.

* Fixed dashboard message page re-requeue and re-executed  operate bug. (#158)

* refactor code

* refactor log extensions.

* refactor retry task processor.

* Fixed  configuration options of FailedThresholdCallback could not be invoke when the value less then three.  (#161)

* update samples.

* Fixed SendAsync or ExecuteAsync recursion retries bug. (#160)

* Fixed SendAsync or ExecuteAsync recursion retries bug. (#160)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.