OraFAQ Forum: SQL & PL/SQL » Generic application error

Home » SQL & PL/SQL » SQL & PL/SQL » Generic application error (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Generic application error [message #574414]

Thu, 10 January 2013 03:30

patneel
Messages: 47
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

Report message to a moderator

Re: Generic application error [message #574418 is a reply to message #574414]

Thu, 10 January 2013 03:49

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: Generic application error [message #574421 is a reply to message #574418]

Thu, 10 January 2013 03:55

patneel
Messages: 47
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

Report message to a moderator

Re: Generic application error [message #574422 is a reply to message #574421]

Thu, 10 January 2013 03:59

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

Report message to a moderator

Re: Generic application error [message #574423 is a reply to message #574422]

Thu, 10 January 2013 04:02

patneel
Messages: 47
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..

Report message to a moderator

Re: Generic application error [message #574426 is a reply to message #574421]

Thu, 10 January 2013 04:17

Michel Cadot
Messages: 68645
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 01:44:31 CDT 2024