Error in Desktop Intelligence

[Former Member]

Greetings,

I have an error when I tried to run a report using Free Hand SQL, I run the query in toad and it retrieved Data but I put in desktop intelligence, I received the following error:

Exception: DBD, ORA-01002: fetch out of sequence

ORA-02063: preceding line from CENT.COM

State: N/A

I don't understand is what happening. Any idea ?

[former_member212749 · Accepted solution]

Hi Migual,

It is an error from the Oracle which tell you the error ORA-01002 relates to cursor issue.

and the other ora-02063 distributed transactions .

Hope it would be better to discuss with your DBA.

Regards

Prashant

[Former Member]

Hi Miguel,

Could you follow the above :

To work around this behavior, add the following line to the oracle.sbo file find here:

%BO_HOME%\BusinessObjects Enterprise 115\dataAccess\RDBMS\connectionServer\oracle:

Line to be added is :

"<Parameter Name="Transactional Available">No</Parameter>"

The section should like like this according to your oracle version:

<DataBases>

<DataBase Active="Yes" Name="Oracle 8.1">

<Aliases>

<!-- You can add an alias here if you are using some connections that are defined with an older database engine -->

<Alias>Oracle 8</Alias>

<Alias>Oracle 8.0</Alias>

</Aliases>

<Parameter Name="Transactional Available">No</Parameter>

</DataBase>

Regards,

Sarbhjeet Kaur

[Former Member]

Thank you for your support. I appreciate your help.