Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
1811 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Iam trying fetch data to be displayed in a grid from a table which is in externa
divyav
over 9 years ago
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
0
divyav
over 9 years ago
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"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
divyav
over 9 years ago
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"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data