Deski Issues with Oracle 10G database

building reports desktopintelligence
1

Hi,

I am having issues with Deski using oracle 10g database.(we are using Hyperroll functionality with Oracle database).

when i am creating a simple reprot wih just one object it is failing in deski which runs pretty good in webi.

we have XI R2 sp1/sp2 with Fix pack 2.4 installed.

the error is as below:

Error During SQL Execution(DA0003)

Exception: DBD, ORA-01002: fetch out of sequence
ORA-02063: preceding line from CONCEPT25
State: N/A

Any ideas to fix this issue is appreciated

Thanks
SUJAY

sujaym123 (BOB member since 2007-08-29)

2

It sounds like paramater Autocommit=1 is set and you need to set it to Autocommit=0

Check on your C drive, under Program Files\Business Objects Data Access Folder Oracle and look for the oracle.sbo file.

In there check to see if autocommit=1…if it is, then set it to 0 and that should do the trick

Janie

Downij2 (BOB member since 2007-09-05)

3

Things that have helped in the past also revolve around changing the FETCH size in your connection settings. Lowering this number will potentially increase the fetch time, but provide a more consistent retrieval of rows… especially on networks that have a lot of noise.

digpen :us: (BOB member since 2002-08-15)

4

Solution for this issue:

e.g. BO XI R2

edit:
[drive]:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\oracle\oracle.sbo

add parameter:

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

it looks like this:

<?xml version="1.0" encoding="UTF-8"?> 
<Defaults>
    <Parameter Name="Family">Oracle</Parameter>
    <Parameter Name="SQL External File">oracle</Parameter>
    <Parameter Name="SQL Parameter File">oracle</Parameter>
    <Parameter Name="Description File">oracle</Parameter>
    <Parameter Name="Strategies File">oracle</Parameter>
    <Parameter Name="Driver Level">31</Parameter>
    <Parameter Name="Array Fetch Available">True</Parameter>
    <Parameter Name="Array Fetch Size">250</Parameter>
    <Parameter Name="Array Bind Available">True</Parameter>
    <Parameter Name="Array Bind Size">32767</Parameter>
    <Parameter Name="Query TimeOut Available">False</Parameter>
    <Parameter Name="Binary Slice Size">32000</Parameter>
    <Parameter Name="CharSet Table">oracle</Parameter>

No

…
…

and save the file.
Next step is restart business objects application if you have opened.

It works for me.

jezyk :poland: (BOB member since 2005-05-13)

5

Hello,

thanks for posting the solution with this transactional parameter.

However when doing this (I needed this solution to be able to access a mysql table through an oracle database via a db link), the BO desktop client (BO 6.5) is no longer capable of contacting the server.

We are forced to start deski in “offline mode” which off course prevents us from downloading reports from corp docs or see-ing universe updates.

What is the underlying cause for not being able to contact the server anymore?

best regards,
Ruben

By the way: when we do not include the transactional parameters in de oracle.sbo file, then the error reported by deski is
ORA-01002: fetch out of sequence ORA-02063: preceding line from [mysql database] when trying to query the mysql table via oracle.

rsa :belgium: (BOB member since 2008-07-11)

6

Disabling the transactional parameter has solved the problem ora-01002. Using dblink to db2.

Thanks

Freestyle :ru: (BOB member since 2009-01-13)