我在用户管理界面添加了一个新的自定义属性"ServiceNowGroup"(文字型),用户信息视图也可以看到这个新加的属性,在本地操作可以正常查询和编辑这个属性。然后发布到服务器,服务器上的用户管理可以看到有这个自定义属性被创建了,但是进行访问时日志报错提示“no such column: a.ServiceNowGroup"”。
SQLite error (1): no such column: a.ServiceNowGroup in "select a.[用户名] as C0,a.[全名] as C1,a.[ServiceNowGroup] as C2,a.[角色] as C3,a.[CPMS_Site] as C4 from [用户信息视图] as a Where a.[CPMS] = @p0 ORDER BY a
Sql execute exception--------------------------------------
{
"errorCode": 1,
"ClassName": "System.Data.SQLite.SQLiteException",
"Message": "SQL logic error
no such column: a.ServiceNowGroup",
"Data": null,
"InnerException": null,
"HelpURL": null,
"StackTraceString": " at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at Forguncy.DataSourceBase.FillTableAsync(String commandText, IEnumerable`1 parameters)",
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": null,
"HResult": -2147481665,
"Source": "System.Data.SQLite",
"WatsonBuckets": null
}
|