Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Repeated timestamps while using WinCC OLEDB Provider of Connectivity Pack

Created by: Seeker at: 9/14/2006 1:49 PM (15 Replies)

Rating (1)

Thanks 0

Result pages:: |; 1 | 2; |

16 Entries

Entries per page: 10 | all

9/14/2006 1:49 PM	Rate (0)
Seeker Posts: 18 Rating: (0)	Hi everyone I posted this problem some 10 days back and got few suggestions like not changing the PC name after SQL Server installation and upgrade to WinCC v6.0 SP4 and others. I tried all of them but no positive results yet. I would be grateful if you people look into this again as it is realkly important Nowthe current status of my WinCC project is this: Actually what i want is to fetch last 6 minutes of data after every 5 minutes from WinCC runtime database and put it into my SQL SERVER database using WinCC OLEDB provider. I am using VB 6.0 for this but getting the problem for last 3 weeks whichg is explained below. When I query to fetch last 6 minutes of data, it fetches sometimes 6 minutes data sometimes 5 minutes data sometimes 4 minutes databut ofsome 8 minutes or 9 minutes back. To elaborate on this, I would be grateful if you just go through quickly with the following observation I had with my project and data retreival strategy. Things were not as desired, hence I deactivated my WinCC, restarted my PC (all dbs detached successfully) at 5:15 pm I reactivated my WinCC at --------------------------------------------------------------5:17 PM Retreived last 6 minutes of data with query mentioned to you before at------------------5:24 PM Result- Data of-------------------------------------------------------------------------5:10 PM to 5:15 PM Instead of------------------------------------------------------------------------------5:19 PM to 5:24 PM Whats more is on next cycle after 5 min, at 5:29 PM, it again gets same-----------------5:10 PM to 5:15 PM and keeps doing so To change this, I decativated my WinCC at-----------------------------------------------5:55 PM Restarted all and Reactivated my winCC at-----------------------------------------------5:58 PM Retreives last 6 minutes of data at-----------------------------------------------------6:10 PM But the result is-----------------------------------------------------------------------5:59 PM to 6:02 PM and this keeps up repeating until I restart all again. The point is it is misbehaving in two ways: 1) Instead of reading last 6 minutes of data, it is reading 6 minutes of data some 8 minutes back consistently. 2) This read only appears at first time after WinCC Project activation and then it keeps on reading the same data read in first cycle until you deactivate the WinCC Project (so the dbs are detached) and then resatrt all. It seems as if its logging is not up to date. First i had the WinCC project with all Tag logging Dbs closed. Somehow I have managed to get the WinCC Project which has its last database open with only the initial timestamp. The Dbs made in Enterprise Manager are in sequence for 10 days that is 24th Aug to 4th Sep. But then this project wasn't activated until 12th Sep. Therefore the next db has 4th Sep its initial and 12th sep its last. Pls help
Seeker Posts: 18 Rating: (0)
Suggestion To thank Quote Answer

9/15/2006 10:58 AM	Rate (0)
Nemo Posts: 3149 Rating: (171)	Hi, could you please attach your WinCC log files here? Are you using TimeSynchronization in WinCC, PC and S7?? Are you using a lot of C-Scripts in your WinCC project? nemo
Nemo Posts: 3149 Rating: (171)
Suggestion To thank Quote Answer

9/20/2006 11:51 AM	Rate (0)
Seeker Posts: 18 Rating: (0)	Really sorry for a delayed reply Nemo but can you tell me which log files you are talking about and where i can find them I am really sory once again but i am a newbie thanks
Seeker Posts: 18 Rating: (0)
Suggestion To thank Quote Answer

9/20/2006 1:56 PM	Rate (0)
Danielle Posts: 1275 Rating: (123)	Hi! The log files are in the C:\Program Files\Siemens\WinCC\Diagnose folder, as a default.
Danielle Posts: 1275 Rating: (123)
Suggestion To thank Quote Answer

9/27/2006 4:49 AM	Rate (0)
Seeker Posts: 18 Rating: (0)	Sorry for delayed response My 4 WinCC log files are attached in zip folder. Note that the behaviour of the project i mentioned in my first post in a bit inconsistent. Sometimes it goes 3 days back and some times 8 min back data in an attempt to fetch last 6 min of data. Sometimes it works well for the first cycle query and then starts misbehaving. One thing it is consistent about is that it keeps on giving the values of first cycle again and again until WinCC is restarted again. I am not using Time synchronization and not using any C Scripts Attachment WincCC Log files.zip (430 Downloads)
Seeker Posts: 18 Rating: (0)
Suggestion To thank Quote Answer

