Skip to Content
author's profile photo Former Member
Former Member

XMLQuery Fails in Active Portal

When trying to use Activity Portal, 'Premature end of file' errors are entered into the AlertLog, and metric values of 'zero' are recorded.

When the 'ActivePortalMonitor' transaction is executed from workbench, no error is recorded and the metric value is recorded correctly.

We are currently running xMII version 12.0.5 on Netweaver SPS16.

In the logs I can see that the XML Connector returns

Error Processing XMLQuery Status (404): Not Found

which in turn causes the 'Premature end of file' error.

This error is encountered by all XMLQueries in the Activity Portal when run from the scheduler.

Log When Executed From Scheduler

14:20:56:865	select: name XMLQuery.%
14:20:56:880	TimeParams[_Shift=null,_TimePeriod=null,_Times=null,_EndDate=null,_StartDate=null,_Duration=
60,_Units=M,_Format=MM/dd/yyyy HH:mm:ss,bAllowFuture=true]

14:20:56:880	StartDate=12/22/2008 13:20:56&EndDate=12/22/2008 14:20:56

14:20:56:880	Setting template properties for TEMPLATE [id=-1,name=XMLQuery,desc=,path(508)=ActivePortal,type=TEMPLATETYPE [id=27,name=XMLQuery,kind=Query],default=false,readers=[],writers=[Everyone, XMII Users, XMII Developers, XMII Administrators],props{AllowBuffering=false, AllowFuture=true, CacheDuration=0, CacheDurationUnits=M, Comment=, Connector=XMLConnector, DateFormat=MM/dd/yyyy HH:mm:ss, Debug=false, Duration=60, DurationUnits=M, EndDate=, InlineTransform=, IntervalCount=1...

14:20:56:880	{NumberFormat=0.00, WriterRoles=Everyone,XMII Users,XMII Developers,XMII Administrators, IsCachable=false, PathID=508, CacheDuration=0, DurationUnits=M, Connector=XMLConnector, Mode=XMLQuery, IntervalCount=1, RowCount=100, AllowFuture=true, Version=12.0.5 Build(128), Trace=false, Server=XMLConnector, Duration=60, Debug=false, DocType=XMLQuery, DateFormat=MM/dd/yyyy HH:mm:ss, SaveDate=12/22/2008 12:47:43, CacheDurationUnits=M, AllowBuffering=false, ID=-1}

14:20:56:880	Tags:{}

14:20:56:880	TimeParams[_Shift=null,_TimePeriod=null,_Times=null,_EndDate=null,_StartDate=null,_Duration=
60,_Units=M,_Format=MM/dd/yyyy HH:mm:ss,bAllowFuture=true]
14:20:56:880	StartDate=12/22/2008 13:20:56&EndDate=12/22/2008 14:20:56
14:20:56:880	Using service: IlluminatorService
14:20:56:880	Request for service com.sap.xmii.Illuminator.services.handlers.IlluminatorService
14:20:56:880	Validating query...
14:20:56:880	Trying to process request
14:20:56:896	Error Processing XMLQuery Status (404): Not Found

Log When Executed From Workbench

13:51:42:986	select: name XMLQuery.%

13:51:43:001	Setting template properties for TEMPLATE [id=-1,name=XMLQuery,desc=,path(508)=ActivePortal,type=TEMPLATETYPE [id=27,name=XMLQuery,kind=Query],default=false,readers=[],writers=[Everyone, XMII Users, XMII Developers, XMII Administrators],props{AllowBuffering=false, AllowFuture=true, CacheDuration=0, CacheDurationUnits=M, Comment=, Connector=XMLConnector, DateFormat=MM/dd/yyyy HH:mm:ss, Debug=false, Duration=60, DurationUnits=M, EndDate=, InlineTransform=, IntervalCount=1...

13:51:43:001	{NumberFormat=0.00, WriterRoles=Everyone,XMII Users,XMII Developers,XMII Administrators, IsCachable=false, PathID=508, CacheDuration=0, DurationUnits=M, Connector=XMLConnector, Mode=XMLQuery, IntervalCount=1, RowCount=100, AllowFuture=true, Version=12.0.5 Build(128), Trace=false, Server=XMLConnector, Duration=60, Debug=false, DocType=XMLQuery, DateFormat=MM/dd/yyyy HH:mm:ss, SaveDate=12/22/2008 12:47:43, CacheDurationUnits=M, AllowBuffering=false, ID=-1}

13:51:43:001	Tags:{}

13:51:43:017	TimeParams[_Shift=null,_TimePeriod=null,_Times=null,_EndDate=null,_StartDate=null,_Duration=
60,_Units=M,_Format=MM/dd/yyyy HH:mm:ss,bAllowFuture=true]

13:51:43:017	StartDate=12/22/2008 12:51:43&EndDate=12/22/2008 13:51:43
13:51:43:017	COOKIE [domain=.<ourdomain>.<ourcompany>.net,path=/,name=saplb_*]
13:51:43:017	COOKIE [domain=.<ourdomain>.<ourcompany>.net,path=/,name=JSESSIONID]
13:51:43:017	COOKIE [domain=.<ourdomain>.<ourcompany>.net,path=/,name=MYSAPSSO2]
13:51:43:017	TimeParams _Shift=null,_TimePeriod=null,_Times=null,_EndDate=null,_StartDate=
null,_Duration=60,_Units=M,_Format=MM/dd/yyyy HH:mm:ss,bAllowFuture=true]

13:51:43:017	StartDate=12/22/2008 12:51:43&EndDate=12/22/2008 13:51:43
13:51:43:017	Using service: IlluminatorService
13:51:43:017	Request for service com.sap.xmii.Illuminator.services.handlers.IlluminatorService
13:51:43:017	Validating query...
13:51:43:017	Trying to process request
13:51:43:017	COOKIE [domain=.<ourdomain>.<ourcompany>.net,path=/,name=saplb_*]
13:51:43:017	COOKIE [domain=.<ourdomain>.<ourcompany>.net,path=/,name=JSESSIONID]
13:51:43:017	COOKIE [domain=.<ourdomain>.<ourcompany>.net,path=/,name=MYSAPSSO2]
13:51:43:033	Requested URL is http://<server>.<ourdomain>.<ourcompany>.net:50000/XMII/Illuminator?QueryTemplate=<project>/Production/OEE/Calculation/sqlOEEpct&Content-Type=text/xml&Param.5=BTL1&Param.9=BTL1+OEE&TimePeriod=Last30Days&---=---&---=---&---=---&---=---&---=---

Some debug in the BLS tells me that the identical URL is passed to the XMLQuery in both cases:

server://XMII/Illuminator?QueryTemplate=AZ/Production/OEE/Calculation/sqlOEEpct&
Content-Type=text/xml&Param.5=BTL1&Param.9=BTL1+OEE&TimePeriod=Last30Days&---=---
&---=---&---=---&---=---&---=--- 

Any suggestions would be appreciated.

Happy Holidays,

Rod Hoffman

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 08:43 PM

    Rod, what's the URL in your XMLQuery look like?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 08:47 PM

    Hi Rick,

    It was at the bottom of my post

    server://XMII/Illuminator?QueryTemplate=AZ/Production/OEE/Calculation/sqlOEEpct&
    Content-Type=text/xml&Param.5=BTL1&Param.9=BTL1+OEE&TimePeriod=Last30Days&---=---
    &---=---&---=---&---=---&---=---

    Rod

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 12:17 PM

    Hmmmm. Well, if it's any consolation, it looks like you're not alone:

    XMLQuery fails when executed as a job

    Might want to report a bug.

    Edited by: Rick Bullotta on Dec 23, 2008 7:18 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yeah, I've seen reference to this issue several times, however the thread never seems to end with a resolution, or solid workaround.

      One thread indicated it may be a 12.0.2 issue with scheduler, so I was a bit disappointed when after updating to 12.0.5 it still persisted.

      For as long as Activity Portal and v12 have been around, I'm surprised that no one else has come across and found a suitable workaround for this issue. It's really got me bummed 😔

      I will go ahead and submit a bug report.--

      UPDATE:

      When reporting the bug I stumbled across SAP Note 1245634 which identifies an issue when running XMLQueries from scheduler, the solution provided.

      Solution

      The URL in XMLQuery's run from the scheduler must be fully qualified with server and port rather than using server:// or web://.

      For the credential propagation issue the IllumLoginName and IllumLoginPassword properties must be passed in the URL being queried as parameters. This is only necessary when calling a XMII URL.

      Of course as these thing go, I tried both 'fully qualified server and port' and passing credentials, just not both at the same time.

      The issue is now resolved.

      Rod

      Edited by: Rod L. Hoffman on Dec 23, 2008 2:46 PM

      Edited by: Rod L. Hoffman on Dec 23, 2008 3:00 PM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.