1 Reply Latest reply on Sep 25, 2019 1:40 AM by Sathyanath N

    Database query [EXEC stored_procedure] is empty in JDBC connection:[jdbc:informatica:sqlserver://host:port;DatabaseName=DBName;ApplicationName=AppName,agentid=null;agentGroupId=xxxx;orgId=xxx;]

    Sownaj Narayanan New Member

      I am trying to execute a stored procedure through the source query when i am facing this issue.

      Database query [EXEC stored_procedure] is empty in JDBC connection:[jdbc:informatica:sqlserver://host:port;DatabaseName=DBName;ApplicationName=AppName,agentid=null;agentGroupId=xxxx;orgId=xxx;]

       

      This issue occurs when i try to validate it.

       

      The SP has a result set from a select statement that i am trying to load into a table, The SP additionally has some temp tables created at run time.

       

      Anybody has any solution to this issue. Thanks.