9/27/2006 12:54 PM	Rate (1)
Reuben Posts: 70 Rating: (13)	Hi I had a client asking me the same question about the OLE-DB providernot producing the correct data. I fiddled withit for a few hours, and I coudn'tget it to work at all. Maybe that was a beta release, but I didn't like the non-standard query structure it used so I never tried it again. I have a current release now, so can you post the actual SQL query you are using to fetch the data? I'll give it a test on my system. PS: I wouldn't be surprised if the WinCC tag logging system is caching the latest batch of data in memory, before compressing it and stuffing it into the database (ie: that data may not be available via the OLE-DB provider - we'll have to read the documentation) If you use a compressed archive you have to use the OLE-DB provider to unpack the data. I wrote a program to extract WinCC V5 archive data directly from the database, maybe this will work in V6 with uncompressed archives -I'll have to check into that. PPS: Your problem highlights the absurdity of storing WinCC archives in the MS SQL database in a proprietary compressed format. The data is already in an SQL database but you have to copy it to another SQL database because the only way to get it is using the OLE-DB provider (which you must pay extra for). It does not use a standard "SELECT" query format, and hence is incompatible with anything. Sorry for the tirade - maybe the development team is reading this and working on something new!
Reuben Posts: 70 Rating: (13)	Last edited by: Reuben at: 9/27/2006 1:06 PM
Suggestion To thank Quote Answer

9/28/2006 4:58 AM	Rate (0)
Seeker Posts: 18 Rating: (0)	Thanks for a detailed reply The query i am using to fetch last 6 minutes of data after every 5 minutes is: sSql = "TAG:R,tagid,'0000-00-00 00:06:00.000','0000-00-00 00:00:00.000'" That is using Relative time I loop this query 126 times in VB 6 since there are 126 tags in my project. I alsotried Absolute time but it doesn't work well. The query sometimes work well fior the first time but then it either repeats the same data or give the data in back dates. What ever it gives, it keeps on repeating that thanks and regards
Seeker Posts: 18 Rating: (0)
Suggestion To thank Quote Answer

9/28/2006 11:05 AM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Your log file contains lots of errors like : "ArchiveManager,Database ArchiveManager\TagLoggingSlow\KIII_Dhabeji WInCC_TLG_S_200609031901_200609041901.mdf does not exist!" and : "TLGRT,Error archiving at least one tag - tagname: ProcessValueArchive\MV_MF4_kVAr_R" It sounds like your database files may be corrupt / missing / something ! If possible I would delete all runtime data (http://support.automation.siemens.com/WW/view/en/17853608). I would also recommend you look at the above tag and see why it cannot be archived. It could be that the configuration database is messed up to !!? If so then you can use the Excel Configuration Tool to export the database into a new project to recover from the corruption (only do this as a last resort as it is a little fiddly). Key thing is, you have a problem querying your tag logging data and your log files show errors with the tag logging data. Clear the errors and the querying problem should disappear too.

Suggestion To thank Quote Answer

9/28/2006 2:01 PM	Rate (0)
Reuben Posts: 70 Rating: (13)	Hi "TLGRT,Error archiving at least one tag - tagname: ProcessValueArchive\MV_MF4_kVAr_R" I think thisis probably because that one tag was deleted from the tag list after being added to tag logging. "ArchiveManager,Database ArchiveManager\TagLoggingSlow\KIII_Dhabeji WInCC_TLG_S_200609031901_200609041901.mdf does not exist!" This error is probably because the tag logging archives (the "ArchiveManager" folder in the WinCC project) were manually deleted. WinCC usually recreates the archives after adding this message to the diagnose log. If I look at the timestamps in the log files this error did not occur the next time WinCC was restarted, so it probably is not a problem.
Reuben Posts: 70 Rating: (13)
Suggestion To thank Quote Answer

9/28/2006 2:39 PM	Rate (0)
Reuben Posts: 70 Rating: (13)	Ok, here are the versions that I have tested: WinCC V6.0 SP4 + Hotfix 2 WinCC Connectivity Pack V6.1 SP1 I have used the VB test application that you can install off the CD in the samples directory. Using this application i use the following query: *TAG:R,<ArchiveTagID>,'0000-00-00 00:00:15','0000-00-00 00:00:00'* This is fetching the last 15 seconds from a tag that is being logged at 500ms intervals from a S7-314 PLC via TCP/IP. I have tested it with tags that are changing, tags that remain constant zero, and tags with 0.0%hysteresis. I'll leave it running for a while, but so far it seems correct - it is always returning the latest timestamps, except that the timestamps are in GMT and not local time. Oh-oh! I get errors in the following conditions: Trying to fetch data for a tag with 0.0% hysteresis that is not changing. The value has not changed yet, so there is nothing logged. It does not return nothing, it returns an error: *Error in : TAG:R,<ArchiveTagID>,'0000-00-00 00:00:15','0000-00-00 00:00:00' The parameter is incorrect.* Do you have hysteresis on your tags? Maybe if your data has not changed in the last six minutes it returns unpredictable results.
Reuben Posts: 70 Rating: (13)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on