Post reply

Application intermittently not finding Stored procedures in SQL 2008R2

  • December 9, 2013 at 9:48 am

    #281007

    Sorry I cant find anywhere I can delete a thread. I believe I found the issue -

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27902

    The software seems to be recreating the the stored procedures which is screwing everything up.

    DB is on a Simple testing server and when we have multiple users logging in to do testing we get

    System.Data.SqlClient.SqlException' occurred and was caught

    Type : System.Data.SqlClient.SqlException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

    Message : Could not find stored procedure 'StoredProcedure_Blah'.

    Source : .Net SqlClient Data Provider

    The application errors and when we restart the application it can then find the stored procedure on the same machine. This is very hard to track.

    I have never seen an issue like this. Any ideas what could be going on? I was on the server and the CPU was normal and it was not locking up in transactions. I did not start an audit, but I can if needed.

    Any help would be great thanks

  • December 9, 2013 at 9:57 am

    #1672035

    Maybe somebody or something keeps changing the default schema so that sometimes you're looking for the procedure in the dbo schema, and sometimes you're looking for it in a different schema?

    John

  • December 9, 2013 at 3:58 pm

    #1672156

    Object drop and create events are noted in the default trace.

    You can see in there what process/user causes the drop/recreate, if in fact that is happening.

  • December 9, 2013 at 4:01 pm

    #1672158

    I was trying not to run a trace but yes I may have to. No one has peeped up saying they did it.

  • December 9, 2013 at 4:20 pm

    #1672168

    The default race is always running, unless it was stopped.

    Look at the .trc files in the MSSQL\Log folder.

    If the files cover the period(s) in question, the answer is in there.

  • December 10, 2013 at 3:02 am

    #1672231

    Also worth considering if a connection component isn't configured somewhere for an incorrect database or server.

    Its fairly unlikely that any DB objects are simply "disappearing".

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply