08-17-2018 02:06 PM
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.
Error message:
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
08-17-2018 04:38 PM
Can you view the Database externally for your new procedure?
What syntax are you using for the query?
08-20-2018 07:57 AM
Hi Quigath
I'm literally using basic query in stored procedure to test that in CUIC.. Here it is..
USE [abc_hds]
GO
/****** Object: StoredProcedure [dbo].[TestManoj] Script Date: 8/20/2018 10:52:51 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[TestManoj]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- 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'
END
I have also attached the error I'm getting in CUIC. What do mean when you say view the db externally for SP?
08-21-2018 03:52 PM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide