Search the Community

Showing results for tags 'size of database'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Found 26 results

  1. Can anyone help me find where is recipe plus or recipe manager in View desginer(studio 5000) software. i want to create an recipe but i am unable to find a recipe manager .
  2. I have a 1747-L30B SLC Brick and it is set to load from EEPROM on boot S:5/8, Error S:1/10, and Run S:1/12. I need to make changes to the program and then store it to EEPROM via "Comms>EEPROM>Store to EEPROM."  When I attempt to store the program with changes, it displays the message "Insufficient Memory Module Size." I assumed the EEPROM memory was maxed out, but I also uploaded the existing program currently stored to EEPROM, made no changes, and attempted storing it back to EEPROM and received the same message. Any advice?
  3. I would like to get some feedback or alternate suggestions in terms of monitoring a database connection. The attachment here shows the current programming for the DB_Connect function block which requires the Execute input to constantly be ON.  From what I can tell, if the connection is dropped - let's just say the Ethernet cable is unplugged - this input will still be on, and according to the function block, still connected. The Get1minClk is in place to continuously try establish this connection once powered on, but I cannot find any way to periodically check this connection without dropping it and reestablishing it.  My understanding is the _DBC_Status.Run only checks that the PLC service is running properly, but is there a way to monitor a heartbeat of the connection TO the database?  The only way I've found thus far is to drop the connection and reconnect.  But this would be detrimental to the system as it would possibly be reconnecting to the database while trying to write to out to it and hold up the show.  As it stands in the second image, the Ethernet cable is unplugged, but the connection shows no errors. Thanks and happy Friday! -K  
  4. Hello I choose a 5kw AC Motor , But I do not know how to select a right cable or wire for it?? Thank you
  5. Hey guys,   I am looking to query a database through FactoryTalk SE.  I will be scanning packages, and using that bar code to find a lane assignment from the database.     My question has to do with where the VB script will reside in the FactoryTalke SE program.  I want this script to run at all times.  I see that each screen has a "VBA Code" but I am assuming that these will only run when the screen is visible.   Where does this have to be stored in order to run all the time?   Thanks In Advance!
  6. Hi friends, The scene is like this... I have some 200 energy meters whose readings are continuously logged at 15-min intervals into a logging table. The meter does not have any other value logged. Let's consider these readings as analog tags. However these tag values are continuously increasing to ever larger numbers. Thus we have a problem for display on trends. Customer now requires that the Citect shows usage trends for any meter for a specified period of the past. That is to say, the meter that he wishes to observe is selected - along with a period typically between 2 dates (perhaps also with a sampling period) - and the trend must appear. So in other words, given a single trend object, how do you make values appear for any selected tag on this trend. Perhaps this can be overcome by some genie/super-genie mechanism. My approach to this is...For the selected meter, I use SQL to query the 15 minute logged values (also taking into account the required sampling period) taking the reading on starting date as initial. All values thereafter are subtracted -within the SQL query- and the result of this query is kept in a 2 dimensional array(x for time, Y for value) or a new database table so that the trend displays values starting with zero. This much I can do with Cicode. After this, I need a method to display the values so obtained in a trend object. Essentially this is the same as feeding a trend object with a set of X & Y values that I have in the form of an array or in a database table. I shall greatly appreciate any help to meet the above objective. Thanks for looking in. With best wishes.
  7. Hi, guys.I am struggling to develop a solution for a costumer in a Historical Alarm Viewer screen, I am new to Cimplicity and to database supervisory interface. Among other things, the customer is asking to:- Change the "A"; "R"; "G"; "N" notations under "log_action" column to somenthing more intuitive for the users (operation). Please have a look at the image "image.jpg";-Change the point manager process "MASTER_PTMR0_RP" log under "logged_by" column to the user that is currently logged in. Specificaly saying, when I send a command (changing a setpoint or issue a reset command, for example), although it is the user acting, the historical alarm viewer logs the action as "MASTER_PTMR_RP". I Imagine that is because this process is reponsable for exchange point data to/from the IHM points database, but it is still essential to the system administrator to know which user sent that reset command or changed the variable setpoint.The log inputs at the image "image.jpg" has boolean and integer commands (".CXX" sufix);-Log into the historical alarm viewer if the user logs out and what user logged in.It is valid to mention that I am using the ALARM_LOG table (apparently it is the only table working with the application, DATA_LOG, EM_LOG and the others simply do not work, they don't show any column at all, honestly I don't know why).I tried to use Microsoft SQL Server Management Studio to edit the table information, but, somehow, it seems to be blocked to edition.I imagine they are some specific configurations, but I have no idea on how to acomplish them. Maybe if I could use other tables would fulfill the requirements, but , like I said, they are not working (right now I am trying to re-configure the Database Logger from the beggingin to see if it works with other tables).If you could give me some inisights on how to change these settings I would be very grateful. I will be happy to give more information if needed.Thanks in advance.
  8. I am having a problem getting citect to write to my sql database.  Whilst it will write I am restricted by the length of a single cicode command. I think its 255 characters. For my problem I am trying to write 48 tags to the database in one write command to obtain 1 time stamp. Is it possible to write multiple times to the same tables row ? Currently when I write a new row is created at the given timestamp. the cicode is attached. A solution would be to do 4 writes of 12 tags at a time but all would need to go in the same MSSQL table row. I'm ok using the data instead of time and date as this write only happens once each day Any help would be awesome..   *********************************************************************************************************************************** /* **    FILE:        SpurLoad.CI ** * Load Tags from Citect in TO temp array */ STRING tagname[24]="M340_PwrCtrl_SLD0000","M340_PwrCtrl_SLD0030","M340_PwrCtrl_SLD0100","M340_PwrCtrl_SLD0130","M340_PwrCtrl_SLD0200","M340_PwrCtrl_SLD0230","M340_PwrCtrl_SLD0300","M340_PwrCtrl_SLD0330","M340_PwrCtrl_SLD0400","M340_PwrCtrl_SLD0430","M340_PwrCtrl_SLD0500","M340_PwrCtrl_SLD0530","M340_PwrCtrl_SLD0600","M340_PwrCtrl_SLD0630","M340_PwrCtrl_SLD0700","M340_PwrCtrl_SLD0730","M340_PwrCtrl_SLD0800","M340_PwrCtrl_SLD0830","M340_PwrCtrl_SLD0900","M340_PwrCtrl_SLD0930","M340_PwrCtrl_SLD1000","M340_PwrCtrl_SLD1030","M340_PwrCtrl_SLD1100"; /* add array TO hold values */ STRING tagval[24]; INT hSQL; FUNCTION SQL_INSERT_lds() /* Loop FOR number of tags (13 lots of 30 min) TO be read adding to array Variables */ INT i;     FOR i = 0 TO 21 DO              tagval = TagRead(tagname);              END      /* Open ODBC connection TO CitectDB configured in ODBC Manager with DSN_SQL */          hSQL = SQLConnect("DSN=DSN_SQL"); /* IF connection IS OK, insert in TO table "lds" the values */ IF hSQL <> -1 THEN     SQLExec(hSQL, "INSERT INTO lds (dateandtime,S0000,S0030,S0100,S0130,S0200,S0230,S0300,S0330,S0400,S0430,S0500,S0530,S0600,S0630,S0700,S0730,S0800,S0830,S0900,S0930,S1000,S1030) VALUES (SYSDATETIME(),'"+tagval[0]+"','"+tagval[1]+"','"+tagval[2]+"','"+tagval[3]+"','"+tagval[4]+"','"+tagval[5]+"','"+tagval[6]+"','"+tagval[7]+"','"+tagval[8]+"','"+tagval[9]+"','"+tagval[10]+"','"+tagval [11]+"','"+tagval[12]+"','"+tagval[13]+"','"+tagval[14]+"','"+tagval[15]+"','"+tagval[16]+"','"+tagval[17]+"','"+tagval[18]+"','"+tagval[19]+"','"+tagval[20]+"','"+tagval[21]+"')");     SQLEnd(hSQL);     SleepMS(100); SQLDisconnect(hSQL); ELSE     Message("Error Message","SQL TRADING DAY DATABASE WRITE FAIL",48); END END   SpurLoad.ci
  9. I'm attempting to make a backup of a program, complete with comments. I go connect to the PLC over Ethernet, and select Use Upload File to merge the comments from an original copy of the program. After that, I go file-saveas to backup the program. However the new saved file, complete with comments is only 134 KB, and the very original copy of the program is 230 KB, from 2003. Is there a reason for this, the program hasn't shrunk in size, only minor tweaking of some span calibration numbers.
  10. Hey, I recently started trying my hand at creating function blocks. At the moment I'm trying to create a PID function block, however I keep getting this error: "ERROR: Variable does not have enough size." No idea why it does this. Can anyone help?  
  11. In the machine is array with size 100 (ARRAY [1..100]]. Can I simply change it to 200 without data loss?
  12. Exceed maximum step size

    Hi guys!   Need some help from the real specialists!   I`am used to work normally with Scheider Unity and make my program`s always in function blocks. Now working on my first GXworks2 project, and programmed the whole project also in FBD.   I have an FX2N-32MR plc, and defined in the configuration the maximum step size of the cpu to 8000 steps. I have compiled my program successfully, but the result gives an program size of 10217 steps. (and i`m not finished programming yet)   Converting the program to ladder or ST is not possible i think....?  (and i`am not very familiar with those languages) Add additional memory card is also not possible because of the type installation. Did have some self-made function blocks inside, but they are very simple.     How is counting of steps working in GXworks2? Are the 8000 steps for the complete project, or per POU, so than split into pou,s will reduce steps??  Strange is when i add one single BIT move block into the program, and compile again. Program size becomes 10229.  (so the one move block is 12 steps?)   Are there any tips for reducing the memory/program  load?     
  13. Hello, I am having an issue with FIX Dynamics Real Time Database and the database columns available within when trying to query the database. On a system running iFIX 5.0, there are 19 data columns available, LHS of attached screenshot (in the screenshot example, crystal reports is used to view the columns). However in iFIX 5.9, only 15 columns are available (RHS of attached screenshot ), how can these missing columns be made available to be accessed? Regards, John
  14. Hi All, I am pretty new at electrical design for PLC control panels. We are a UL508A shop, so this is the code I refer to most. Something struck me as odd when I was trying to size wire for this control panel. UL508A 28.3.1 says this: The required size of the field wiring terminal shall not be less than 14 AWG (2.1 mm2) and shall be determined by: a) Calculating the required ampacity per 28.3.2 – 28.3.6; and b) Determining the minimum field wiring conductor size from Table 28.1 having a corresponding ampacity that is equal to or greater than the required ampacity from (a). How can the minimum wire size be #14 AWG? We use #16 AWG for wire to the PLC modules? Are we breaking code or is there something I am missing? Also, understanding code books can be difficult. Is there a website or place I can go to get a plain English translation? I feel like I will read a sentence over and over again to try to understand what they are saying, and feel like there's is a much easier way to say it than the way it is written. For example, "28.3.1 b" ……...what is it really saying?  
  15. Good day, I would like to extract the FT View SE Alarm Log. We currently have got a Excel spreadsheet set up with a connection to the FTAE SQL Database.  When I refresh the data, Excel give an error telling me that the data is more than what can be displayed in a spreadsheet. So it then discards the latest data. I have tried setting a database limit in the Factory Talk Administration console to only keep the last 60 days worth of data but it does not seem to take effect. I get data from January 2017 up to 15 October 2018. Is there a way to configure the ODBC connection in excel to only give me the data for the last 30 days or is there someone that can help me to limit the size of the database? I have attached the current connection config.
  16. Anyone with knowledge of a VBA Run-time error '4205'  Can't find the project database! VBA stops at gTagDb.GetTag  Here are some things I already tried.  Cleared the CACHE files in the project.  Deleted .CAC file in TAG folder,  Removed Watcom SQL 4.0 from ODBC User DSN.  Uninstall and Re-install RSView32 Works 7.50 and then upgraded to 7.60.  
  17. Hey guys,   I have worked on the FTView ME platform many of times.  I am now working on a FTView SE (Local Station) application, and I am having trouble connecting an Offline .ACD file to my program so that I can design.   If someone could help me with this it would be greatly appreciated.   Thanks in advance!
  18. I want to create a database that keeps track of all of the different PLC and automation hardware (Remote I/O, Flex I/O, Robots, etc.). It would include data such as firmware version, when the backup battery was last replaced, location, etc. I have started doing this in MS Access but I was curious if anyone knew of an existing software that already does something similar?
  19. Good morning everyone!   I tried to open an older project with Factory Talk View ME which was last opened with “FactoryTalk View Studio 5.0 “. The current version that I have installed and licensed is Release Number 9.00.00 (CPR 9 SR 9), Patch/Pack Number: 00, Build Number 241. Upon opening the project, I receive the following error message:   “The target HMI project is a legacy project (Factory Talk View v6.00 or earlier). Please use the legacy Tag Database utility to convert its tag database to the new format (Factory Talk View v6.10 or later) before opening the HMI project on a computer running on a 64-bit operating system. Refer to Help for guidance.”   I tried to use the Legacy Tag Database Conversion tool, selected “Create Factory Talk View Tag Database in new format”, then I selected “Factory Talk view Machine Edition”, selected the source folder and used the option to “Search Sub-folders”. After hitting the Next button it shows a list of available projects, but the one project that I try to convert is not listed.   Any ideas how to approach this? Is it possible to install multiple revision supports with Factory Talk View? So, far I always used the latest and just created the run time as an older version, if the panel I used wasn’t updated.   Please let me know what you guys think I should try.
  20. I am using FactoryTalk View Studio SE 8.20 to develop SCADA Application, and whenever I tried to open Tag Database it shows error "an error occurred while attempting to open the tag database editor" and not able to Open Tag database. Does anyone know solution for this? Error Screenshot Attached
  21. Hi, this is my problem, I created an app on FT Administration Console, in fact, one for network and one for local, I changed the connection to local on Log On FT, but, when I try to define the data points on Step 3 of configuration checklist, only shows me the network app, i select the app, after click OK, the FTTM freezes, anything else happens, I don´t know what am I doing wrong.  
  22. Hello everyone, I hope you are all doing very great, I'm new to Schneider PLCs and I have a project that I need to work on, so I will need your help with the following issues: *) How can one determine which Schneider PLC series is used if you only have a fuzzy picture of the PLC ?  *) I need to setup a historic of alarms, I have 13 PLCs, no connexion between them... I was thinking about creating a connexion between those PLCs and a database, so I need your help to determine a list of ALL the materials i will need (from cables to servers to a computer if necessary...) and some documentation on how that can be done... Thank you so much for helping me, Best regards
  23. Here is a recent post that I would like to share. Using Visual Basic 2015 we will log three holding registers from the PLC along with time and date into a Microsoft Access Database. We will log every minute into the database with the information that we collect from the PLC via Modbus TCP (Ethernet). All code will be done and shown so you can implement this in your application with different parameters. The information collected in the database can then be distributed or analyzed in the future. Visual Basic 2015 will be used with the EasyModbusTCP client/server library for .net. We will communicate to an Automation Direct – Do-More PLC. Using the free simulation software of the PLC Designer Software, we will retrieve three values of the Modbus Holding Registers using Modbus TCP. Once we have this information out of the programmable logic controller it will be placed in a Microsoft Access (2010) Database. This will be done by using a SQL command to insert the data. Read the rest of the post... Let me know what you think, Thank you Garry http://accautomation.ca/
  24. During run time on my KTP700 BASIC HMI panel, there is a keyboard pop-up screen that appears, when I press on an input field (for example, like the one in the inbuilt Logon pop-up screen). Is it possible to change the font size, and/or the size of the keys on this keyboard? How so? Thanks in advance.
  25. I am using a KTP700 BASIC HMI panel. I have two languages in the HMI program. On the inbuilt Logon screen, I want to show English text in size 21, French text in size 15. In Runtime settings > Languages and Fonts, I give each language different font sizes, but when I run the program on the HMI panel, they both show up the same size. (For example, I set English to font size 21, and French to font size 15. However, if I access the password screen in English, then later in French, the text is shown in font size 21 in both occasions). This is a problem because the French words are longer, and hence some letters get cut off. Any ideas about how to get around this? (besides just using font size 15 for both?)