You must Sign In to post a response.
  • Category: .NET

    Stored procedure execution stopped partially from vb application

    Hi Friends,

    Its an old project and designed the project in vb 6. Calling 5 stored procedures, First 3 stored Procedures executed properly . While executing 4th Insert stored procedure, its partially inserting data and stopped execution. No errors. Nothing from vb application.

    When I execute the same stored procedure in sql server 2012. Executing within 1 minute. No Issues.

    How to solve this issue ?

    Thanks
  • #768352
    Hi,

    First thing is, it is executing well as Stored Procedure when you run in SQL but when you run from .NET application you are facing issue.

    So definitely problem with the parameters it passed.
    While passing the parameters especially on the 4th Procedure kindly keep the Pause and see the parameters or else take those parameter which are coming in for 4th Procedure. With the same parameter execute your procedure in SQL Server,

    Note:
    Issue might be also in Space. suppose you have input like "5" if sometime it comes as "5 " it throws issue.
    So check entire input parameter for fourth procedure.

    Thanks,
    Mani

  • #768455
    Hi,

    In SQL it's take around 1 min that is not good, I guess while execute the same in your application may be timeout occur, try to optimize the sql query and try to reduce the time taken for executing the procedure and then check the inputparameters from sql side as well as application side try to pass both are same and then re-execute the application.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #768489
    Hi,

    You can break the long queries into small chunks.
    Also you can asynchronously run the queries.
    Please take a look at this:
    https://www.codeproject.com/Articles/541834/How-to-execute-multiple-long-running-SQL-Statement


Sign In to post your comments