Drecik  2023-1-15 20:32:51 |
1 227

4

回帖

170

金币

95

积分

积分
95
发表于 2023-1-15 20:32:51 | 显示全部楼层 |阅读模式

马上注册,下载996引擎,与更多游戏开发者交流。

您需要 登录 才可以下载或查看,没有账号?注册

×
引擎版本:2022.12.08.0_64位
游戏版本:180复古战神
自己搭建了一个本地Sql Server,配置管理器中的更新数据库已经更新成,但是启动M2的时候报错,完整报错在附件,主要报错信息为:
  1. [2023-01-15 20:08:32:959] 执行SQL异常 TDbThread.ExecSql,Sql:MERGE INTO dbo.TBL_VAR A
  2. USING ( SELECT 'system' AS FLD_USERID,'ITEMNUMBER' AS FLD_VAR_NAME,0 AS FLD_TYPE,'10000' AS FLD_VAR_VALUE,'2023-01-15 20:08:31.441' AS tUpdateTime
  3. ) B
  4. ON (A.FLD_USERID=B.FLD_USERID AND A.FLD_VAR_NAME=B.FLD_VAR_NAME AND A.FLD_TYPE=B.FLD_TYPE)
  5. WHEN MATCHED THEN
  6.         UPDATE SET A.FLD_VAR_VALUE=B.FLD_VAR_VALUE,A.tUpdateTime=B.tUpdateTime
  7. WHEN NOT MATCHED THEN
  8.         INSERT(FLD_USERID,FLD_VAR_NAME,FLD_TYPE,FLD_VAR_VALUE,tUpdateTime)
  9.         VALUES(B.FLD_USERID,B.FLD_VAR_NAME,B.FLD_TYPE,B.FLD_VAR_VALUE,B.tUpdateTime);  Except:[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0][SQL Server]对象名 'dbo.TBL_VAR' 无效。[00000000009A50C1] JclDebug._ZN8Jcldebug17TJclStackInfoListC3EbiPvbS1_S1_ (Line 5510, "JclDebug.pas" + 34)
  10. [00000000009A4912] JclDebug._ZN8Jcldebug18JclCreateStackListEbiPvbS0_ (Line 5351, "JclDebug.pas" + 1)
  11. [00000000009A47F4] JclDebug._ZN8Jcldebug21DoExceptionStackTraceEPN6System7TObjectEPvbS3_ (Line 5292, "JclDebug.pas" + 20)
  12. [00000000009A7908] JclDebug._ZN8Jcldebug14DoExceptNotifyEPN6System7TObjectEPvbS3_ (Line 6742, "JclDebug.pas" + 7)
  13. [00000000009964E2] JclHookExcept._ZN13Jclhookexcept13TNotifierItem8DoNotifyEPN6System7TObjectEPvbS4_ (Line 272, "JclHookExcept.pas" + 5)
  14. [000000000099674B] JclHookExcept._ZN13Jclhookexcept14DoExceptNotifyEPN6System7TObjectEPvbS3_ (Line 339, "JclHookExcept.pas" + 13)
  15. [00000000009968B0] JclHookExcept._ZN13Jclhookexcept20HookedRaiseExceptionEjjjPNS_19TExceptionArgumentsE (Line 381, "JclHookExcept.pas" + 14)
  16. [0000000000412053] System._ZN6System14_RaiseAtExceptEPNS_7TObjectEPv (Line 22049, "System.pas" + 32)
  17. [00000000004120B8] System._ZN6System11_RaiseAgainEv (Line 23128, "System.pas" + 9)
  18. [00000000009FF564] FireDAC.Comp.Client._ZN7Firedac4Comp6Client16TFDCustomCommand15InternalExecuteEiib (Line 6853, "FireDAC.Comp.Client.pas" + 16)
  19. [00000000009FF96F] FireDAC.Comp.Client._ZN7Firedac4Comp6Client16TFDCustomCommand7ExecuteEiib (Line 6871, "FireDAC.Comp.Client.pas" + 4)
  20. [0000000000A09065] FireDAC.Comp.Client._ZN7Firedac4Comp6Client17TFDAdaptedDataSet15DoExecuteSourceEii (Line 10089, "FireDAC.Comp.Client.pas" + 5)
  21. [00000000009B7E21] FireDAC.Comp.DataSet._ZN7Firedac4Comp7Dataset10TFDDataSet7ExecuteEii (Line 3186, "FireDAC.Comp.DataSet.pas" + 9)
  22. [0000000000A0C2A9] FireDAC.Comp.Client._ZN7Firedac4Comp6Client14TFDCustomQuery7ExecSQLEv (Line 11526, "FireDAC.Comp.Client.pas" + 2)
  23. [0000000000F1E076] uThread_Db._ZN10Uthread_db9TDbThread7ExecSqlEN6System13UnicodeStringEPNS1_7TVarRecEi (Line 2778, "uThread_Db.pas" + 11)
  24. [0000000000F1DC3F] uThread_Db._ZN10Uthread_db9TDbThread7ExecSqlEN6System13UnicodeStringE (Line 2704, "uThread_Db.pas" + 1)
  25. [0000000000F173A8] uThread_Db._ZN10Uthread_db9TDbThread14UpdateBatchVarEv (Line 1737, "uThread_Db.pas" + 29)
  26. [0000000000F0DF62] uThread_Db._ZN10Uthread_db9TDbThread5OnRunEv (Line 393, "uThread_Db.pas" + 54)
  27. [00000000007ECB46] uThreadPools._ZN12Uthreadpools11TThreadPool10ThreadProcEv (Line 171, "uThreadPools.pas" + 18)
  28. [00000000007EC6FB] uThreadPools._ZN12Uthreadpools9TMyThread7ExecuteEv (Line 71, "uThreadPools.pas" + 3)
  29. [0000000000531263] System.Classes._ZN6System7Classes10ThreadProcEPNS0_7TThreadE (Line 15686, "System.Classes.pas" + 18)
  30. [0000000000412C2D] System._ZN6System13ThreadWrapperEPv (Line 25373, "System.pas" + 9)
  31. [00007FF982527614] BaseThreadInitThunk
  32. [00007FF9835E26A1] RtlUserThreadStart
复制代码
另外Sql Server中的表截图显示都可以正确连接到Sql Server并更新成功了表

QQ截图20230115202936.png

error_20230115_001.zip

4.09 KB, 下载次数: 0, 下载积分: 金币 -1

回复

使用道具 举报

9963

回帖

2万

金币

1万

积分

积分
16228
发表于 2023-1-16 09:25:49 | 显示全部楼层
执行SQL异常 TDbThread.ExecSql,Sql:MERGE INTO dbo.TBL_VAR A

控制台更新一下数据库
或者工具服里更新数据库
回复

使用道具 举报