【10.0.5】试图转换值 '59aba046-c22f-4903-b3b3-9fcfb541002b' 时失败
2024-11-24 18:24:11.205 - - {
"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 - - Query data from database, result has 113928 rows and 11 column. It may impact performance.
2024-11-24 18:27:25.324 - - Query data from database, result has 114044 rows and 11 column. It may impact performance.
您好，这个问题和空值查询策略有关。
比如我们设置变量命令的空值查询策略设置为空记录，空记录意思就是参数为空时，不要返回数据。
活字格底层在处理时，为了保证去数据库查询结果要返回空记录，就是一条记录都没有，底层在处理，传了一个 GUID 去做过滤。但是由于我们字段类型可能不是文本，比如整数，就会出现类型转换的错误。
但是这个不会影响到功能的使用，只是日志里会记录一个警告级别的日志。
如果觉得这个日志有点多，可以把空值查询策略修改一下，修改成查询值为空的记录，这样就会用空的参数直接做过滤，就不会出现警告日志了。
页:
[1]