Execute Job

Operation Name

Execute Job

Function Overview

Batch execute job for Microsoft Azure Machine Learning.

Data Model

XML type.

For input/output schema, refer to "Schema".

Properties

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter the name to show on the script canvas.

Required settings

Item name	Required/Optional	Use of variables	Description	Remarks
Destination	Required	Not available	Select a global resource. [Add]: Adds a new global resource. [Edit list]: Enables to edit the global resource settings in the "Edit resource list".
Wait for completion of job execution	Optional	Not available	Select whether to wait for completion of job execution or not. [Checked]:(default) Waits for processing until completing execution of job. [Not Checked]: Not waits but goes on to the following process when having been sent a job execution request.	If waiting for completion of job execution, output element of output schema can be gotten in following processes. Also, if not waiting for completion of job execution, output element of output schema cannot be gotten in following processes.
Specify BLOB which is passed to Web service input	Optional	Not available	Select whether to specify BLOB which is passed to Web service input or not. [Checked]:(default) Specifies BLOB which is passed to Web service input. [Not Checked]: Not specify BLOB which is passed to Web service input.	Check if there is Web service input in a target job.
BLOB storage to use	Required	Not available	Select a global resource of BLOB storage. [Add]: Adds a new global resource. [Edit list]: Enables to edit the global resource settings in the "Edit resource list".	If [Specify BLOB which is passed to Web service input] is checked, it is enabled.
BLOB path starting from container name	Required	Available	Specify a BLOB path starting from container name and in which job input is stored.	If [Specify BLOB which is passed to Web service input] is checked, it is enabled.

Global parameter settings

Item name	Required/Optional	Use of variables	Description	Remarks
Global parameters	Optional	-	Set global parameters of the job. Each column can be operated by following buttons. [Add]: Adds a column. [Up]: Moves the order of the selected column upwards by one. [Down]: Moves the order of the selected column downwards by one. [Delete]: Deletes a column.
Global parameters/Key	Required	Available	Enter key name of global parameter.	It corresponds with <KEY> of Sample Request Payload of API "{ "GlobalParameters": { "<KEY>": "<VALUE>" } }".
Global parameters/Value	Optional	Available	Enter value of global parameter.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this adapter. The description will be reflected in the specifications.

Schema

Input Schema

None.

Output Schema

<?xml version="1.0"?>
<job job_id="" status_code="" >
  <output output_id="" base_location="" relative_location="" sas_blob_token="" >
  </output>
</job>

Element name	Attribute name	Description	Remarks
job	-
	job_id	This is the ID issued in Azure Machine Learning server.
	status_code	State of the executed Job.
output	-	Appears every output of job.	If [Wait for completion of job execution] is checked, it can be gotten.
	output_id	The output name of output Job result.
	base_location	The endpoint URL of output BLOB storage.
	relative_location	The BLOB path starting from container name of output BLOB storage.
	sas_blob_token	The SAS BLOB token of output BLOB.

Loading Schema on Mapper

Schema is loaded automatically.

For details, refer to "Edit schema".

Transaction

Transaction is not supported.

PSP Usage

PSP is not supported.

Available Component Variables

Component variable name	Description	Remarks
message_category	Stores the category of message code corresponding to the occurred error.	Default value is null.
message_code	Stores the code of message code corresponding to the occurred error.	Default value is null.
message_level	Stores the severity of message code corresponding to the occurred error.	Default value is null.
error_type	Stores the error type of occurred error.	Default value is null. Error is represented in the format depicted below. Example:java.io.FileNotFoundException The value may vary depending on the DataSpider Servista version.
error_message	Stores the error message of occurred error.	Default value is null. The value may vary depending on the DataSpider Servista version.
error_trace	Stores the trace information of occurred error.	Default value is null. The value may vary depending on the DataSpider Servista version or the client application used.

Specification Limits

For executing job with this adapter, it is required to deploy Web service of Microsoft Azure Machine Learning.
Operation limits such as job execution for Microsoft Azure Machine Learning and access control of data rely on settings of Microsoft Azure Machine Learning and API specification.
Parameters and items which are able to be dealt differ depending on API version. For more details, refer to the documents of Microsoft Azure Machine Learning.

Main Exceptions

Exception name	Cause	Solution
ResourceNotFoundException Resource definition could not be found. Name:[]	[Destination] or [BLOB storage to use] is not specified.	Specify [Destination] or [BLOB storage ot use].
ResourceNotFoundException Resource definition could not be found. Name: [<Global resource name>]	Resource definition chosen in [Destination] or [BLOB storage to use] could not be found.	Check global resource specified in [Destination] or [BLOB storage to use].
InvalidPropertyConfigurationException <Property name> is required.	[<Property name>] is not specified.	Specify [<Property name>].
AzureMachineLearningException Unauthorized: Request is unauthorized to access resource. ScoreRequestUnauthorized: Invalid credentials provided.	[Destination] is invalid.	Check the settings of [Location], [Workspace ID], [Service ID], and [API Key] of the global resource specified in [Destination].
AzureMachineLearningException Please ensure all input data is specified and try again.	[Specify BLOB which is passed to Web service input] is not specified.	Specify [Specify BLOB which is passed to Web service input].
AzureMachineLearningException Reason: The remote name could not be resolved: '<endpoint>'.	[BLOB storage to use] is wrong.	Check [Account] specified in [BLOB storage to use].
AzureMachineLearningException Reason: The remote server returned an error: (403) Forbidden..	[BLOB storage to use] is invalid.	Check [Access key] specified in [BLOB storage to use].
AzureMachineLearningException Reason: The specified blob <BLOB path> does not exist. Please provide a valid blob reference.	[BLOB path starting from container name] is wrong.	Check BLOB path and container name specified in [BLOB path starting from container name].
AzureMachineLearningException Supported file extensions for this output type are: ".csv, .tsv, .arff".	The extension of BLOB specified in [BLOB path starting from container name] is not supported.	Check an extension of BLOB specified in [BLOB path starting from container name].
AzureMachineLearningException Verify the parameter(s) expected for the module(s) are correct and try again.	[Global parameter] is invalid.	Check settings of [Key] and [Value] specified in [Global parameter].
AzureMachineLearningException InternalError: Internal error occurred.	Failed to start job.	Check whether unavailable character is included in the BLOB path specified in [BLOB path starting from container name]. Confirm that subscription of Microsoft Azure is valid.
AzureMachineLearningException Internal Server Error	Failed to start job.	Check settings of [Workspace ID] of the global resource sepcified in [Destination].
AzureMachineLearningException Exceptions other than the above	Failed to execute job.	Check settings of [Key] and [Value] specified in [Global parameter].

Notes

HTTPS is used in the communication between Azure Machine Learning and this adapter.
Specification might change without notice by specification change of Azure Machine Learning.
If [Wait for completion of job execution] is not checked, it finishes normally without script exection error even if error occurs during job execution of Microsoft Azure Machine Learning.