Data Collector and Data Buffer Manual
Contents
1. If your JNIOR IP address is not listed you can manually enter the JNIOR IP address in case JNIOR Beacon was disabled on this JNIOR or it is on the other side of a router or you are using a VPN connection NOTE In order to use the Update features in the JNIOR Support Tool the PC running the JNIOR Support Tool must have an IP address similar to the JNIOR IP address so that they are compatible Select JNIORs Enter New IP Address Serial Number IP Address Description 10 0 0 200 Web Demo 209070102 10 0 0 117 Utility Test 1 209080012 10 245 Linema too Select Deselect Configuring the Buffer Program Once the Buffer program is running on the JNIOR a series of Registry Keys will be available to configure the Buffer program to meet your needs If you launch the main JNIOR Web page and go to the Registry Editor tab and then the AppData Buffer folder the following list of keys will be displayed The default values are shown JNIOR A Network I O Resource 4 Data Collector Manual INTEG Process Group Inc Jr109080201 VO Control Configuration Registry Editor CommandLine Applications About Add Key Edit Key Delete Folder Delete Key AppData Buffer JNR31001 LastUploadTime Mon Nov 09 10 40 20 GMT 2009 S amp ootTime AppData Buffer Quit false D bModel AppData Buffer Started Mon Nov 09 05 30 41 GMT 2009 5 SerialNumber AppData Buffer C2. E C MSSQL model mdf 2 240 KB SOL Server Backup 2 modellog IdF 1 024 501 Server Databa Data msdbdakta rndF 5 568 SOL Server Databa 3 Loa 2 msdblag ldf 2 048 SOL Server Databa C3 repldata E mssglsystemresaurce ldf 512 SOL Server Databa C Template Data mssglsystemresaurce mdr 38 976 KB SOL Server Databa If you are going to install the JNIOR database with your own existing instance of SQL Server then leave the box unchecked and select your Instance from the pull down box You must run this step on the PC which has your instance of SQL Server however it can be a different PC than the one where you will install the Data Collector Service Select your mode of Authentication and click on the Install Database button When complete click on the Next button to proceed to Step 3 JNIOR Data Collector Installer step 2 Install JniorData Database The ata database must be installed and associated with the INTEGPG instance another user specilied instance Select Instance Authentication Windows Authentication C3 SQL Authentication Password Errors Install Database Step 2 4 JNIOR Network I O Resource 12 Data Collector Manual INTEG Process Group Inc 5 3 Step 3 Installing the Data Collector Windows Service Click on the Install JNIOR Data Collector Windows Service button and the application wlll be Insta
3. 0 0 0 00000000010 1010 12 15 2909 10 57 21 AM O 00000 0 0 00 0 000 0 0 10 1 0 gt 12115009 10 59 02 AM O 0 0 00 0 000 0 0 1 0 1010 D 2009 11 01 02 O 00000 0 0 00 0 000 0 1 0 1 0 1 0 1 0 1 In the screen shot below you can see a normal event type 1 and an overwrite event type 3 The overwrite occurred during the night when the central PC was off line Eventually the JNIOR buffer had to start overwriting its data because it became full Table dbo Jniors Table dbo Jnr310 Summary Jnr310 Id Jnr310 TimeStamp ete nas dont hes the aba dba ah ab ak abes ab abe aba bo bi E aba abeo aba Abo ab a a Ea a abe ur 1 12 14 2008 0 00000 0 0 00 0 0 00 0 1 0 11 10 11 10 1 0 1 1 120412009 3 15 10 0 85 10 1 0 1 0 1 0 5 1 12 76 2009 4 12 34 AM 0 85 0 000020 0 0 00 00 0 0 0 1 0 1 0 1 1 12 15 2009 4 13 U2 0 85 0 0 0 0000 0 002002020200 0 1 0 1 0 1 1 12 15 2009 4 14 03 AM 0 85 O 1 0 1 0 110 1 0 1 JNIOR Network I O Resource 19 Data Collector Manual INTEG Process Group Inc When the central PC is back on line the Data Collector Console will show that the first data transmission contained many records as the JNIOR buffer downloaded all its
4. 00100100 045 00100101 046 00100110 047 00100111 050 00101000 051 00101001 052 00101010 053 00101011 054 00101100 055 00101101 056 00101110 057 00101111 Oct Bin 140 01100000 141 01100001 142 01100010 143 01100011 144 01100100 145 01100101 146 01100110 147 01100111 150 01101000 151 01101001 152 01101010 153 01101011 154 01101100 155 01101101 156 01101110 157 01101111 Oct Bin 240 10100000 241 10100001 242 10100010 243 10100011 244 10100100 245 10100101 246 10100110 247 10100111 250 10101000 251 10101001 252 10101010 253 10101011 254 10101100 255 10101101 256 10101110 257 10101111 Oct Bin 340 11100000 341 11100001 342 11100010 343 11100011 344 11100100 345 11100101 346 11100110 347 11100111 350 11101000 351 11101001 352 11101010 353 11101011 354 11101100 355 11101101 356 11101110 357 11101111 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F INTEG Process Group Inc Dec Hex Oct Bin 060 00110000 061 00110001 062 00110010 063 00110011 064 00110100 065 00110101 066 00110110 067 00110111 070 00111000 071 00111001 072 00111010 073 00111011 074 00111100 075 00111101 076 00111110 077 00111111 Oct Bin 160 01110000 161 01110001 162 01110010 163 01110011 164 01110100 165 01110101 166 01110110 167 01110111 170 01111000 171 01111001 172 01111010 173 01111011 174 01111100 175 01111101 176 0111
5. 1211412009 12 02 1 Security Rename E Ld Security Delete 1 12 14 2005 12 0 La ee Refresh 1 12 14 2009 12 0 ud Fepication Properties l 12 14 2009 12 0 1 Management 1 12 14 2009 12 0E 1 12 14 2009 12 08 1 14 iriri d JN OH Network I O Resource 24 Data Collector Manual Appendix Decimal to Binary Table The following table can be used to help determine the appropriate mask to use Dec Hex 2 O n O TI O O Dec Hex 64 40 65 41 66 42 67 43 68 44 69 45 0 46 1 47 72 48 73 49 74 75 48 76 4C 77 40 78 T9 JNIOR A Network I O Resource Oct Bin 000 00000000 001 00000001 002 00000010 003 0000001 1 004 00000100 005 00000101 006 00000110 007 00000111 010 00001000 011 00001001 012 00001010 013 00001011 014 00001100 015 00001101 016 00001110 017 00001111 Oct Bin 100 01000000 101 01000001 102 01000010 103 01000011 104 01000100 105 01000101 106 01000110 107 01000111 110 01001000 111 01001001 112 01001010 113 01001011 114 01001100 115 01001101 116 01001110 117 01001111 Oct Bin 200 10000000 201 10000001 202 10000010 203 10000011 204 10000100 205 10000101 206 10000110 207 10000111 210 10001000 211 10001001 212 10001010 213 10001011 214 10001100 215 10001101 216 10001110 217 10001111 Oct Bin 300 11000000 301 11000001 302 11000010 303 110
6. Cnt5 Jnr310 Cnt6 Jnr310 Cnt7 Jnr310 Cnt amp Jnr310 Usel Jnr310 11562 Jnr310 Use3 Jnr310 11564 Jnr310 11565 Jnr310 Use6 Jnr310 11567 Jnr310 Uses Jnr310 Use9 Jnr310 UselO Jnr3 10 115611 Jnr3 10 115612 Jnr3 10 115613 Jnr3 10 115614 Jnr3 10 115615 Jnr310 115616 Jnr310 EventType SchemaAudit EventID EventData JN OH A Network I O Resource Data Collector Manual varchar 32 varchar 15 datetime int int int bit bit varchar 16 archar 50 varchar 15 int datetime int int int int int int int int int int float float float float float float float float float float float float float float float float int int xml INTEG Process Group Inc 28 Sienals Signal_Id Signal_DeviceTypeld Signal_Name Version Version_AppName Version_AppVersion Network I O Resource Data Collector Manual int char 2 varchar 50 varchar 50 varchar 50 INTEG Process Group Inc 29 INTEG Process Group Inc Appendix C Example Database Queries The following are several examples of how you might query the data stored In the JNIOR database tables Example 1 To get all records for a certain JNIOR with serial number 106080089 you would execute the following SQL statement SELECT FROM Jnr310 JOIN Devices ON Jnr310 Jnr310 Id Devices Device Id WHERE Devices Device Serial 106080089 Example 2 To get all records for a certain 10 volt
7. external module with id 45110000725 681 you would execute the following SQL statement SELECT FROM ExternallOv JOIN Devices ON ExternallOv Extl1O0v Devicerid Devices Device Id WHERE Devices Device Serial 45110000725e68fd Example 3 To get all the JNIOR Internal I O records for a given JNIOR 106080089 on a given day 10 1 2008 you would execute the following SQL statement SELECT FROM Ignr31l0 JOIN Devices ON Jnr310 Jnr310 Id Devices Device Id WHERE Devices Device Serial 106080089 AND Jnr310 Jnr310 Timestamp gt 10 1 2008 AND Jnr310 Jnr310 Timestamp 10 2 2008 JNIOR A Network I O Resource 30 Data Collector Manual Summary INTEG Process Group Inc Thank you for purchasing the JNIOR Hopefully this manual made the getting to know process of your new JNIOR very quick and easy The JNIOR has many more wonderful tools and features available and are explained in detail in the supplied documents Copyright Notice Trademarks Use Restrictions Copyright 2009 INTEG Process Group Inc All rights reserved Every effort was made to make this manual as accurate and useful as practical at the time of the writing of this manual However all information is subject to change Trademarks are the property of their respective holders Sun Sun Microsystems the Sun logo and Java are trademarks or registered trademarks of Sun Microsystems I
8. integ JNIOR Utilizing the JAVA Platform process group inc JNIOR Series 2 A Network I O Resource Utilizing the JAVA Platform Data Collector Manual Release 1 0 NOTE JNIOR OS 3 4 or greater required INTEG Process Group Inc 2919 East Hardies Hd First Floor Gibsonia PA 15044 PH 724 933 9350 FAX 724 443 3553 www integpg com JNIORsales integpg com 2009 INTEG Process Group Inc All Rights Reserved Last updated on December 15 2009 INTEG Process Group Inc TABLE OF CONTENTS Whabtis Data Colector uu yuna hasa uu aaa abusata iu 1 2 Overview orbata ColleetoF oet usus A Gusan 1 3 Guidelines on Installing Data Collector I u itt e pt ure i viera 2 do L IDUPCTSPEO PE ED emu c UE 3 4 1 Installing the Buffer Program on a JNIOR 3 42 Contreuring the Butter Pros rain us ua oret cu tss 4 5 Installing the Data Collector Program on a PC 7 a step Install Nicrosott SOL Server iei bios 9 52 2 Installing the JNIOR Database 10 5 3 Step 3 Installing the Data Collector Windows Servtce 13 54 Step 4 Installing the Data Collector License 14 Data Collector
9. record sent from each JNIOR to the central PC The JNIOR does not have a large hard disk or unlimited memory However the Buffer application provides a reliable way to handle brief interruptions up to several hours or longer of the network connection between the JNIOR and the central PC or when the central PC is down The amount of data that can be buffered on the JNIOR before it is overwritten is a function of the amount of data being saved and the frequency of the logging The Registry Keys used to set these features are described later in this manual JNIOR A Network I O Resource 2 Data Collector Manual INTEG Process Group Inc 4 JNIOR Buffer Program The JNIOR Buffer program is installed using the JNIOR Support Tool and the loader zip file provided by INTEG After the Buffer program is running on the JNIOR a set of Registry Keys will be available to configure the Buffer functionality via the main JNIOR Web page 4 1 Installing the Buffer Program on a JNIOR NOTE Please do NOT unzip the Buffer loader file Please let the JNIOR Support Tool unzip it Please go to the Update tab in the JNIOR Support Tool and click on the Open Project link and then navigate to where you saved the Buffer loader zip file After the project is shown in the Update tab you can see the four steps used to install the Buffer program The only item that you must configure for your installation is to set the Server IP address of the central PC that will be
10. to separate the Installation between two computers then you run the Installation packaee twice once on each computer as follows Computer number 1 run steps and 2 or optionally just step 2 if you are going to use an existing instance of SQL Server You do not need to install the INTEG instance of SQL Server Step 2 must be run on the computer containing the instance of SQL Server you intend to use Computer number 2 run steps 3 and 4 to install the Data Collector Service and the license JN OH Network I O Resource 7 Data Collector Manual INTEG Process Group Inc Getting Started Please double click on the installation program Data Collector Install exe and the following screen will be displayed Please select which Steps you want to run NOTE To display the revision level of the installer click on the question mark amp JNIOR Data Collector Installer Welcome This Installer will walk you through the steps of installing the JNIOR Data Collector application There are several steps to a complete installation of the JNIOR Data Collector Please check all of the steps wish to perform during this installation you installing the SOL Database and Data Collector on separate computers then you will need to run this installer once on each computer Perform the first steps on the SQL Server computer and the second two steps on the computer that will hast the JNIOR Data Collector Windows Service S
11. was stored as part of the normal logging The number is in the event type data field 2 Blackout The JNIOR just rebooted or the Buffer application was otherwise restarted This is the first record since the application restart This indicates that the data since this record and the one prior to this record is unknown because the JNIOR was not operating or Buffer was not running to record it There 15 a data gap or blackout period The number 2 is in the event type data field 3 Overwrite The buffer is full and this record overwrote the oldest record in the buffer on the JNIOR The number 3 is in the event type data field In the screen shot below you can see a normal event type 1 and a blackout event type 2 in the Jnr310 table The blackout occurred because of a reboot of the JNIOR This 15 a warning that a restart of the Buffer application occurred and there 15 most likely a gap in the data In the first column below you will see the Jnr310 Id is 1 indicating this was JNIOR number one From the JNIORs table we know this 1s the JNIOR with IP address 10 0 0 201 Table dbo Jnr310 Xummary Jnr310 Id Jnr310X TimeStamp al gas dbo aba abo ab a 2b thes Lab the abo Ea Ebo abes abo Lab Eas 313 ab abs age 1 12 15 2009 10 53 02 AM 85 0 0000 0 0 00 0 000 0 0 1 0 1 0 1 0 1 0 1 12 15 2009 10 54 03 4M 85
12. 00011 304 11000100 305 11000101 306 11000110 307 11000111 310 11001000 311 11001001 312 11001010 313 11001011 314 11001100 315 11001101 316 11001110 317 11001111 Data Collector Manual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F Dec Hex Oct Bin 020 00010000 021 00010001 022 00010010 023 00010011 024 00010100 025 00010101 026 00010110 027 00010111 030 00011000 031 00011001 032 00011010 033 00011011 034 00011100 035 00011101 036 00011110 037 00011111 Oct Bin 120 01010000 121 01010001 122 01010010 123 01010011 124 01010100 125 01010101 126 01010110 127 01010111 130 01011000 131 01011001 132 01011010 133 01011011 134 01011100 135 01011101 136 01011110 137 01011111 Oct Bin 220 10010000 221 10010001 222 10010010 223 10010011 224 10010100 225 10010101 226 10010110 227 10010111 230 10011000 231 10011001 232 10011010 233 10011011 234 10011100 235 10011101 236 10011110 237 10011111 Oct Bin 320 11010000 321 11010001 322 11010010 323 11010011 324 11010100 325 11010101 326 11010110 327 11010111 330 11011000 331 11011001 332 11011010 333 11011011 334 11011100 335 11011101 336 11011110 337 11011111 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F Dec Hex Oct Bin 040 00100000 041 00100001 042 00100010 043 00100011 044
13. 1110 177 01111111 Oct 260 10110000 261 10110001 262 10110010 263 10110011 264 10110100 265 10110101 266 10110110 267 10110111 270 10111000 271 10111001 272 10111010 273 10111011 274 10111100 275 10111101 276 10111110 277 10111111 Oct Bin 360 11110000 361 11110001 362 11110010 363 11110011 364 11110100 365 11110101 366 11110110 367 11110111 370 11111000 371 11111001 372 11111010 373 11111011 374 11111100 375 11111101 376 11111110 377 11111111 25 INTEG Process Group Inc Appendix B Database Tables Layout The following is a list of the various database tables and the data format for each record BarCode Barcode_Deviceld Barcode_Timestamp Barcode_Scan Debug Debug_Id Debug_Type Debug_Time Debug_Source Debug_Description Debug_Data Devices Device_Id Device Serial Device_Typeld Device_ParentId Device InIMin Device InI Max Device Inl Units Device In2Min Device In2Max Device In2Units Device In3Min Device In3Max Device In3Units Device In4Min Device IndMax Device 1540115 DeviceTypes DeviceType Id DeviceType Description DeviceType FullScaleIn DeviceType FullScaleOut Externall0v ExtlOv DevicelId ExtlOv Timestamp Inl In2 JNIOR Network I O Resource Data Collector Manual Int datetime varchar 50 Int Int datetime varchar 50 varchar 4096 varbinary 1024 Int varchar 50 8 2 Int Int Int varchar 50 Int Int varcha
14. associated with the various JNIOR expansion modules The data is logged based on a user adjustable timer and then pushed to the central PC based on a different time interval also user configurable Data can also be logged and sent to the central PC based upon various interrupts Interrupts are changes in the state of a digital input or output on the JNIOR that cause an immediate logging of the I O data The user can configure one or more interrupts When the input or output goes from low to high or high to low off to on or on to off the JNIOR data will be logged and immediately sent to the central PC The data continues to be logged at its normal logging interval and pushed to the central PC at its scheduled interval If the network connection or the central PC 1s unavailable the Buffer program will continue to store each log record on the JNIOR until the connection 15 restored The Buffer program 15 currently capable of storing up to 64K worth of data for the internal I O and 64K worth of data for the external modules both in a circular buffer When the buffer fills the oldest data will be overwritten The total number of records that will be stored In each 64K buffer area depends upon the configuration and amount of data to be logged with each record The Collector Service running on the central PC runs as a background service waiting to accept connections from one or more JNIORs Each time the data 15 sent from the JNIOR
15. een shot below you will see two JNIORs with Jnr310_id 1 and 2 Table dbo Jnr310 Summary 310 Id Jnr31 TimeStamp Jnrs10_InputStates Jnrsi0_OutputStates Jnr310_Cnti Jnr310_Cnte 1 12 15 2009 11 22 02 AM O 25 1 12 15 2009 11 23 02 0 25 1 12 15 2009 11 23 42 0 2 2 12 14 2009 12 18 00 PM 0 22 DET 2 12 14 2009 12 20 15 PM 0 22 ALEL The data for each expansion module is stored in a table named for the type of expansion module All expansion modules of that type are stored in the expansion module type table regardless of which JNIOR it is connected to In the screen shot below you will see two 4 20 mA expansion modules with Deviceld 4 and 5 The Devices table above indicates which JNIOR each module is connected to Table dbo External420 Summary Ext42 Deviceld Ext420_Timestamp Ext4z _In1 Ext4z _In2 4 12 15 2009 10 46 01 D 4 12 15 2009 10 46 30 AM D 5 12 15 2008 10 41 46 AM D 5 12 15 2009 10 42 01 O 5 12 15 2009 10 42 31 AM 0 JN OH A Network I O Resource 18 Data Collector Manual INTEG Process Group Inc Event Type When the data is stored in the database an event type 15 associated with each record in the Jnr310 table and expansion module table indicating the circumstances under which the data was stored The event type field contains the number 1 2 or 3 1 Normal The buffer application is running normally and the data record
16. eing the rightmost bit Below are some examples Mask Binary Representation Input or Output Number 1 00000001 Input 1 Output 1 255 11111111 All Inputs or All Outputs 16 00010000 Input 5 Output 5 175 10101111 Inputs 1 2 3 4 6 8 or Outputs 1 2 3 4 6 8 Appendix A contains a table that converts the decimal numbers 1 through 255 to binary The table can be used as a guide to find the appropriate mask for the Registry Keys JNIOR A Network I O Resource 5 Data Collector Manual INTEG Process Group Inc The Registry Keys that are available for configuring the Buffer application are as follows Counter Mask the mask value to determine which input counters will be logged The default value is 0 Dumpinterval the frequency in milliseconds at which the data in the buffer will be sent to the central PC The default value 1s 120000 120 seconds ExternalCaptureInterval the frequency in milliseconds at which the values from the external expansion modules analog 4 20 mA analog 0 10 VDC analog RTD 4 relay output temperature sensor will be saved in the buffer The frequency for the external modules can be different than the frequency for the internal I O The default value is 60000 60 seconds InputInterruptMask the mask value to determine which digital inputs on the JNIOR will cause an immediate logging of the data to the JNIOR buffer Normally the data will log to the bu
17. ffer at the frequency set in the InternalCaptureInterval and ExternalCaptureInterval Registry Keys However when any input defined with the InputInterrupMask goes from low to high or high to low an immediate logging will occur in between the scheduled captures and be immediately sent to the central PC This logging does not affect the timing of the scheduled logs The default value is 0 none InputUsageMask the mask value to determine which input usage meters will be logged The default value is 0 none InternalCaptureInterval the frequency in milliseconds at which the values from the internal I O 8 digital inputs and 8 relay outputs will be saved in the buffer The frequency for the internal I O can be different than the frequency for the external modules The default value 1s 60000 60 seconds OutputInterruptMask the mask value to determine which digital outputs on the JNIOR will cause an immediate logging of the data to the JNIOR buffer Normally the data will log to the buffer at the frequency set In the InternalCaptureInterval and ExternalCaptureInterval Registry Keys However when any output defined with the OutputInterrupMask goes from low to high or high to low an immediate logging will occur in between the scheduled captures and be immediately sent to the central PC This logging does not affect the timing of the scheduled logs The default value is 0 none OutputUsageMask the mask value to de
18. gs of the internal states of the JNIOR I O Input Counters and I O Usage Meters Each record also holds a timestamp and an Event Type Please refer to the Event Type explanation at the beginning of this section SchemaAudit This table 15 not used by anyone other than INTEG It is designed for tracking development changes Signals This 15 a table that 15 populated as the database inserts records for new devices Version This table holds the version of the Data Collector Service that is populating the database It also holds the current state of the license file The states for the license file are simply true or false indicating the validity of the license file JN OH A Network I O Resource 22 Data Collector Manual INTEG Process Group Inc 7 2 Viewing Data You can view the JNIOR database tables by installing Microsoft SQL Server Management Studio Express The login information is as follows using the INTEG installed Microsoft SQL Server Instance Login integ Password integ T Microsoft SOL Server Management Studio Express Fille Edit View Tools Window Community Help 68 Query j SEB Object Explorer wh mi m A f Connect to Server Microsoft iat Windows Server System SQL Server 2005 Server Database Engine Server Authentication Login Password Remember password After you C
19. he JNIOR database on a computer with an existing instance of SQL Server JNIOR A Network I O Resource 20 Data Collector Manual INTEG Process Group Inc 7 1 Database Tables The format for the database tables is Included in Appendix B A general description 15 provided below BarCode When the Buffer application is configured to work with a bar code scanner the scanned barcodes will be logged to this table Future feature Debug This table holds debugging information generated by the Data Collector Windows Service Entries can be informative describing events such as the service starting or they can be errors such as the JNIOR disconnecting in the middle of the Buffer download operation This information is useful to INTEG should the application not function properly Devices This table contains all of the connected JNIORs and the external modules that are configured to log Using the ParentId column we can determine which JNIOR the external module belongs to DeviceTypes This table is a definition table that holds the description of the standard External Devices as well as other information critical to determining how to convert raw data for each device type to valid scaled values Externall0v This table holds records containing the 10volt Module logged values These values are not adjusted to the actual signal scale These are raw values and must be scaled by the user Each record also holds a timestamp and an event t
20. icense file to run our curent license set to run until License file does not exist Select License File The selected file will expire on Step 474 Cancel Prev Once you select the file the installation program will read the date or indentify it as a perpetual license and display the expiration date Click on the Apply Selected License File button JNIOR Data Collector Installer Step 4 License The JNIOR Data Collector Service needs a valid License File to run Your current license is set to run until License file does not exist C Documents and Settingsrshulkoskyw INTEGPG2 Desktop Data Coll Select License File The selected file will expire on Perpetual Apply Selected License File Step 474 Cancel Prev JNIOR A Network I O Resource 14 Data Collector Manual INTEG Process Group Inc If the license file is successfully installed the date the license will expire will be displayed as shown in the screen below JMIOR Data Collector Installer Step 4 License The JNIOR Data Collector Service needs a valid License file ta run jour current license 5 set to run until Perpetual Select License File The selected file will expire on Step 474 The JNIOR Data Collector application on the PC should now be complete and you can click on the Finish button to close the installer JNIOR A Network I O Resource 15 Data Collector Manual INTEG P
21. iors_LastUpdate k ALE 10 0 0 201 61400 10 0 0 201 6231 1211512009 9 54 47 AM 2 DE 10 0 0 245 48192 10 0 0 245 4071 12 15 2009 9 53 15 AM NUS L NUS z NUS E NUE E NU I Devices _ Table dbo DeviceTypes Table dbo Devices DeviceTvpe Id DeviceTvpe Description The Devices Type table lists all the 10 Ternperature potential type of devices that can be 28 Temperature used with the JNIOR Data Collector FB 4 Relay Out system This includes the JNIORs and expansion modules You will see that af each device type is given a unique FD 0 10 V device type ID FE 4 20 ma FF jnior 310 Fk ACRI JN OH Network I O Resource 17 Data Collector Manual INTEG Process Group Inc The Devices table list all the devices ever used with this installation of JNIOR Data Collector system As JNIORs or expansion modules are added they are given a unique device ID For expansion modules the parent ID 1s the JNIOR they are connected to If a JNIOR or expansion module is removed from the system the device ID still remains in the table since data records remain in other tables that are still associated with this device Table dbo Devices Table dbo Jnr310 Summary Device Id Device _Serial Device Tvpeld Device ParentId 091 10004 FF AUT 2 209080012 FF ALLS 3 91111091125005Fd Fd 2 4 z2b1DUDDDDD236bFe Fe 2 5 FF 100000002 292 Fe The data for all the JNIORS is stored in the Jnr310 table In the scr
22. k on the Next button to proceed to Step 3 JNIOR Data Collector Installer Step 2 Install JniorData Database The JniorD ata database must be installed and associated with the IHTEGPG instance or another user specified instance Use the Local INTEGPG Instance Errors 0 Step 2 4 Clicking on the Errors link for a good installation 0 errors will display the following Installing Database Executing JniorD ata Create sql Executing JniorD ata T ables Create sql Executing JniorD ata StoredProcs Create sql Executing JniorD ata Functions Create sql Executing JniorD ata Triggers Create sql Executing JniorD ata Users Create sql Executing JniorD ata Map Users Roles sql Executing JniorD ata Data Insert DeviceT ypes sql Close JNIOR A Network I O Resource 11 Data Collector Manual INTEG Process Group Inc The INTEG Instance of Microsoft SQL Server Express Edition 2005 is installed in your Program Files folder under the Microsoft SQL Server folder The following screen shot shows the JNIOR database installation files that are added Address C C Program Files Microsoft SQL Server MSSQL 1 MS55QL Data Size 17 600 KB SOL Server Databa Folders 3 Microsoft SQL Server 80 lt gt JhiorData_log laf 1 280 KB SQL Server Databa 90 Le 4 096 KB SOL Server Databa E MssQL 1 mastlag ldf 1 280 SQLServer Databa
23. lled on your PC E JNIOR Data Collector Installer Step 3 Install JNIOR Data Collector Windows Service This step will install the Data Collector Windows Service The Winows Service is responsible for taking the data from the JMIOR Buffer and storing it in the SOL Database Install JNIOR Data Collector Windows Service Step 3 4 Cancel After the service 15 successfully installed the following screen will be displayed Please click on the Next button to proceed to Step 4 amp JNIOR Data Collector Installer Step 3 Install JNIOR Data Collector Windows Service This step will install the JNIQA Data Collector Windows Service The Winows Service iz responsible for taking the data from the JNIOR Buffer and storing it in the SAL Database Step 3 4 JNIOR A Network I O Resource Data Collector Manual 13 INTEG Process Group Inc 5 4 Step 4 Installing the Data Collector License INTEG will provide you with a license file that 1s installed in Step 4 If you purchased the JNOR Data Collector then your license will be set to run as perpetual forever If you are installing a trial version then your license will be set to expire on a certain calendar day Please save the license file license oms to your PC and then click on the Select License File link and navigate to the folder where it was saved i JNIOR Data Collector Installer Step 4 License The JNIOR Data Collector Service needs a valid L
24. nc in the United States and other countries Microsoft Windows MS DOS and Internet Explorer are registered trademarks of Microsoft Corporation HyperTerminal is a registered trademark of Hilgraeve Inc This User s Manual and the software contained in the JNIOR are copyrighted by INTEG Process Group Inc and may not be copied or reproduced without prior consent from INTEG Process Group Inc INTEG Process Group Inc is not responsible for any errors or omissions that may be contained in this manual Please do not hesitate to contact our JNIOR team at INTEG Process Group Inc We can be reached via phone fax or e mail as follows INTEG Process Group Inc 2919 E Hardies Road 1 Floor Gibsonia PA 15044 www integpg com JNIORsales integpg com 724 933 9350 extension 20 FAX 724 443 3553 JUNIOR A Network I O Resource 31 Data Collector Manual
25. onnect you can view the data tables by right clicking on a table name and selecting Open Table as shown in the screen shot below Each table 1s described in the previous section and the table format is described in Appendix B JNIOR A Network I O Resource Data Collector Manual 23 INTEG Process Group Inc Microsoft SQL Server Management Studio Express Edit View Query Designer Tools Window Community Help new Query Oy 851 5 Object Explorer Table dbo Jnr310 Summary Jnr310 Id Jnr310 TimeStarr DEvLAPTOPIINTEGPG SQL Server 9 0 1399 in 1 12 14 2009 11 45 La Databases l 12 14 2009 11 4 Li SEEN Databases i 12 14 2009 11 4 zi T JniarData 1 Database Diagrams 1 12 14 2008 11 45 Tables 1 12 14 2009 11 50 System Tables 1 1211412009 11 50 dbo Barcode ki E dbo Debug 1 12 14 2009 11 51 LE dba Devices 12 14 2009 11 52 m dbo DeviceTypes 1 12 14 2009 11 5 dbo ExternallDv m dba Externald20 l 1271472005 11 55 dbo External4Relayaut 1 12 14 2009 11 55 dbo ExternalTemperature 6 3 1 12 14 2009 11 5 M Table 12 14 2009 11 57 960 51 Modify 1 12 14 2009 11 5 z dbo Si gp IR ren Table 1 12 14 2009 12 00 E views 1 12 14 2009 12 00 Hg Synonyms view Dependencies 1 12 14 2008 12 01 4 1 Programm 1
26. onsole uu uuu una Seana ote m dum saam tenuate 16 Pata Coll O or ata Suyu nu uuu u naa hua MEL An Ele DEOR DIDI 17 WN e E 21 T2 OI nA P 23 Appendix A Decimal to Binary TaD erea pde per iret 25 Appendix B Database Tables Layout 26 Appendix C Example Database Quert6s 30 JN OH A Network I O Resource Data Collector Manual INTEG Process Group Inc 1 What 15 Data Collector Data Collector consists of two programs that work together to provide the ability to log I O information from one or more JNIORs to a database located on a central PC A program 15 installed on the JNIOR called Buffer that logs data to the JNIOR memory and sends it to an application called the Collector Service running on a central PC The Collector Service receives the information from one or more JNIORs and writes it to a database 2 Overview of Data Collector Data Collector provides the user of the JNIOR with an easy way to log I O data for historical reasons for use in other systems and for reports the JNIOR I O data can be brought back to a central location for ease of use and storage The Buffer program running on the JNIOR is configurable such that it can be set to record the I O status input counter values input output usage meters and the data
27. orrect and that the JNIORs are on the same network scheme JNIOR Data Collector Console IP Address Block Type Download Time Status There are 085 reporting JNIOR A Network I O Resource 16 Data Collector Manual INTEG Process Group Inc 7 Data Collector Database The Data Collector database 15 a collection of tables that are responsible for storing Information about the state of the JNIORs and their external modules The user can interact with this data using normal database techniques This section discusses some key points to understand about the organization of the JNIOR Data Collector Database The list of the tables is provided in section 7 1 A detailed listing of the data in each table is provided in Appendix B Learning SQL or how to interact with an SQL programmatically is beyond the scope of this manual Some examples are provided in Appendix C to illustrate how you might query the JNIOR data Section 7 2 provides you with a method to view the data tables using the free Microsoft SQL Server Management Studio Express software package JNIOR ID When a JNIOR makes a connection to the Data Collector Service it is given a unique ID Jniors_Id This ID 15 used to identify the source of the data in the Jnr310 data table Below 15 a screen show of the Jniors table that contains two JNIORs Table dbo Jniors Table dbao Jnr31 Summary Jniors Id Jniors_D Jniors Alias Jniors_Ip ddress Jn
28. ounterMask 0 5 Version AppData Buffer Dumplinterval 120000 5 AppData AppData Buffer EmbeddedBaseVersion v 1 0 1125 12 13 7 Buffer AppData Buffer ExternalCapturelnterval 60000 D JNR31001 LastUpla AppData Buffer Inputinterrupt Mask 0 E AppData Buffer InputUsageMask 0 ui AppData Buffer InternalCapturelnterval 60000 D 13 59 AppData Buffer Name Buffer 1 CounterMask AppData Buffer OutputinterruptMask 0 1 Dumplnterval AppData Buffer OutputUsageMask 0 5 EmbheddedBaseVversia AppData Buffer Server 10 0 0 100 5 ExternalCapturelntervall AppData BufferMersion 2 1 1211 1250 5 Inputinterruptiiask 5 InputlisageMask 5 Internalcapturelnterval Name 5 Outputinterrupthtask 5 Server Version Mask Settings Several of the keys use a mask concept Since there are 8 inputs and 8 outputs on the main JNIOR there are a lot of combinations defining which inputs and outputs are to be logged The information includes the input and output status the input counters and the input and output usage meters Instead of defining a key for each input and output and associated item a mask concept was implemented where a number from 0 to 255 is entered to represent the inputs or outputs to be used When the mask number 15 converted to binary the user can see the pattern of the 8 bits representing the I O to be used with the lowest numbered I O point b
29. ource 9 Data Collector Manual INTEG Process Group Inc The following screen will be displayed upon completion Click on the Next button to proceed to Step 2 JNIOR Data Collector Installer Step 1 Install INTEG SQL Instance JMIOR Data Collector requires an Instance of Microsoft SQL Server ta be running This installer can Install an INTEGPG Instance to use to make things easier The Instance iz optional but having a seperate instance could protect your current data from security risks associated with providing the login to JMIOR Data Instance Already Exists Uninstall Step 1 4 5 2 Step 2 Installing the JNIOR Database If you are using the INTEG Instance of SQL Server then leave the box checked and click on the Install Database button JNIOR Data Collector Installer Step 2 Install JniorData Database The Jno ata database must be installed and associated with the F instance another user specified instance Use the Local INTEGPG Instance Errors Install Database Step 2 4 Cancel Prey JNIOR A Network I O Resource 10 Data Collector Manual INTEG Process Group Inc After the JNIOR Database has been installed you will see the following screen If you see any Errors a non zero value in the lower left corner please click on the Errors link to view the errors and take the appropriate action If you do not have any errors a 0 value is displayed then clic
30. r 50 Int Int varchar 50 Int Int varchar 50 char 2 varchar 50 int int int datetime int int 26 Ext10v_In3 Ext10v_In4 Ext10v_Outl Ext10v_Out2 ExtlOv_EventType External420 Ext420_Deviceld Ext420_Timestamp Ext420 Inl Ext420 112 420 In3 420 114 Ext420_Outl Ext420 Out2 Ext420 EventType ExternaldRelayOut Ext4Rout_Deviceld Ext4Rout_Timestamp Ext4Rout_ States Ext4Rout_EventType ExternalRtd ExtRtd_Deviceld ExtRtd_Timestamp ExtRtd_InCelcius1 ExtRtd InCelcius2 ExtRtd InCelcius3 ExtRtd InCelcius4 ExtRtd InFahrenheitl ExtRtd InFahrenheit2 ExtRtd InFahrenheit3 ExtRtd InFahrenheit4 ExtRtd_EventType ExternalTemperature Temp_Deviceld Temp_Timestamp Temp_Celcius Temp_Fahrenheit Temp_EventType Jniors Jniors_ Id Jniors_DeviceTypeld Network I O Resource Data Collector Manual INTEG Process Group Inc int int int int int int datetime int int int int int int int int datetime int int int datetime float float float float float float float float int int datetime float float int int int 27 Jniors Alias Jniors_IpAddress Jniors_LastUpdate Jniors_InputCounterMask Jniors_InputUsageMask Jniors_OutputUsageMask Jniors_ActiveFalg Jniors_NewConfig Jniors_LastAttempt Jniors_ Versions Jniors_CollectorIp Jnr310 Jnr310 Id Jnr310 TimeStamp Jnr310 InputStates Jnr310_OutputStates Jnr310 Jnr310 Cnt2 Jnr310 Cnt3 Jnr310 Cnt4 Jnr310
31. rocess Group Inc 6 Data Collector Console After you have installed the JNIOR Buffer application on one or more JNIORs including configuring the IP address of the Data Collector Service and installing the Data Collector Service and database tables the JNIORs should automatically start buffering data and sending it back to the central PC One way to tell that your installation is working correctly is to use the Data Collector Console When the central PC first boots up it will install the Data Collector Service and display the Data Collector Console pop up window If the Data Collector Console window is not displayed you can launch it by going to Start Programs INTEG Data Collector and selecting the JNIOR Data Collector Console amp JNIOR Data Collector Console Jnior IP Address Block Type Download Time Status 20908001 2 10 0 0 245 Internal 12 14 2009 2 44 04 Received 1 Hecord s Successtully 20909001 2 10 0 0 245 Esternal 12 14 2008 2 44 07 Received 5 Hecard s Successtully 209110004 10 0 0 201 Internal 12 14 2008 2 45 13 Received 1 Recordi Successtully A JNIOR icon should be displayed in your lower Open Windows task bar area and you can right click on it Ei to open the console window or exit iia a 951 PM If the pop up console window contains the message There are no JNIORs reporting then please check that the IP address entered for the server in the Buffer registry key is c
32. running the Collector Service Click on the Edit Project Configuration link and change the IP address in the Set Server Step to the correct address and then click on the Save amp Close button JNIOR Support Tool ord View About Beacon Devices Macro Update Logs Snapshot Open Project Close Project Edit Project Confiquration Publish Update to JNIOR Cancel Current Project C Program Files INTEGWAIOR Support TaohFilessllpdate Projects JNIOR_Butfer2 1 1214 956 Step Statys Elapsed JMIOR Buffer 2 1 1214 956 Load Buffer Set Run key MoAL 1 Set Server Reboot Title r Password Load Butter Update Buffer set Run Key Registry Key El General Set Server Registry Key Set Server Reboot Reboot Reboothequred True Reg alue Value of the Registry JUNIOR A Network I O Resource 3 Data Collector Manual INTEG Process Group Inc Next click on the Publish Update to JNIOR link to load the software Since you must be using a JNIOR with JNIOR OS version 3 x and assuming you did not disable the JNIOR Beacon functionality your JNIOR should be displayed in the Beacon tab and be available for selection in the pop up JNIOR Selection Window Please select your JNIOR and click on the OK button The Buffer program will be loaded on your JNIOR and the JNIOR will be rebooted so that the Buffer program is started
33. stored data to the central PC This is shown in the screen shot below The amount of records 15 a function of how the Buffer program is configured 1 6 what data to log the frequency etc JNIOR Data Collector Console Jnior IP Address Black Tvpe Download Time 20908001 2 10 0 0 245 Internal 12 15 2003 8 21 42 Hecerved 1 Record s Successtully 209080012 10 0 0 245 External 12 15 2003 3 21 52 AN Received 1234 Record s Succes D 209110004 10 0 0 201 Internal 12 15 2009 8 21 42 Hecerved 3 1 Record s Successt Connection To keep any data stored in other database tables separate from the JNIOR data INTEG has included the steps to create a new SQL instance as part of our Data Collector installer Microsoft recommends that the authentication method should be Windows Authentication However this is not always easy to explain or setup Since INTEG is not on site to assist all installations a different authentication method was chosen for an INTEG Instance of SQL Server INTEG has chosen to use SQL Authentication The connection string is located in the applications config file This way the SQL authentication login only pertains to this new instance of the SQL Server The default connection for the local INTEGPG instance using SQL Server 2005 is Data Source SQLExpress Initial Catalog master User Id integ Password integ You may choose to not install a separate instance of SQL Server and instead choose to load t
34. tep 1 Install an INTEGPG Instance of Microsoft SQL Server Express Step 2 Install the JNIQA Data Database Step 3 Install the JMIDR Data Collector Windows Service Step 4 Install the License File Step 0 Cancel JUNIOR A Network I O Resource 8 Data Collector Manual INTEG Process Group Inc 5 1 Step 1 Install Microsoft SQL Server If you want to use the INTEG Instance of Microsoft SQL Server 2005 Express Edition with the JNIOR Data Collector then click on the Install INTEG SQL Instance button If you want to use your own Instance of Microsoft SQL Server please skip this step by clicking on the Next button JHIOR Data Collector Installer step 1 Install INTEG SQL Instance JHIDR Data Collector requires an Instance of Microsoft SOL Server running This installer can install an INTEGPG Instance to use to make things easier The Instance is optional but having a seperate instance could protect your current data from security risks associated with providing the login ta JNIOR Install INTEG SUL Instance Step 174 You will see the following screen during the Microsoft SQL Server installation Microsoft SQL Server 2005 Setup Setup Progress The selected components are being configured Product Status PSOL Setup Support Files Configuring components SQL Native Client SQL Writer SOL Server Database Services Status Cancel JUNIOR A Network I O Res
35. termine which output usage meters will be logged The default value is 0 none Server the IP address of the PC that 15 running the JNIOR Data Collector service JN OH A Network I O Resource 6 Data Collector Manual INTEG Process Group Inc 5 Installing the Data Collector Program on a PC The Data Collector functionality consists of two main items that can be installed on two separate computers 1 Database Tables the database tables are associated with an Instance of the Microsoft SQL Server supplied by INTEG or with an Instance of Microsoft SQL Server already provided by the user 2 Data Collector Service the Data Collector Service is a program that runs in the background on a PC This service can be installed on the same PC hosting the Microsoft SQL Server or a separate PC INTEG supplies an installation package with 4 Steps so the user can customize the installation to meet their needs The four Steps are as follows Install Microsoft SQL Server 2005 Express Edition if required Install the JNIOR database tables and associate them with the SQL Server Install the Data Collector Windows Service Install the License File Installation One Computer versus Two Computers INTEG recommends that for ease of Installation and separation of data to Install the Data Collector system on one computer If you are Installing the system all one computer then you simply run all 4 steps on the same computer If you want
36. the Collector Service will receive the data and store it in the appropriate database table The user then has the ability to access this data via normal data base queries The combination of the Buffer and Collector Service programs provide a robust and reliable way to log I O data from one or many JNIORs to a database for a variety of uses JN OH A Network I O Resource 1 Data Collector Manual INTEG Process Group Inc 3 Guidelines on Installing Data Collector The Data Collector system consists of one or more JNIORs and a central PC and requires the following software proerams 1 Buffer Program the Buffer program must be installed on each JNIOR that will be reporting information back to the central database The Buffer program is easily installed using the JNIOR Support Tool and the loader zip file provided by INTEG There are several configuration parameters that can be set via the JNIOR Registry Editor using the main JNIOR Web page 2 Data Collector Service the Data Collector Service is easily installed using the Data Collector Service Installation program The Data Collector Service utilizes an instance of Microsoft SQL Server 2005 Express Edition The Express edition is free and supplied as part of the Data Collector Service installation As an option the user can associate the JNIOR database tables to their own instance of Microsoft SQL Server A JNIOR Data Collector Console is available to view the timestamp of the last data
37. ype Please refer to the Event Type explanation at the beginning of this section External420 This table holds records containing the 4 20ma Module logged values These values are not adjusted to the actual signal scale These are raw values and must be scaled by the user Each record also holds a timestamp and an event type Please refer to the Event Type explanation at the beginning of this section JN OH A Network I O Resource 21 Data Collector Manual INTEG Process Group Inc External4RelayOut This table holds records containing the 4 Relay Output Module logged states Each record also holds a timestamp and an event type Please refer to the Event Type explanation at the beginning of this section ExternalRtd This table holds records containing the RTD Module logged values These values are not adjusted to the actual signal scale These are raw values and must be scaled by the user Each record also holds a timestamp and an event type Please refer to the Event Type explanation at the beginning of this section ExternalTemperature This table holds records containing the External Temperature Probe logged values Each record also holds a timestamp and an event type Please refer to the Event Type explanation at the beginning of this section Jniors This table holds the list of JNIORs and JNIOR specific information in regards to the Buffer connection and Buffer configuration Jnr310 This table holds records containing the lo
Download Pdf Manuals
Related Search