3 Replies Latest reply on Mar 15, 2019 1:46 PM by TimCarmichael

    Cannot load data from sql database to PI

    KrystianSobotka

      Hello everyone!!  I cant load data from sql database to PI. I will post some attachments to help u understand whats the problem.

      I used this script in sql database to change format of datetime to  dd-mm-yyyy hh-mm-ss, becasue this is the format thats PI system need.

       

      SELECT TOP (10) [SensorId]

      ,[KeyId]

      ,Replace(convert(Varchar, convert(Datetime, [Date],120),103),'/','-') +' '+ convert(Varchar, convert(Datetime, [Date], 120),108)

      ,REPLACE(convert(varchar, [Value]),'.',',')

       

        FROM [IRP_MonitorPowietrza_test].[dbo].[MeasurementData]

       

      In PI interface Logs i got error: PI timestamp is not of timestamp data type - u can see it on the attachment 5.

       

      What can i do?