Table Access

building semantic layer
1

Hi Folks,

I was running a report, in the mean time, one of our DBA locked a table. I got the error message as ’ is undefined’. Is there any way to access the table eventhough the tables are locked? Do we have any options on the designer/supervisor level, like uncommitted read options?

Thanks in Advance for your reply.
Ravi.

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

2

Ravi,
If you are using BO 4.1.x,add END_SQL=WITH UR in [GENERAL] section of your parameter file
for Uncommitted Read.

Hope it helps.

Regards,
Durgesh

Hi Folks,

I was running a report, in the mean time, one of our DBA locked a table. I got the error message as ’ is undefined’. Is there any way to access the table eventhough the tables are locked? Do we have any options on the designer/supervisor level, like uncommitted read options?

Thanks in Advance for your reply.
Ravi.

Listserv Archives (BOB member since 2002-06-25)

3

Durgesh, Is this still a way to query SQLServer as an uncommitted read…hence preventing me from competing with users on an OLTP database. The DBA’s are positively in snit over this issue. :roll_eyes:

Cindy Clayton :us: (BOB member since 2002-06-11)

4

Cindy,
The example I gave you in that list serv post used to work with DB2 and version 4.1 of BO. That was in my previous project.

For SQL Server, you need to set transaction isolation level for the connection first and then you can use WITH NOLOCK or WITH UNCOMMITTED READ.

SET TRANSACTION ISOLATION LEVEL
{ READ COMMITTED
| READ UNCOMMITTED
| REPEATABLE READ
| SERIALIZABLE
}

I dont know a way to do this in BO though.

dcdas :us: (BOB member since 2002-06-17)

5

Cindy,

Did you finally figured out how to do it in BO?

Thanks
Reema

reemagupta (BOB member since 2002-09-18)

6

Nope I don’t think so. Its been a while though so I’ll keep thinking about that.

Cindy Clayton :us: (BOB member since 2002-06-11)

7

Thanks Cindy

If you think of anything or find any solution, do post it here.

Reema

reemagupta (BOB member since 2002-09-18)