PI noticification datetime issue

Discussion created by gajendra_konnur on Jun 8, 2012
Latest reply on Jun 14, 2012 by Ahmad Fattahi

Hi Team,




I Have configured PI noticification with web service as delivery channel. Web service is having method which takes 4 parameters name ,desc, value and time.


When cdt158>200,it send the event details to web service method which then writes to sql database table having 4 columns:  name, desc ,value and time.




Initially I tested this with 3 parameters name, desc and value. So it was working fine. But later I have added time column ,since then it giving below error:




“The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.


The statement has been terminated.”

















Both are Datetime only. Request you to assist me in the same.