注册

在连接数据库时一直报错,提示无效表或视图名[SYS_TIMER]

天天开心 2023/05/30 776 2 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:LInux
【CPU】:
【问题描述】*:
在我所迁移的数据库中都没有[SYS_TIMER]这个表或者是试图,在启动连接的时候,一直提示

Sql:

SELECT "ISDELETED","JOBNAME","DOONCE","STARTNOW","EXECUTETYPE","INTERVAL","CRON","TIMERTYPE","REQUESTURL","REQUESTPARAMETERS","HEADERS","REQUESTTYPE","REMARK","CREATEDTIME","UPDATEDTIME","CREATEDUSERID","CREATEDUSERNAME","UPDATEDUSERID","UPDATEDUSERNAME","ID" FROM "SYS_TIMER" WHERE ( "STARTNOW"=1 ) AND ( "ISDELETED" = N'False' )
Unhandled exception. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
---> Dm.DmException (0x80004005): 第1 行附近出现错误:
无效的表或视图名[SYS_TIMER]
at SqlSugar.AdoProvider.GetDataReader(String sql, SugarParameter[] parameters)
at SqlSugar.QueryableProvider1.GetData[TResult](KeyValuePair2 sqlObj)
at SqlSugar.QueryableProvider1._ToListTResult at SqlSugar.QueryableProvider1.ToList()
at Magic.Core.Service.SysTimerService.StartTimerJob() in D:\git\QD-School-WebCore\backend\Magic.Core\Service\Timer\SysTimerService.cs:line 284
at Magic.Web.Core.Startup.ConfigureServices(IServiceCollection services) in D:\git\QD-School-WebCore\backend\Magic.Web.Core\Startup.cs:line 98
--- End of inner exception stack trace ---

回答 0
暂无回答
扫一扫
联系客服