Sat Oct 20, 2018 4:02 am
Login Register Lost Password? Contact Us


Occasional Roxie Error 6.2.4-1

Comments and questions related to the Enterprise Control Language

Thu Jun 14, 2018 1:48 pm Change Time Zone

Hello

Our operational team are reporting about 200 errors per day from our Roxie service where the result appears to be corrupt or as you can see from the error below a blank where we should get a resultname. When we try this directly in ESP or IDE we have never been able to replicate it.

Code: Select all
Sent via DB Mail    DateTime: 14/06/2018 13:22:57  SingleId: 0  MultiId: 106290  MultiUserId: 1413055      System.Xml.XmlException: Name cannot begin with the ' ' character, hexadecimal value 0x20. Line 18, position 40.     at Cpl.Data.Hpcc.GetData(String MethodName, NameValueCollection Parameters, NameValueCollection ColumnMapping, String[] DataSetNames)     at Cpl.Web.Pages.Base.PageAuthenticated.HPCCGetDescStatsPaged(Int32 MultiUserId, Int32 CurrentPageIndex, Int32 PageSize, String SortMode, String Filter)


Any help would be appreciated.

Thanks

David
daviddasher
 
Posts: 5
Joined: Fri Dec 08, 2017 12:39 pm

Fri Jun 15, 2018 7:56 am Change Time Zone

I'm not sure that this error is coming from our system - I searched the sources (and the brains of a few developers) for the string "HPCCGetDescStatsPaged" and it does not appear.

You say it's caused by a resultname being blank? Would that be in the XML from roxie, or from ESP ?
richardkchapman
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 108
Joined: Fri Jun 17, 2011 8:59 am

Fri Jun 15, 2018 8:01 am Change Time Zone

Morning Richard

The "HPCCGetDescStatsPaged" is our Roxie query name which is being called from our internal data access library.

This only happens when getting xml from Roxie. It's not linked to one roxie query as it can happen on any.

Thanks

David
daviddasher
 
Posts: 5
Joined: Fri Dec 08, 2017 12:39 pm

Fri Jun 15, 2018 12:10 pm Change Time Zone

The error message gives a line number and location. Can you include the code, please?
tlhumphrey2
 
Posts: 256
Joined: Mon May 07, 2012 6:23 pm

Fri Jun 15, 2018 12:47 pm Change Time Zone

Do you have any tracing that would tell you what the xml returned from Roxie is when you get these errors?
richardkchapman
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 108
Joined: Fri Jun 17, 2011 8:59 am

Fri Jun 15, 2018 1:21 pm Change Time Zone

Hello

No tracing currently, only in our core library which was in the original message. Is there anything we can turn on in the Roxie config that would help?

Thanks

D
daviddasher
 
Posts: 5
Joined: Fri Dec 08, 2017 12:39 pm

Mon Jun 18, 2018 8:51 am Change Time Zone

Roxie doesn't log what it writes - but you'd probably be better off tracing what you receive anyway.

What led you to think that the result from Roxie was corrupt (as opposed to some bug in your core library, for example)?

Richard
richardkchapman
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 108
Joined: Fri Jun 17, 2011 8:59 am


Return to ECL

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron