I have a job that is designed to parse XML and write to a dataset. The job is based on another which is working fine, but the table definition has changed. I use the External Source stage to read in the XML source file. There are several namespaces declared.
When I run the job it fails, producing two Fatal messages - the last being a standard looking:
The one with most info (but not sadly not enough for me to debugmain_program: Creation of a step finished with status = FAILED.
![Confused :?](./images/smilies/icon_confused.gif)
There was a previous posting in 2004 with this exact error that came up in a search, but there were no replies to that.ParseXml: When processing argument -outlinkpropsWhen processing output link property list: {
accept_nulls=0,
replace_nulls=1,
discard_empty_values=1,
include_namespaces=1,
namespace_declaration='xmlns:ns1="http://myurl.com/Common/2008-01-18/" xmlns:defns="http://myurl.com/Organization/2008-01-15/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ns3="http://myurl.com/Envelope/2007-10-29/" xmlns:ns2="http://data.schemas.tfn.thomson.com/Common/2008-01-18/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"',
use_custom_xslt=0,
xslt_source='property',
xslt_text='text',
is_reject_link=0,
inherit_properties=0,
format_serialized_chunks=0,
DSDescription={organizationType='/defns:OrganizationType/@organizationType', organizationTypeCode='/defns:OrganizationType/@organizationTypeCode', organizationNameTypeCode='/defns:OrganizationNameType/@organizationNameTypeCode', organizationNameType='/defns:OrganizationNameType/@organizationNameType', organizationBusinessDescriptionTypeCode='/defns:OrganizationBusinessDescriptionType/@organizationBusinessDescriptionTypeCode', organizationBusinessDescriptionType='/defns:OrganizationBusinessDescriptionType/@organizationBusinessDescriptionType', unresolved='/ns2:Category/@unresolved', text='/ns2:Category/@text', OrganizationPublicPrivateCode='/defns:OrganizationPublicPrivateCode/text()', organizationPhoneType='/defns:OrganizationPhoneType/@organizationPhoneType', organizationPhoneTypeCode='/defns:OrganizationPhoneType/@organizationPhoneTypeCode', addressType='/defns:OrganizationAddressType/@addressType', addressTypeCode='/defns:OrganizationAddressType/@addressTypeCode', majorVersion='/ns3:ContentEnvelope/@majorVersion', publishingStyle='/ns3:ContentEnvelope/@publishingStyle', minorVersion='/ns3:ContentEnvelope/@minorVersion', Id='/ns3:ContentEnvelope/ns3:Header/ns3:Info/ns3:Id/text()', TimeStamp='/ns3:ContentEnvelope/ns3:Header/ns3:Info/ns3:TimeStamp/text()', Any='/ns3:ContentEnvelope/ns3:Header/*', Body.majorVersion='/ns3:ContentEnvelope/ns3:Body/@majorVersion', Body.minorVersion='/ns3:ContentEnvelope/ns3:Body/@minorVersion', contentSet='/ns3:ContentEnvelope/ns3:Body/@contentSet', action='/ns3:ContentEnvelope/ns3:Body/ns3:ContentItem/@action', EntitlementCode='/ns3:ContentEnvelope/ns3:Body/ns3:ContentItem/ns3:AuthorizationMetadata/ns3:ProductEntitlement/ns3:EntitlementCode/text()', ContentGroup='/ns3:ContentEnvelope/ns3:Body/ns3:ContentItem/ns3:AuthorizationMetadata/ns3:SourceEntitlement/ns3:ContentGroup/text()', ProductEntitlement.EntitlementCode='/ns3:ContentEnvelope/ns3:Body/ns3:ContentItem/ns3:PreviousAuthorizationMetadata/ns3:ProductEntitlement/ns3:EntitlementCode/text()', SourceEntitlement.ContentGroup='/ns3:ContentEnvelope/ns3:Body/ns3:ContentItem/ns3:PreviousAuthorizationMetadata/ns3:SourceEntitlement/ns3:ContentGroup/text()', organizationSubtypeCode='/defns:OrganizationSubtype/@organizationSubtypeCode', organizationSubtype='/defns:OrganizationSubtype/@organizationSubtype', organizationStatus='/defns:OrganizationStatus/@organizationStatus', organizationStatusCode='/defns:OrganizationStatus/@organizationStatusCode', entityCreatedDate='/defns:Organization/@entityCreatedDate', entityModifiedDate='/defns:Organization/@entityModifiedDate', OrganizationId='/defns:Organization/defns:OrganizationId/text()', languageCode='/defns:Organization/defns:OrganizationName/@languageCode', languageCultureCode='/defns:Organization/defns:OrganizationName/@languageCultureCode', effectiveFrom='/defns:Organization/defns:OrganizationName/@effectiveFrom', effectiveTo='/defns:Organization/defns:OrganizationName/@effectiveTo', OrganizationName.organizationNameTypeCode='/defns:Organization/defns:OrganizationName/@organizationNameTypeCode', languageScriptCode='/defns:Organization/defns:OrganizationName/@languageScriptCode', OrganizationName='/defns:Organization/defns:OrganizationName/text()', OrganizationAddress.addressTypeCode='/defns:Organization/defns:OrganizationAddress/@addressTypeCode', OrganizationAddressLine1='/defns:Organization/defns:OrganizationAddress/defns:OrganizationAddressLine1/text()', OrganizationAddressLine2='/defns:Organization/defns:OrganizationAddress/defns:OrganizationAddressLine2/text()', OrganizationAddressLine3='/defns:Organization/defns:OrganizationAddress/defns:OrganizationAddressLine3/text()', OrganizationAddressLine4='/defns:Organization/defns:OrganizationAddress/defns:OrganizationAddressLine4/text()', OrganizationAddressLine5='/defns:Organization/defns:OrganizationAddress/defns:OrganizationAddressLine5/text()', OrganizationAddressCity='/defns:Organization/defns:OrganizationAddress/defns:OrganizationAddressCity/text()', OrganizationAddressStateProvince='/defns:Organization/defns:OrganizationAddress/defns:OrganizationAddressStateProvince/text()', OrganizationAddressPostalCode='/defns:Organization/defns:OrganizationAddress/defns:OrganizationAddressPostalCode/text()', OrganizationAddressCountryCode='/defns:Organization/defns:OrganizationAddress/defns:OrganizationAddressCountryCode/text()', OrganizationPhone.organizationPhoneTypeCode='/defns:Organization/defns:OrganizationPhone/@organizationPhoneTypeCode', OrganizationPhone='/defns:Organization/defns:OrganizationPhone/text()', OrganizationBusinessDescription.languageCode='/defns:Organization/defns:OrganizationBusinessDescription/@languageCode', OrganizationBusinessDescription.languageCultureCode='/defns:Organization/defns:OrganizationBusinessDescription/@languageCultureCode', OrganizationBusinessDescription.organizationBusinessDescriptionTypeCode='/defns:Organization/defns:OrganizationBusinessDescription/@organizationBusinessDescriptionTypeCode', OrganizationBusinessDescription.languageScriptCode='/defns:Organization/defns:OrganizationBusinessDescription/@languageScriptCode', OrganizationBusinessDescription='/defns:Organization/defns:OrganizationBusinessDescription/text()', OrganizationWebsite='/defns:Organization/defns:OrganizationWebsite/text()', PublicPrivateFlag='/defns:Organization/defns:PublicPrivateFlag/text()', IpoDate='/defns:Organization/defns:IpoDate/text()', OrganizationInactiveDate='/defns:Organization/defns:OrganizationInactiveDate/text()', OrganizationFoundedYear='/defns:Organization/defns:OrganizationFoundedYear/text()', FiscalYearEnd='/defns:Organization/defns:FiscalYearEnd/text()', Organization.OrganizationTypeCode='/defns:Organization/defns:OrganizationTypeCode/text()', Organization.OrganizationStatusCode='/defns:Organization/defns:OrganizationStatusCode/text()', Organization.OrganizationSubtypeCode='/defns:Organization/defns:OrganizationSubtypeCode/text()'},
DSIsKey={Id=1},
DSDisplayWidth={organizationType=200, organizationTypeCode=50, organizationNameTypeCode=50, organizationNameType=200, organizationBusinessDescriptionTypeCode=50, organizationBusinessDescriptionType=200, unresolved=255, text=255, OrganizationPublicPrivateCode=50, organizationPhoneType=200, organizationPhoneTypeCode=50, addressType=200, addressTypeCode=50, majorVersion=255, publishingStyle=255, minorVersion=255, Id=255, TimeStamp=20, Any=255, Body.majorVersion=255, Body.minorVersion=255, contentSet=255, action=255, EntitlementCode=255, ContentGroup=255, ProductEntitlement.EntitlementCode=255, SourceEntitlement.ContentGroup=255, organizationSubtypeCode=50, organizationSubtype=200, organizationStatus=200, organizationStatusCode=50, entityCreatedDate=20, entityModifiedDate=20, OrganizationId=10, languageCode=50, languageCultureCode=50, effectiveFrom=20, effectiveTo=20, OrganizationName.organizationNameTypeCode=50, languageScriptCode=50, OrganizationName=255, OrganizationAddress.addressTypeCode=50, OrganizationAddressLine1=100, OrganizationAddressLine2=100, OrganizationAddressLine3=100, OrganizationAddressLine4=100, OrganizationAddressLine5=100, OrganizationAddressCity=255, OrganizationAddressStateProvince=100, OrganizationAddressPostalCode=100, OrganizationAddressCountryCode=2, OrganizationPhone.organizationPhoneTypeCode=50, OrganizationPhone=255, OrganizationBusinessDescription.languageCode=50, OrganizationBusinessDescription.languageCultureCode=50, OrganizationBusinessDescription.organizationBusinessDescriptionTypeCode=50, OrganizationBusinessDescription.languageScriptCode=50, OrganizationBusinessDescription=255, OrganizationWebsite=255, PublicPrivateFlag=50, IpoDate=20, OrganizationInactiveDate=20, OrganizationFoundedYear=20, FiscalYearEnd=10, Organization.OrganizationTypeCode=50, Organization.OrganizationStatusCode=50, Organization.OrganizationSubtypeCode=50},
DSSQLType={organizationType=12, organizationTypeCode=12, organizationNameTypeCode=12, organizationNameType=12, organizationBusinessDescriptionTypeCode=12, organizationBusinessDescriptionType=12, unresolved=12, text=12, OrganizationPublicPrivateCode=12, organizationPhoneType=12, organizationPhoneTypeCode=12, addressType=12, addressTypeCode=12, majorVersion=12, publishingStyle=12, minorVersion=12, Id=12, TimeStamp=11, Any=12, Body.majorVersion=12, Body.minorVersion=12, contentSet=12, action=12, EntitlementCode=12, ContentGroup=12, ProductEntitlement.EntitlementCode=12, SourceEntitlement.ContentGroup=12, organizationSubtypeCode=12, organizationSubtype=12, organizationStatus=12, organizationStatusCode=12, entityCreatedDate=11, entityModifiedDate=11, OrganizationId=2, languageCode=12, languageCultureCode=12, effectiveFrom=11, effectiveTo=11, OrganizationName.organizationNameTypeCode=12, languageScriptCode=12, OrganizationName=12, OrganizationAddress.addressTypeCode=12, OrganizationAddressLine1=12, OrganizationAddressLine2=12, OrganizationAddressLine3=12, OrganizationAddressLine4=12, OrganizationAddressLine5=12, OrganizationAddressCity=12, OrganizationAddressStateProvince=12, OrganizationAddressPostalCode=12, OrganizationAddressCountryCode=12, OrganizationPhone.organizationPhoneTypeCode=12, OrganizationPhone=12, OrganizationBusinessDescription.languageCode=12, OrganizationBusinessDescription.languageCultureCode=12, OrganizationBusinessDescription.organizationBusinessDescriptionTypeCode=12, OrganizationBusinessDescription.languageScriptCode=12, OrganizationBusinessDescription=12, OrganizationWebsite=12, PublicPrivateFlag=12, IpoDate=11, OrganizationInactiveDate=11, OrganizationFoundedYear=11, FiscalYearEnd=12, Organization.OrganizationTypeCode=12, Organization.OrganizationStatusCode=12, Organization.OrganizationSubtypeCode=12},
DSSQLPrecision={organizationType=200, organizationTypeCode=50, organizationNameTypeCode=50, organizationNameType=200, organizationBusinessDescriptionTypeCode=50, organizationBusinessDescriptionType=200, unresolved=255, text=255, OrganizationPublicPrivateCode=50, organizationPhoneType=200, organizationPhoneTypeCode=50, addressType=200, addressTypeCode=50, majorVersion=255, publishingStyle=255, minorVersion=255, Id=255, TimeStamp=20, Any=255, Body.majorVersion=255, Body.minorVersion=255, contentSet=255, action=255, EntitlementCode=255, ContentGroup=255, ProductEntitlement.EntitlementCode=255, SourceEntitlement.ContentGroup=255, organizationSubtypeCode=50, organizationSubtype=200, organizationStatus=200, organizationStatusCode=50, entityCreatedDate=20, entityModifiedDate=20, OrganizationId=10, languageCode=50, languageCultureCode=50, effectiveFrom=20, effectiveTo=20, OrganizationName.organizationNameTypeCode=50, languageScriptCode=50, OrganizationName=255, OrganizationAddress.addressTypeCode=50, OrganizationAddressLine1=100, OrganizationAddressLine2=100, OrganizationAddressLine3=100, OrganizationAddressLine4=100, OrganizationAddressLine5=100, OrganizationAddressCity=255, OrganizationAddressStateProvince=100, OrganizationAddressPostalCode=100, OrganizationAddressCountryCode=2, OrganizationPhone.organizationPhoneTypeCode=50, OrganizationPhone=255, OrganizationBusinessDescription.languageCode=50, OrganizationBusinessDescription.languageCultureCode=50, OrganizationBusinessDescription.organizationBusinessDescriptionTypeCode=50, OrganizationBusinessDescription.languageScriptCode=50, OrganizationBusinessDescription=255, OrganizationWebsite=255, PublicPrivateFlag=50, IpoDate=20, OrganizationInactiveDate=20, OrganizationFoundedYear=20, FiscalYearEnd=10, Organization.OrganizationTypeCode=50, Organization.OrganizationStatusCode=50, Organization.OrganizationSubtypeCode=50},
DSDerivation={organizationType='GemOrganizationMaster.organizationType', organizationTypeCode='GemOrganizationMaster.organizationTypeCode', organizationNameTypeCode='GemOrganizationMaster.organizationNameTypeCode', organizationNameType='GemOrganizationMaster.organizationNameType', organizationBusinessDescriptionTypeCode='GemOrganizationMaster.organizationBusinessDescriptionTypeCode', organizationBusinessDescriptionType='GemOrganizationMaster.organizationBusinessDescriptionType', unresolved='GemOrganizationMaster.unresolved', text='GemOrganizationMaster.text', OrganizationPublicPrivateCode='GemOrganizationMaster.OrganizationPublicPrivateCode', organizationPhoneType='GemOrganizationMaster.organizationPhoneType', organizationPhoneTypeCode='GemOrganizationMaster.organizationPhoneTypeCode', addressType='GemOrganizationMaster.addressType', addressTypeCode='GemOrganizationMaster.addressTypeCode', majorVersion='GemOrganizationMaster.majorVersion', publishingStyle='GemOrganizationMaster.publishingStyle', minorVersion='GemOrganizationMaster.minorVersion', Id='GemOrganizationMaster.Id', TimeStamp='GemOrganizationMaster.TimeStamp', Any='GemOrganizationMaster.Any', Body.majorVersion='GemOrganizationMaster.Body.majorVersion', Body.minorVersion='GemOrganizationMaster.Body.minorVersion', contentSet='GemOrganizationMaster.contentSet', action='GemOrganizationMaster.action', EntitlementCode='GemOrganizationMaster.EntitlementCode', ContentGroup='GemOrganizationMaster.ContentGroup', ProductEntitlement.EntitlementCode='GemOrganizationMaster.ProductEntitlement.EntitlementCode', SourceEntitlement.ContentGroup='GemOrganizationMaster.SourceEntitlement.ContentGroup', organizationSubtypeCode='GemOrganizationMaster.organizationSubtypeCode', organizationSubtype='GemOrganizationMaster.organizationSubtype', organizationStatus='GemOrganizationMaster.organizationStatus', organizationStatusCode='GemOrganizationMaster.organizationStatusCode', entityCreatedDate='GemOrganizationMaster.entityCreatedDate', entityModifiedDate='GemOrganizationMaster.entityModifiedDate', OrganizationId='GemOrganizationMaster.OrganizationId', languageCode='GemOrganizationMaster.languageCode', languageCultureCode='GemOrganizationMaster.languageCultureCode', effectiveFrom='GemOrganizationMaster.effectiveFrom', effectiveTo='GemOrganizationMaster.effectiveTo', OrganizationName.organizationNameTypeCode='GemOrganizationMaster.OrganizationName.organizationNameTypeCode', languageScriptCode='GemOrganizationMaster.languageScriptCode', OrganizationName='GemOrganizationMaster.OrganizationName', OrganizationAddress.addressTypeCode='GemOrganizationMaster.OrganizationAddress.addressTypeCode', OrganizationAddressLine1='GemOrganizationMaster.OrganizationAddressLine1', OrganizationAddressLine2='GemOrganizationMaster.OrganizationAddressLine2', OrganizationAddressLine3='GemOrganizationMaster.OrganizationAddressLine3', OrganizationAddressLine4='GemOrganizationMaster.OrganizationAddressLine4', OrganizationAddressLine5='GemOrganizationMaster.OrganizationAddressLine5', OrganizationAddressCity='GemOrganizationMaster.OrganizationAddressCity', OrganizationAddressStateProvince='GemOrganizationMaster.OrganizationAddressStateProvince', OrganizationAddressPostalCode='GemOrganizationMaster.OrganizationAddressPostalCode', OrganizationAddressCountryCode='GemOrganizationMaster.OrganizationAddressCountryCode', OrganizationPhone.organizationPhoneTypeCode='GemOrganizationMaster.OrganizationPhone.organizationPhoneTypeCode', OrganizationPhone='GemOrganizationMaster.OrganizationPhone', OrganizationBusinessDescription.languageCode='GemOrganizationMaster.OrganizationBusinessDescription.languageCode', OrganizationBusinessDescription.languageCultureCode='GemOrganizationMaster.OrganizationBusinessDescription.languageCultureCode', OrganizationBusinessDescription.organizationBusinessDescriptionTypeCode='GemOrganizationMaster.OrganizationBusinessDescription.organizationBusinessDescriptionTypeCode', OrganizationBusinessDescription.languageScriptCode='GemOrganizationMaster.OrganizationBusinessDescription.languageScriptCode', OrganizationBusinessDescription='GemOrganizationMaster.OrganizationBusinessDescription', OrganizationWebsite='GemOrganizationMaster.OrganizationWebsite', PublicPrivateFlag='GemOrganizationMaster.PublicPrivateFlag', IpoDate='GemOrganizationMaster.IpoDate', OrganizationInactiveDate='GemOrganizationMaster.OrganizationInactiveDate', OrganizationFoundedYear='GemOrganizationMaster.OrganizationFoundedYear', FiscalYearEnd='GemOrganizationMaster.FiscalYearEnd', Organization.OrganizationTypeCode='GemOrganizationMaster.Organization.OrganizationTypeCode', Organization.OrganizationStatusCode='GemOrganizationMaster.Organization.OrganizationStatusCode', Organization.OrganizationSubtypeCode='GemOrganizationMaster.Organization.OrganizationSubtypeCode'},
DSSchema='record
(
organizationType:string[max=200];
organizationTypeCode:string[max=50];
organizationNameTypeCode:string[max=50];
organizationNameType:string[max=200];
organizationBusinessDescriptionTypeCode:string[max=50];
organizationBusinessDescriptionType:string[max=200];
unresolved:string[max=255];
text:string[max=255];
OrganizationPublicPrivateCode:string[max=50];
organizationPhoneType:string[max=200];
organizationPhoneTypeCode:string[max=50];
addressType:string[max=200];
addressTypeCode:string[max=50];
majorVersion:string[max=255];
publishingStyle:string[max=255];
minorVersion:string[max=255];
Id:string[max=255];
TimeStamp:timestamp;
Any:string[max=255];
Body.majorVersion:string[max=255];
Body.minorVersion:string[max=255];
contentSet:string[max=255];
action:string[max=255];
EntitlementCode:string[max=255];
ContentGroup:string[max=255];
ProductEntitlement.EntitlementCode:string[max=255];
SourceEntitlement.ContentGroup:string[max=255];
organizationSubtypeCode:string[max=50];
organizationSubtype:string[max=200];
organizationStatus:string[max=200];
organizationStatusCode:string[max=50];
entityCreatedDate:timestamp;
entityModifiedDate:timestamp;
OrganizationId:decimal[10,0];
languageCode:string[max=50];
languageCultureCode:string[max=50];
effectiveFrom:timestamp;
effectiveTo:timestamp;
OrganizationName.organizationNameTypeCode:string[max=50];
languageScriptCode:string[max=50];
OrganizationName:string[max=255];
OrganizationAddress.addressTypeCode:string[max=50];
OrganizationAddressLine1:string[max=100];
OrganizationAddressLine2:string[max=100];
OrganizationAddressLine3:string[max=100];
OrganizationAddressLine4:string[max=100];
OrganizationAddressLine5:string[max=100];
OrganizationAddressCity:string[max=255];
OrganizationAddressStateProvince:string[max=100];
OrganizationAddressPostalCode:string[max=100];
OrganizationAddressCountryCode:string[max=2];
OrganizationPhone.organizationPhoneTypeCode:string[max=50];
OrganizationPhone:string[max=255];
OrganizationBusinessDescription.languageCode:string[max=50];
OrganizationBusinessDescription.languageCultureCode:string[max=50];
OrganizationBusinessDescription.organizationBusinessDescriptionTypeCode:string[max=50];
OrganizationBusinessDescription.languageScriptCode:string[max=50];
OrganizationBusinessDescription:string[max=255];
OrganizationWebsite:string[max=255];
PublicPrivateFlag:string[max=50];
IpoDate:timestamp;
OrganizationInactiveDate:timestamp;
OrganizationFoundedYear:timestamp;
FiscalYearEnd:string[max=10];
Organization.OrganizationTypeCode:string[max=50];
Organization.OrganizationStatusCode:string[max=50];
Organization.OrganizationSubtypeCode:string[max=50];
)'
} is not a valid property list: Error parsing list for property "DSDescription"
Error parsing list for property "DSDisplayWidth"
Error parsing list for property "DSSQLType"
Error parsing list for property "DSSQLPrecision"
Error parsing list for property "DSDerivation"
If anyone can offer any suggestions as to what the issue might be here, please do let me know.
Many thanks in advance.
Kind regards,
S