Forum

This content is now out of date.

Visit Our Community

Report display stuck on some Unicode problematic characters

It seems that having some unicode characters (as data values) in a report display causes it to be stuck on 'Please wait' ajax.


This happens only when the problematic characters are about to be displayed.

Example of such a character: 'u0018'

my Yellowfin Application Details
Current Schema Version: 20121119
Original Code Version: 20130627
Current Code Version: 20131023
Import Version: 4.27
Build Type: FULLVERSION
Current Session Count: 1
Current Session Timeout: 7200 seconds
Application Server Boot Time: Tue Nov 19 14:22:19 UTC 2013
Current Server Time: Tue Nov 19 14:49:00 UTC 2013 (UTC +0000)
Request Listener: Initialised
Request Count: 1
Configuration Database: Microsoft SQL Server 11.00.3128
Encryption Functions: Ok
BIRT Report Engine: Not available
Geometry Cache: 0 / 4000
Hi Oren,

I inserted the unicode character 'u0018' (?) as a data value in a table but it didn't cause any problems with a report:


Forum image


and I haven't done any special tweaking of my Yellowfin setup to allow for unicode.

I'm wondering if you could send us your browser console logs, maybe there is a useful error message contained within there.

regards,
Dave
Hi Dave,
We tested this issue on several browsers (Firefox, IE-11, Chrome) and all of them could not display the report. we traced the problematic character and it's 'u0006' - ACK character (we ran the report with different filters parameters this time).
The error we got from IE was: "XML5617: Illegal XML character. Line: 478, Column 44", the attached file has this line as well as a line before and after this one.
We hope that you can do some escaping for those characters.
Hi Oren,

we are wondering if you are using your own version of Tomcat (i.e. not the Tomcat that is installed with Yellowfin), could you please confirm this?

The reason I ask is because the ACK character is not causing any problem in my Yellowfin instance as you can see from the below screenshot:


Forum image


regards,
Dave
We are using the Tomcat that was supplied with Yellowfin: Apache Tomcat/6.0.35
It seems that this issue only happens when a report has filters (doesn't even matter on what fields).
Hi Oren,

that's interesting, you've got the same version of tomcat as I'm using, and also my report has filters, and yet no problems with the ACK character.

There must be something different in your report than in mine, are your filters cached? Are you using Left Nav filters or top/bottom/left/right filters?
Could you please attach a screenshot of the report before and after it gets stuck?

regards,
Dave
I've attached 2 screenshots here, also, I've noticed that the report this issue happens only when I press the filters "Go" button, then the report just won't load - YF_Capture4.png
Hi Oren,

unfortunately the screenshots didn't get attached, could you please try again? Also, don't forget to answer the question "are your filters cached"?

regards,
Dave

Forum image


Forum image


Forum image


The filters are not cached in this report, but I've seen this happening also with cached filters.
Hi Oren,

Thanks for that. I have tested on a few machines here in the office though cannot replicate.

The errors you are seeing on the page, is exactly what we used to see in older releases of 6.3, and using unicode characters + the left side nav filter.

The things below should isolate where the issue lies;

-Can you please create a report with a filter, and do NOT use left side filter.
Just use either Top/Bottom filter displays.

-Send across all information from the 'system information' page. Open all sections and copy everything and send to us.

-Send across the 'server.xml' file located under Yellowfinappserverconf

You can email across the results to support@yellowfin.bi and reference this post.

Hopefully having this last bit of information should help us identify the issue.

Thans,
David
Hi David,
issue reconstructed with YF7.

-Erez
Hi Erez,

Hmm, I'm thinking it could an issue with your YF configuration.

-Can you please create a report with a filter, and do NOT use left side filter.
Just use either Top/Bottom filter displays.

-Send across all information from the 'system information' page. Open all sections and copy everything and send to us.

-Send across the 'server.xml' file located under Yellowfinappserverconf

Thanks,
David

Hi David,
YF7 Build 20131224 still misbehaves.
I'm emailing support the requested files.
Regards,
Erez
Hi Erez,

Thanks for the server.xml.

It looks like you�re actually connecting to another application server, so we�re thinking that server (MCE-BI-YF) is not handling UTF-8.
Can you try adding this to your Server.xml (see bold text) then restart YF.
[code]
<!-- Uncomment this for an AJP connector, to connect tomcat to another
web server such as Apache or IIS -->

<Connector port="8009" protocol="AJP/1.3" redirectPort="443" URIEncoding="UTF-8" />
[/code]

Please let me know how you go.

Regards,
David

Hi David,
we've relaunched YF 7 build 20131224 as a clean install on a Unix machine. The server's name is MCE-BI-YF. The YF configuration database runs on the same instance. Only the data comes from a different server.
The problem persists.
What would you advise?
Thanks,
Erez
Hi Erez,

Thanks for the info, though I believe you may still have the same issue because of the server.xml.

Can you please try adding the additional line as mentioned in the previous post and let me know how it goes?

Thanks,
David
Hello,
I have not made the changes as suggested, but am happy to say the problem is fixed after updating to YF 7 build 20140131.

Thanks Erez for letting us know, but we really do not understand what changed that would have fixed this issue :(

We are dumbfounded!

Please let us know if this issue pops up again.