BI Query Wizard result doesn't appear in table view

[Former Member]

Hi,

I'm trying to create an iview showing the result of a query.

First of all I've tried the connection between vc and portal deployinga simple form iview and it works.

Then I created a BI Jdbc system (Oracle 9) in portal and the connection works.

Then I got the system in my systems list in VC and my schema and table in the tree and I put it into the model.

Now I'm running the BI query wizard getting "All Data"

choosing my db and my table and I get the complete list of the records in it.

So I think it's working but if I put the output in a table view and I click on preview this message appears:

LOGIC ERRORS/WARNINGS APPEAR: [W] element "all data" is not in use.

Note that

- opening the wizard in the log panel a lot of execption e='c? is not defined appears

- if I try to write the query myself I get the ORA-00933 error.

Thanks a lot

Massimiliano

[Former Member]

I got the same problem with query on R/3 system on table KNA1.

Any ideas??

[Former Member]

Hi Massimiliano,

First of all save your Model.

I hope any of the following steps will solve your problem:

1. Refresh your IE.

2. Close your Model and re-open it.

3. Close the IE and open a new IE and then continue.

[Former Member]

Thanks Deep,

but this doesn't solve.

I've tried to open the model in different client but the error is the same. I've tried to change the query also. I've used freeform and as a result the message is: [W] element freeform is not in use.

Bye

Massimiliano