5 Replies Latest reply on Jan 27, 2011 10:03 AM by albert rofail - oracle

    FDM Reports Data Access Error

    752796
      Hi Everyone,

      When I try to run any FDM reports I get the following error 'Data Access Error'

      I have tried changing the language settings to English(UnitedStates) as mentioned in a previous thread but no success.

      I get the same error when I run a Validation Rules (CheckReport) on export.

      The log is displayed below. Any ideas what the Client App line is? It is currently set to WebClient

      Any ideas would be greatly recieved

      Thanks

      G


      ** Begin FDM Runtime Error Log Entry [2010-09-15-12:07:51] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147217900
      Description...................................... Data access error.
      Procedure........................................ clsAppServer.fPublishReport
      Component........................................ upsAppSv
      Version.......................................... 1111
      Thread........................................... 808

      IDENTIFICATION:
      User............................................. ktadmin
      Computer Name.................................... WIN3KB
      App Name......................................... VF_TRAIN
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... SQLOLEDB
      Data Server...................................... win3kb
      Database Name.................................... Vodafone
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... ACT_GB001
      Location ID...................................... 966
      Location Seg..................................... 17
      Category......................................... ACTIC
      Category ID...................................... 13
      Period........................................... Apr - 2007
      Period ID........................................ 4/30/2007
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False
        • 1. Re: FDM Reports Data Access Error
          WPaffhausen
          Hello,

          Unfortunately without more information it is hard to comment on what the true cause of the error is. Anytime a 'Data Access Error' is returned there should be SQL statements and plenty of information in the error log for review/diagnosis.

          I would suggest you clear your user error log (Tools > Clear User Error Log) and then reproduce the issue. If you have a hard time understanding the log or the SQL statement it contains; please feel free to post the entire log for review.

          Thank you,
          1 person found this helpful
          • 2. Re: FDM Reports Data Access Error
            MRS
            Hi everyone,

            I have the same problem as mentioned and I´m able to attach all information needed in order to resolve the problem. I attach below the error log and the SQL query of the standard report *"TB Current Location, With Rules"*
            I´ve made no changes and if I make zoom or preview the data through Workbench Client I receive the data correctly but if I execute the Check phase through the FDM Workflow I receive "Data Access Error"

            The database is SQL as you can see in the error trace


            Thanks in advance



            Error Log:

            Begin FDM Runtime Error Log Entry [2010-12-15-09:45:21]
            -------------------------------------------------------------
            ERROR:
            Code............................................. -2147217900
            Description...................................... Incorrect syntax near '~'.
            SELECT
            tPOVPartition.PartName AS PartitionKey,
            tPOVCategory.CatKey,
            tPOVCategory.CatName,
            vData.PeriodKey,
            vData.Account AS SrcAcctKey,
            vData.Entity AS SrcCenterKey,
            vData.Desc1 AS SrcAcctDesc,
            vData.Amount AS SrcAmount,
            vDataMap.SrcKey AS ARule,
            vDataMap_1.SrcKey AS ERule,
            tPOVPartition.PartCurrencyKey

            FROM
            vData
            INNER JOIN tPOVCategory
            ON vData.CatKey = tPOVCategory.CatKey
            INNER JOIN tPOVPartition
            ON vData.PartitionKey = tPOVPartition.PartitionKey
            INNER JOIN vDataMap
            ON vData.AccountR = vDataMap.DataKey
            INNER JOIN vDataMap vDataMap_1
            ON vData.EntityR = vDataMap_1.DataKey

            WHERE (((tPOVCategory.CatKey)=~CatKey~)
            AND ((vData.PartitionKey)=759)
            AND ((vData.PeriodKey)=N'~Period~')
            AND ((vData.CalcAcctType)=0 OR (vData.CalcAcctType)=1 OR (vData.CalcAcctType)=9)
            AND ((vDataMap.CatKey)=~CatKey~)
            AND ((vDataMap.PartitionKey)=759)
            AND ((vDataMap.PeriodKey)=N'~Period~')
            AND ((vDataMap_1.CatKey)=~CatKey~)
            AND ((vDataMap_1.PartitionKey)=759)
            AND ((vDataMap_1.PeriodKey)=N'~Period~'))

            ORDER BY vData.Account
            Procedure........................................ clsDataAccess.farsSnap
            Component........................................ upsWDataWindowDM
            Version.......................................... 1111
            Thread........................................... 8672

            IDENTIFICATION:
            User............................................. admin
            Computer Name.................................... RINGIL
            App Name......................................... SCOV1
            Client App....................................... WebClient

            CONNECTION:
            Provider......................................... SQLOLEDB
            Data Server...................................... xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.com
            Database Name.................................... FDMAPP2
            Trusted Connect.................................. False
            Connect Status.. Connection Open

            GLOBALS:
            Location......................................... AT00
            Location ID...................................... 759
            Location Seg..................................... 11
            Category......................................... REAL
            Category ID...................................... 12
            Period........................................... Feb - 2010
            Period ID........................................ 2/28/2010
            POV Local........................................ False
            Language......................................... 1033
            User Level....................................... 1
            All Partitions................................... True
            Is Auditor....................................... False


            And finally, the SQL query is:

            SELECT
            tPOVPartition.PartName AS PartitionKey,
            tPOVCategory.CatKey,
            tPOVCategory.CatName,
            vData.PeriodKey,
            vData.Account AS SrcAcctKey,
            vData.Entity AS SrcCenterKey,
            vData.Desc1 AS SrcAcctDesc,
            vData.Amount AS SrcAmount,
            vDataMap.SrcKey AS ARule,
            vDataMap_1.SrcKey AS ERule,
            tPOVPartition.PartCurrencyKey
            FROM
            vData
            INNER JOIN tPOVCategory
            ON vData.CatKey = tPOVCategory.CatKey
            INNER JOIN tPOVPartition
            ON vData.PartitionKey = tPOVPartition.PartitionKey
            INNER JOIN vDataMap
            ON vData.AccountR = vDataMap.DataKey
            INNER JOIN vDataMap vDataMap_1
            ON vData.EntityR = vDataMap_1.DataKey
            WHERE (((tPOVCategory.CatKey)=~CatKey~)
            AND ((vData.PartitionKey)=|PartitionKey|)
            AND ((vData.PeriodKey)='~Period~')
            AND ((vData.CalcAcctType)=0 OR (vData.CalcAcctType)=1 OR (vData.CalcAcctType)=9)
            AND ((vDataMap.CatKey)=~CatKey~)
            AND ((vDataMap.PartitionKey)=|PartitionKey|)
            AND ((vDataMap.PeriodKey)='~Period~')
            AND ((vDataMap_1.CatKey)=~CatKey~)
            AND ((vDataMap_1.PartitionKey)=|PartitionKey|)
            AND ((vDataMap_1.PeriodKey)='~Period~'))
            ORDER BY vData.Account
            • 3. Re: FDM Reports Data Access Error
              WPaffhausen
              Hello,

              I would suggest that you open a Service Request and have someone from Support review.
              If the report works from the workbench but not from the Web; then there must be something else going on.

              Thank you,
              • 4. Re: FDM Reports Data Access Error
                MRS
                Thanks so much WPaffhausen

                I will do it because it´s very strange..


                Kind regards,


                M
                • 5. Re: FDM Reports Data Access Error
                  albert rofail - oracle
                  Hello,

                  This error happened when you import the wrong report xml file that not match your application database; you need to make sure that you import the reports for MSSQL not Oracle.

                  Thanks,
                  Albert