SQL Prepare Request

building reports webintelligence
1

How can you eliminate BO prepare requests?

It seems that all requests from BO generate a prepare request. The SQL Prepare request takes a few seconds of CPU time and makes an entry in DBQL as a record of the prepare request. This all happens as expected.

I’ve been asked how to eliminate BO issuing the prepare request. I believe this is being done at other customer sites.

Thanks!

Eileen King :us: (BOB member since 2002-07-10)

2

Hi Eileen,

Are you using Teradata as a database?

I had a similar (if not exactly the same problem) some time ago when we ran BOBJ against a Teradata database. Every query generated by a WebI report first created a prepare request and only then the query was executed. We tried several things (including an SAP tech support) but we haven’t succeeded in changing the behavior. Not to mention that the tech support was of very little help and even lesser understanding of the actual problem :roll_eyes:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Elileen, This post alludes to the fact it may be a check box property of the Teradata DB driver:-

https://bobj-board.org/t/22976/3

Mak 1 :uk: (BOB member since 2005-01-06)

4

Mak,

I’m not sure that is the answer but my first thought was that it was related to an option in the connection. I’ll direct them to take a look at that!

Thanks!

Eileen King :us: (BOB member since 2002-07-10)

5

No worries Eileen, fingers crossed. There is very little out there on this, so let us know what you find.

Mak 1 :uk: (BOB member since 2005-01-06)