Item name |
Required / Optional |
Use of Variables |
Description |
Remarks |
Type |
Required |
Not available |
Select SAP Query or SAP Table.
-
[QUERY]:(Default)
-
[TABLE]:
|
-
The operation that you select another one makes the following values initialization.
-
[CONFIG ID]
-
[CONFIG TEXT]
-
[Item List]
-
[Execution Parameters]
-
[Definition]
-
[Conditions]
|
CONFIG ID |
Required |
Not available |
Select a ID. |
-
Choosing another ID makes the following values initialization.
-
[Variable Parameters / Value]
|
CONFIG TEXT |
- |
- |
The description of [CONFIG ID] you specified is displayed. |
|
Item List |
Required |
- |
Output fields are displayed. |
|
Field Name(Technical Name) |
Required |
Not available |
Each field name is displayed. |
- Field name displayed in [Item List] is displayed in schema of Mapper.
|
Description(Text) |
Required |
Not available |
Each field description is displayed. |
|
Component variable name |
Description |
Remarks |
count |
The number of retrieving the data from SAP system. |
- The value defaults to null.
- If error occurs, 0 is returned.
|
loginId |
Login ID in Configuration Tool |
- The value defaults to null.
|
tableName |
table name |
- The value defaults to null.
- if [Type] is [QUERY], an empty string is returned.
|
userGroup |
user group |
- The value defaults to null.
- if [Type] is [TABLE], an empty string is returned.
|
queryName |
SAP query name |
- The value defaults to null.
- if [Type] is [TABLE], an empty string is returned.
|
variant |
variant |
- The value defaults to null.
- if [Type] is [TABLE], an empty string is returned.
|
message_category |
Stroes the category to which corresponding message code belongs to, when an error occurs. |
- The value defaults to null.
|
message_code |
Stores its corresponding message code of occured error. |
- The value defaults to null.
|
message_level |
Stores the severity of the corresponding message code of the occured error. |
- The value defaults to null.
|
error_type |
Returns the error type when error occurred.
java.io.FileNotFoundException format. |
- The value defaults to null.
- If no error occurred, returns null.
- The contents may change depending on version.
|
error_message |
Returns the error message when error occurred. |
- The value defaults to null.
- The contents may change depending on version.
|
error_trace |
Returns trace information when error occurred. |
- The value defaults to null.
- The contents may change depending on version.
|
Exception name |
Causes |
Solution |
InvalidConfigIdException No CONFIG ID found. CONFIG ID:<CONFIG ID> |
The tool failed to get [CONFIG ID] with specified ID. |
Please check out the [CONFIG ID]. |
InvalidConfigIdException Invalid CONFIG ID found. CONFIG ID:<CONFIG ID> |
The [CONFIG ID] is invalid.
|
-
in case of [QUERY] in [Type]
Check permissions on the following directories.
-
Windows
$DATASPIDER_HOME\SAPTableQueryAdapter\config\query
-
UNIX/Linux
$DATASPIDER_HOME/SAPTableQueryAdapter/config/query
-
in case of [TABLE] in [Type]
Check permissions on the following directories.
-
Windows
$DATASPIDER_HOME\SAPTableQueryAdapter\config\table
-
UNIX/Linux
$DATASPIDER_HOME/SAPTableQueryAdapter/config/table
|
ExecuteCommandFailedException Process canceled. Code:<value> |
This adapter failed to connect to SAP system.
This adapter found invalid parameters in [Execution Parameters], and so on. |
Check execute logs in My log of DataSpider Studio. |