Analysis Hierarchy Labels - Output Payload Overview

The following shows the output payload from a successful run:

<?xml version="1.0" encoding="UTF-8" ?>
<SSC>
    <User>
        <Name>PKP</Name>
    </User>
    <SunSystemsContext>
        <BusinessUnit>PKP</BusinessUnit>
    </SunSystemsContext>
    <Payload>
        <AnalysisHierarchyLabels status="success" Reference="1">
            <AnalysisHierarchyLabel>AHL001</AnalysisHierarchyLabel>
            <AnalysisCatID>
                <AnlCat_SHead>PRODUCT</AnlCat_SHead>
            </AnalysisCatID>
            <AnalysisHierarchyCodes>
                <AnalysisHierarchyCode>AHLC001</AnalysisHierarchyCode>
            </AnalysisHierarchyCodes>
        </AnalysisHierarchyLabels>
    </Payload>
</SSC>

It shows that the execution of the payload was successful and the data values that were used to update the database.

Failed Execution

The following shows the output payload from a run in which an error was generated:

<?xml version="1.0" encoding="UTF-8" ?>
<SSC>
    <User>
        <Name>PKP</Name>
    </User>
    <SunSystemsContext>
        <BusinessUnit>PKP</BusinessUnit>
    </SunSystemsContext>
    <Payload>
        <AnalysisHierarchyLabels status="fail" Reference="1">
            <AnalysisDimension>11</AnalysisDimension>
            <AnalysisHierarchyLabel>AHL064</AnalysisHierarchyLabel>
            <DateTimeLastUpdated>01212003</DateTimeLastUpdated>
            <Description>AHL064</Description>
            <LookupCode>AHL064</LookupCode>
            <ShortHeading>AHL064</ShortHeading>
            <Status>0</Status>
            <UpdateCount>0</UpdateCount> 
            <UserIdLastUpdated>PKP</UserIdLastUpdated>
            <AnalysisCatID>
                <AnlCat_SHead>PRODUCT</AnlCat_SHead>
            </AnalysisCatID>
            <AnalysisHierarchyCodes>
                <AnalysisDimension>11</AnalysisDimension>
                <AnalysisHierarchyCode>AHLC004</AnalysisHierarchyCode>
                <AnalysisHierarchyLabel>AHL064</AnalysisHierarchyLabel>
                <DateTimeLastUpdated>01012003</DateTimeLastUpdated>
                <Description>AHLC004</Description>
                <LookupCode>ACBDEFGHIJKLMNOPQRSTUVWXYZ</LookupCode>
                <ShortHeading>AHLC004</ShortHeading>
                <Status>0</Status>
                <UpdateCount>0</UpdateCount>
                <UserIdLastUpdated>PKP</UserIdLastUpdated>
            </AnalysisHierarchyCodes>
        </AnalysisHierarchyLabels>
    </Payload>
    <ErrorMessages>
        <Message>
            <PayloadRef>1</PayloadRef>
            <UserText>
                <![CDATA[ The value 'ACBDEFGHIJKLMNOPQRSTUVWXYZ' is too long for the current item.

]]>
            </UserText>
            <Exception>
                <![CDATA[
com.systemsunion.JBO.common.datavalue.DataValueTooLongException:
The value 'ACBDEFGHIJKLMNOPQRSTUVWXYZ' is too long for the current item.
at com.systemsunion.JBO.common.datavalue.StringDataType.setValue(Unknown Source)
at com.systemsunion.JBO.common.datavalue.String15.<init>(Unknown Source)
at com.systemsunion.JBO.common.datavalue.LookupCode.<init>(Unknown Source)
at com.systemsunion.JBO.analysishierarchylabels.AnalysisHierarchyLabelsDataConverter.
lookupCodeFromObject(Unknown Source)
at com.systemsunion.JBO.common.datavalue.LookupCode.fromObject(Unknown Source)
at com.systemsunion.JBO.common.datavalue.DataValueType.valueFromObject(Unknown Source)
at com.systemsunion.JBO.SSC.dataimport.BaseBuilder.createItemValuesHelper(Unknown Source)
at com.systemsunion.JBO.SSC.dataimport.BaseBuilder.createItemValues(Unknown Source)
at com.systemsunion.JBO.SSC.dataimport.BaseBuilder.createItemValues(Unknown Source)
at com.systemsunion.JBO.SSC.dataimport.BaseBuilder.processRecord(Unknown Source)
at com.systemsunion.JBO.SSC.dataimport.BaseBuilder.buildValueObject(Unknown Source)
at com.systemsunion.JBO.SSC.dataimport.Importer.importRecord(Unknown Source)
at com.systemsunion.JBO.SSC.dataimport.Importer.importData(Unknown Source)
at com.systemsunion.SSTS.components.business.analysishierarchylabels.
AnalysisHierarchyLabelsImport.execute(AnalysisHierarchyLabelsImport.java:62)
at com.systemsunion.SSTS.drivers.DJI.DJIMethod.execute(Unknown Source)
at com.systemsunion.SSTS.drivers.DJI.DJIDriver.execute(Unknown Source)
at com.systemsunion.SSTS.streaming.ExecutionFilter.execute(Unknown Source)
at com.systemsunion.util.streaming.AbstractFilter.execute(Unknown Source)
at com.systemsunion.util.streaming.AbstractStreamBase$1.run(Unknown Source)
at java.lang.Thread.run(Thread.java:536)]]>
             </Exception>
         </Message>
     </ErrorMessages>
</SSC>

The example above illustrates that the execution of the payload failed and the runtime data values that were used.

The component assigned a payload failure reference (<AnalysisHierarchyLabels status="fail" Reference="1">) to the particular error allows you to find failing payload records if there are multiple records present. The error message text for this failure was written to the <ErrorMessages> element with the failure payload reference, allowing you to easily cross reference a particular error message with its matching payload record. In the example shown, the component reported that there were too many characters specified in the LookUp element.

Note: Although not shown in the example, the component does not stop executing when a data error is encountered. In the case of multiple payload records, the component will issue an error message and will then attempt to process the next payload record, assuming one exists.