I am using ms-sql azure where i have created reflection and PDS ,If something changes in Orignal source VirtualData set not previewing /RUN , here is attached screens
I want to know if there is way auto detect changes in VDS if orignal source changed
I am also attaching Query Profileb1a47ca1-8b3c-4a62-9726-915a1bc1f138.zip (48.8 KB)
Hello @Vikash_Singh,
What specifically is changing in the PDS? From the error stack (which can be found in the profile under the “error” tab), it looks like a datetime function is operating on an incorrectly formatted string or numerical type.
(java.lang.IllegalArgumentException) Invalid format: “0.0” is malformed at “.0”
org.joda.time.format.DateTimeFormatter.parseLocalDateTime():900
org.joda.time.LocalDateTime.parse():168
com.dremio.s.ProjectorGen42627.doEval():1405
com.dremio.sabot.op.project.ProjectorTemplate.projectRecords():53
com.dremio.exec.store.CoercionReader.next():225
com.dremio.sabot.op.scan.ScanOperator.outputData():209
If you’re making major schema changes to PDS while retaining the same name for those tables, then you will need to change the downstream VDS definitions to reflect these changes.
Hello Ben ,
Thanks for your Reply, i am not able to understand what this statement says
If you’re making major schema changes to PDS while retaining the same name for those tables, then you will need to change the downstream VDS definitions to reflect these changes.
My current issue is following
here is the list of Eror
3.1) Invalid format: “”
3.2) Invalid format: “24.0” is malformed at “.0”
3.3) Empty String
i am attaching Profile for above 2 continues Error
To Workaround i have delete Old VirtualDataSet and re-create with same name in that case also Reflection is not creating it took too long to create and hangs
so, if i change VDS DataSet name i have to change in BI tools too ,so please guide me the steps i need to follow to make that stable 8d301706-2f27-4827-b2b7-8792d3f9d5e6.zip (42.7 KB)
