Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Forms 10g: Please help on Urdu Language Support

Ahmed HaroonDec 5 2016 — edited Dec 12 2016

hi all,

Database 11gR2, Forms 10g

Test App Server: OS = Windows 2003

Development:

OS = WinXP

created an entry in default.env file as  NLS_LANG=AMERICAN_AMERICA.AL32UTF8 which cause problem so remark it.

AMC.@.testdb > SELECT *

  2  from NLS_DATABASE_PARAMETERS

  3  WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');

PARAMETER                      VALUE

------------------------------ ----------------------------------------

NLS_LANGUAGE                   AMERICAN

NLS_TERRITORY                  AMERICA

NLS_CHARACTERSET               WE8MSWIN1252

We temporary changed above character set to AMERICAN.AMERICA.AL32UTF8 but we have to use WE8MSWIN1252 because here are some application modules running on Very Old version of Forms and Reports which is 6i.

created a Function to get values in xmltype ( thanks to Billy Verreynne ) through an another Function which convert these values in normal format ( thanks to odie_63 ) but due to some data in Urdu Language it not showing those column data as it should be. the first function getting data through a Web Service and data is in utf-8 character set.

link for above mentioned topic: How to access API through Web Service in Oracle 11gR2

@"odie_63" advised me in his Reply # 13 of topic Oracle 11g: Character Set / Language Problem :

As for your issue in Forms, I suggest you ask over in Forms space.

please help how to display Urdu Language in Forms 10g? it is very similar to Arabic Language and Right to Left.

regards

Comments

Sherry George

Hi Bhaskar,

Did you forgot to post the error message? Setting that parameter (to 1 or 2) allows OBIEE users to call database functions. Here is the documentation.

https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-C2C5B43E-4BB9-4ED7-94DE-D262698DCF98.htm#BIMIG-GUID-C2C5B43E-4BB…

Edit: There shouldn't be any impact to existing reports (but you would know better in term's of security who needs what access). Also you cannot  do it through EM.

3427784

I was in the same boat a while back. I believe setting it at level 2 lets all users call database functions in OBIEE. If I find my reference from my notes, I'll post it over here.

User_1JG01

Sherry George,

sorry my bad

here you go

++++++++++++++++++++++++++++++++++++++++++++++++

Odbc driver returned an error (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)
++++++++++++++++++++++++++++++++++++++++++++++++
Sherry George

ok, and did you confirm that the report that throws the error uses "Evaluate" in it's criteria? If so change the value of the param to 1 or 2 and test. Here is the 11g doc for the same.

https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/configfileref.htm#BIESG417

The links  explain the usage and what the values mean and possible security vulnerabilities if  not set to zero.

Syedsalmancs110

Just to add to all above comments:

EVALUATE_SUPPORT_LEVEL value 1 or 2 meaning:

For value 1 Evaluate is supported for users with manageRepositories permission(it is assigned through application policies to an application role of which user is part of)

For value 2 Evaluate is supported for any user.

User_1JG01

Hi Sherry

thanks for your inputs, yes i have noticed EVALUATE function has been used across various fields in couple of reports

guess based on above definition also provided by Syed , i m thinking to go for

VALUATE_SUPPORT_LEVEL = 1;

So once i make these changes, should i have to request my IT team to restart the entire OBIEE servers or is  there anything that i could do from my end through EM/Console to have these changes reflected immediately

Please share your inputs

Regards:

Bhasker.V

Jsglp

Sherry George
Answer

Hi Bhaskar,

If you set the value to 1 then only  users with the manageRepositories permission will be able to run the reports. And normal bi user's doesn't have that permission. But if this is required only for users with that permission then set the value to 1 and restart BI services or if all users need to run reports with "Evaluate" in it, then set to 2 and restart services.And you can restart the services from EM.

Marked as Answer by User_1JG01 · Sep 27 2020
Syedsalmancs110

Make the change in NQSConfig.INI i.e. define EVALUATE_SUPPORT_LEVEL

EVALUATE_SUPPORT_LEVEL = 1;

Save the file

Through either EM or through command console restart your OPMN managed BIEE Services(coreapplication_obis1,coreapplication_obips1 etc..)

User_1JG01

sure

EVALUATE_SUPPORT_LEVEL = 2;

guess i wanted to go with 2 with your explanation,

is there a way to change it from the front end applications, rather than doing this from back end

where i searched for this in the directoty i have 2 of these files NQSConfig.INI

one located under instance/instance1/....../coreapplication_obis1/

Other one is under Oracle_BI/bifoundation/......./OracleBiServerComponent/

Please let me know

Regards:

bahsekr.V

jsglp

Sherry George

You should make the edit in the file itself. And the file is the one under the instance directory. Also take a backup before editing the file.

User_1JG01

Thanks for all the info. m all set with this request

Regards:

Bhasker.V

Jsglp

1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 9 2017
Added on Dec 5 2016
21 comments
4,150 views