ReportServer - ReportServer Admin Guide 4.7 - 20.4. clearInternalDbCache

ReportServer Admin Guide 4.7

Navigation

1. Preamble
2. First Steps
- 2.1. Configuration and installation
- 2.2. Login
- 2.3. Creating a datasource
- 2.4. Creating your First Report
- 2.5. Importing a Graphical Report
- 2.6. Creating users
- 2.7. Terminal and FileServer
3. User and Permission Management
- 3.1. The User Tree
- 3.2. Permission Management
4. Datasources
- 4.1. Relational Databases
- 4.2. Athena
- 4.3. Db2 for IBM i
- 4.4. Db2 for z/OS
- 4.5. Derby
- 4.6. CockroachDB
- 4.7. CrateDB
- 4.8. Exasol
- 4.9. Google BigQuery
- 4.10. Incorta
- 4.11. MySQL
- 4.12. PostgreSQL
- 4.13. Redshift
- 4.14. SAP HANA
- 4.15. SQL Server
- 4.16. SQL Server (Old driver, jTDS)
- 4.17. SQLite
- 4.18. Teradata
- 4.19. YugabyteDB
- 4.20. Storage of Database Passwords
- 4.21. Datasource Pool
- 4.22. CSV Lists
  - 4.22.1. Database Cache
  - 4.22.2. Configuration at the Object
- 4.23. Script datasources
  - 4.23.1. Configuration at the Object
- 4.24. BIRT Report datasource
- 4.25. Mondrian Datasource
- 4.26. Using XMLA with SQL Server Analysis Services
- 4.27. Datasource Bundle
- 4.28. Configuration of a Standard Datasource
5. Datasinks
- 5.1. Email - SMTP
- 5.2. Table datasinks
- 5.3. SFTP
- 5.4. FTPS
- 5.5. FTP
- 5.6. Samba - SMB/CIFS
- 5.7. Amazon S3
- 5.8. SCP
- 5.9. Local Filesystem
- 5.10. Printer Datasinks
- 5.11. Script Datasinks
- 5.12. OAuth2-authenticated datasinks
- 5.13. Dropbox
- 5.14. OneDrive - SharePoint (O365)
- 5.15. Google Drive
- 5.16. Box
6. File System
- 6.1. Configuration Files
- 6.2. Filing of Scripts
- 6.3. Rendering Graphviz DOT files
- 6.4. Rendering Markdown files
- 6.5. Accessing Resources by URL
7. Report Management
- 7.1. Fundamentals
- 7.2. The Dynamic List
- 7.3. Working with Parameters
- 7.4. JasperReports
  - 7.4.1. Unformatted Excel Output: Plain Excel
  - 7.4.2. Exporting Jasper reports containing images to HTML
- 7.5. Eclipse Birt
- 7.6. SAP Crystal Reports
  - 7.6.1. Prepare ReportServer for Crystal
  - 7.6.2. Use Crystal Reports
- 7.7. Saiku / Mondrian Reports
- 7.8. JXLS Reports
  - 7.8.1. JXLS2
- 7.9. Script Reports
- 7.10. Grid Editor Reports
- 7.11. Executing Reports via the URL
- 7.12. Report Properties
  - 7.12.1. Available Report Properties per Type
- 7.13. Report Metadata
  - 7.13.1. Using Metadata as Parameters
- 7.14. Drill Down Reports
8. Global Constants
9. User Variables
- 9.1. Defining User Variables
- 9.2. Allocating User Variables
- 9.3. Using User Variables in Reports
10. Import and Export
- 10.1. Exporting
  - 10.1.1. Export Format
- 10.2. Importing
11. Transports
- 11.1. General Introduction
  - 11.1.1. Overview of the Use Cases
  - 11.1.2. Conclusion
- 11.2. Configuration and Prerequisites
- 11.3. Usage
- 11.4. Monitoring and Logging
- 11.5. Frequently Asked Questions FAQ
12. REST API
- 12.1. Finding the REST URL
- 12.2. Authentication
- 12.3. test Service
- 12.4. general-info Service
- 12.5. dot-renderer Service
- 12.6. markdown-renderer Service
- 12.7. node-exporter Service
13. Markdown
- 13.1. Markdown Syntax Examples
14. Graphviz DOT
- 14.1. Basic DOT Syntax
15. Remote RS Servers
16. Scheduling of Reports
- 16.1. Technical Backgrounds to Scheduler Jobs
- 16.2. Filtering by the Status of a Job
- 16.3. Notifications
- 16.4. Terminal Commands
- 16.5. Conditional Scheduling
- 16.6. Creating and Using a Condition Report
  - 16.6.1. Creating a condition
  - 16.6.2. Using the condition while scheduling
