Difference between revisions of "DataConnectIT:Appendix Log Values Service"

From Nolek Wiki
Jump to navigation Jump to search
Line 467: Line 467:
 
|StreamWithClient
 
|StreamWithClient
 
|PipeClientStream
 
|PipeClientStream
 +
|-
 +
|}
 +
 +
====7.2.2.4 Other IDs====
 +
 +
{| class="wikitable" style="text-align:center|"
 +
!colspan="5"|Other IDs
 +
|-
 +
|'''Other ID'''
 +
|'''Other Description'''
 +
|'''Method'''
 +
|'''Class'''
 +
|'''Alert type'''
 +
|-
 +
 +
 +
|3000
 +
|Service disconnected from OPC
 +
|DisconnectOPCServer
 +
|OPCMethods
 +
|
 +
|-
 +
|3001
 +
|
 +
|ExecuteSQLWrite
 +
|DBCommunicator
 +
|
 +
|-
 +
|3002
 +
|OPC_Read was called
 +
|Read
 +
|OPC_Read
 +
|
 +
|-
 +
|3003
 +
|SQL delete from backup device after having uploaded result
 +
|Write
 +
|SQL
 +
|
 +
|-
 +
|3004
 +
|Data device Write result: 1 (success), writing to responseTag: 1
 +
|Write
 +
|OPC_Read
 +
|
 +
|-
 +
|3005
 +
|Last Config Activated
 +
|ActivateLastConfig
 +
|SQliteMethods
 +
|
 +
|-
 +
|3006
 +
|OPC Writing details (columns and their values + reply values)
 +
|Write
 +
|OPC_Write
 +
|
 +
|-
 +
|3007
 +
|Writing to responseTag:  (responseToOpc)
 +
|Write
 +
|OPC_Write
 +
|
 +
|-
 +
|3008
 +
|SQL execution result (OK/NOK) whether it has read from SQL
 +
|Read
 +
|SQL
 +
|
 +
|-
 +
|3009
 +
|Client stopped the Trigger Process (reasonOfStopping received from client)
 +
|StreamWithClient
 +
|PipeClientStream
 +
|
 +
|-
 +
|3010
 +
|Service pipe waiting for a connection
 +
|ServerThread
 +
|ServerSetup
 +
|
 +
|-
 +
|3011
 +
|Client disconnected, currently connected Clients: (count)
 +
|SubtractThread
 +
|ThreadHandler
 +
|
 +
|-
 +
|3012
 +
|Result of creating SQLiteDatabase(exists/created/error)
 +
|OnStart
 +
|Service1
 +
|
 +
|-
 +
|3013
 +
|Configs in SQlite : (configCount)
 +
|OnStart
 +
|Service1
 +
|
 +
|-
 +
|3014
 +
|No config found in service
 +
|OnStart
 +
|Service1
 +
|
 +
|-
 +
|3015
 +
|"Trigger tag of (GroupName) is triggered"
 +
|ExecuteTriggerProcess
 +
|TriggerProcess
 +
|
 +
|-
 +
|3016
 +
|OPC Connection status: Service is connected to OPC Server
 +
|ConnectToOPC
 +
|OPCMethods
 +
|
 +
|-
 +
|3017
 +
|Try to reupload
 +
|Write
 +
|SQL
 +
|
 +
|-
 +
|3018
 +
|Uploaded all data to SQL, no more in backup
 +
|Write
 +
|SQL
 +
|
 +
|-
 +
|3019
 +
|The previous value/status of uploading result to database
 +
|Read
 +
|TriggerProcess
 +
|
 +
|-
 +
|3020
 +
|Writing response value to Controller device (success)
 +
|Write
 +
|OPC_Read
 +
|
 +
|-
 +
|3021
 +
|Writing response value to Controller device (after fail to store to backup or to read values from opc)
 +
|read
 +
|OPC_Read
 +
|
 +
|-
 +
|3022
 +
|writing respone value to Controller device after succesful storing in backup device
 +
|Write
 +
|OPC_Read
 +
|
 +
|-
 +
|3023
 +
|Writing 2(error) to response tag, backup is not enabled and using Gateway response values
 +
|Write
 +
|OPC_Read
 +
|
 +
|-
 +
|3024
 +
|writing error to response tag, due to a datadevice error
 +
|WriteNonGatewayResponse
 +
|OPC_read
 +
|
 +
|-
 +
|3025
 +
|writing error to response tag, due to datadevice Connection fail
 +
|WriteNonGatewayResponse
 +
|OPC_Read
 +
|
 +
|-
 +
|3026
 +
|writing error to responsetag after failing to read from OPC
 +
|WriteNonGatewayResponse
 +
|OPC_Read
 +
|
 +
|-
 +
|3027
 +
|writing error to responsetag after failing to store in backup
 +
|WriteNonGatewayResponse
 +
|OPC_Read
 +
|
 +
|-
 +
|3028
 +
|Writing error to responsetag. Most likely an SQL stored procedure error(wrong or non existing), can also be an unknown error
 +
|WriteNonGatewayResponse
 +
|OPC_Read
 +
|
 +
|-
 +
|3029
 +
|There is no Project in configuration for service to load
 +
|StartProcess
 +
|TriggerProcess
 +
|1
 +
|-
 +
|3030
 +
|Cannot read values from Controller device, going to next iteration
 +
|ExecuteTriggerProcess
 +
|TriggerProcess
 +
|1
 +
|-
 +
|3031
 +
|File device renamed file after performing trigger action
 +
|HandleActionFile
 +
|FileHandler
 +
|
 +
|-
 +
|3032
 +
|File device moved file after performing action
 +
|HandleActionFile
 +
|FileHandler
 +
|
 +
|-
 +
|3033
 +
|File device: Deleted file after using it, as specified in file config.
 +
|HandleActionFile
 +
|FileHandler
 +
|
 +
|-
 +
|3034
 +
|Restarted upload processes (from backup to datadevice)
 +
|RestartUploadProcess
 +
|TriggerProcess
 +
|
 +
|-
 +
|3035
 +
|Stored data to backupdevice after X time
 +
|Write
 +
|SQLite
 +
|
 +
|-
 +
|3036
 +
|Group(group name) Writing to OPC response tag:  (response)
 +
|Write
 +
|OPC_Write
 +
|
 +
|-
 +
|3037
 +
|Group read from backup, prepare to upload to SQL
 +
|Write
 +
|SQL
 +
|
 +
|-
 +
|3038
 +
|Putting responsetag to 0 because trigger not validated
 +
|Write
 +
|OPC_Read
 +
|
 +
|-
 +
|3039
 +
|Group(groupname) Inserted value to SQLite (grouppropertiesmodel.items[2].controllervalue)
 +
|Write
 +
|SQLite
 +
|
 +
|-
 +
|3040
 +
|Backup device is empty, stopping upload process until next trigger/start
 +
|Write
 +
|SQL
 +
|
 +
|-
 +
|3041
 +
|License status received:  (licStatus)
 +
|StreamWithClient
 +
|PipeClientStream
 +
|
 +
|-
 +
|3042
 +
|Created SQLite backup file
 +
|CreateBackupSqlite
 +
|SQLiteHandler
 +
|
 +
|-
 +
|3043
 +
|Created SQLite UploadProcess file
 +
|CreateUploadProcessSQLite
 +
|SQLiteHandler
 +
|
 +
|-
 +
|3044
 +
|Group(groupname) writing (x) to response tag, while data upload was not succesful
 +
|
 +
|
 +
|
 
|-
 
|-
 
|}
 
