XMLQuery Fails in Active Portal

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

Might want to report a bug.

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

[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

[Former Member]

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