XML Input - Error parsing list for property "DSDescrip

sjordery · Post by **sjordery** » Tue Mar 04, 2008 11:33 am

Hello All,

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:

main_program: Creation of a step finished with status = FAILED.

The one with most info (but not sadly not enough for me to debug

) is:

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"

There was a previous posting in 2004 with this exact error that came up in a search, but there were no replies to that.

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

eostic · Post by **eostic** » Tue Mar 04, 2008 4:22 pm

What does your job do? Do the records still get read out of the XML document, but then the job aborts? Any chance this is on Solaris?

sjordery · Post by **sjordery** » Wed Mar 05, 2008 4:29 am

Hi Ernie,

Job has 4 stages:

Code: Select all

External Source ===> XML_Input ===> Dataset
                        ||
                     Rejects

The job reads in an XML file (using the 'ls' command in the External Source stage), parses it in XML input and writes to a Dataset. The job works fine in another application, but for this job I have amended the table definition (imported from an xsd) and am reading in a different XML file - other than that, everything is the same as the working job.

Nothing appears to go down any of the links - the links remain 'black' with no row counts etc. Neither dataset or rejects file is populated.

It's not a Solaris server.

Thanks
S

sjordery · Post by **sjordery** » Fri Mar 07, 2008 5:33 am

Just to add..

The XML file validates against the schema in Liquid XML Studio. I have tried removing the default namespace prefixes, but to no avail.

I have now raised this with IBM support and will post up if I manage to resolve the issue.

Cheers,
S

eostic · Post by **eostic** » Sat Mar 08, 2008 6:29 am

...and if you uncheck validation, does it work? ...what happens when you remove the namespaces? ...can you cut/paste some of the xml here?

No rows "almost" always indicates an xpath issue of some type.

Ernie

sjordery · Post by **sjordery** » Fri Mar 14, 2008 11:37 am

Hi All,

The XSD schemas we use contain imports of other XSDs which result in several being embedded together. The XML Meta Data Importer had problems with multi-file XSDs and this resulted in xpaths that were not correct and that could not be satisfied. Furthermore, there were lots of odd duplication of elements etc.

To resolve this, I have manually entered the xpaths and this has worked fine. Another resolution, suggested by eostic, would be to generate a complete XML document instance (eg. in xmlSpy) and then import that document into the DataStage table definition.

Thanks to Ernie for his input.

Regards,
S

eostic · Post by **eostic** » Fri Mar 14, 2008 4:06 pm

There are some odd xsd's out there...... using an XML instance for import is fine, but be careful of two things in particular:

a) be sure the xml instance document is fully populated. You can ensure this if you generate a sample with a tool, but not so sure if it's a real sample.....sometimes people always include empty elements, but often an element is optional....so might be missed altogether. You simply wouldnt have it in your meta data...... and unlike a flat file, the job will work fine, even if the element appears one day.

b) datatypes. you'll get more realistic datatypes if you use the xsd, although this really isn't an issue. It's text anyway....better that you know that and then deal with it as needed downstream.

Ernie