topic Re: Re: OLEDB Error Failed on SP in QlikView

OLEDB Error Failed on SP

Tue, 18 Mar 2014 14:51:34 GMT

In my script I am executing a sp but on the reload I am getting the error OLEDB Error Failed SP_Name

Any help please?

Re: OLEDB Error Failed on SP

maxgro — Tue, 18 Mar 2014 14:57:31 GMT

please could you post your script and your error?

Re: OLEDB Error Failed on SP

Tue, 18 Mar 2014 15:01:41 GMT

My script for the SQL is

Cost:

Load Class, ][Financial Period] AS FinancialPeriod ;

sql execute CostQlikView

The script has a OLEDB connection has the script includes connection to a SQL Server db and has other load statements to tables.

Re: OLEDB Error Failed on SP

maxgro — Tue, 18 Mar 2014 15:06:08 GMT

try

Cost:

Load *;

sql execute CostQlikView;

you have a ]

Re: OLEDB Error Failed on SP

Tue, 18 Mar 2014 15:22:33 GMT

thats worked. Why would that be? Does that mean that in the SP i should rename the fields that have [a and b ] should be made into a single field as aandb

Re: Re: OLEDB Error Failed on SP

maxgro — Tue, 18 Mar 2014 15:27:57 GMT

yes you can rename field

but you have an error or two

]

;

Cost:

Load Class, ][Financial Period] AS FinancialPeriod ;

sql execute CostQlikView;

for example this works on my sql server

load id_banca, [cod_banca] as newfield;

sql execute sisim_stat..sp_test '%BANCA%';

Re: Re: OLEDB Error Failed on SP

Tue, 18 Mar 2014 15:37:36 GMT

This what i have when it fails

Cost:

Load [P&L Classification] ,[Point] AS POD ;

sql execute C_CostQlikView;

Re: OLEDB Error Failed on SP

maxgro — Tue, 18 Mar 2014 15:54:07 GMT

perhaps you have a wrong field name

this works for me

qlikview script is

load [P&L Classification], [Point] AS POD;

sql execute sisim_stat..sp_test2;

sql server procedure is

alter PROCEDURE [dbo].[sp_test2]

BEGIN

SET NOCOUNT ON;

SELECT id_banca [P&L Classification], cod_banca [Point] from d001_banche; -

END

RESULT is