I had Problem when try loading data from xml to hashed file
Error Message
The name '{0}' is not a valid NCName.
expression = '/:getcddistResponse/:getcddistResult/:ZBAPITXXPRCDDIST' Remaining tokens are: ('/')
My Structure Data at Hashed table
MANDT Decimal /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/MANDT/text()
BUKRS Varchar(255) /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/BUKRS/text()
DIST_CODE Decimal /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/DIST_CODE/text()
DIST_DESC Varchar(255) /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/DIST_DESC/text()
WERKS Varchar(255) /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/WERKS/text()
and My XML
<getcddistResponse xmlns="http://tempuri.org/PerfRptWs/Service1">
<getcddistResult>
<ZBAPITXXPRCDDIST>
<MANDT xmlns="">300</MANDT>
<BUKRS xmlns="">D012</BUKRS>
<DIST_CODE xmlns="">01</DIST_CODE>
<DIST_DESC xmlns="">OFFICE 2</DIST_DESC>
<WERKS xmlns=""/>
</ZBAPITXXPRCDDIST>
<ZBAPITXXPRCDDIST>
<MANDT xmlns="">310</MANDT>
<BUKRS xmlns="">D012</BUKRS>
<DIST_CODE xmlns="">02</DIST_CODE>
<DIST_DESC xmlns="">OFFICE 1</DIST_DESC>
<WERKS xmlns=""/>
</ZBAPITXXPRCDDIST>
</getcddistResult>
</getcddistResponse>
How do i fix this problem
thx
nh
Error when loading XML
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 2
- Joined: Tue May 13, 2008 12:40 am
- Location: indonesia
Looks like it's an issue for 8.x that was corrected awhile back. There is a patch for this, and it usually relates to namespaces. Contact whoever provides your support. It's a pretty clear symptom. In "most" cases, to continue with your development in the meantime, you should be able to read a test document successfully if you remove all the namespace details (all the xmlns="http//....." and prefixes on the elements).
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
We just installed the "namespace" patch (Which also addresses end-of-wave issues) and it works like a charm.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 2
- Joined: Tue May 13, 2008 12:40 am
- Location: indonesia
Thank's Ernie, After I remove the namespace details and it's work.eostic wrote:Looks like it's an issue for 8.x that was corrected awhile back. There is a patch for this, and it usually relates to namespaces. Contact whoever provides your support. It's a pretty clear symptom. In "most" cases, to continue with your development in the meantime, you should be able to read a test document successfully if you remove all the namespace details (all the xmlns="http//....." and prefixes on the elements).
Ernie
My current Datastage is 8.0.
if i want to add namespace in the xml, do i need to update the fix pack 8.0.1 ?
That fixpack may be a good idea for other reasons, but no...for this namespace issue you need a specific patch.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
patch
Hi guys,
I too am having this problem but can't seem to find which patch needs to be installed?
I was wondering if anyone had a link to it? I tried searching the APAR's etc but to no avail
(Or do i have to contact IBM support for the patch, would it not be listed?)
Cheers and thanks
Jon
I too am having this problem but can't seem to find which patch needs to be installed?
I was wondering if anyone had a link to it? I tried searching the APAR's etc but to no avail
(Or do i have to contact IBM support for the patch, would it not be listed?)
Cheers and thanks
Jon
"if" it's the same namespace issue, it's a patch whose number is e117664.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>