Access Log - Mitsubishi Electric GOT 1000 Series Manual

7.8.1

Access log

The following explains the access log contents.
(1) Service start/end
(a) Start
Item
Output log format
Example
(b) End
Item
Output log format
Example
(2) Connection/disconnection from the GOT
(a) Connection
Item
Output log format
Example
(b) Disconnection
Item
Output log format
Example
(3) Connection/disconnection to a database
(a) Connection
Item
Output log format
Example
*1
(b) Disconnection
Item
Output log format
Example
*1
(4) SQL text reception/processing results
(a) SELECT
Item
Output log format
Example
*2
(b) UPDATE
Item
Output log format
Example
*3
7 - 20 7.8 Output Log Specifications
[Date] [Error code] Service Start
2005/07/01 12:00:00.000 0x00000000 Service Start
[Date] [Error code] Service Stop
2005/07/01 12:00:00.000 0x00000000 Service Stop
[Date] [Error code] SID [Session ID]:MIFWS Connected:[Source IP]:[Target data source]:
[Connection ID]
2005/07/01 12:00:00.000 0x00000000 SID 0:MIFWS Connected:192.168.3.3:DataSource:ID
[Date] [Error code] SID [Session ID]:MIFWS Disconnected:[Source IP]:[Target data source]:[Connection ID]
2005/07/01 12:00:00.000 0x00000000 SID 0:MIFWS Disconnected:192.168.3.3:DataSource:ID
[Date] [Error code] SID [Session ID]:DB Connect:[Target data source]: [Connection ID]:[Connection result
2005/07/01 12:00:00.000 0x00000000 SID 0:DB Connect:DataSource:ID:Success
When succeeded: Success, when failed: Failed
[Date] [Error code] SID [Session ID]:DB Disconnect:[Target data source]: [Connection ID]:[Disconnection result
2005/07/01 12:00:00.000 0x00000000 SID 0:DB Disconnect:DataSource:ID:Success
When succeeded: Success, when failed: Failed
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:[Processing result
2005/07/01 12:00:00.000 0x00000000 SID 0:SQL<SELECT COL from TABLE;>:Success(1)
When succeeded: Success ([No. of selected records]), when failed: Failed (Line feed) Database message
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:[Processing result
2005/07/01 12:00:00.000 0x00000000 SID 0:SQL<UPDATE TABLE SET COL = '';>:Success(1)
When succeeded: Success ([No. of updated records]), when failed: Failed (Line feed) Database message
Description
Description
Description
Description
Description
Description
Description
*2
]([No. of selected records])
Description
*3
]([No. of updated records])
*1
]
*1
]