- check the concern in the application, when generating the sell thru report it is not responding and still no report generated
- when checking, an error is encountered on my side, the bulk is causing an error
- check and fix the error for the continuation of checking the application, fix the error, and debug the application again
- as per debugging, found out that the cause of the not responding is extracting data from MSSQL and nothing from the application
- the stored procedure called by the application to extract data is calling many stored procedure causing to generate the report long, too many data and too many stored procedure to pass before generating the report