为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8,驱动版本号:DM.DmProvider 8.3.1.28188
【操作系统】:
【CPU】:
【问题描述】*:具体语句如下: Dm.DmException:“第 3 行, 第 75 列[]附近出现错误:
不完整的语法项 [sql]: {
INSERT INTO "Job" ("Id", "InvocationData", "Arguments", "CreatedAt", ExpireAt")
VALUES (:ID, :INVOCATION_DATA, :ARGUMENTS, :CREATED_AT, :EXPIRE_AT)}; [params]: {ID=22} {CREATED_AT=2025/4/15 9:48:50} {EXPIRE_AT=2025/5/15 9:48:50} {INVOCATION_DATA={"Type":"OctopusPrivate.Dispatch.Infrastructure.Configuration.Hangire.SendForUserJob, OctopusPrivate.Dispatch.Infrastructure, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null","Method":"Execute","ParameterTypes":"[]","Arguments":null}} {ARGUMENTS=[]};”
建表语句:
-- Table structure for Job
CREATE TABLE [SchemaName]"Job" (
"Id" INT,
"StateId" INT,
"StateName" VARCHAR(20),
"InvocationData" CLOB,
"Arguments" CLOB,
"CreatedAt" TIMESTAMP,
"ExpireAt" TIMESTAMP
);
ALTER TABLE [SchemaName]"Job" ADD PRIMARY KEY ("Id");
已发现问题 ExpireAt") 左边少了双引号