Filter
Top Products
8
DB CONNECTION SERVICE AND SETTING TOOL
8.8 Output Log Specifications
8.8.1 Access log
8
- 28
1
OVERVIEW
2
SYSTEM
CONFIGURATION
3
SPECIFICATIONS
4
SETTINGS AND
PROCEDURE TO
OPERATION
5
INSTALLATION AND
UNINSTALLATION
6
FUNCTIONS
7
MES INTERFACE
FUNCTION
CONFIGURATION TOOL
8
DB CONNECTION
SERVICE AND
SETTING TOOL
(d) COMMIT
(e) ROLLBACK
(f) GetNext (Request for next record)
(g) DELETE
(5) Stored procedure reception/processing results
Table 8.20 COMMIT
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:COMMIT:Success
When failed
[Date] [Error code] SID [Session ID]:COMMIT:Failed
Database Message [Database error number] [Database error message]
Example
When
succeeded
2007/10/01 12:00:00.000 0x00000000 SID 00000001:COMMIT:Success
Table 8.21 ROLLBACK
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:ROLLBACK:Success
When failed
[Date] [Error code] SID [Session ID]:ROLLBACK:Failed
Database Message [Database error number] [Database error message]
Example
When
succeeded
2007/10/01 12:00:00.000 0x00000000 SID 00000001:ROLLBACK:Success
Table 8.22 GetNext (Request for next record)
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:GetNext:Success
When failed
[Date] [Error code] SID [Session ID]:GetNext:Failed
Database Message [Database error number] [Database error message]
Example
When
succeeded
2007/10/01 12:00:00.000 0x00000000 SID 00000001:GetNext:Success
Table 8.23 DELETE
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:Success([No. of deleted records])
When failed
[Date] [Error code] SID [Session ID]:SQL<[SQL text]>:Failed
Database Message [Database error number] [Database error message]
Example
When
succeeded
2007/10/01 12:00:00.000 0x00000000 SID 00000001:SQL<DELETE FROM TABLE;>:Success(1)
When failed
2007/10/01 12:00:00.000 0x20600023 SID 00000c60:SQL<DELETE FROM table1 ;>:Failed
Database Message 0x000003ae [Oracle][ODBC][Ora]ORA-00942: table or view does not exist.
Table 8.24 Stored procedure execution reception/processing results
Item Description
Output
log format
When
succeeded
[Date] [Error code] SID [Session ID]:Procedure<[Procedure name] ([Value in argument 1][, Value in argument
2][, ...])>:Success ([Return value])
When failed
[Date] [Error code] SID [Session ID]:Procedure<[Procedure name] ([Value in argument 1][, Value in argument
2][, ...])>:Failed ([Return value])
Database Message[Database error number][Database error factor message]
Example
When
succeeded
2013/10/01 12:00:00.000 0x00000000 SID 00000e14:Procedure<StoredProcedure1 ( '10', '0','0' )>:Success(0)
When failed
2013/10/01 12:00:00.000 0x20f00007 SID 00000794:Procedure<StoredProcedure1>:Failed
Database Message 0x00000afc [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
procedure 'StoredProcedure1'.