cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
617
Views
0
Helpful
3
Replies

CUIC error while adding Stored Procedure

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

3 REPLIES 3
Quigath
Enthusiast

Can you view the Database externally for your new procedure?

What syntax are you using for the query?

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?

 

My mistake. I'm not sure why you are getting an error for CUIC.
Content for Community-Ad