Use stored procedure in Desktop Intelligene

[Former Member]

I used a stored procedure and it has 3 parameters and 2 parameters are date. When I run the stored procedure has the following message: No Column or Data Fetch. I test the stored procedure in SQL and it has data. The issue has relationship with the parameters that are date, I don't understand why it can not run in Desktop Intelligence. Any suggestions ?

[Former Member]

Thank you for the support.

[Former Member]

Hi Miguel,

Following information might help you to resolve the issue.

1.Make a backup copy of the odbc.sbo file. The file is located at <installation directory>:\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\.

2.Open the file in a text editor. Scroll to the SQL Server 2005 section of the file.

3.Add the following line:

<Parameter Name="Force SQLExecute">Always</Parameter>

4.Save and close the file.

5.Make a backup copy of the oledb.sbo file. The file is located at <installation directory>:\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\.

6.Open the file in a text editor. Scroll to the SQL Server 2005 section of the file.

7.Add the following line:

<Parameter Name="Force SQLExecute">Always</Parameter>

8.Save and close the file.

If this occurs in a test environment, restart all servers before testing the issue.

If this occurs in a production environment, check with restarting Desktop Intelligence servers and the connection server for testing the issue.

ADAPT00692670-The issue you are getting might be related to this bug id which is fixed in Fixpack 2.4.

Regards,

Sarbhjeet Kaur

[former_member212749]

Hi Miguel Rodriguez,

Can you call you SP using a SQL as given below.

Try this

Declare @ASSIGNDATE1 DATETIME

Declare @ASSIGNDATE2 DATETIME

set @ASSIGNDATE1=@variable('1. (Assigned Date) From MM/DD/YYYY')

set @ASSIGNDATE2=@variable('2. (Assigned Date) To MM/DD/YYYY')

exec ModspaceRpt_VIC @ASSIGNDATE1,@ASSIGNDATE2

Make sure that you input the date values as it is in the Database.

Hope this helps you.

Regards

Prashant