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]

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