|}

Revision as of 14:38, 4 September 2019

7.2.2 Log Values Service

7.2.2.1 Client Setting

Client Setting
Log setting from client # Error Other Change Alert Always '
(Warning)
None 1 x
Only Errors and warnings 2 x x x
All changes 3 x x x x Default
Everything 4 x x x x x
Alert type
Notification Setting from client # 0 1 2 3
Always Info Warning Error
None 1 x
Only Errors 2 x x
Only Errors and warnings 3 x x x
All changes 4 x x x x

7.2.2.2 Debug IDs

Debug IDs
Debug ID Debug Description Method Class
1000 Temporary file deleted DeleteTempFile ConfigMethods
1001 Did not read succesfully from group's specified OpcServer ReadItemValuesFromGroup GroupPropertiesModel
1002 Checking: Is another thread currently trying to connect to OPC RepeatConnectionAttempt OPCMethods
1003 Repeat Connection Attempt was called. Checks If OPC is Currently Connected RepeatConnectionAttempt OPCMethods
1004 Trying to connect to Opc Server: (opcServerName) RepeatConnectionAttempt OPCMethods
1005 Connected, informing the other threads. RepeatConnectionAttempt OPCMethods
1006 Setting thread connecting to false (next triggerprocess that loses opcConnection will know to connect by itself) RepeatConnectionAttempt OPCMethods
1007 Another thread is trying to connect, waiting till it's done RepeatConnectionAttempt OPCMethods
1008 Resuming (when a thread has reestablished OPC connection) RepeatConnectionAttempt OPCMethods
1009 End of repeat-connect attempt. Checking if something is still trying to connect (should be false) RepeatConnectionAttempt OPCMethods
1010 Shows Stored procedure commandText, group items count, CommandTimeout setting ExecuteSqlRead DBCommunnicator
1011 Try to connect to opcServer from Read in OPC READ Read OPC_Read
1012 Try to connect to opcServer from Write in OPC READ Write OPC_Read
1013 Try to connect to opcServer from ReadTags in OPC READ ReadTags OPC_Read
1014 Try to connect to opcServer from READ in OPC WRITE Read OPC_Write
1015 Try to connect to opcServer from WRITE in OPC WRITE Write OPC_Write
1016 DB Writing: (all item names and values for the group) ExecuteSqlWrite DBCommunnicator
1017 Retrieved following response in OPC WRITE (not 1) Write OPC_Write
1018 Try to connect to OpcServer ReadTags OPC_Write
1019 Trying to create a new alert pipe connection to the connected client ConnectToAlertPipe ClientAlerter
1020 Trying to create pipe alert ConnectToAlertPipe ClientAlerter
1021 Connection to Alert pipe: (true or false) ConnectToAlertPipe ClientAlerter
1022 Writing to Alert pipe: (message) SendAlert ClientAlerter
1023 Stream with (clientApplication) started StreamWithClient PipeClientStream
1024 "Connection to (DataConnectIT client Application) was lost, going to close the pipe-connection." StreamWithClient PipeClientStream
1025 Waiting for value from connected client... StreamWithClient PipeClientStream
1026 Received: (received string from client) StreamWithClient PipeClientStream
1027 Retrieved from Client (received string from client) StreamWithClient PipeClientStream
1028
1029
1030
1031 Trigger Process was running StreamWithClient PipeClientStream
1032 Alert pipe name received: (alertpipename) StreamWithClient PipeClientStream
1033 Ends the entire pipe commucation after an error StreamWithClient PipeClientStream
1034 Pipe created ServerThread ServerSetup
1035 Thread X waiting for connection to client. (first version only supports 1 client, so thread nr. is irrelevant) ServerThread ServerSetup
1036
1037 Sending first string to client ServerThread ServerSetup
1038 ClientName Connected to the service ServerThread ServerSetup
1039 Closing Pipe server ServerThread ServerSetup
1040 New client connected, current Clients connected: X ClientConnected ThreadHandler
1041 Client connected, max clients allowed: X ClientConnected ThreadHandler
1042 Service license: (licenceStatus) OnStart Service1
1043
1044
1045 Ready to accept first client OnStart Service1
1046 Trigger process started NewTriggerProcess Controller
1047 "ValueTag From OPC: X, Value of TriggerTag In OPC: Y" ExecuteValidation Helper
1048 (group): Trigger Value From OPC: (OPC ValueTag Value). Value From Config: (Validationtype of first group trigger) ExecuteValidation Helper
1049 Time that the response should be reset if nothing changed StartResetTimer Helper
1050 Group is active StartProcess TriggerProcess
1051 Group is not active. StartProcess TriggerProcess
1052
1053 Data stored in the BackUp Device SaveToXML XMLHandler
1054 The amount of the groups in the BackUp device ReadXML XMLHandler
1055 Delete the a row with the a specific GroupID DeleteFromXml XMLHandler
1056 SQL device delete from Backup device Write SQL
1057 Content of backup is empty, stop the upload process Write SQL

