Dataconnect: The specified datatype for objective field is invalid

[drichter]

Hi,

I connect ThingWorx with Analytics via DataConnect (just like in this blog post How to use DataConnect when sending property values from the ThingWorx platform to ThingWorx Analytics.)

If I click in the last step on "Execute" it shows me "Status: Failed" in the upper right corner. In the logfiles of the DataConnect it shows me this rows:

2017-08-25T11:28:56.245Z [WARN] [http-bio-8085-exec-6] [com.coldlight.dataconnect.rest.util.ValidateSubmitJobRequest] - [Invalid request: The specified datatype for objective field is invalid. Accepted values are BOOLEAN or CONTINUOUS for standard data and CONTINUOUS timeseries data]

2017-08-25T11:28:56.254Z [ERROR] [http-bio-8085-exec-6] [com.coldlight.dataconnect.rest.transformer.TransformerController] - [4f9c7cca-0669-48bf-afb0-2047bdbd6bf1 Unexpected Error. com.coldlight.dataconnect.rest.exception.InvalidRequestException: The specified datatype for objective field is invalid. Accepted values are BOOLEAN or CONTINUOUS for standard data and CONTINUOUS timeseries data]

Which mean the field which i select to be the goal is not an BOOLEAN or a CONTINUOUS. But it is a BOOLEAN (see attchment)

What is wrong?

[drichter]

So I change the field "Error" to NUMBER and now I get an other error:

2017-08-25T13:37:38.452Z [INFO] [dataconnect_proc-1] [com.coldlight.dataconnect.worker.job.JobExecutor] - [Processing job 22 with dataset AnalyticsTesterDataAnalysisDefinition2 in executor executor_1]

2017-08-25T13:37:38.452Z [DEBUG] [dataconnect_proc-1] [com.coldlight.dataconnect.worker.job.JobExecutor] - [Mark job: AnalyticsTesterDataAnalysisDefinition2 as activated.]

2017-08-25T13:37:38.452Z [DEBUG] [dataconnect_proc-1] [com.coldlight.dataconnect.worker.job.JobExecutor] - [update job :AnalyticsTesterDataAnalysisDefinition2 status to dataconnect running.]

2017-08-25T13:37:38.525Z [DEBUG] [dataconnect_proc-1] [com.coldlight.dataconnect.worker.job.JobExecutor] - [job: AnalyticsTesterDataAnalysisDefinition2 is executing...]

2017-08-25T13:37:38.531Z [ERROR] [dataconnect_proc-1] [com.coldlight.dataconnect.worker.job.JobExecutor] - [[49aa7111-76fb-4a38-84d3-a880f2682dc8] Error with job [22]: java.io.IOException: File Not Found: file:///repository/SystemRepository/AnalyticsTesterDataAnalysisDefinition2/AnalyticsTesterDataAnalysisDefinition21503591167010.zip]

2017-08-25T13:37:38.534Z [INFO] [dataconnect_proc-1] [com.coldlight.dataconnect.worker.job.JobExecutor] - [Deleting dataset AnalyticsTesterDataAnalysisDefinition2 for job 22]

2017-08-25T13:37:38.585Z [DEBUG] [dataconnect_proc-1] [com.coldlight.dataconnect.worker.job.JobExecutor] - [Mark job: AnalyticsTesterDataAnalysisDefinition2 as inactivated.]

The zip-file existis on this location but maybe the dataconnect can not find it.

[drichter]

Ok the error has something todo with ne rights on the linux system. Now the file problem is fixed. The first problem (Error on BOOLEAN goal) still exists.

[cmorfin]

Hello David

If this is still an issue for you , could you please:

1) reproduce the error "Unexpected Error. com.coldlight.dataconnect.rest.exception.InvalidRequestException: The specified datatype for objective field is invalid. Accepted values are BOOLEAN or CONTINUOUS for standard data and CONTINUOUS timeseries data]"

in order to make sure we look at fresh data

2) collect the following data:

- /opt/dataconnect/logs directory

- /repository/SystemRepository/<DADName> directory

Thank you

Kind rgeards

Christophe