Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] WebFocus Creating a URL Link with chinese , german characters - multicode

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] WebFocus Creating a URL Link with chinese , german characters - multicode
 Login/Join
 
Member
posted
Hi, we have customer requirement with crystal reports - .rpt files - but when publishing using webfocus Creating a URL Link - report name with chinese / german characters the link name getting updated with garbage characters instead of whatever we sent.

1) we are using below webfocus configuration - below from install.cfg file, oracle database

INSTOPT_Product=WebFOCUS
INSTOPT_Version=8.2
INSTOPT_Service_Pack=01

2) in nlscfg.err we have below contents

LANG = AMENGLISH
CODE_PAGE = 65001
DATEOUTPUT = DEFAULT
COLLATION = CODEPAGE


3) request -
here report name is 2.3CR_Desktop_Report_-耳_虫.url, and description is 2._3bCR Desktop Report -耳 虫

http://W2016:9080/ibi_apps/rs/...on=put&IBIRS_object=
aHR0cDovL3d3dy55YWhvby5jb20=





when we call above webservice it is going to insert data into QV tables.
wf_reposobj table under OBJNAME column is storing with special characters
Ex - durchgeführte_Validierungeäöün.url & CR_Desktop_Report_-耳_虫.url

but wf_nlsobj table under OBJDESC column is having garbage character - this will be shown in Analytics UI - this is the issue for customer as of now.
Ex – durchgeführte_Validierungeäöün & CR Desktop Report -è³ è™«

Looks like this issue might be with webfocus - because while inserting into wf_reposobj table they are encoding and inserting properly but while inserting into wf_nlsobj table it is inserting garbage characters. if we update with special characters in wf_nlsobj table - on UI its showing fine.

Could someone shed some light on this - as this is ongoing issue from past few months. customer is escalating on this.

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 6 | Registered: February 12, 2020Report This Post
Virtuoso
posted Hide Post
Hi Sateesch

First of all welcome to Focal Point, I think you will find it a great place to get answers to your development questions.

What database is the WebFOCUS repository using. You should check the collation settings on there as well. Also double check that your WF reporting server NLS setting match the 65000 of the WF Client.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
Thank you for immediate response. for WebFOCUS repository we are using oralce database.

we checked collation settings in database, NLS settings in webfocus server & webfocus client - everywhere it is 65001 - Unicode(UTF-8).

But my question is how wf_reposobj table is saving whatever we sent including chinese/german characters but other table wf_nlsobj table is saving with garbled characters for chinese/german letters.

could you please create urls with below examples and let me know how they are saving in database. please remove if name has any spaces.

2.3CR_Desktop_Report_-耳_虫.url
durchgeführte_Validierungeäöün.rpt
CCИзмененияпопродуктам.rpt

This message has been edited. Last edited by: sateeshc,
 
Posts: 6 | Registered: February 12, 2020Report This Post
Virtuoso
posted Hide Post
Sateesh

I am not set up with Oracle. I think you need to report this to techsupport as it appears you have all your setting correct but something is causing the garbage in that table.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
Thanks for your reply. Could you please check if you have mssql / sql set up - is it possible to create URL's with chinese/german characters?. if the database contains those 2 tables - could you please check the contents.

Thank You
 
Posts: 6 | Registered: February 12, 2020Report This Post
Virtuoso
posted Hide Post
Sateesh

I'm sorry but I am using SQL Server 2012 and it doesn't list any UTF8 collation sequences for me to set up the repository database with. Maybe someone else has a more recent version of SQL Server. I still think you need to report this to techsupport.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
ok thank you..we will check with IB Techsupport and update you if we got any findings.
 
Posts: 6 | Registered: February 12, 2020Report This Post
Member
posted Hide Post
For Quality View Tomcat - server.xml - changed connector like this :
Connector connectionTimeout="20000" maxPostSize="-1" port="9080" protocol="HTTP/1.1" redirectPort="8443"

and by removing
URIEncoding="UTF-8" useBodyEncodingForURI="true"

then after this OBJDESC column of wf_nlsobj table saving report name with special characters like multicode and unicode
 
Posts: 6 | Registered: February 12, 2020Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] WebFocus Creating a URL Link with chinese , german characters - multicode

Copyright © 1996-2020 Information Builders