Skip to content
I am running into a...
 
Notifications
Clear all

I am running into an error when trying to define a stored proc

3 Posts
2 Users
0 Reactions
1,260 Views
Posts: 2
Topic starter
(@larry-locke)
New Member
Joined: 2 years ago

Hi,

I am running into an error when trying to define a stored proc. Please see the video

https://watch.screencastify.com/v/N1C1aXvrXamM1sqnuJoA

Thanks

Larry O. Locke
2 Replies
Posts: 33
Admin
(@admin)
Member
Joined: 3 years ago
Hey Larry
 
Can you please send me the error it's showing in the network tab for the debugger? It's most likely that the method for the search url route is wrong. 
 
The first thing to check is that in /Scripts/dotnetreport-setup, the in searchStoredProcedure method, it's using the right url:
 
    self.searchStoredProcedure = function () {
        if (!self.searchProcedureTerm()) {
            toastr.error('Please enter a term to search stored procs');
            return;
        }
 
        ajaxcall({
            url: "/DotNetSetup/SearchProcedure",
 
It should be /DotNetSetup/SearchProcedure. I think some versions of the nuget package is incorrectly putting /Setup/SearchProcedure. 
 
The next thing would be to make sure that DotNetSetupController has the method, put a break point in it and see if it's throwing an exception:
 
image
 
Hopefully it's just the wrong url, but if not, let me know if it's hitting the method, and if there are any exceptions it's throwing. 
 
Thanks
dotnet Report Team
 
Reply
Posts: 2
Topic starter
(@larry-locke)
New Member
Joined: 2 years ago

I checked and you were correct it was wrong. I changed it, clean, rebuild, build, and cleared the cache. The same result just takes longer. No error in the console, and it is not hitting the method. 

 
Reply
Share:
Index
;