#__AW_Repository_Version '12.1.0.0000';
#__AW_Product_Version '12.1.1.3';
#__AW_ATL_Locale 'eng_gb.utf-8';
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Aug 31 11:01:47 2009' , "ActaName_3" = 'RDate_modified' , "ActaValue_3" = 'Mon Aug 31 13:21:28 2009', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '43', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
CREATE __AL_MESSAGE DATASTORE eAccount_Test::'86346c1e-9f19-4a0b-bed6-a650da02d662' ( ApplicationArea al_nested_table ( MessageID varchar(1024) SET("Native Type" = 'String',
"XML Type" = 'ELEMENT') ,
CreationDateTime datetime SET("Native Type" = 'DateTime',
"Required" = 'No',
"XML Type" = 'ELEMENT') ,
Verb varchar(1024) SET("Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ,
Noun varchar(1024) SET("Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ,
SenderID varchar(1024) SET("Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ,
CorrelationID varchar(1024) SET("Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ,
Status varchar(1024) SET("Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ,
Errors al_nested_table ( Error al_nested_table ( ErrorId varchar(1024) SET("Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ,
ErrorType varchar(1024) SET("Native Type" = 'String',
"XML Type" = 'ELEMENT') ,
ErrorDescription varchar(1024) SET("Native Type" = 'String',
"XML Type" = 'ELEMENT') ,
ErrorInstanceID varchar(1024) SET("Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ,
"DateTime" datetime SET("Native Type" = 'DateTime',
"XML Type" = 'ELEMENT') ,
AdditionalInformation varchar(1024) SET("Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ) SET("Maximum Occurrence" = 'unbounded',
"Minimum Occurrence" = '1') ) SET("Maximum Occurrence" = 'unbounded',
"Minimum Occurrence" = '0',
"Optional Table" = 'Yes') ,
UserArea al_nested_table ( ) SET("Maximum Occurrence" = '1',
"Minimum Occurrence" = '0',
"Optional Table" = 'Yes') ,
SecurityCredentials al_nested_table ( Username varchar(1024) SET("Native Type" = 'String',
"XML Type" = 'ELEMENT') ,
Password varchar(1024) SET("Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ) SET("Maximum Occurrence" = '1',
"Minimum Occurrence" = '0',
"Optional Table" = 'Yes') ) SET("Maximum Occurrence" = '1',
"Minimum Occurrence" = '1') ,
DataArea al_nested_table ( "Load" al_nested_table ( Status varchar(1024) SET("Enumeration" = 'Success|Failure',
"Native Type" = 'String',
"Required" = 'No',
"XML Type" = 'ELEMENT') ,
ProcessType varchar(1024) SET("Native Type" = 'String',
"XML Type" = 'ELEMENT') ) SET("Maximum Occurrence" = 'unbounded',
"Minimum Occurrence" = '1') ) SET("Maximum Occurrence" = '1',
"Minimum Occurrence" = '0',
"Optional Table" = 'Yes') )
SET ("ACTA_INCLUDE_E:\\eAccount\\XSD\\ETLProcessSchema0.1.xsd" = '
Notifcation for Load completion
Confirms Load Process
This element defines Load
The complex type to notify that ETL process has completed
Defines Success or Failure Complex Type
This complex type confirms receipt of notify message to ETL tool
This complex type defines load type
SUCESS/FAILURE
Process e.g FA_SETTLEMENT
',
"ACTA_INCLUDE_XISCommonTypes0.3.xsd" = '
This segment will contain any credentials related to security. At present, it only contains Username and Password elements that plain, open text. It is recognised that this is NOT SECURE and as such must be replaced prior to any components being used in a Production environment. However, these elements are required at present to aid development.
Header Information Complex Type
Error Complex Type
unique error identifier
Denotes the type of ErrorCode used e.g System,Applciation,Business,Interface etc
A human-readable description of the error that has occured.
Identifies a single instance of the error. Will allow to keep track of the error instance across all layers of the architecture.
Time Error Occurred
Additional Info like stack trace etc
Error Details
Collection of Error Complex Type
Errors Details
Consistent header structure
Unique identifier of this message.
Date/Time this message was created.
Verb of this Business Object (i.e: Get, Create, Delete, Sync, etc)
Noun of this Business Object (i.e: Technical Account,Document, Policy, Person, etc)
Unique Identifier of the Sender of this message.
MessageID of original message (i.e: if this message is a response to an original request this will contain the MessageID from the request message).
Indicates whether this message is a positive ("Ack") or negative ("Nak") acknowledgement
Contains any errors relating to a Status = "Nak".
Extendable area for sending any Application Area data within this message. Note: The contents of the UserArea will not be validated.
Security Credentials
',
"DEFAULT_VARCHAR_SIZE_IN_IMPORTED_XML_DEFINITION" = '1024',
"DTD2NRDM_CIRCULAR_LEVEL" = '0',
"DTDRootElement" = 'NotifyLoad',
"IsDTD" = 'no',
"is_xml_schema" = 'yes',
"message_type" = 'xml',
"schema_file" = 'E:\\eAccount\\XSD\\ETLProcessSchema0.1.xsd',
"schema_string" = '
' );ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Aug 31 18:50:36 2009' )
CREATE SESSION Job_Web_Service_Test::'9ee8b7d3-665f-4968-91ff-e1fcb2128c57'( )
BEGIN
ALGUICOMMENT( x = '959', y = '-603' )
CALL DATAFLOW DF_Web_Service_Test::'b8ccc98a-0276-48be-b503-e116edae5b96'();
END
SET("job_checkpoint_enabled" = 'no',
"job_collect_statistics" = 'no',
"job_collect_statistics_monitor" = 'no',
"job_enable_assemblers" = 'yes',
"job_enable_audit" = 'yes',
"job_enable_dataquality" = 'yes',
"job_export_repo" = 'no',
"job_guid" = '9ee8b7d3-665f-4968-91ff-e1fcb2128c57',
"job_isrecoverable" = 'no',
"job_mode" = 'Multi-Process',
"job_monitor_sample_rate" = '1000',
"job_name" = 'Job_Web_Service_Test',
"job_print_version" = 'no',
"job_testmode_enabled" = 'no',
"job_trace_abapquery" = 'no',
"job_trace_all" = 'no',
"job_trace_ascomm" = 'no',
"job_trace_assemblers" = 'no',
"job_trace_audit" = 'no',
"job_trace_dataflow" = 'yes',
"job_trace_idoc_file" = 'no',
"job_trace_memory_loader" = 'no',
"job_trace_memory_reader" = 'no',
"job_trace_optimized_dataflow" = 'no',
"job_trace_parallel_execution" = 'no',
"job_trace_rfc_function" = 'no',
"job_trace_row" = 'no',
"job_trace_script" = 'no',
"job_trace_session" = 'yes',
"job_trace_sql_only" = 'no',
"job_trace_sqlfunctions" = 'no',
"job_trace_sqlloaders" = 'no',
"job_trace_sqlreaders" = 'no',
"job_trace_sqltransforms" = 'no',
"job_trace_stored_procedure" = 'no',
"job_trace_table" = 'no',
"job_trace_table_reader" = 'no',
"job_trace_transform" = 'no',
"job_trace_userfunction" = 'no',
"job_trace_usertransform" = 'no',
"job_trace_workflow" = 'yes',
"job_type" = 'batch',
"job_use_statistics" = 'yes',
"locale_codepage" = '',
"locale_language" = '',
"locale_territory" = '')
ALGUICOMMENT( x = '-1', y = '-1' )
CREATE DATAFLOW DF_Web_Service_Test::'b8ccc98a-0276-48be-b503-e116edae5b96'
BEGIN
ALGUICOMMENT( x = '350', y = '-412', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '43', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
GUID::'5c8ae375-668a-4a15-a9dc-7a341cdb6d35' READ __AL_MESSAGE eAccount_Test OUTPUT ( eAccount_Test ) SET (
"DTDRootElement" = 'NotifyLoad',
"DTDValidation" = 'no',
"idoc_reader_file" = 'no',
"reader_filename_col" = 'DI_FILENAME',
"reader_filename_col_size" = '100',
"reader_filename_only" = 'no',
"reader_include_filename" = 'no',
"table_weight" = '0',
"xml_reader" = 'yes');
ALGUICOMMENT( x = '656', y = '-531' , ui_acta_from_schema_0 = 'eAccount_Test' , UpperContainer_HeightProp = '50', InputSchema_WidthProp = '43', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
GUID::'42895e4c-7c33-4a84-b884-ae6f4efbd06b' CREATE VIEW Query ( "DS_WebService_Test..NotifyLoad" al_rfc_schema_group ( ConfirmLoad varchar(1024) SET("Native Type" = 'String',
"XML Type" = 'ELEMENT') ,
AL_ERROR_NUM int,
AL_ERROR_MSG varchar(255) ) )
AS SELECT &ERROR('__AL_TRAN_FUNCTION DS_WebService_Test..NotifyLoad () ')
FROM eAccount_Test SET (
"distinct_run_as_separate_process" = 'no',
"group_by_run_as_separate_process" = 'no',
"join_run_as_separate_process" = 'no',
"order_by_run_as_separate_process" = 'no',
"run_as_separate_process" = 'no');
ALGUICOMMENT( x = '1203', y = '-562', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '43', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
GUID::'059ab92b-fa69-41b5-b637-808184db8884' LOAD TABLE class_triggers_ds.CLASS_TRIGGERS.TMP_WEB_SERVICE_TEST INPUT ( Query ) SET (
"connection_port" = 'no',
"ldr_configuration_enabled" = 'yes',
"ldr_configurations" = '
/127
yes
100000
10
append
1000
,
no
yes
no
no
compare_by_name
yes
yes
append
1
overflow_file
0
no
0
no
no
1000
yes
None
None
None
API
File
None
append
write_data
no
no
',
"loader_template_table" = 'yes',
"name" = 'class_triggers_ds',
"use_unicode_varchar" = 'no');
END
SET("Cache_type" = 'pageable_cache',
"Parallelism_degree" = '0',
"allows_both_input_and_output" = 'yes',
"run_once" = 'no',
"use_dataflow_links" = 'no',
"use_datastore_links" = 'yes',
"validation_xform_exists" = 'no',
"validation_xform_stats" = 'no')