Filter
Top Products
8
- 31
8.8 Output Log Specifications
8.8.2 SQL failure log
8
DB CONNECTION SERVICE AND SETTING TOOL
8.8.2 SQL failure log
When an SQL text or stored procedure is executed on a database, if an error occurs, the
error contents are output to the SQL failure log.
The following shows the SQL failure log contents
For details on [Database error number] and [Database error message] in the output log
format, refer to the manual for each database.
Depending on the [Error code], however, Database Message and subsequent data cannot
be output.
According to the error code, confirm the error details and take corrective actions.
Section 10.2.2 (3) SQL failure log of DB Connection Service
(1) SQL execution failed
(2) Stored procedure execution failed
Table 8.32 SQL execution failed
Item Description
Output log format
[Date] [Error code] [Target data source]:[SQL text]
Database Message [Database error number] [Database error message]
Example
2007/10/01 12:00:00.000 0x00000000 DataSource:INSERT INTO TABLE ( COL ) VALUES ('') ;
Database Message 0x00000388 [Oracle][ODBC][Ora]ORA-00904: "COL" :invalid identifier
Table 8.33 Stored procedure execution failed
Item Description
Output log format
[Date] [Error code] [Target data source]:[Procedure name] ([Value in argument 1][, Value in argument 2][, ...])
Database Message [Database error number] [Database error message]
Example
2013/10/01 12:00:00.000 0x20f00007 SQLSERVER:SampleProcedure ( '003', 'MES' )
Database Message 0x00000afc [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
procedure 'SampleProcedure'.