Hi,
I'm getting the same error ... but I'm not able to find the above patch
I tried to work around and I've got some good things but my solution produces some warnigs that I can't hunderstand.
My job is like this FOLDER STAGE --> XML INPUT --> trasnformer --> seq.file
1) I've removed the "xsd:" from the xml table definition in the XML Input Stage
2) the values are correctly written in the seq. file but a lot of warnigs are generated in the log.
A warning is generated for each fileds different from the first field (the repetition element ... the key), here is an example of the warnigs
BGAS_00200_XML_INPUT_TABELLA..XML_INPUT: XSLT Processor: Unknown element on the output. Element Name = "protocolloRichiesta"
Then, after these warnigns, a Phantom appears :
Server:WETLSRVV
Project:ESTRAZIONI
Job No:369
Job name:BGAS_00200_XML_INPUT_TABELLA
Invocation:
Event Number:560472
Event type:Warning
User:WETLSRVV\Administrator
Timestamp:26/05/2010 16.24.39
Message Id:DSTAGE_RUN_E_0187
Message:
DataStage Job 369 Phantom 482
XSLT Warning: Source tree node: messaggio. (, line 21, column 109.)
XSLT Warning: Source tree node: messaggio. (, line 22, column 103.)
XSLT Warning: Source tree node: messaggio. (, line 23, column 146.)
XSLT Warning: Source tree node: messaggio. (, line 24, column 128.)
XSLT Warning: Source tree node: messaggio. (, line 25, column 134.)
XSLT Warning: Source tree node: messaggio. (, line 26, column 144.)
XSLT Warning: Source tree node: messaggio. (, line 27, column 117.)
XSLT Warning: Source tree node: messaggio. (, line 28, column 121.)
XSLT Warning: Source tree node: messaggio. (, line 29, column 216.)
XSLT Warning: Source tree node: messaggio. (, line 45, column 117.)
XSLT Warning: Source tree node: messaggio. (, line 46, column 87.)
XSLT Warning: Source tree node: protocolloInoltro. (, line 376, column 64.)
XSLT Warning: Source tree node: messaggio. (, line 21, column 109.)
Please can someone help me ? Thanks in advance !
Here is an extract of the XML file (I've inserted "." to preserve the alignement:
<?xml version="1.0" encoding="UTF-8"?>
<xsd:richiesteSgate xmlns:xsd="
http://www.sgate.ancitel.it/xsd/">
...<xsd:messaggio>
......<xsd:protocolloInoltro>424361</xsd:protocolloInoltro>
......<xsd:richiesta><xsd:protocolloRichiesta>424360</xsd:protocolloRichiesta>
......<xsd:tipologiaDomanda>NUOVA</xsd:tipologiaDomanda>
......<xsd:clienteDomestico>
.........<xsd:codiceFiscaleClienteDomestico>NDRMLA73M51H211Z</xsd:codiceFiscaleClienteDomestico>
.........<xsd:nomeClienteDomestico>MAILA</xsd:nomeClienteDomestico>
.........<xsd:cognomeClienteDomestico>ANDREANI</xsd:cognomeClienteDomestico>
.........<xsd:componentiFamigliaAnagrafica>5</xsd:componentiFamigliaAnagrafica>
......</xsd:clienteDomestico>
......<xsd:fornitura>
.........<xsd:tipologiaFornitura>INDIVIDUALE</xsd:tipologiaFornitura>
.........<xsd:individuale>
............<xsd:pdrIndividuale>02490000159641</xsd:pdrIndividuale>
............<xsd:intestatarioFornituraIndividuale>
...............<xsd:codiceFiscaleClienteDomestico>NDRMLA73M51H211Z</xsd:codiceFiscaleClienteDomestico>
...............<xsd:nomeClienteDomestico>MAILA</xsd:nomeClienteDomestico>
...............<xsd:cognomeClienteDomestico>ANDREANI</xsd:cognomeClienteDomestico>
...............<xsd:componentiFamigliaAnagrafica>5</xsd:componentiFamigliaAnagrafica>
............</xsd:intestatarioFornituraIndividuale>
............<xsd:utilizzoFornituraIndividuale>
...............<xsd:AcquaCaldaSanitariaCotturaCibi>true</xsd:AcquaCaldaSanitariaCotturaCibi>
...............<xsd:Riscaldamento>true</xsd:Riscaldamento>
............</xsd:utilizzoFornituraIndividuale>
.........</xsd:individuale>
.........<xsd:indirizzoFornitura>
............<xsd:istatPdr>043043</xsd:istatPdr>
............<xsd:fasciaClimaticaPdr>D</xsd:fasciaClimaticaPdr>
............<xsd:capPdr>62018</xsd:capPdr>
............<xsd:indirizzoPdr>VIALE TRIESTE</xsd:indirizzoPdr>
............<xsd:civicoPdr>22</xsd:civicoPdr>
.........</xsd:indirizzoFornitura>
.........<xsd:pod>IT001E585736007</xsd:pod>
......</xsd:fornitura>
......<xsd:bonus>
.........<xsd:dataDisponibilita>2010-03-30</xsd:dataDisponibilita>
.........<xsd:dataPresentazione>2010-03-30</xsd:dataPresentazione>
.........<xsd:dataInizioAgevolazione>2010-05-01</xsd:dataInizioAgevolazione>
.........<xsd:dataFineAgevolazione>2011-04-30</xsd:dataFineAgevolazione>
.........<xsd:retro>true</xsd:retro>
......</xsd:bonus></xsd:richiesta>
...</xsd:messaggio>
...
...<xsd:messaggio><xsd:protocolloInoltro>425548
......</xsd:protocolloInoltro>
.....
</xsd:messaggio></xsd:richiesteSgate>