COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: Stejawh on 26 Nov 2008 09:12:53 AM

Title: Unable to bulk load data
Post by: Stejawh on 26 Nov 2008 09:12:53 AM
Hi,

We've got a macro that runs a Table Only Publish. 

On external Job Servers the macro falls over with the following message:

bcp.exe is used to bulk load data for SQL Server

What am i missing on my Job servers?

Thanks,

Steve
Title: Re: Unable to bulk load data
Post by: ducthcogtechie on 26 Nov 2008 12:23:02 PM
sql server management tools will include bcp.exe
Title: Re: Unable to bulk load data
Post by: StuartS on 27 Nov 2008 04:23:26 AM
Hello

I has a simliar problem and fixed it by installing the SQL Native Client.
Title: Re: Unable to bulk load data
Post by: Stejawh on 27 Nov 2008 07:58:44 AM
 Hi,

I've installed what i need from the Management Tools and it has cured my initial error.

However now the Jobserver picks up jobs and seems to be processing but the Macro hangs on Job_end.  The Macro is not running any quicker than when i had just the one job server.  Could my new Job server be picking up jobs and not completing them hence a timeout?

Steve.