on 12-22-2008 8:01 PM
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
Rod, what's the URL in your XMLQuery look like?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.