【10.0.5】试图转换值 '59aba046-c22f-4903-b3b3-9fcfb541002b' 时失败

登录

2024-11-24 18:24:11.205 [WARN ] - [bb75e93d-6085-4958-9158-dd4218c8ec90] - {
  "ClassName": "System.FormatException",
  "Message": "转换失败:Input string was not in a correct format.
试图转换值 '59aba046-c22f-4903-b3b3-9fcfb541002b' 时失败",
  "Data": null,
  "InnerException": {
"$type": "System.FormatException, System.Private.CoreLib",
"ClassName": "System.FormatException",
"Message": "Input string was not in a correct format.",
"Data": null,
"InnerException": null,
"HelpURL": null,
"StackTraceString": " at System.Number.ThrowOverflowOrFormatException(ParsingStatus status, TypeCode type)
at System.Int64.Parse(String s, NumberStyles style, IFormatProvider provider)",
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": null,
"HResult": -2146233033,
"Source": "System.Private.CoreLib",
"WatsonBuckets": null
  },
  "HelpURL": null,
  "StackTraceString": " at ForguncyCoreUtilities.SuperConverter.ParseString(String value, Type targetType, IFormatProvider formatProvider)
at ForguncyCoreUtilities.SuperConverter.Convert(Object value, TypeConverter sourceTypeConverter, Type targetType, TypeConverter targetTypeConverter, String format, IFormatProvider formatProvider)
at ServerDesignerCommon.Common.SqlConditionUpdater.<>c__DisplayClass11_0.<UpdateValueType>b__0(SqlConditionBase sqlConditionBase)",
  "RemoteStackTraceString": null,
  "RemoteStackIndex": 0,
  "ExceptionMethod": null,
  "HResult": -2146233033,
  "Source": "ForguncyCoreUtilities",
  "WatsonBuckets": null
}

CurrentMethodName: UpdateValueType
2024-11-24 18:27:19.591 [WARN ] - [646186ee-bc58-49e1-bf9c-4103205bb665] - Query data from database, result has 113928 rows and 11 column. It may impact performance.
2024-11-24 18:27:25.324 [WARN ] - [fbac2e27-425b-429c-bb9d-56705865bb54] - Query data from database, result has 114044 rows and 11 column. It may impact performance.

Simon.Sun · Simon.Sun

您好，这个问题和空值查询策略有关。
比如我们设置变量命令的空值查询策略设置为空记录，空记录意思就是参数为空时，不要返回数据。
活字格底层在处理时，为了保证去数据库查询结果要返回空记录，就是一条记录都没有，底层在处理，传了一个 GUID 去做过滤。但是由于我们字段类型可能不是文本，比如整数，就会出现类型转换的错误。

但是这个不会影响到功能的使用，只是日志里会记录一个警告级别的日志。
如果觉得这个日志有点多，可以把空值查询策略修改一下，修改成查询值为空的记录，这样就会用空的参数直接做过滤，就不会出现警告日志了。

		自动登录	找回密码
密码			立即注册

[已处理] 【10.0.5】试图转换值 '59aba046-c22f-4903-b3b3-9fcfb541002b' 时失败

最佳答案

1 个回复

悬赏达人

活字格认证

活字格高级认证

Wyn高级认证

Wyn认证