A database error occured. The database error text is:[.(WIS 10901)]

Database Client:- Informix 2.90 CSDK ( installed on SUSE LINUX Enterprise Server 9)

Database Server :- Informix Dynamic Server 10 (Installed on Windows 2003)

BO :- Business Objects Enterprise XI3.0 (Installed on SUSE LINUX Enterprise Server 9)

Client tool (Installed on Windows 2003)

Report Type: - Web Intelligence and Desktop Intelligence

Summary :-

When we run webi report from Infoview or CMC we can view report but as soon as we clicked on Refresh Data, we get this error message "A database error occurred. The database error text is:(WIS 10901)"

In other hand when try to create new report from Infoview we get same error. when you click on OK process will complete and we get one message "No data to retrieve Query "

When we go for Modify from Inforview >> Edit Query >> Run Query we get same error.

Checked DSN from isql and odbctest.sh it works properly fetch data from table.

But when we try to fetch data from Infoview or CMC we get error.

From client machine when we try to create report through Webi rich client it works fine.

When we try to run Deski report from Infoview we get error " SetPrompts failed- The following data providers have not been successfully refreshed:Query1 with xxxx.(DMA0007)

ODBCTEST.SH

Result:-

xir2@D2659SUSE:/home/xir3/bobje> ./odbctest.sh

System DSNs

User DSNs

[CRSQLServerWP]

[CRSybaseWP]

[CRText]

[BOBJTEST]

DSNs from /home/xir3/bobje/odbc.ini

[CRSQLServerWP]

[CRSybaseWP]

[CRText]

[D2659INF]

[BOBJTEST]

DSN name (without []s): BOBJTEST

User name: Administrator

Password:

----

---

Connected!

sql-statement

help [tablename]

quit

----

---

SQL> select * from employee

----

---

--

---

+

---

+

---

+ --

---

+

first

last

address

city

state

----

---

--

---

+

---

+

---

+ --

---

+

sun

chandrakar

Chinchwad

Pune

MH

ram

chandra

Ayodhya

Ilahabad

UP

Anup

Verma

Birla Palce

Hyderabad

AP

----

---

--

---

+

---

+

---

+ --

---

+

3 rows returned

ODBC.INI

[ODBC Data Sources]

CRSQLServerWP=DataDirect 5.1 SQLServer Wire Protocol Driver

CRSybaseWP=DataDirect 5.1 Sybase Wire Protocol Driver

CRText=DataDirect 5.1 Text Driver

BOBJTEST=IBM INFORMIX ODBC DRIVER

[BOBJTEST]

Driver=/home/informix/lib/cli/libifcli.so

Description=IBM INFORMIX ODBC DRIVER

Database=bobjtest

LogonID=Administrator

pwd=password

Servername=d2659inf

CursorBehavior=0

CLIENT_LOCALE=en_us.8859-1

DB_LOCALE=en_us.8859-1

TRANSLATIONDLL=/home/informix/lib/esql/igo4a304.so

Please advice me .............

Thanks in Advance

Suraj Kumar Chandrakar

Edited by: Suraj Chandrakar on Aug 4, 2008 9:26 PM