#__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')