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.