By David Youngquist, Senior Support EngineerThursday, June 13, 2013
Running a SmartConnect map and receiving an error stating, ‘The taExtenderWindowSetValue procedure does not exist or you do not have access.’ when trying to run a Smart Connect map to import data. I have tried running System Maintenance to reload the Extender Nodes but it is still not creating the procedure.
The system maintenance process for SmartConnect will try to remove the SmartConnect_Trace view in the SmartConnect database. If this cannot be completed, the process fails.
In this case the SmartConnect_Trace view had been created with a different schema than dbo which meant the currently logged in user did not have access to remove the view. Once we gave that user access to that schema, we manually removed the view and we were able to run SmartConnect System Maintenance as a user with the default schema of dbo.