Home » SQL & PL/SQL » SQL & PL/SQL » Generic application error (oracle 10g)
Generic application error [message #574414] Thu, 10 January 2013 03:30 Go to next message
patneel
Messages: 39
Registered: June 2007
Location: India
Member
Hi,

In order to display non-english characters properly in Business Objects reports, We have changed the NLS_LANG parameter at BO server level from ENGLISH_UNITED KINGDOM.WE8MSWIN1252 to AMERICAN_AMERICA.AL32UTF8

After this change non-english characters are coming properly but some of our existing reports started giving below error after this change.

A database error occured. The database error test is: (CS) "Error on Fetch: Generic Application exception" (WIS 10901)

Can anyone please provide inputs what could be the issue and how to debug this issue..dont find much information
Re: Generic application error [message #574418 is a reply to message #574414] Thu, 10 January 2013 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is "WIS 10901" and Oracle error?

I bet the error comes from string size as all characters in WE8MSWIN1252 are one byte length while they are from 1 to 4 bytes in AL32UTF8.

Regards
Michel
Re: Generic application error [message #574421 is a reply to message #574418] Thu, 10 January 2013 03:55 Go to previous messageGo to next message
patneel
Messages: 39
Registered: June 2007
Location: India
Member
Thanks Michel

WIS 10901 is Business Objects error code.. My same query runs properly at back end which has AL32UTF8 as character set..It seems to be error at BO processing..

What could be the possible resolution for this error..I mean how to find out which character is bad and causing issue
Re: Generic application error [message #574422 is a reply to message #574421] Thu, 10 January 2013 03:59 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
if this is BO error, you should post your query to BO forum.

regards,
Delna
Re: Generic application error [message #574423 is a reply to message #574422] Thu, 10 January 2013 04:02 Go to previous messageGo to next message
patneel
Messages: 39
Registered: June 2007
Location: India
Member
My purpose is just How i can find out lossy or trucncated character which causing this issue after this change..
Re: Generic application error [message #574426 is a reply to message #574421] Thu, 10 January 2013 04:17 Go to previous message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
patneel wrote on Thu, 10 January 2013 10:55
Thanks Michel

WIS 10901 is Business Objects error code.. My same query runs properly at back end which has AL32UTF8 as character set..It seems to be error at BO processing..

What could be the possible resolution for this error..I mean how to find out which character is bad and causing issue


You should then post your question in a Business Object forum, we have no way to know why changing a client character set can lead to an error in BO.
I told you what I think.
With this hint you can go on a BO forum and get a proper answer.

Regards
Michel
Previous Topic: Filter Special Characters
Next Topic: How can i use Substr to get required result
Goto Forum:
  


Current Time: Tue Sep 30 17:52:11 CDT 2014

Total time taken to generate the page: 0.10788 seconds