启动报错
引擎版本：2022.12.08.0_64位游戏版本：180复古战神
自己搭建了一个本地Sql Server，配置管理器中的更新数据库已经更新成，但是启动M2的时候报错，完整报错在附件，主要报错信息为：
执行SQL异常 TDbThread.ExecSql,Sql:MERGE INTO dbo.TBL_VAR A
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
) B
ON (A.FLD_USERID=B.FLD_USERID AND A.FLD_VAR_NAME=B.FLD_VAR_NAME AND A.FLD_TYPE=B.FLD_TYPE)
WHEN MATCHED THEN
UPDATE SET A.FLD_VAR_VALUE=B.FLD_VAR_VALUE,A.tUpdateTime=B.tUpdateTime
WHEN NOT MATCHED THEN
INSERT(FLD_USERID,FLD_VAR_NAME,FLD_TYPE,FLD_VAR_VALUE,tUpdateTime)
VALUES(B.FLD_USERID,B.FLD_VAR_NAME,B.FLD_TYPE,B.FLD_VAR_VALUE,B.tUpdateTime);Except：对象名 'dbo.TBL_VAR' 无效。 JclDebug._ZN8Jcldebug17TJclStackInfoListC3EbiPvbS1_S1_ (Line 5510, "JclDebug.pas" + 34)
JclDebug._ZN8Jcldebug18JclCreateStackListEbiPvbS0_ (Line 5351, "JclDebug.pas" + 1)
JclDebug._ZN8Jcldebug21DoExceptionStackTraceEPN6System7TObjectEPvbS3_ (Line 5292, "JclDebug.pas" + 20)
JclDebug._ZN8Jcldebug14DoExceptNotifyEPN6System7TObjectEPvbS3_ (Line 6742, "JclDebug.pas" + 7)
JclHookExcept._ZN13Jclhookexcept13TNotifierItem8DoNotifyEPN6System7TObjectEPvbS4_ (Line 272, "JclHookExcept.pas" + 5)
JclHookExcept._ZN13Jclhookexcept14DoExceptNotifyEPN6System7TObjectEPvbS3_ (Line 339, "JclHookExcept.pas" + 13)
JclHookExcept._ZN13Jclhookexcept20HookedRaiseExceptionEjjjPNS_19TExceptionArgumentsE (Line 381, "JclHookExcept.pas" + 14)
System._ZN6System14_RaiseAtExceptEPNS_7TObjectEPv (Line 22049, "System.pas" + 32)
System._ZN6System11_RaiseAgainEv (Line 23128, "System.pas" + 9)
FireDAC.Comp.Client._ZN7Firedac4Comp6Client16TFDCustomCommand15InternalExecuteEiib (Line 6853, "FireDAC.Comp.Client.pas" + 16)
FireDAC.Comp.Client._ZN7Firedac4Comp6Client16TFDCustomCommand7ExecuteEiib (Line 6871, "FireDAC.Comp.Client.pas" + 4)
FireDAC.Comp.Client._ZN7Firedac4Comp6Client17TFDAdaptedDataSet15DoExecuteSourceEii (Line 10089, "FireDAC.Comp.Client.pas" + 5)
FireDAC.Comp.DataSet._ZN7Firedac4Comp7Dataset10TFDDataSet7ExecuteEii (Line 3186, "FireDAC.Comp.DataSet.pas" + 9)
FireDAC.Comp.Client._ZN7Firedac4Comp6Client14TFDCustomQuery7ExecSQLEv (Line 11526, "FireDAC.Comp.Client.pas" + 2)
uThread_Db._ZN10Uthread_db9TDbThread7ExecSqlEN6System13UnicodeStringEPNS1_7TVarRecEi (Line 2778, "uThread_Db.pas" + 11)
uThread_Db._ZN10Uthread_db9TDbThread7ExecSqlEN6System13UnicodeStringE (Line 2704, "uThread_Db.pas" + 1)
uThread_Db._ZN10Uthread_db9TDbThread14UpdateBatchVarEv (Line 1737, "uThread_Db.pas" + 29)
uThread_Db._ZN10Uthread_db9TDbThread5OnRunEv (Line 393, "uThread_Db.pas" + 54)
uThreadPools._ZN12Uthreadpools11TThreadPool10ThreadProcEv (Line 171, "uThreadPools.pas" + 18)
uThreadPools._ZN12Uthreadpools9TMyThread7ExecuteEv (Line 71, "uThreadPools.pas" + 3)
System.Classes._ZN6System7Classes10ThreadProcEPNS0_7TThreadE (Line 15686, "System.Classes.pas" + 18)
System._ZN6System13ThreadWrapperEPv (Line 25373, "System.pas" + 9)
BaseThreadInitThunk
RtlUserThreadStart
另外Sql Server中的表截图显示都可以正确连接到Sql Server并更新成功了表
执行SQL异常 TDbThread.ExecSql,Sql:MERGE INTO dbo.TBL_VAR A
控制台更新一下数据库
或者工具服里更新数据库
页:
[1]