I'm trying to add very basic stored procedure that I have created icm_hds database. It gives results of TCD tables for the time frame of 5minutes.
Have also given cuic user the permission to execute it. Now when I goto report definition and try to add that stored procedure, I click on create parameters I'm getting below error.
Stored procedure doesn't exist or syntax is invalid. Please provide a valid stored procedure and click on create parameters.
Can someone help me what I am missing?
We are using UCCE v11.0 and CUIC v11.0
I'm literally using basic query in stored procedure to test that in CUIC.. Here it is..
/****** Object: StoredProcedure [dbo].[TestManoj] Script Date: 8/20/2018 10:52:51 AM ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
ALTER PROCEDURE [dbo].[TestManoj]
-- Add the parameters for the stored procedure here
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT * from Termination_Call_Detail where DateTime between '08/17/2018 08:00' and '08/17/2018 08:02'
I have also attached the error I'm getting in CUIC. What do mean when you say view the db externally for SP?