Custom Fields - Could not find stored procedure ikb_sp_InsertArticleCustomFieldValues_*


InstantKB Problem
I got this error when posting a new article after upgraded to kb2014, any idea how to fix it?

Exception Type:   System.Data.SqlClient.SqlException
Exception Message:  Could not find stored procedure 'ikb_sp_InsertArticleCustomFieldValues_1'.
Exception Source:  .Net SqlClient Data Provider
Exception Target Site: OnError

InstantKB Problem

Hi Directed,

Thank you for your post. I'm sincerely sorry to hear of the trouble. The stored procedure you are referring to is created or updated dynamically each time you add a custom field to tabs within InstantKB. This is the stored procedure that manages the INSERT and UPDATE of custom field data.

I mention this as you won't find a stored procedure called ikb_sp_InsertArticleCustomFieldValues_1 within any of our installation scripts. You should however still see this stored procedure when you connect to your upgraded InstantKB database. We don't delete or alter those procedures during any upgrade. 

Do you know if the SQL account has changed that your using to connect to your updated database? If so it could be the ikb_sp_InsertArticleCustomFieldValues_1 stored procedures owner is set to the previous account so you can't access this with the new account. 

The "_1" at the end of the stored procedure name refers to the TabID that the custom fields belong to within InstantKB. In this case your Knowledgebase Tab. By default this tab has the TabID of 1 within the InstantKB_Tabs table. If the TabID has changed (this should not change with our upgrade scripts) this could cause problems. 

If you connect to your database via SQL Server Management Studio does the object owner change for this stored  procedure. I've highlighted the object owner below...

https://community.instantasp.co.uk/uploads/images/67ef036f-96ce-4021-96dc-7cb0.png

I hope something here helps point you in the right direction.

Don't hesitate to respond if these suggestions don't help resolve the issues and I'll certainly assist further,

http://www.instantasp.co.uk/images/line.gif
Kindest Regards,

Ryan Healey



ryan@instantasp.co.uk
www.instantasp.co.uk
Blog | Community | Docs

http://www.instantasp.co.uk/core/assets/images/email/facebook.png http://www.instantasp.co.uk/core/assets/images/email/twitter.png http://www.instantasp.co.uk/core/assets/images/email/google.png http://www.instantasp.co.uk/core/assets/images/email/linkedin.png
GO

Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....







InstantASP Forums


Search