hi all,
We have a view for bar cart field which recently bracked in prod due heavy volume of data approx (1,048,576) records in my sql db .
so we plan to query data going with sp with (executestoredprocedure) function. my question is can we query data in a barcart field with SP ?
while executing SP with mandatory parameters getting error as "Use the Execute Stored Procedure Smart Service to modify data. This function must only be used to query data, not modify."
if i pass optional parameters also getting error as "The conversion from UNKNOWN to UNKNOWN is unsupported".
Below is the code for SP,
a!localVariables( local!sp: fn!executestoredprocedure( cons!DATA_SCOURCE_NAME, cons!TASK_GRAPHIC_SUMMARY, { {
name:"assignedTo", value:ri!currentUserEmail }, { name:"categoryName", value:ri!categoryName }, { name:"lob", value:ri!lob }, { name:"assignedcategory", value:ri!assignedcategory }, { name:"taskId", value:ri!taskId }, { name:"dueIn", value:ri!dueIn }, } ), {local!sp})
Thanks In Advance Guys.
Discussion posts and replies are publicly visible
This is not the way to go! You will have to reduce the volume of data you load into memory. If you go into more detail, we might be able to provide some suggestions.
Since,it was retrieving lots of data and its reaches the maximum limit,it was throwing the error
So stefan, instead of view we can't use store procedure function to get data and show in barcart
You just cannot load more than 1mb of data. Regardless of how you do it.
You will have to adjust your design. In case you aggregate the data in memory, try to offload that to DB using the Appian data aggregation features.