Adapter Notes

Note the following adapter changes.

• Oracle: Support for system-versioned temporal tables. Temporal queries against ORACLE System-Versioned tables have been implemented by introducing fields with TEMPORAL_PROPERTY SYSTEMTIME. Add this property by editing the synonym.
• Microsoft SQL Server: Support has been dropped for version 2005.

  If you do a Refresh Install to migrate a Reporting Server from an earlier release, if that server has an SQLMSS adapter configured for MS SQL Server 2005 (either OLE DB or JDBC), the following problems will occur.

  • That adapter will not be visible on the Web Console Connect to Data page.
  • The EDAPRINT log file will have multiple instances of the following message:

    (FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLMSS

  To fix these problems, in the Web Console:

  1. Open the Workspace page.
  2. Under Configuration Files, right-click Workspace - edaserve.cfg, and click Edit to open the edaserve.cfg file for editing.
  3. Find the line that says:

     mss_rel = 2005

     Change it to:

     mss_rel=2008 

  4. Click the Save icon at the top of the panel to save and restart the server.
• Rserve:
  • In order for your R scripts to be visible in the Server Web Console file picker, you must save your R script files with a lowercase extension (scriptname.r).
  • R version 3.5.0 has a known problem with spaces in directory or file names. A patch to resolve this problem can be downloaded and installed from https://cran.r-project.org/bin/windows/base/rpatched.html.