How do you set break points or debug a Custom Load Method stored procedure in Infor Cloudsuite Indus

I can set breakpoints in the form script and debug them with Visual Studio Pro 2017 but I need to debug the Custom Load Method stored procedure. That stored procedure is called when the form loads and before the form script is executed. I am actually trying to debug stored procedure CLM_ApsGetDemandSummarySp which is the load method in form "Demand Summary APS". Has anyone been able to set breakpoints in a stored procedure called from a form load?

Find more posts tagged with

EAM Development

Accepted answers

All comments

Legacy Contributor

Debugging SPs from the client isn't possible as far as I know, but something you might consider as an alternative is to use the SQL Server Profile tool to trace the CLM execution that you are trying to debug and run that captured code in SQL directly to mimic the form calling the SP so you can debug as you like from there.

Legacy Contributor

Breakpoints won't be possible but as shown about 1 minute into this video you can use the IDORuntimeHost (or the log viewer) to see all transactions, which presumably would include your stored procedure.

www.youtube.com/watch

IDORuntimeHost is an alternative to the IDORuntimeService which usually runs in the background, see the 1st video in the series for how to set this up
www.youtube.com/watch

This can be useful as it can show you the raw SQL call allowing you to grab it and run it in SSMS.

Also don't forget you also have all of the usual SQL server tools at your disposal, I'm sure a quick google search will give you options to trace, maybe even debug, a stored procedure.

Copyright © 2025 Infor. All rights reserved.