• Font Size
  • S
  • M
  • L

Search via FAQ No.


  • No : 30697
  • Open Date : 2019/08/30 15:51
  • Print
NEW

[DataSpider Servista] Please tell me how to check the SAP table query adapter execution result

How can I check the SAP Table Query Adapter execution result?
 
Category : 

Answer

How to Check
 
The SAP Table Query Adapter execution result is roughly divided into the following three log files:
  • A log of scripts that are executed using the SAP Table Query Adapter component
  • A log of the Configuration Tool that is executed
  • A log of errors that occurred in Configuration Tool
Please check each log below.
  • Log when executing scripts (XML log)
It is output to the following directory:
$ DATASPIDER_HOME / server / logs / <date directory (yyyyMMdd)> / execution
  • Log when executing Configuration Tool (CONFIGURATION_TOOL.log)
It is output to the directory specified in the following SAP table query log configuration file:
$ DATASPIDER_HOME / SAPTableQueryAdapter / etc / log4j.properties
Key: log4j.appender.CP_ET.File
 
If you keep the default settings, it is output to the following directory:
$ DATASPIDER_HOME / SAPTableQueryAdapter / log
  • The Configuration Tool Error Log (CONFIGURATION_TOOL_ERROR.log)
It is output to the directory specified in the following SAP table query log configuration file:
$ DATASPIDER_HOME / SAPTableQueryAdapter / etc / log4j.properties
Key: log4j.appender.CP_ET_ERROR.File
 
If you keep the default settings, it is output in the following directory:
$DATASPIDER_HOME/SAPTableQueryAdapter/errlog
 
■Supplementary
 
The log of when executing Configuration Tool can output more detailed information by changing the value of the log setting file. Please change the setting if you want to check the processing status in more detail.
 
$ DATASPIDER_HOME / SAPTableQueryAdapter / etc / log4j.properties
Key: log4j.category.CP_ET_BATCH
 
The key value is set as INFO by default as follows:
log4j.category.CP_ET_BATCH = INFO, CP_ET_BATCH
 
You can change the content of the log output by changing the INFO part above. If you want to output the most detailed log, please specify the DEBUG as follows:
log4j.category.CP_ET_BATCH = DEBUG, CP_ET_BATCH
 
Reference Information
 
・Log Guide