IDO creation - new Stored procedure does not show selectable and generates error when typed in

Darryl Hoar

Going through some Infor training for creating custom reports, data views in CSI 10. While following along on the create IDO step, I had created a new stored procedure in the database using SSMS. SSMS show and can execute the Stored Procedure. Go back into IDO creation for my IDO project and the Stored Procedure does not show in the drop down for selection. Lets say the Stored procedure name is Rpt_GetStuff, if I type it in and try to leave the field I get the following error "Rpt_GetStuff is not a valid stored procedure". Other stored procedures I've created (not for this report) show and work as documented in the guide. What am I doing wrong? Yes, the SP is in the correct database .

thanks.

hshaik

Darryl,

I believe you are facing an issue while creating the IDO Method for the newly created stored procedure.

Please do the below steps to troubleshoot,

1. Make sure you clear the IDO Cache, for that perform the below 2 steps
   a) Select the Unload IDO Metadata with Forms checkbox to TRUE as mentioned below
   
   b) From the top menu Select Form→ Definition→ Unload All Global Form Objects as shown below,
   
   
2. Make sure the schema name is dbo. for the newly created Stored Procedure in the SSMS.

Thanks,

Hanife