Trend Recording Error 30402 occurred

AlexRoss
2020-06-02
2020-10-10
  • AlexRoss

    AlexRoss - 2020-06-02

    Hello Codesys Users,

    I'm using Codesys 3.5.13.0 and remotely connected via 3G modem EPEC 6107 display. Trend configuration consists of 5 different data recording setups with implemented TENDAPI fuctionality from Codesys Store.
    One of them is now showing Error 30402 occurred, and timestamps are became from 01-01-2014

    I found different topics on similar problems in German:

    https://forge.codesys.com/forge/talk/Deutsch/thread/87cd99b9fc/?limit=25#390d

    https://forge.codesys.com/forge/talk/Deutsch/thread/386385cbda/

    Also I have access to the sqlite-journal file, don't know if it is possible to read something from it.

    Device is using only internal memory without any SD cards.

    Any information on this issue will be appreciated!

     
  • m.prestel

    m.prestel - 2020-06-04

    Hello @AlexRoss,
    could you please provide the full error message?
    Error Code 30402 normally comes with additional information.

    Best regards,
    Marcel

     
    • AlexRoss

      AlexRoss - 2020-06-04

      Hi,

      Can you help where I can look at the additional information?
      I have this additional file only.

      Thanks in advance!

       
  • m.prestel

    m.prestel - 2020-06-04

    Please check the device log.

     
    • AlexRoss

      AlexRoss - 2020-06-04

      Ok. Thank you for the advice. At this moment it is not possible, but I have a test HMI with the same project. I will check the log when it will occur and share it here.

       
  • AlexRoss

    AlexRoss - 2020-06-04

    Some extra information about the issue I have:
    I've deleted the file mentioned above and the trend database is alive again, see the pictures below.

     
  • m.prestel

    m.prestel - 2020-06-04

    Could you maybe update to CompilerVersion 3.5.13.12 or higher?
    Maybe this solves the issue!

    Best regards,
    Marcel

     
  • januar

    januar - 2020-08-04

    It is also possible that the file becomes too big. It should not exceed 2 Gb.

     
  • pruwetbe

    pruwetbe - 2020-08-31

    Hello,

    I am new here.

    I try to find what are the limits of the Trend tool when running codesys on a rpi 3B but could not find anything up to now.

    Where does this 2Gb limit come from?

    Thanks In advance

    Pierre

     
  • januar

    januar - 2020-09-02

    Hi Pierre,

    On the trend configuration at the bottom you have trend storage button.
    So Trend Recording Manager, choose the trend you want to configure and at the bottom you have trend storage button.

    Januar

     
  • pruwetbe

    pruwetbe - 2020-09-28

    Hello,
    I continue investigating on this subject and configured my first trend yesterday .
    I am just a bit surprised of the share between the storage configuration and the visu configuration.
    In fact they are completely dependent of each other and for changing some pure visu properties, you have to do it from the storage config and then you need a complete download of the software in the target...just because you want to change the color or pen style of a curve... this is not a good news for me...
    Another bad news for me is that each time a pen is used in a trend picture, I need to log it in the related storage so I will save the same data plenty of time on my SD to be able to see it on different trends frame ?

    My idea would be to create one trend storage with all the signals I need and then select for each trend visu which signal I want to view but I did not find how to proceed on this up to now.

    Any help idea are welcome .

     
    • Morberis

      Morberis - 2020-10-06

      How about using the cartesian XY chart? Here is an example project.

      You could use the datalog manager to save a CSV file. Then you could use something like the CSV utility in the IIOT libraries to open it and write the data to the variables for the XY chart.

      If you don't get a better answer here it might be worth paying for a support ticket to see if there is an easier way or to get assistance on reading the csv data to the xy chart. That could maybe be a bit of a job.

      It would definately be easier to have several trends that you switch between displaying. But if as you say you're repeating the storage of the same variable many times and that variable will be making many entries it will wear the storage down unnecessarily. Maybe there is a better way to do what you want than either of those options.

      Edit: The CSV parser FB's from the Oscat Netlib library might work for you.

      I don't know but it might be easier to do all this outside the PLC. But if you do find a good way of graphing an arbitrary and changing list of variables from a log please post about it.

      Edit 2: Maybe something like Cross Control has the functionality you're looking for.

       

      Last edit: Morberis 2020-10-06
      • januar

        januar - 2020-10-07

        Hi,

        Thank you for the suggestion. We will take a look and try it.

        Kind regards,

        Januar

         
  • pruwetbe

    pruwetbe - 2020-10-07

    Hello Januar and Morberis,
    I think my approach regarding the trends is probably biased by the tools I use to work with I’m my main activity.
    I checked this evening what could be the limit of noner of variable on the trend storage but could not find any info in the help file on this.
    I tried adding variable but there is no limit in the editor of trend storage... the limit comes when you compile and get a message that you are over the limit ... what a pity ... the max is probably 10..
    Ah the limit can be adjusted in the recording parameter with the sampling time
    But changing the limit need a cold download ( because DP the size of SQLite file change.,,)

    I found a easy roundabout....To avoid saving same signal in multiple trend storage :
    if I want to see one signal like the outside temperature or average temperature inside in multiple trends for analysis in correlation with other signal, I just need to combine two trend visu elementS in one visualisation screen that share the same time and date selector object...
    Il willl check if this is possible
    Edit;
    But this is not working properly ...
    So I have to use separate object but link them together...differently...

    I also saw a possibility to hide some curve..
    An easy interface I have seen in many graphing tools in python world is that clicking on the legend toggle the visibility of the curve in the graph ...
    this seems not the case here...
    More investigation needed

     
    • Morberis

      Morberis - 2020-10-07

      It might be worth it for you to pay for a support ticket. Get some better answers and help.

      Edit: Forgot to mention. Look at the Variable settings tab when configuring the Display settings for the trend. You can change the visibility of variables during runtime with it. You'll need to make your own control buttons for that. I'm sorry I should have thought of this first.

       

      Last edit: Morberis 2020-10-07
  • pruwetbe

    pruwetbe - 2020-10-08

    Thanks,
    I had seen this possibility and was wondering If there was some ready made function for this inside the legend object for example ...
    I will need to create some button for this in the visu .
    The best should be to have a transparent rectangle put on top of the curve legend that would activate the related curve of the legend.
    Generally speaking I find the Codesys heavy. Each time I want to configure a field in a pop up I need to browse again and again to go to exact same place... there must be some tricks to save time ... I willl try the drag and drop from a browser window.
    I am thinking to create a frame including trend, legend, visibility trigger and accessories and instantiate the frame....
    For now a support ticket is an option I keep for future...
    I still have time to explore and need more time to learn the capacity of existing tools.
    Thanks for all your idea

     
    • Morberis

      Morberis - 2020-10-09

      One thing that can really help is the shortcuts. What can really help is having a dedicated macro-pad that executes those shortcuts at the press of a key and maybe has an appropriate image.

      You can take an old or cheap usb numpad and convert it into a macropad as well.

      You might want to take a look at some of the settings for the software itself. Like do you want the input assistant window to open all the time, do you want new networks to come pre-populated with an empty coil and contact etc.

      Those are the tips I have.

       
  • pruwetbe

    pruwetbe - 2020-10-10

    I have checked the visibility monitoring of a curve this morning
    It is working properly except that when a pen is invisible, it’s legend is not greyed but deleted So it is imposdible to associate a visu element that will toggle the visibility And associate it graphically to the legend.
    So the only way I see is to use check box in a separate pop up and link the text manually by encoding the same text as the text as the tooltip text defined for the pen in trend config...
    So, impossible to define a trend template with visibility function include.
    All the trends visualisation need to be done manually, what a pity...
    I will rather use data logging and plot curve with python script on my computer and limit trend uses for now.
    Perhaps later when I have some good Trace python script I can run them on the RPi rather than on my computer.

     

Log in to post a comment.