Advertisement

06.28.2007 at 10:42PM PDT, ID: 22666063
[x]
Attachment Details

SQL Job hangs when running a DTS Pkg that executes a BusinessObjects report from a Batch file

Asked by klgrube in MS SQL DTS, Business Objects

Tags: sql, dts, job, hangs

Hi!

   I have a Windows batch file that exectues BO 6.5.  The text of the batch file is here

     "C:\Program Files\Business Objects\BusinessObjects Enterprise 6\bin\busobj.exe" "C:\BusinessObjects Automation\ShippingReport.rep" -nologo -user grubek -pass mypass -keyfile Bomain

I also have this batch file being executed from within a SQL Server DTS package as an Execute Process Task.

The text of the Execute Process Task is:

     c:\BusinessObjects Automation\ImportShipments.bat

And I have scheduled the package as a SQL Server Job.

The intent of the process is to upload data from a BO Universe to a SQL Server Database.   When I execute the package from the Enterprise Manager, it runs fine.  The table in SQL gets updated (or rather re-created) through the onOpen macro I wrote that refreshes the data provider then exports to a SQL Server table.   But, when the job runs, the package / process seems to hang.  I can see in the windows task manager that Business Objects appears to be running.   But the job just sits there and doesn't update or recreate the table.  The process runs in about two minutes when I run it from the Enterprise manager, but sits there for an hour without doing anything when the job runs.

I am in the SysAdmin role in SQL Server.
I am in the Administrator Group on the server. so I guess that makes me a local admin.
I gave myself explicit full rights to the folder where the batch file is located.  
I am the owner of the job
I am the owner of the DTS package
I have set explicit rights to the ProgramFiles/BusinessObjecs folder.

I almost looks as though BO can't connect to the Universe, but there's no error message or anything.  It's just hanging.

The thing is that this was all running nicely on this same box under Windows 2000.  We upgraded to Windows 2003 a week or so ago, and I'm sure I just didn't set something up the same.  I just can't figure out what it could be.  I have other non-BusinessObjects jobs that are running just fine.

Any suggestions?  I'm really desperate to get this fixed.  Please help if you can

Thanks!
KarenStart Free Trial
 
Keywords: SQL Job hangs when running a DTS P…
Title
1 DTS
2 SQL DTS not Executing
3 DTS Expert
4 Saving DTS Packages
5 Clear Data from an EXCEL Worksheet …
6 Using global variables within DTS
 
Loading Advertisement...
 
[+][-]07.01.2007 at 05:55AM PDT, ID: 19398603

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.01.2007 at 08:45AM PDT, ID: 19399371

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.01.2007 at 09:27AM PDT, ID: 19399493

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.01.2007 at 09:29AM PDT, ID: 19399496

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, Business Objects
Tags: sql, dts, job, hangs
Sign Up Now!
Solution Provided By: nigelrivett
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.01.2007 at 10:24AM PDT, ID: 19399616

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.01.2007 at 10:41AM PDT, ID: 19399664

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.01.2007 at 10:44AM PDT, ID: 19399670

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.01.2007 at 10:45AM PDT, ID: 19399672

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.01.2007 at 10:53AM PDT, ID: 19399694

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.01.2007 at 10:56AM PDT, ID: 19399699

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 08:22AM PDT, ID: 19404238

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 03:28PM PDT, ID: 19407400

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2007 at 03:54PM PDT, ID: 19407526

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32