Forum Discussion

ataft's avatar
ataft
Advocate I
8 years ago
Solved

when refreshing report the database connection stays open causing multiple open connections

I have setup a SQL Server database connection using the enterprise data gateway. The connection is good and refreshes the data just fine.

 

The problem is that each time a refresh happens, scheduled once a day, the database connection stays open on the database. There were 12 open connections before we noticed a problem with the db and had to restart the database to clear all of those connections.

 

Anyone know of a solution?

 

thanks

adam

  • ataft's avatar
    ataft
    8 years ago

    Thanks for asking questions on this issue! This must have been an anomoly of some kind. I have not been able to reproduce the problem. The past few days I've done everything to try to cause the problem and it doesn't happen.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI ataft,

     

    What version of enterprise gateway you used? AFAIK, it only open one active session to handle refresh operation even if refresh operation triggered many times.

     

    Regards,

    Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi ataft,

         

        Can you please use SQL Server Profiler to trace more detailed information and share here to help us clarify your scenario?

        SQL Server Profiler

         

        Regards,

        Xiaoxin Sheng