- 16.7. Predefined Conditions
- 16.8. Defining a Simple Condition via Scripting
17. Theming
18. Terminal
- 18.1. Using the Terminal
- 18.2. The Virtual File System
- 18.3. Assigning Aliases
- 18.4. Scripts
- 18.5. Object Resolver
19. Terminal Operators
- 19.1. Write-into-file operators
- 19.2. Write-into-datasink operator
20. Terminal Commands
- 20.1. birt
- 20.2. cat
- 20.3. cd
- 20.4. clearInternalDbCache
- 20.5. clearInternalScriptCache
- 20.6. columnsExist
- 20.7. columnsMetadata
- 20.8. config
- 20.9. connPoolStats
- 20.10. copy
  - 20.10.1. copy parameterDefinitions
  - 20.10.2. copy tableContents
- 20.11. cp
- 20.12. createTextFile
- 20.13. datasourceMetadata
- 20.14. deployReport
- 20.15. desc
- 20.16. diffconfigfiles
- 20.17. dirmod
- 20.18. echo
- 20.19. editTextFile
- 20.20. eliza
- 20.21. entitymerge
- 20.22. env
- 20.23. exec
- 20.24. export all
- 20.25. groupmod
- 20.26. haspermission
- 20.27. hello
- 20.28. hql
- 20.29. id
- 20.30. info
  - 20.30.1. info datasource
- 20.31. import all
- 20.32. kill
- 20.33. ldapfilter
- 20.34. ldapguid
- 20.35. ldapimport
- 20.36. ldapinfo
- 20.37. ldapschema
  - 20.37.1. ldapschema attributeInfo
  - 20.37.2. ldapschema attributeList
  - 20.37.3. ldapschema entry
  - 20.37.4. ldapschema matchingRuleInfo
  - 20.37.5. ldapschema matchingRuleList
  - 20.37.6. ldapschema objectClassInfo
  - 20.37.7. ldapschema objectClassInfo
  - 20.37.8. ldapschema syntaxRuleInfo
  - 20.37.9. ldapschema syntaxRuleList
- 20.38. ldaptest
  - 20.38.1. ldaptest filter
  - 20.38.2. ldaptest guid
  - 20.38.3. ldaptest groups
  - 20.38.4. ldaptest organizationalUnits
  - 20.38.5. ldaptest users
  - 20.38.6. ldaptest orphans
- 20.39. listlogfiles
- 20.40. listpath
- 20.41. locate
- 20.42. ls
- 20.43. meminfo
- 20.44. mkdir
- 20.45. mv
- 20.46. onedrive
- 20.47. pkg
  - 20.47.1. pkg install
  - 20.47.2. pkg list
- 20.48. properties
  - 20.48.1. properties clear
  - 20.48.2. properties contains
  - 20.48.3. properties list
  - 20.48.4. properties put
  - 20.48.5. properties remove
- 20.49. ps
- 20.50. pwd
- 20.51. rcondition
- 20.52. registry
  - 20.52.1. registry clear
  - 20.52.2. registry contains
  - 20.52.3. registry list
  - 20.52.4. registry put
  - 20.52.5. registry remove
- 20.53. reportmod
- 20.54. rev
- 20.55. rm
- 20.56. rpull
  - 20.56.1. rpull copy
- 20.57. scheduleScript
- 20.58. scheduler
- 20.59. sql
- 20.60. tableExists
- 20.61. transport
  - 20.61.1. transport create
- 20.62. ssltest
- 20.63. teamspacemod
- 20.64. unzip
- 20.65. updateAlias
- 20.66. updatedb
- 20.67. usermod
- 20.68. variantTest
- 20.69. viewlogfile
- 20.70. xslt
- 20.71. zip
21. ReportServer Scripting
- 21.1. A first Hello World
- 21.2. How to Handle Errors
- 21.3. Administrative Scripts
- 21.4. Changing the Data Model
- 21.5. Enhancing ReportServer with Scripts
- 21.6. Scheduling of Scripts
- 21.7. Accessing Scripts by URL
22. Integrating ReportServer with an Active Directory using LDAP
- 22.1. Synchronizing Users
- 22.2. Authenticating Users
- 22.3. Possible Improvements
23. Dashboards and Dadgets
- 23.1. Static HTML Dadgets
- 23.2. Embedding Dashboards via the URL
24. SFTP Server
25. Maintenance
- 25.1. Testing User Specific Settings (su)
- 25.2. Logging
- 25.3. Recovering of Objects
A. Expression Language
B. Demo Data