1 Reply Latest reply on Nov 18, 2013 4:55 PM by JeffJon

    Error: Your session has ended or timed out. Please login again. FDM error on "Export"

    Anjum Ara

      On logging into FDM URL, with a specific user on clicking "Export Fish" FDM Processes gives the options for load but on the other hand when we click on "Export" from the left panel(navigation). "It throws Your session has ended or timed out. Please login again." Quite anomalous behaviour ,when I try with admin this issue does not exist. In shared service this user has the access for that group with WRITE permissions.

      Other relevant info:

      Version: 11.1.2.3

      DB: SQL Server

      Project: Upgraded

      User type: Intermediate

      Target: HFM

       

       

      Tried creating a new native user with all admin priv on the FDMApp,HFM app but the issue did not get resolved.

      It is peculiar and unable to gain any pointers.

       

      Extra Info:

      On clicking the Export option on left panel. It shows Processing,please wait and logs out with error as session timeout.

      Please help.

       

       

      Admin Error logs. Tools -> View Error as admin user

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:44] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... The connection cannot be used to perform this operation. It is either closed or invalid in this context.

      SELECT tPOVPartition.* From tPOVPartition Where ((PartName) = '')

      Procedure........................................ clsDataAccess.farsSnap

      Component........................................ upsWDataWindowDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:44] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... Data access error.

      Procedure........................................ clsSQLMgr.fPartition

      Component........................................ upsWObjectsDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:44] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... Data access error.

      Procedure........................................ clsPOVMgr.fCheckLocProf

      Component........................................ upsWObjectsDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:44] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... Data access error.

      Procedure........................................ clsSQLMgr.fMapItems

      Component........................................ upsWObjectsDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:44] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... The connection cannot be used to perform this operation. It is either closed or invalid in this context.

      SELECT tSecObjectItems.AppType, tSecObjectItems.AppObject, tSecObject_Locale.AppObjectCaption, tSecObject.AppObjectSeq, tSecObjectItems.AppObjItem, tSecObjectItems.AppObjControl, tSecObjectItems.AppObjControlType, tSecObjectItems_Locale.AppObjControlCaption, tSecObjectItems_Locale.AppObjControlToolText, tSecObjectItems.AppObjControlLevel, tSecObjectItems.AppObjControlIndex, tSecObjectItems_Locale.LangKey FROM tSecObject INNER JOIN tSecObjectItems ON tSecObject.AppObject = tSecObjectItems.AppObject AND tSecObject.AppType = tSecObjectItems.AppType INNER JOIN tSecObject_Locale ON tSecObject.AppType = tSecObject_Locale.AppType AND tSecObject.AppObject = tSecObject_Locale.AppObject INNER JOIN tSecObjectItems_Locale ON tSecObjectItems.AppType = tSecObjectItems_Locale.AppType AND tSecObjectItems.AppObject = tSecObjectItems_Locale.AppObject And tSecObjectItems.AppObjItem = tSecObjectItems_Locale.AppObjItem WHERE (((tSecObjectItems.AppType)=N'WebClient') AND ((tSecObjectItems.AppObject)=N'Maps Form') AND ((tSecObjectItems_Locale.AppObjControlCaption)<>N'-') AND ((tSecObject_Locale.LangKey)=1033) AND ((tSecObjectItems_Locale.LangKey)=1033)) ORDER BY tSecObject.AppObjectSeq, tSecObjectItems.AppObjItem

      Procedure........................................ clsDataAccess.farsSnap

      Component........................................ upsWDataWindowDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:45] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... Data access error.

      Procedure........................................ clsSQL.fSecItemsForObject

      Component........................................ upsWDataWindowDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:45] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... The connection cannot be used to perform this operation. It is either closed or invalid in this context.

      SELECT tCtrlOption.* From tCtrlOption Where (((tCtrlOption.OptionKey) = N'Period')) ORDER BY tCtrlOption.OptionOrder

      Procedure........................................ clsDataAccess.farsSnap

      Component........................................ upsWDataWindowDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:45] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... Data access error.

      Procedure........................................ clsSQL.fOptionListForKey

      Component........................................ upsWDataWindowDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:45] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... Data access error.

      Procedure........................................ clsDBTools.fGlobalOptionGet

      Component........................................ upsWDataWindowDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:26:45] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3709

      Description...................................... Data access error.

      Procedure........................................ clsDBTools.fGlobalOptionGetVA

      Component........................................ upsWDataWindowDM

      Version.......................................... 1112

      Thread........................................... 11708

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 0

      Location Seg..................................... 0

      Category.........................................

      Category ID...................................... 0

      Period...........................................

      Period ID........................................ 12:00:00 AM

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:34:01] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3098

      Description...................................... CONNECT Action Adapter Script failed to load!

      Procedure........................................ clsBlockProcessor.ActConnect

      Component........................................ upsWBlockProcessorDM

      Version.......................................... 1112

      Thread........................................... 13632

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 770

      Location Seg..................................... 41

      Category......................................... Source Actual

      Category ID...................................... 12

      Period........................................... Oct - 2013

      Period ID........................................ 10/31/2013

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

       

       

       

       

      ** Begin FDM Runtime Error Log Entry [2013-11-15 10:34:01] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 3098

      Description...................................... CONNECT Action Adapter Script failed to load!

      Procedure........................................ clsBlockProcessor.ActExport

      Component........................................ upsWBlockProcessorDM

      Version.......................................... 1112

      Thread........................................... 13632

       

       

      IDENTIFICATION:

      User............................................. hypadmpr

      Computer Name.................................... mycomputerName

      App Name......................................... FDMAPP

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... SQLOLEDB

      Data Server...................................... devsql1

      Database Name.................................... HYP_FDMAPP

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HOME~FURNISHING-TB

      Location ID...................................... 770

      Location Seg..................................... 41

      Category......................................... Source Actual

      Category ID...................................... 12

      Period........................................... Oct - 2013

      Period ID........................................ 10/31/2013

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False