Business Objects XI R2 - Oracle Stored Proc - Deski report failing

[Former Member]

Business Objects XI R2

Hi All,

I have a stored proc created in Oracle 10 - see bottom for code

I run a deski report on iit - using it as a datasource. This works fine in Desktop Intelligence until I schedule the report from infoview - then I get the following error...

"Object failed to run due to an error while processing on the Job Server"

My other deski reports based on Universes are ok.

____________________________________________________

create or replace procedure test_PROC1

(Test_Rpt_Cur OUT SYS_REFCURSOR)

is

begin

open Test_Rpt_Cur FOR

SELECT ID, FIRSTNAME, LASTNAME

FROM test_table;

end test_proc1;

[Former Member]

Hi,

Could you check, No of jobs in CMC for job server?

If you could increasing the No of jobs would fix your issue.

[Former Member]

Hi,

Following information might help you to resolve the issue.

Deski reports are getting failed when we schedule recurringly. The same works fine when we manually refresh from deski.

Multiple NIC's are there and clustered environment with many servers.

Solution

Add "_outproc" switch (to release child job process) to the command line of deski job server and save changes, start the server and will be able to schedule the report.

Regards,

Sarbhjeet Kaur

[Former Member]

Thanks all for the suggestions, Any idea why these setting would ONLY affect a deski run on a stored proc?

[Former Member]

Hi All,

I've tried these but they haven't worked.

Any other ideas?

Thanks,

[Former Member]

Hi,

Could you please test the following solutions to resolve the issue.

Hi,

Could you please test the following solutions to resolve the issue.

Solution1:

Test the issue by inserting the following parameter in .SBO file.

<Parameter Name="Force SQLExecute">Always</Parameter> .

Solution2

Just put SET NOCOUNT OFF in the end of the stored procedure SQL.

If the above doesnu2019t works then please try the following solution.

Solution3

Make the new connection from the scratch using ODBC connection and test the issue or test the issue by using another version of connection like for example OLEDB.

I hope this will help you.

Regards,

Sarbhjeet Kaur

[Former Member]

Also,you can try the following solution if later is not helpful to resolve the issue.

To modify the Desktop Intelligence Job Server temp directory path in the Central Management Console (CMC), perform the following steps:

Log on to the CMC.

Click Server > <clustername>.Desktop_IntelligenceJobServer > Properties.

Modify Temp Directory with a shorter path.

Regards,

Sarbhjeet Kaur

[Former Member]

Hi,

Incase the solution suggested by Sandeep doesn'thelp to resolve the issue then please try the following solution.

Short the name of the report or universe.

Short the cache path for the DESKI server. Login to CMC

Go to servers,

Select Desktop Intelligence Cache server

Under properties tab change the cache location to short path.

Make the changes at registry level also HKEY_LOCAL MACHINE\SOFTWARE\BUSINESSOBJECTS\SUITE115\RAS21\DESKICACHESERVR and point it to new cache path .

Regards,

Sarbhjeet Kaur

[Former Member]

Hi,

Cause of this issue :

Once the Job Server recieves the scheduled job and spawns a new child process, the child process is unable to complete the job. The child process constantly is waiting to load the job. Looking further into the log and specifically the startup script, the -port option was incorrectly used (-restart-port) and didn't allow the child process to bind to the correct port using the correct DNS name.

In Order to resolve this issue follow the steps given below..

1.Open CCM

2. Stop Server

3. Right Click Server and go to Properties

4. insert -port option in to command line, example below

ex. "
win2k3\C$\ProgramFiles\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\JobServerFullClient.exe" -service -name win2k3.Desktop_IntelligenceJobServer -ns win2k3 -objectType CrystalEnterprise.FullClient -lib pp_procFC -jsTypeDescription "Desktop Intelligence Job Server" -maxDesktops 0 -restart -port win2k3.it.bo.example

5. Save setting and restart server.

Hope it helps.

Regards,

Sandeep Singh