Iam trying fetch data to be displayed in a grid from a table which is in externa

Iam trying fetch data to be displayed in a grid from a table which is in external Database (not in Appian environment). We have data source name for it and stored procedure name but no other details. The current functionality is in Portal, where we are fetching data from that table through execute stored procedure smart service in a sub process. But now I need to implement it in 7.10 SAIL Interface. Within the same form I need to enter a firm name which will passed as input to that stored procedure and all details of that firm needs to be fetched from that and display in a grid.

Basically I need to know how to execute stored procedure in SAIL Interface.

OriginalPostID-183470

OriginalPostID-183470

  Discussion posts and replies are publicly visible

Parents
  • Thanks for the above details.
    We have tried providing schema name. Procedure name and able to establish connection with the stored procedure, but it is returning blank data.
    When searched in Application-server logs, we are getting
    "07:54:29,924 INFO [stdout] (http-/0.0.0.0:8080-9) 2015-12-14 07:54:29,924 [http-/0.0.0.0:8080-9] WARN com.appiancorp.common.monitoring.SailAggregatedDataCollector - recordTime called for an unknown endpoint. This means SAIL X-Ray logging is not fully implemented for that endpoint"
Reply
  • Thanks for the above details.
    We have tried providing schema name. Procedure name and able to establish connection with the stored procedure, but it is returning blank data.
    When searched in Application-server logs, we are getting
    "07:54:29,924 INFO [stdout] (http-/0.0.0.0:8080-9) 2015-12-14 07:54:29,924 [http-/0.0.0.0:8080-9] WARN com.appiancorp.common.monitoring.SailAggregatedDataCollector - recordTime called for an unknown endpoint. This means SAIL X-Ray logging is not fully implemented for that endpoint"
Children
No Data