Stored Procedure execution failing on QV server.

[Anonymous]

Hi,

I need some assistance with reloading data.

When I reload the model on my machine locally it runs fine and data reloads, but it seems to fail when we publish the model on the server and try to reload there.

In the script I have 2 stored procedures, here is the script:

SPL:

Load

Id as SPL_ID, 

UID, 

Project, 

[SAP ID], 

[Network ID], 

ExecutiveID, 

Executive, 

OwnerId, 

Owner, 

BIOId, 

BIO, 

PortfolioManagerId, 

[Portfolio Manager / PDM], 

Portfolio, 

PortfolioId, 

[BIO Area], 

[BIOAreaId], 

ProgrammeManagerId, 

[Programme Manager], 

Programme,

ProjectManagerId, 

[Project Manager], 

ProjectAdministratorId, 

[Project Administrator], 

[Project Phase], 

[Project Status / State], 

[Project Type], 

[Initiative Classification], 

[Delivery Stream / Schedule Type], 

BusinessUnitId, 

[Business Unit / iBP], 

BusinessAreaID, 

[Business Area], 

[Start Date], 

[Finish Date], 

[Baseline Start Date], 

[Baseline Finish Date], 

[Baseline Cost],

IsRegisteredinEPM,

SourceKey

;

SQL Execute MIAnalyticReporting.[dbo].[spReport_SingleProjectList];

SPLRegStats:

SQL Execute [MIAnalyticReporting].[dbo].[spReport_SingleProjectListOtherStats];

The reload seems to be failing at the first stored procedure.

SPL_ID is the key that links the 2 stored procedures.

Has anyone encountered such a problem before? or know how to solve the issue?

Thanks,

Tiaan

[amit_saini]

Hi Tiaan,

Could you please check your log file on server once .

Thanks,

AS

[MayilVahanan]

Hi

Please check the connection. Whether you can able to connect the db from QV server.

[SergeyMak]

Hi

Probably the user which qlikview server service run doesn't have rights on the SQL server, but your user has.

[Anonymous]

Hi,

Thanks for the response, I think the connection is fine as all our other reports that uses the same server and db are reloading fine on the server.

[Anonymous]

Hi Amit,

Thanks for responding so quickly.

What should I be looking for on the log file? anything specific?

Thanks,
Tiaan

[amit_saini]

Tiaan,

Check for Error in it, if it is there than please share error script.

Thanks,

AS

[Anonymous]

Hi Amit,

The error is:

Error: SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream

[ashfaq_haseeb]

Hi Tiaan,

What version of QlikView Server you used.

I remember earlier versions had issue running stored procedures on servers.

Does is running fine with desktop?

Regards

ASHFAQ

[amit_saini · Accepted solution]

Hi Tiaan,

Seems like there is something wrong in your connections , Kindly follow this link:

http://community.qlik.com/thread/66825

Thanks,
AS