Failed to read back xml file using xml query

[Former Member]

Software :xMII 12.0

Fact(No issue):When running the BLS manually

1) able to save file using XMLSaver action block under web.

i.e "web://OPERATIONS_APPLICATIONS/XmlFile/" & Local.SiteID & "_" & Local.RanomNumber & "_" & "Throughput.xml"

2) able to delete file using Delete file action block

i.e. "web://OPERATIONS_APPLICATIONS/XmlFile/" & Local.SiteID & "_" & Local.RanomNumber & "_" & "Throughput.xml"

3) able to read back data using xml query and create chart. and when generating chart,sending URL for xml file dynamically and it works.

Fact(with issue): when ruuning from soap/wsdl

Number 3 mentioned above fails.Means it able to save xml file,delete xml file,but cannot read xml file

using xml query in chart action block.

Thanks

Sajjad

[agentry_src]

Hi Sajjad,

Can you try it using the Scheduler?

Also can you post the SOAP script you are using?

Thanks,

Mike

[Former Member]

Hi Mike,

Thanks for your prompt answer.

It shows same behavior as soap if i run from scheduler.

Thanks

Sajjad

__SOAP Script__

POST /XMII/SOAPRunner/OPERATIONS_APPLICATIONS/ServiceObject/TestappThroughputDetails HTTP/1.1

User-Agent: Mindreef HTTP Client

SOAPAction: "http://www.sap.com/xMII"

Content-Type: text/xml; charset=UTF-8

Host: xmiixmdwd:8210

Cookie: $Version=0; saplb_*=(J2EE2697100)2697150

Content-Length: 626

<soapenv:Envelope

xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<s0:XacuteRequest

xmlns:s0="http://www.sap.com/xMII"

xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<s0:LoginName>abc</s0:LoginName>

<s0:LoginPassword>abc</s0:LoginPassword>

<s0:InputParams>

<s0:SiteID>1</s0:SiteID>

<s0:strTagList />

</s0:InputParams>

</s0:XacuteRequest>

</soapenv:Body>

</soapenv:Envelope>

[agentry_src]

Hi Sajjad,

I am going to look it over for syntax a bit, but have one more suggestion to try. Change your xml read and writes from web:// to db://. Probably doesn't make a difference, but web is trying to publish and db just saves the file.

Hope this helps,

Mike

[Former Member]

Mike,

I did. Same result.

I did more testing. Seems like, based on url you can save and delete but you cannot read using XML query. It gives following error.

<?xml version="1.0" encoding="UTF-8"?>

<Rowsets DateCreated="2009-01-23T10:51:12" EndDate="2009-01-23T10:51:12" StartDate="2009-01-23T10:51:12" Version="12.0.2 Build(88)"><FatalError>Premature end of file.</FatalError></Rowsets>

Thanks

Sajjad

[agentry_src]

Hi Sajjad,

Remembered this issue from before:

[XMLQuery Issue|]

I would also read the note he mentions. I suspect this is the same issue that you are experiencing.

Good luck and let us know if you get it fixed.

Thanks,

Mike