Log Mitsubishi PLC data to MSSQL via Kepserver DataLogger |OPC UA Standard|Forum|OPC Foundation

Avatar
sp_LogInOut Log In
sp_Search Search
Advanced Search
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
Lost password?
sp_Feed sp_PrintTopic sp_TopicIcon
Log Mitsubishi PLC data to MSSQL via Kepserver DataLogger
Avatar
Jakub Zajac
New Member
Members
Forum Posts: 2
Member Since:
04/04/2019
sp_UserOfflineSmall Offline
1
04/04/2019 - 05:43
sp_Permalink sp_Print sp_EditHistory

Hi all,

I would like to logg data from Mitsubishi PLC to MSSQL via OPC Kepware DataLogger plug-in, but I have issues to see values correctly

I simulate Mitsubishi PLC on OPC, I see values on OPC client correctly … but when I logg data to MSSQL db via DataLogger I have issues with data … any of data are displaye as 0, string data as NULL …

What is wrong ? In attached files you can see datatypes on OPC and MSSQL.

Thank you

[Image Can Not Be Found]

Avatar
Randy Armstrong
Admin
Forum Posts: 1579
Member Since:
05/30/2017
sp_UserOfflineSmall Offline
2
04/04/2019 - 06:54
sp_Permalink sp_Print

Who’s product are your using to log the data via MSSQL?

Avatar
Jakub Zajac
New Member
Members
Forum Posts: 2
Member Since:
04/04/2019
sp_UserOfflineSmall Offline
3
04/05/2019 - 00:16
sp_Permalink sp_Print

I´m using KepServerEx 6 and Kepware Datalogger to log data from PLC to MS SQL

Avatar
Randy Armstrong
Admin
Forum Posts: 1579
Member Since:
05/30/2017
sp_UserOfflineSmall Offline
4
04/05/2019 - 07:31
sp_Permalink sp_Print

I recommend that you check logs of KepServerEx – the most likely problem is it can’t connect to the PLC because of a configuration issue (i.e. untrusted certificates) and is reporting default values on scan.

sp_Feed
Go to top
Forum Timezone: America/Phoenix
Most Users Ever Online: 510
Currently Online:
Guest(s) 50
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Forum Stats:
Groups: 2
Forums: 10
Topics: 1445
Posts: 4889