7.2.2.3 Change IDs

ChangeIDs
Change ID Change Description Method Class
2000
2001
2002 Demo expired GetDemoTimerStatus LicenseHandler
2003 Client sent a new Configuration file. StreamWithClient PipeClientStream
2004 Client updated Log path to (newpath) StreamWithClient PipeClientStream
2005 Client updated Log format and degree to: (logFormat), (Logdegree). + (success or not) StreamWithClient PipeClientStream
2006
2007 Client stopped the upload process Write SQL
2008 "Client updated DeviceTimeOut(timeOutTime): "" + (success or not)" StreamWithClient PipeClientStream
2009 Client started again the Trigger Process StreamWithClient PipeClientStream

7.2.2.4 Other IDs

Other IDs
Other ID Other Description Method Class Alert type
3000 Service disconnected from OPC DisconnectOPCServer OPCMethods
3001 ExecuteSQLWrite DBCommunicator
3002 OPC_Read was called Read OPC_Read
3003 SQL delete from backup device after having uploaded result Write SQL
3004 Data device Write result: 1 (success), writing to responseTag: 1 Write OPC_Read
3005 Last Config Activated ActivateLastConfig SQliteMethods
3006 OPC Writing details (columns and their values + reply values) Write OPC_Write
3007 Writing to responseTag: (responseToOpc) Write OPC_Write
3008 SQL execution result (OK/NOK) whether it has read from SQL Read SQL
3009 Client stopped the Trigger Process (reasonOfStopping received from client) StreamWithClient PipeClientStream
3010 Service pipe waiting for a connection ServerThread ServerSetup
3011 Client disconnected, currently connected Clients: (count) SubtractThread ThreadHandler
3012 Result of creating SQLiteDatabase(exists/created/error) OnStart Service1
3013 Configs in SQlite : (configCount) OnStart Service1
3014 No config found in service OnStart Service1
3015 "Trigger tag of (GroupName) is triggered" ExecuteTriggerProcess TriggerProcess
3016 OPC Connection status: Service is connected to OPC Server ConnectToOPC OPCMethods
3017 Try to reupload Write SQL
3018 Uploaded all data to SQL, no more in backup Write SQL
3019 The previous value/status of uploading result to database Read TriggerProcess
3020 Writing response value to Controller device (success) Write OPC_Read
3021 Writing response value to Controller device (after fail to store to backup or to read values from opc) read OPC_Read
3022 writing respone value to Controller device after succesful storing in backup device Write OPC_Read
3023 Writing 2(error) to response tag, backup is not enabled and using Gateway response values Write OPC_Read
3024 writing error to response tag, due to a datadevice error WriteNonGatewayResponse OPC_read
3025 writing error to response tag, due to datadevice Connection fail WriteNonGatewayResponse OPC_Read
3026 writing error to responsetag after failing to read from OPC WriteNonGatewayResponse OPC_Read
3027 writing error to responsetag after failing to store in backup WriteNonGatewayResponse OPC_Read
3028 Writing error to responsetag. Most likely an SQL stored procedure error(wrong or non existing), can also be an unknown error WriteNonGatewayResponse OPC_Read
3029 There is no Project in configuration for service to load StartProcess TriggerProcess 1
3030 Cannot read values from Controller device, going to next iteration ExecuteTriggerProcess TriggerProcess 1
3031 File device renamed file after performing trigger action HandleActionFile FileHandler
3032 File device moved file after performing action HandleActionFile FileHandler
3033 File device: Deleted file after using it, as specified in file config. HandleActionFile FileHandler
3034 Restarted upload processes (from backup to datadevice) RestartUploadProcess TriggerProcess
3035 Stored data to backupdevice after X time Write SQLite
3036 Group(group name) Writing to OPC response tag: (response) Write OPC_Write
3037 Group read from backup, prepare to upload to SQL Write SQL
3038 Putting responsetag to 0 because trigger not validated Write OPC_Read
3039 Group(groupname) Inserted value to SQLite (grouppropertiesmodel.items[2].controllervalue) Write SQLite
3040 Backup device is empty, stopping upload process until next trigger/start Write SQL
3041 License status received: (licStatus) StreamWithClient PipeClientStream
3042 Created SQLite backup file CreateBackupSqlite SQLiteHandler
3043 Created SQLite UploadProcess file CreateUploadProcessSQLite SQLiteHandler
3044 Group(groupname) writing (x) to response tag, while data upload was not succesful