AnsweredAssumed Answered

(10) Data missing is in this list saying requested data missing in FM?

Question asked by mrandyv on Jan 24, 2018

Running this statement  from Automation Engine

 

Select *

from T16s2_esko_cad_start

inner join T16_PROJECTS

on T16s2_esko_cad_start.ID_Project=T16_PROJECTS.ID_Project

where T16s2_esko_cad_start.esko_Task_CAD = 'Pending'

 

getting this error

java.lang.Exception: Scanning DB Upload Point FileMaker_CAD_Task_Specs failed:Select *

from T16s2_esko_cad_start

inner join T16_PROJECTS

on T16s2_esko_cad_start.ID_Project=T16_PROJECTS.ID_Project

where T16s2_esko_cad_start.esko_Task_CAD = 'Pending'

    at com.esko.server.buc.utl.BUC_TDBScanner.Scan(BUC_TDBScanner.java:348)

    at com.esko.server.buc.srv.BUC_TPointHandler.HandleDBPollPoint(BUC_TPointHandler.java:444)

    at com.esko.server.buc.srv.BUC_TPointHandler.Handle(BUC_TPointHandler.java:150)

    at com.esko.server.buc.srv.BUC_TPointHandler.Handle(BUC_TPointHandler.java:128)

    at com.esko.server.buc.srv.BUC_TWorkConsumer$TWorker.ProcessPoint(BUC_TWorkConsumer.java:354)

    at com.esko.server.buc.srv.BUC_TWorkConsumer$TWorker.run(BUC_TWorkConsumer.java:285)

    at java.lang.Thread.run(Unknown Source)

Caused by: com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC]  (10): Data missing

    at com.filemaker.jdbc.FM_API.getColumnDefinitions(Unknown Source)

    at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)

    at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)

    at com.filemaker.jdbc1.CommonJ1Statement.execDirect(Unknown Source)

    at com.filemaker.jdbc1.CommonJ1Statement.executeQuery(Unknown Source)

    at com.filemaker.jdbc1.CommonJ1Statement.executeQuery(Unknown Source)

    at com.esko.server.buc.utl.BUC_TDBScanner.Scan(BUC_TDBScanner.java:146)

    ... 6 more

Outcomes