WIS 10901 && ORA-01722

[system]

Hello All,

I am getting wis 10901 error when i run the query from WebI,
its working fine when i run SQL from SQL*Plus and DeskI

Here is the error

Database error: ORA-01722: invalid number
. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)

Can you please suggest any way to get rid of this error

Thanks in advance

MSR

---

KSReddy (BOB member since 2006-08-17)

[system]

Can anyone please let me know…how to solve this error

Reply will be really appreciated

thanks
msr

---

KSReddy (BOB member since 2006-08-17)

[system]

you can find the solution in this thread…

120×120 10.4 KB

I have identifed one of the object which is a number and the description is as to_char(DateVariable,‘YYYY’) i have changed it to to_number(to_char(DateVariable,‘YYYY’) But the above object is not creating the problem. When i remove a condition between two Date type objects , then i am not getting the error. Please help me lampack93 (BOB member since 2008-05-23)

---

lampack93 (BOB member since 2008-05-23)