kd.bos.ksql.exception.ParserException: format sql error. target database is 'Oracle10' detail message is :

ERROR. Token's value : FROM, token's type : Keyword, line 1, column 9

source sql is :

SELECT FROM (SELECT

b.fnumber as "groupstandard_number",

c.fid as "group_id",

a.fmaterialid as "material_id",

a.fstandardid as "groupstandard_id"

FROM t_bd_materialgroupdetail a

LEFT JOIN t_bd_mtgroupstandard b on a.fstandardid = b.fid

LEFT JOIN T_BD_MaterialGroup c on a.fgroupid = c.fid) ISC_VIEW WHERE material_id =?

提示：上述异常由“当前账套(self)”数据源抛出。若需要更详细的日志分析报错，请在连接配置“主数据分发(baseDataKafka)”所对应的系统中获取更多日志。

java.lang.RuntimeException:

at kd.bos.ksql.TransInner.doTransSQL(TransInner.java:126)

at kd.bos.ksql.TransInner.transSQL(TransInner.java:92)

at kd.bos.ksql.TransUtil.translate(TransUtil.java:93)

at kd.bos.ksql.shell.KDConnection.getSql(KDConnection.java:250)

at kd.bos.ksql.shell.KDConnection.prepareStatement(KDConnection.java:284)

at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:316)

at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)

at kd.bos.util.jdbcproxy.ConnectionProxy.prepareStatement(ConnectionProxy.java:210)

at kd.bos.util.jdbcproxy.ConnectionProxy.prepareStatement(ConnectionProxy.java:210)

at kd.bos.trace.instrument.jdbc.ConnectionAOP.prepareStatement(ConnectionAOP.java:124)

at kd.bos.db.tx.DelegateConnection.prepareStatement(DelegateConnection.java:550)

at kd.isc.iscb.platform.core.connector.self.SelfPreparedStatement.<init>(SelfPreparedStatement.java:38)

at kd.isc.iscb.platform.core.connector.self.SelfConnection.prepareStatement(SelfConnection.java:41)

at kd.isc.iscb.util.db.DbUtil.executeQuery2(DbUtil.java:465)

at kd.isc.iscb.util.db.DbUtil.executeQuery(DbUtil.java:492)

at kd.isc.iscb.platform.core.connector.JdbcConnectionWrapper.executeQuery(JdbcConnectionWrapper.java:100)

at kd.isc.iscb.platform.core.dc.e.s.EntryTableDataDecorator.decorate(EntryTableDataDecorator.java:41)

at kd.isc.iscb.platform.core.dc.e.DataCopyInput.decorate(DataCopyInput.java:117)

at kd.isc.iscb.platform.core.dc.e.DataCopyInput.read(DataCopyInput.java:86)

at kd.isc.iscb.platform.core.dc.e.DataCopyRunner.doCopy(DataCopyRunner.java:308)

at kd.isc.iscb.platform.core.dc.e.DataCopyRunner.doMainTask(DataCopyRunner.java:227)

at kd.isc.iscb.platform.core.dc.e.DataCopyRunner.access$300(DataCopyRunner.java:40)

at kd.isc.iscb.platform.core.dc.e.DataCopyRunner$1.run(DataCopyRunner.java:213)

at kd.isc.iscb.util.trace.TraceTask.invoke(TraceTask.java:24)

at kd.isc.iscb.util.trace.TraceManager.run(TraceManager.java:84)

at kd.isc.iscb.platform.core.trace.TraceStack.run(TraceStack.java:155)

at kd.isc.iscb.platform.core.trace.TraceStack.run(TraceStack.java:122)

at kd.isc.iscb.platform.core.dc.e.DataCopyRunner.doCopyWithTrace(DataCopyRunner.java:207)

at kd.isc.iscb.platform.core.dc.e.DataCopyRunner.doCopyWithTrace(DataCopyRunner.java:198)

at kd.isc.iscb.platform.core.dc.e.DataCopyRunner.doJob(DataCopyRunner.java:185)

at kd.isc.iscb.platform.core.dc.e.DataCopyRunner.run(DataCopyRunner.java:175)

at kd.isc.iscb.platform.core.dc.DataCopyThread.execute(DataCopyThread.java:225)

at kd.isc.iscb.platform.core.dc.DataCopyThread.doJob(DataCopyThread.java:139)

at kd.isc.iscb.platform.core.dc.DataCopyThread.doDataCopy(DataCopyThread.java:93)

at kd.isc.iscb.platform.core.dc.DataCopyThread.run(DataCopyThread.java:72)

at kd.isc.iscb.platform.core.dc.DataCopyJob.run(DataCopyJob.java:64)

at kd.isc.iscb.platform.core.job.JobRunner.run(JobRunner.java:75)

at kd.isc.iscb.platform.core.job.JobRunner.innerExecute(JobRunner.java:65)

at kd.isc.iscb.platform.core.job.JobRunner.access$000(JobRunner.java:20)

at kd.isc.iscb.platform.core.job.JobRunner$1.run(JobRunner.java:56)

at kd.isc.iscb.util.trace.TraceTask.invoke(TraceTask.java:24)

at kd.isc.iscb.util.trace.TraceManager.trace(TraceManager.java:24)

at kd.isc.iscb.platform.core.trace.TraceStack.traceJob(TraceStack.java:63)

at kd.isc.iscb.platform.core.job.JobRunner.doJob(JobRunner.java:53)

at kd.isc.iscb.platform.core.job.AbstractJobProxy.run(AbstractJobProxy.java:34)

at kd.isc.iscb.platform.core.task.TaskWorker.innerExecute(TaskWorker.java:148)

at kd.isc.iscb.platform.core.task.TaskWorker.execute(TaskWorker.java:130)

at kd.isc.iscb.platform.core.task.TaskWorker.access$400(TaskWorker.java:23)

at kd.isc.iscb.platform.core.task.TaskWorker$Worker.executeTask(TaskWorker.java:178)

at kd.isc.iscb.platform.core.task.TaskWorker$Worker.run(TaskWorker.java:167)

at kd.bos.threads.impl.ThreadPoolImpl.lambda$execute$0(ThreadPoolImpl.java:60)

at kd.bos.threads.impl.RequestContextRunnable.run(RequestContextRunnable.java:63)

at kd.bos.thread.ThreadLifeCycleManager$RunnableWrap.run(ThreadLifeCycleManager.java:262)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

Caused by: kd.bos.ksql.exception.ParserException: format sql error. target database is 'Oracle10' detail message is :

ERROR. Token's value : FROM, token's type : Keyword, line 1, column 9

source sql is :

SELECT FROM (SELECT

b.fnumber as "groupstandard_number",

c.fid as "group_id",

a.fmaterialid as "material_id",

a.fstandardid as "groupstandard_id"

FROM t_bd_materialgroupdetail a

LEFT JOIN t_bd_mtgroupstandard b on a.fstandardid = b.fid

LEFT JOIN T_BD_MaterialGroup c on a.fgroupid = c.fid) ISC_VIEW WHERE material_id =?

... 56 more

产品问题集成相关问题

500 产品问题 集成相关问题

恭喜您！

产品问题
集成相关问题

500 产品问题集成相关问题