跨服务器做了数据库视图

Lay.Li

跨服务器做了数据库视图，然后在同一个数据库关联字段后报错  /Forguncy/Home/GetTableDataWithOffset
Internal Server Error
Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
UserName:140915
Sql Statement:
[
  {
"Sql": "SELECT TABLE_NAME , COLUMN_NAME , DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE (DATA_TYPE = 'rowversion' OR DATA_TYPE = 'timestamp') AND TABLE_NAME = \"产品清单\" AND TABLE_SCHEMA = \"dbo\" ",
"OriginalSql": "SELECT TABLE_NAME , COLUMN_NAME , DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE (DATA_TYPE = 'rowversion' OR DATA_TYPE = 'timestamp') AND TABLE_NAME = @p0 AND TABLE_SCHEMA = @p1",
"SqlParams": [
   {
      "Name": "@p0",
      "Value": "产品清单"
   },
   {
      "Name": "@p1",
      "Value": "dbo"
   }
],
"SqlParam": null,
"Duration": "1.2982ms"
  },
  {
"Sql": "SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,IS_NULLABLE AS NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE NOT IN ('geography', 'hierarchyid' ,'geometry') AND TABLE_NAME = \"产品清单\" AND TABLE_SCHEMA = \"dbo\" ORDER BY ORDINAL_POSITION ",
"OriginalSql": "SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,IS_NULLABLE AS NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE NOT IN ('geography', 'hierarchyid' ,'geometry') AND TABLE_NAME = @p0 AND TABLE_SCHEMA = @p1 ORDER BY ORDINAL_POSITION",
"SqlParams": [
   {
      "Name": "@p0",
      "Value": "产品清单"
   },
   {
      "Name": "@p1",
      "Value": "dbo"
   }
],
"SqlParam": null,
"Duration": "2.0394ms"
  },
  {
"Sql": "select  Top 0 [ID],[客户ID],[规格],[品号],[厂内品名],[模具ID],[图片附件],[备注],[对应旧料号],[SOP版本],[SIP版本],[包装设计版本],[作业流程版本],[生产资料],[FGC_Creator],[FGC_CreateDate],[FGC_LastModifier],[FGC_LastModifyDate],[FGC_Rowversion],[FGC_UpdateHelp],[有效性],[单号],[状态],[担当者],[审核者],[审核时间] from [dbo].[产品清单] ",
"OriginalSql": null,
"SqlParam": null,
"Duration": "0.5476ms"
  },
  {
"Sql": "SELECT CC.COLUMN_NAME ,CC.CONSTRAINT_NAME,TC.CONSTRAINT_TYPE FROM  INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC  \r\n                   INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CC ON TC.CONSTRAINT_NAME = CC.CONSTRAINT_NAME \r\n\t\t\t\t\tAND TC.TABLE_SCHEMA=CC.TABLE_SCHEMA AND TC.TABLE_NAME=CC.TABLE_NAME\r\n                   WHERE 1=1  and TC.CONSTRAINT_TYPE = \"PRIMARY KEY\" AND TC.TABLE_NAME = \"产品清单\" AND TC.TABLE_SCHEMA  = \"dbo\"  ORDER BY TC.CONSTRAINT_NAME ",
"OriginalSql": "SELECT CC.COLUMN_NAME ,CC.CONSTRAINT_NAME,TC.CONSTRAINT_TYPE FROM  INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC  \r\n                   INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CC ON TC.CONSTRAINT_NAME = CC.CONSTRAINT_NAME \r\n\t\t\t\t\tAND TC.TABLE_SCHEMA=CC.TABLE_SCHEMA AND TC.TABLE_NAME=CC.TABLE_NAME\r\n                   WHERE 1=1  and TC.CONSTRAINT_TYPE = @p1 AND TC.TABLE_NAME = @p2 AND TC.TABLE_SCHEMA  = @p4  ORDER BY TC.CONSTRAINT_NAME",
"SqlParams": [
   {
      "Name": "@p1",
      "Value": "PRIMARY KEY"
   },
   {
      "Name": "@p2",
      "Value": "产品清单"
   },
   {
      "Name": "@p4",
      "Value": "dbo"
   }
],
"SqlParam": null,
"Duration": "5.6191ms"
  },
  {
"Sql": "SELECT CC.COLUMN_NAME ,CC.CONSTRAINT_NAME,TC.CONSTRAINT_TYPE FROM  INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC  \r\n                   INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CC ON TC.CONSTRAINT_NAME = CC.CONSTRAINT_NAME \r\n\t\t\t\t\tAND TC.TABLE_SCHEMA=CC.TABLE_SCHEMA AND TC.TABLE_NAME=CC.TABLE_NAME\r\n                   WHERE 1=1  and TC.CONSTRAINT_TYPE = \"UNIQUE\" AND TC.TABLE_NAME = \"产品清单\" AND TC.TABLE_SCHEMA  = \"dbo\"  ORDER BY TC.CONSTRAINT_NAME ",
"OriginalSql": "SELECT CC.COLUMN_NAME ,CC.CONSTRAINT_NAME,TC.CONSTRAINT_TYPE FROM  INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC  \r\n                   INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CC ON TC.CONSTRAINT_NAME = CC.CONSTRAINT_NAME \r\n\t\t\t\t\tAND TC.TABLE_SCHEMA=CC.TABLE_SCHEMA AND TC.TABLE_NAME=CC.TABLE_NAME\r\n                   WHERE 1=1  and TC.CONSTRAINT_TYPE = @p1 AND TC.TABLE_NAME = @p2 AND TC.TABLE_SCHEMA  = @p4  ORDER BY TC.CONSTRAINT_NAME",
"SqlParams": [
   {
      "Name": "@p1",
      "Value": "UNIQUE"
   },
   {
      "Name": "@p2",
      "Value": "产品清单"
   },
   {
      "Name": "@p4",
      "Value": "dbo"
   }
],
"SqlParam": null,
"Duration": "1.9284ms"
  },
  {
"Sql": "Select COLUMN_NAME,COLUMN_DEFAULT AS DATA_DEFAULT, DATA_TYPE, '' AS CHARACTER_LENGTH,\r\n                   NUMERIC_PRECISION,NUMERIC_SCALE,DATETIME_PRECISION,CHARACTER_MAXIMUM_LENGTH AS CHAR_LENGTH \r\n                   from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = \"产品清单\" AND TABLE_SCHEMA =\"dbo\" ",
"OriginalSql": "Select COLUMN_NAME,COLUMN_DEFAULT AS DATA_DEFAULT, DATA_TYPE, '' AS CHARACTER_LENGTH,\r\n                   NUMERIC_PRECISION,NUMERIC_SCALE,DATETIME_PRECISION,CHARACTER_MAXIMUM_LENGTH AS CHAR_LENGTH \r\n                   from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @p0 AND TABLE_SCHEMA =@p1",
"SqlParams": [
   {
      "Name": "@p0",
      "Value": "产品清单"
   },
   {
      "Name": "@p1",
      "Value": "dbo"
   }
],
"SqlParam": null,
"Duration": "2.8809ms"
  },
  {
"Sql": "  select s.name as VIEW_OWNER ,t.name as VIEW_NAME from sys.views t inner join sys.schemas s on t.SCHEMA_ID =s.SCHEMA_ID where 1=1  and s.name =\"dbo\"  and t.name =\"产品清单\"  order by s.name,t.name asc ",
"OriginalSql": "  select s.name as VIEW_OWNER ,t.name as VIEW_NAME from sys.views t inner join sys.schemas s on t.SCHEMA_ID =s.SCHEMA_ID where 1=1  and s.name =@p0  and t.name =@p1  order by s.name,t.name asc",
"SqlParams": [
   {
      "Name": "@p0",
      "Value": "dbo"
   },
   {
      "Name": "@p1",
      "Value": "产品清单"
   }
],
"SqlParam": null,
"Duration": "0.7071ms"
  },
  {
"Sql": "select sys.identity_columns.seed_value, sys.identity_columns.increment_value, sys.identity_columns.name from sys.identity_columns inner join sys.tables on sys.identity_columns.object_id = sys.tables.object_id inner join sys.schemas on sys.tables.schema_id = sys.schemas.schema_id where sys.tables.name = \"产品清单\" and sys.schemas.name = \"dbo\" ",
"OriginalSql": "select sys.identity_columns.seed_value, sys.identity_columns.increment_value, sys.identity_columns.name from sys.identity_columns inner join sys.tables on sys.identity_columns.object_id = sys.tables.object_id inner join sys.schemas on sys.tables.schema_id = sys.schemas.schema_id where sys.tables.name = @p0 and sys.schemas.name = @p1",
"SqlParams": [
   {
      "Name": "@p0",
      "Value": "产品清单"
   },
   {
      "Name": "@p1",
      "Value": "dbo"
   }
],
"SqlParam": null,
"Duration": "0.864ms"
  },
  {
"Sql": "select  a1.[客户简称] as C0,a.[规格] as C1,a.[品号] as C2,a.[厂内品名] as C3,a.[备注] as C4,a.[对应旧料号] as C5,a2.[版本] as C6,a.[FGC_Rowversion] as C7,a.[ID] as C8 from [dbo].[产品清单] as a  left join [dbo].[ZIMAG001-COPMA] as a1 on a.[客户ID] = a1.[客户编号] left join [dbo].[最新作业流程] as a2 on a.[厂内品名] = a2.[厂内品号] ORDER BY a.[ID] ASC ",
"OriginalSql": null,
"SqlParam": null,
"Duration": "50.9539ms"
  }
]
{
  "IsTransient": false,
  "SqlState": null,
  "BatchCommand": null,
  "ErrorCode": -2147467259,
  "Message": "无法解决 equal to 运算中 \"Chinese_PRC_BIN\" 和 \"Chinese_PRC_CI_AS\" 之间的排序规则冲突。 ",
  "Data": {
"$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib"
  },
  "InnerException": null,
  "HelpLink": null,
  "Source": "GrapeCity.Forguncy.DataBaseApi",
  "HResult": -2147467259,
  "StackTrace": " at GrapeCity.Forguncy.DataBaseApi.DataWrapperBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
at GrapeCity.Forguncy.DataBaseApi.DataWrapperBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
at Forguncy.DataSourceBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
at ForguncyDataAccess.DataAccess.SelectFromDatabaseAsync(String connectionString, String selectString, String databaseType, DbParameter[] parameters, ISqlSettings sqlSettings)
at ForguncyDataAccess.DataAccess.SelectAsync(ISqlSettings sqlSettings, List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
at Forguncy.Server2.ForguncyServerDataAccess.SelectAsync(ISqlSettings sqlSettings, List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
at ForguncyDataAccess.DataAccess.GetDetailDataTableWithSqlSettingsAsync(ISqlSettings sqlSettings, List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at ForguncyDataAccess.DataAccess.GetDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at Forguncy.Server2.ForguncyServerDataAccess.GetDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at Forguncy.Server2.Controllers.HomeController.QueryDataByDataAccessAsync(List`1 infos, Int32 demandRowCount, OffsetSqlCondition offsetCondition, Boolean distinct, ISqlCondition queryConditionObj, TopSqlConditionBase topConditionObj, OrderBySqlCondition orderByConditionObj, List`1 primaryKeys, IDataAccess dataAccess)
at Forguncy.Server2.Controllers.HomeController.GetListviewDataAsync(List`1 infos, CurrentRowInfo currentRowInfo, Int32 demandRowCount, Int32 currentDataLength, Boolean needRowVersion, QueryCommandInfo queryCommandInfo, List`1 currentOrderByInfo, RuntimeQueryConditionData runtimeQueryConditionData, String sortCommandID, OffsetSqlCondition offsetCondition, Boolean needWriteDataAccessLog, ColumnFilterQuery[] columnFilterQueries, Boolean distinct, List`1 totalRowBindingInfos, Boolean allowLoadOnDemaid, Boolean addQueryConditionStatisticColumnToBindingInfoList, String dataSourceGUID)
at Forguncy.Server2.Controllers.HomeController.GetListviewDataAsync(List`1 infos, CurrentRowInfo currentRowInfo, Int32 demandRowCount, Int32 currentDataLength, Boolean needRowVersion, QueryCommandInfo queryCommandInfo, List`1 currentOrderByInfo, RuntimeQueryConditionData runtimeQueryConditionData, String sortCommandID, OffsetSqlCondition offsetCondition, Boolean needWriteDataAccessLog, ColumnFilterQuery[] columnFilterQueries, Boolean distinct, List`1 totalRowBindingInfos, Boolean allowLoadOnDemaid, Boolean addQueryConditionStatisticColumnToBindingInfoList, String dataSourceGUID)
at Forguncy.Server2.Controllers.HomeController.<>c__DisplayClass35_0.<<GetTableDataWithOffsetAsync>b__0>d.MoveNext()
--- End of stack trace from previous location ---
at Forguncy.Server2.Controllers.HomeController.GetTableDataWithCacheAsync[T](CacheSetting cacheSetting, String tableName, Object paramObj, Func`1 action)
at Forguncy.Server2.Controllers.HomeController.GetTableDataWithOffsetAsync(GetTableDataWithOffsetParam data)
at lambda_method1455(Closure, Object)
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at ServerDesignerCommon.CodeEditor.CodeEditorMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.JavaAdapterReflectMiddleWare.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.ProcessEngineMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.ReportsMiddleware.DoInvokeAsync(HttpContext context, ICacheService cacheService, IReportServerService reportServerService)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase`2.InvokeAsync(HttpContext context, TService1 service1, TService2 service2)
at Forguncy.KatanaMiddleware.ServerCommandMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.AppServiceMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at ak.DoInvokeAsync(HttpContext a)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at aj.DoInvokeAsync(HttpContext a)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.StartPageMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.ResourceMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at ForguncyServerCommon.HttpHeaderMiddlewareBase.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at Arsenal.Server.Middlewares.Middleware.InvokeAsync(HttpContext context)
at ForguncyServerCommon.HttpResponseHeaderMiddlewareBase.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.IpRestrictionMiddleware.DoInvokeAsync(HttpContext httpContext)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.RecordProxyHeaderInfoMiddleware.DoInvokeAsync(HttpContext httpContext)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at aq.DoInvokeAsync(HttpContext a)"
}

Lay.Li · Lay.Li

您好，看这个日志，是数据库本身的报错，可以看一下关联的这两个字段的排序规则是不是不一样，如果不一样的话，设置为一样的就可以了~

djs521720 · djs521720

Lay.Li 发表于 2025-5-28 12:21
您好，看这个日志，是数据库本身的报错，可以看一下关联的这两个字段的排序规则是不是不一样，如果不一样 ...

加上COLLATE Chinese_PRC_CI_AS ok了谢谢

Lay.Li · Lay.Li

不客气哈~
后边有问题欢迎随时发帖交流

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

[已处理] 跨服务器做了数据库视图

最佳答案

3 个回复

本帖子中包含更多资源

活字格认证

圣诞拼拼乐

微信认证勋章

悬赏达人

讲师达人

活字格高级认证