7 Replies Latest reply on Feb 11, 2011 8:38 PM by ThinkFDM

    Error: Data access error.Account=ICP_DBL

    user84971
      When i try to run process/ logic maps. I get the following error message. Need to know how to resolve it. Any feedback is greatly appreciated.

      Error: Data access error.Account=ICP_DBL
        • 1. Re: Error: Data access error.Account=ICP_DBL
          TonyScalese
          You have an incorrectly defined logic group.
          • 2. Re: Error: Data access error.Account=ICP_DBL
            WPaffhausen
            Hello,

            While what Tony is stating is correct... it might not always be the case. Anytime a 'DataAccess' error is retrieved something was sent to the database that was not liked. The resulting error/issue should be noted in the FDM User Error log.

            If you were to clear your user error log, reproduce the behavior, and then view the user error log; what message does it contain?

            Also it would be nice to know the following:
            1. Version of FDM
            2. Version of the OS
            3. Version / Vendor of the DB Backend

            Thank you,
            • 3. Re: Error: Data access error.Account=ICP_DBL
              user84971
              Here is the error

              ** Begin FDM Runtime Error Log Entry [2010-10-28-16:33:39] **
              -------------------------------------------------------------
              ERROR:
              Code............................................. -2147217900
              Description...................................... Data access error. Account=ICP_DBL

              Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
              Component........................................ upsWObjectsDM
              Version.......................................... 1111
              Thread........................................... 2420

              IDENTIFICATION:
              User............................................. XXXXXXXXX
              Computer Name.................................... XXXXXXXXXXX
              App Name......................................... NewFDM
              Client App....................................... WebClient

              CONNECTION:
              Provider......................................... ORAOLEDB.ORACLE
              Data Server......................................
              Database Name.................................... fdmdevl
              Trusted Connect.................................. False
              Connect Status.. Connection Open

              GLOBALS:
              Location......................................... ENTERPRISELOAD
              Location ID...................................... 750
              Location Seg..................................... 3
              Category......................................... ACTUAL
              Category ID...................................... 13
              Period........................................... Feb - 2010
              Period ID........................................ 2/28/2010
              POV Local........................................ True
              Language......................................... 1033
              User Level....................................... 1
              All Partitions................................... True
              Is Auditor....................................... False


              1. Version of FDM

              *11.1.1.3*

              2. Version of the OS

              Microsoft Windows 2003 R2 - 32 bit

              3. Version / Vendor of the DB Backend

              Oracle - 10.2.0.4
              • 4. Re: Error: Data access error.Account=ICP_DBL
                WPaffhausen
                Hello,

                Thank you for this information. Unfortunately the information from the error log you pasted is not complete. Anytime there is an 'Data Access Error' there is relevant DB information. Possibly on the entry before?

                Again what I requested was to clear the error log, reproduce the behavior, paste the entire log.

                Thank you,
                • 5. Re: Error: Data access error.Account=ICP_DBL
                  user84971
                  Here is the entire log. I cleared the log and tried again to run the process/logic map.

                  ** Begin FDM Runtime Error Log Entry [2010-10-29-09:10:32] **
                  -------------------------------------------------------------
                  ERROR:
                  Code............................................. -2147217900
                  Description...................................... ORA-00979: not a GROUP BY expression
                  SELECT PARTITIONKEY AS xPartitionKey, CATKEY AS xCatKey, PERIODKEY AS xPeriodKey, ENTITY AS xEntity, DATAVIEW AS xDataView, N'DBL_' || ACCOUNT AS xAccount, N'DBL_' || ICP AS xICP, UD1 AS xUD1, UD2 AS xUD2, UD3 AS xUD3, UD4 AS xUD4, UD5 AS xUD5, UD6 AS xUD6, UD7 AS xUD7, UD8 AS xUD8, UD9 AS xUD9, UD10 AS xUD10, UD11 AS xUD11, UD12 AS xUD12, UD13 AS xUD13, UD14 AS xUD14, UD15 AS xUD15, UD16 AS xUD16, UD17 AS xUD17, UD18 AS xUD18, UD19 AS xUD19, UD20 AS xUD20, Sum(Amount) AS xAmount from tWtekale678059249990 WHERE (((ACCOUNT) In (N'340.5000',N'340.6000',N'340.7000',N'340.8000'))) AND (CalcAcctType = 9) GROUP BY PARTITIONKEY, CATKEY, PERIODKEY, ENTITY, DATAVIEW, N'DBL_' || ACCOUNT, N'DBL_' || ICP, UD1, UD2, UD3, UD4, UD5, UD6, UD7, UD8, UD9, UD10, UD11, UD12, UD13, UD14, UD15, UD16, UD17, UD18, UD19, UD20
                  Procedure........................................ clsDataAccess.farsKeySet
                  Component........................................ upsWDataWindowDM
                  Version.......................................... 1111
                  Thread........................................... 5924

                  IDENTIFICATION:
                  User............................................. XXXXXXXXX
                  Computer Name.................................... XXXXXXXXX
                  App Name......................................... NewFDM
                  Client App....................................... WebClient

                  CONNECTION:
                  Provider......................................... ORAOLEDB.ORACLE
                  Data Server......................................
                  Database Name.................................... fdmdevl
                  Trusted Connect.................................. False
                  Connect Status.. Connection Open

                  GLOBALS:
                  Location......................................... ENTERPRISELOAD
                  Location ID...................................... 750
                  Location Seg..................................... 3
                  Category......................................... ACTUAL
                  Category ID...................................... 13
                  Period........................................... Jan - 2010
                  Period ID........................................ 1/31/2010
                  POV Local........................................ True
                  Language......................................... 1033
                  User Level....................................... 1
                  All Partitions................................... True
                  Is Auditor....................................... False


                  ** Begin FDM Runtime Error Log Entry [2010-10-29-09:10:33] **
                  -------------------------------------------------------------
                  ERROR:
                  Code............................................. -2147217900
                  Description...................................... Data access error. Account=ICP_DBL

                  Procedure........................................ clsLogicEngine.Calculate
                  Component........................................ upsWObjectsDM
                  Version.......................................... 1111
                  Thread........................................... 5924

                  IDENTIFICATION:
                  User............................................. XXXXXXXXX
                  Computer Name.................................... XXXXXXXXXXXX
                  App Name......................................... NewFDM
                  Client App....................................... WebClient

                  CONNECTION:
                  Provider......................................... ORAOLEDB.ORACLE
                  Data Server......................................
                  Database Name.................................... fdmdevl
                  Trusted Connect.................................. False
                  Connect Status.. Connection Open

                  GLOBALS:
                  Location......................................... ENTERPRISELOAD
                  Location ID...................................... 750
                  Location Seg..................................... 3
                  Category......................................... ACTUAL
                  Category ID...................................... 13
                  Period........................................... Jan - 2010
                  Period ID........................................ 1/31/2010
                  POV Local........................................ True
                  Language......................................... 1033
                  User Level....................................... 1
                  All Partitions................................... True
                  Is Auditor....................................... False
                  • 7. Re: Error: Data access error.Account=ICP_DBL
                    ThinkFDM
                    Wayne identified the issue.

                    The Oracle DBA needs to change the CURSOR_SHARING initialization parameter to “EXACT” from ”SIMILAR”. That did the trick one of my implementations.