Author Topic: SQl Server Stored Proc  (Read 271 times)

Offline itgowrishankar

  • Full Member
  • ***
  • Join Date: Feb 2011
  • Posts: 8
  • Forum Citizenship: +0/-0
SQl Server Stored Proc
« on: 08 Dec 2017 03:35:17 pm »
Hi,

I have an strange issue with SQL Server Store proc in Cogno 10.2.2.

I come across to use a stored proc which will results some data to display on the report.

My issue is I am able to run the reports with the stored proc in Dev and QA environments. But, the same reports are failing in UAT.
I have confirmed that the access permission in Dev, QA and UAT are same from SQL Server end. And, I am using Data Query type for Store Proc in Framework Manager.
The stored proc looks like as the attachement (not actual stored proc)

I am brain storing to fix this issue as the reports are running in Dev and QA and sameone is failing in UAt.

Any inputs are really appreciated. Thanks.

Offline itgowrishankar

  • Full Member
  • ***
  • Join Date: Feb 2011
  • Posts: 8
  • Forum Citizenship: +0/-0
Re: SQl Server Stored Proc
« Reply #1 on: 14 Dec 2017 12:28:08 pm »
Hi,

I figured out the issue.

The issue is with the Datasource connection provider. In Dev, the datasource connection has created using Microsoft SQL Server (OLE DB) provider where as in QA and PROD datasource connection has created using Microsoft SQL Server (Native Client).


This may help to you if come across with similar issue.

 


       
Twittear