Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.

SQL in Stored procedures not being picked up

Avatar

Level 2

Hi,

 

I have some SQL in a stored procedure that is selecting data from a database and then making that data available in a drop down list on my website.

 

I have made a change to this SQL but am unable to get my website to pick up my changes.

 

Is there something that I need to do to refresh/update to make the environment pick up the new changes?

 

I have run a Maven compile and deployed that to my environment but that didn't pick up my changes.

 

Thanks. Lisa.

2 Replies

Avatar

Community Advisor

Hi,

where are you checking this Author or Publish. Make sure the service response is not cached on dispatcher.



Arun Patidar

Avatar

Level 2
Hi Arun, I am checking this in Publish. I have already cleared the dispatcher cache.