1 Reply Latest reply on Nov 17, 2009 4:46 AM by 735003

    FDM report error

    691954
      Hello,

      Getting this error when trying to open a FDM report.

      Error: An error occurred retrieving the list of parameters for the selected report:
      Detail: Data access error.

      Could some one please help me with this.

      Thanks
      Hemanth
        • 1. Re: FDM report error
          735003
          The FDM report would not use a date/time of DD.MM.YYYY
          It would use a format of DD/MM/YYYY
          There is still a conversion or difference due to regional settings that will need to be reviewed

          Moreover , the SQL Statement generated for the report , produces the same error when run as Query directly on the Database server.

          This is because of the un-matched date time formats between the FDM SQL Statement and the database SQL Login default language.

          Regional Settings for DCOM User , showing another Format for Date Representation than the one expected in the Report
          As well as , SQL Statement generated produces the same error on the Database server side.

          Solution:

          - Logon to the FDM Application Server as the FDM Service Account.
          - Start > Settings > Control Panel > Regional and Language Options
          - Set the Language Options to "English (United States) and click "Apply"

          Let me know if you have any more queries.

          Thanks and Regards,
          Sam.