I would like to populate a table on a record view that reads its data from an Or

mohamedb over 9 years ago

I would like to populate a table on a record view that reads its data from an Oracle VIEW. I use the a!queryEntity to query the data. The query works fine when reading from existing tables in DB; but gives the attached error when I apply it on the view.

When I try to query the Oracle View from Oracle developer, I realize it really takes a long time to obtain the results. So, most likely it is a time out issue.

Do you recommend any optimizations to Oracle View to better integrate with Appian?

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 9 years ago

@mohamedb Hi, though the view is taking a long time to execute, in Appian, you are just querying one record(as per the batchSize:1 in your expression). May be it would be better to confirm the same by inspecting the logs before taking an action, as logs will let you know the exact root cause.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 9 years ago

@mohamedb Hi, though the view is taking a long time to execute, in Appian, you are just querying one record(as per the batchSize:1 in your expression). May be it would be better to confirm the same by inspecting the logs before taking an action, as logs will let you know the exact root cause.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data