Post reply

I Need Help A.S.A.P. PLEASE HELP

  • December 18, 2002 at 7:40 am

    #158399

    I have a report that runs from Crystal Reports. I pulls data from SQL Server 2000.

    Yesterday the report suddenly stopped running. When I profiled it it shows the query within SQL Server constantly looping.

    I tested this within Query Analyzer to make sure that it was infact SQL Server and not Crystal causing the problem.

    This is what happens.

    In profiler it shows the select statemnt running, then it completes, but then runs again without query analyzer ever producing a result. It is caught in an endless loop and I have no idea why. I have rebooted the system, but to no avail.

    I am talking about a query as simple as this:

    select * from [qry_door_codes]. This loops endlessly.

    Any ideas as to what I can do would be appreciated. This is a semi-emergency as this report is utilized in our call center and is hold things up.

    Thanks in advance

  • December 18, 2002 at 7:47 am

    #444708

    Are there any locks on [qry_door_codes]? Does this only happen for [qry_door_codes] or for other tables/views?

    Regards,

    Andy Jones

    .

  • December 18, 2002 at 7:53 am

    #444709

    I don't see any locks occurring. No, I don't recall this happening to any other views at the moment. Also, I do believe I didn't mention that this is view that pulls data from a couple other views. I have tested each view individually and they run fine, but when this view is run (the one that pulls from the other views) it continually loops. This has been working for months and just started doing this on Friday.

    Any ideas?

  • December 18, 2002 at 8:31 am

    #444717

    I had 1 composite index setup on one of my tables which ran fine with one view that utilized the index, however the view that didn't utilize the index is the one that just constantly loops. This makes no sense. I took the index off and now both views run, but one of them runs slower than when the index was there and the one that didn't run at all now runs.

    What gives? This really makes no sense to me. If anyone needs more info to help them help me please let me know, but I would really like to find some reasoning as to why this is happening.

    Thanks

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

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