Open Forum

Expand all | Collapse all

can't get sessions to work

  • 1.  can't get sessions to work

    Posted Nov 30, 2018 10:10 AM
    I have access to sessions, but get the error that I have no internet browser installed when I try to open it.  Any ideas, I definitely have an internet browser on my PC.  We are using NAV 2016.

    Chastity Branham
    Georg Utz, Inc
    Edinburgh IN

  • 2.  RE: can't get sessions to work

    Posted Dec 03, 2018 07:28 AM
    Sounds weird.  Can you post a picture of the error?  Do you use the web client?

    Jason Wilder
    Senior Application Developer
    Stonewall Kitchen
    York ME

  • 3.  RE: can't get sessions to work

    Posted Dec 04, 2018 11:19 AM

    If you can't still access it, here is a SQL script you can use for now under SQL Studio Mgt Studio.
    Just change the [YourDatabaseName] to your actual database name.
    You can copy/paste the 3 separate ones and run them as once if needed.
    Good luck
    SELECT *

      FROM [YourDatabaseName].[dbo].[Active Session] a

      inner join [YourDatabaseName].[dbo].[User] as b

      ON a.[User SID] = b.[User Security ID]

      where b.[License Type] = 0 and a.[Client Type]=0


    exec sp_who2



    SELECT *

    FROM sys.dm_exec_sessions

    WHERE program_name LIKE  '%Microsoft Dynamics NAV Service%'



        SPID                = er.session_id

        ,STATUS             = ses.STATUS

        ,[Login]            = ses.login_name

        ,Host               = ses.host_name

        ,BlkBy              = er.blocking_session_id

        ,DBName             = DB_Name(er.database_id)

        ,CommandType        = er.command

        ,SQLStatement       = st.text

        ,ObjectName         = OBJECT_NAME(st.objectid)

        ,ElapsedMS          = er.total_elapsed_time

        ,CPUTime            = er.cpu_time

        ,IOReads            = er.logical_reads + er.reads

        ,IOWrites           = er.writes

        ,LastWaitType       = er.last_wait_type

        ,StartTime          = er.start_time

        ,Protocol           = con.net_transport

        ,ConnectionWrites   = con.num_writes

        ,ConnectionReads    = con.num_reads

        ,ClientAddress      = con.client_net_address

        ,Authentication     = con.auth_scheme

    FROM sys.dm_exec_requests er

    OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) st

    LEFT JOIN sys.dm_exec_sessions ses

    ON ses.session_id = er.session_id

    LEFT JOIN sys.dm_exec_connections con

    ON con.session_id = ses.session_id

    Geovanny Fuentes
    San Diego CA

If you've found this thread useful, dive deeper into User Group community content by role