BusinessObjects Board

Timeout that shuts down the query?

Dear BO Experts,

I have a query that runs fine in SQL developer in 47 minutes.

I have a report with this query as Free Hand SQL and it crashes after running 30 minutes with the error CS Unexpected behavior : -1

This happens in BI Launchpad, Webi Rich Client and IDT.

The Connection in IDT has a Pool Timeout of 60 minutes.

Do you know where could there be a limitation of 30 minutes?

Thanks a lot!

:nopity:


Victor_BCN :es: (BOB member since 2009-09-15)

there are a lot of possible timeout-settings:

but you have the urgent need to rework your SQL-statement.
47min does not make sense.
try to use temporary tables, indices, partitions, etc.


n8aktiv :de: (BOB member since 2018-12-29)

Hi n8aktiv!

Indeed the case is being investigated by the DBAs. Cos 1 month of data takes 17 secodns while 2 months of data takes the 47 minutes…

I had a look at the link, everything seems to be sync as the doc says.

Damn, what can it be…I opened a ticket to SAP

Thanks a lot!
:wave:


Victor_BCN :es: (BOB member since 2009-09-15)

The issue was found!

the problem was the version of JDBC we were using.

We have Oracle12 and used the JDBC8, this one gave error from time to time apart of not allowing queries more than 30 minutes run.

I downloaded the ojdbc7.jar and deployed in a folder, then went to the oracle.sbo and in the section, instead of pointing to the ojdbc8.jar now it points to the ojdb7.jar

and problem solved :slight_smile:

:wave:


Victor_BCN :es: (BOB member since 2009-09-15)