gajendra_konnur

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.”

 

 

 

 

 

8103.pino.jpg

 

 

 

 

 

 

 

 

 

 

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

 

 

Outcomes