Post reply

After installation, some of the stored procedure are missing

  • July 9, 2008 at 12:15 am

    #71630

    Hi Gurus,

    I have just now installed one application on the SQL server 2k5 which creates some stored proceudre in the DB. But after installing the application, a few SPs are missing. and I have not found any error message in the logs except:

    ================

    Exception - System.Threading.ThreadAbortException: Thread was being aborted.

    at System.Threading.Thread.AbortInternal()

    at System.Threading.Thread.Abort(Object stateInfo)

    at System.Web.HttpResponse.End()

    at System.Web.HttpResponse.Redirect(String url, Boolean endResponse)

    at System.Web.HttpResponse.Redirect(String url)

    at Approva.BizRights.Presentation.LoginPage.btnLogin_Click(Object sender, EventArgs e)

    Exception - System.IndexOutOfRangeException: Cannot find table 0.

    at Approva.BizRights.Toolbox.ArchiveAnalysis.BindDataForSummary()

    at Approva.BizRights.Toolbox.ArchiveAnalysis.Page_Load(Object sender, EventArgs e)

    ================

    Any direction / help will be highly appreciated. As I am in the middle of work.

    Thanks,

    Sanjeev

  • July 9, 2008 at 12:40 am

    #839886

    Those are .net errors, not SQL errors. Looks like you have a table missing.

    Did the installarion give any problems?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 9, 2008 at 1:03 am

    #839899

    Thanks a lot for your quick reply.....:)

    I did not face any problem while installing the application. But it seems that the problem was something else. I am using OSQL to install it. Probably when a command window opened up, end user closed it unknowingly. I will chekc it and if it resolve the issue, will update you with the same.

    Once again, thanks a lot for your time and help on this....

Viewing 3 posts - 1 through 2 (of 2 total)

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