ERROR DA0003(EXCEPTION CS: JOB ALREADY IN USE)

building reports desktopintelligence
1

Hello Guys,

I’ll be so glad if anyone can help me resolve my peculiar situation for resolving the above error?

I have ran the DESKI reports from various workstations and even directly on the BO Server and it still returns the same error "ERROR DURING SQL EXECUTION (DA0003). Details show EXCEPTION CS: JOB ALREADY IN USE.

I have scanned previous posted resolution on the forum for the error but the closest resolution to it was what was posted by Asnair on Oct 22nd 2007. It goes thus:

“F5 is hardware that provides load balancing on the network. We have 4 Bus Obj servers. The users type in the URL which sends them to the F5, which then rotates among the 4 servers (if one server goes down it will bypass it). Our network team manages the hardware and had to reset the TCP/IP timeout specifically for our Business Objects URL. I hope this helps.”

My situation here is that I do not have any F5 hardware as I do not have a cluster so I do not know where and how to “Reset the TCP/IP timeout specifically for our Business Objects URL” as stated.

I have a single BO Server (On Windows 2003 Server) with 4 CPU that has its repository on an Oracle database server (On Unix).

Any other required info will gladly be supplied.

Thanks a million.

Oloruntoye Nation

Oloruntoye :nigeria: (BOB member since 2005-08-23)

2

Go through this KB article

.

haider :es: (BOB member since 2005-07-18)

3

Hello,

I have the same problem with Desktop Intelligence (Not web InfoView).
Does anyone knows how to solve it?

Thank you

vectras :lithuania: (BOB member since 2007-06-13)

4

As is typical with BO, they changed the way they do support and now all of the KB links do not work. Try this https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3132303431383726 . Don’t know if you need a support account to see this or not.

pcgeekus :us: (BOB member since 2003-10-16)

5

You do need a support account. I just tried to log in, and was prompted for a password and logon.

martin_black :uk: (BOB member since 2008-03-04)

6

The same error we got yesterday when we update the Universe and try to schedule the reports;Somehow the reports are not updating the changes in the universe automatically, so we opened the reports save it again and run the reports, then they are working fine.

Thanks
Ravi

br81 (BOB member since 2007-07-04)

7

Joined: 16 Oct 2003

Posts: 41
Location: Quad Cites, IL

Posted: 28 Aug 2008 20:28
Post subject: Re: ERROR DA0003(EXCEPTION CS: JOB ALREADY IN USE)

As is typical with BO, they changed the way they do support and now all of the KB links do not work. Try this https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3132303431383726 . Don’t know if you need a support account to see this or not.

What is the user name and password we need to pass for support site.

v_b (BOB member since 2007-12-27)

8

Please refer to the following link for the solution.

this problem seems to be prevalent if you are using IE7 and the timeout problem. If you add a ReceiveTimeout DWORD with a new timer value in the registry. It works :slight_smile:

awsns (BOB member since 2008-08-04)

9

Hi

Do you make this new DWORD base value as decimal, hexidecimal or does it not matter?

irish_stan :ireland: (BOB member since 2003-05-13)

10

We get the same error when using user defined objects (udo).
However the udo file has been migrated from 6.5 to Xi (by mearly copying from one folder to the next).
Reports work fine if not using udo’s.

Any thoughts,
mtbIT

mtbIT :uk: (BOB member since 2007-12-05)