> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pdia-admin/manage-the-pentaho-system/manage-the-pentaho-server/remove-sample-data-from-the-pentaho-server.md).

# Remove sample data from the Pentaho Server

By default, you have access to a sample data source and a solution directory filled with example content. These samples are provided for testing with sample data. When you are ready to move from a testing scenario to development or production, you can remove the sample content.

Perform the following steps to completely remove the sample data and content:

1. Stop the Pentaho Server.
2. Delete the `samples.zip` file from the `/pentaho-server/pentaho-solutions/system/default-content` directory.

   If you performed a manual WAR build and deployment, then the file path is: `/pentaho-server/pentaho-solutions/system`.
3. Edit the `/pentaho/WEB-INF/web.xml` file inside of the deployed `pentaho.war`.

   If you used an archive installation method, the path to the WAR file should be `/pentaho-server/tomcat/webapps/pentaho/WEB-INF/web.xml`. If you performed a manual WAR build and deployment, you must adjust the path to fit your specific configuration.
4. Remove the `hsqldb-databases` section from the `/pentaho/WEB-INF/web.xml` file:

   <pre class="language-xml" data-overflow="wrap"><code class="lang-xml">&#x3C;!-- [BEGIN HSQLDB DATABASES] -->
       &#x3C;context-param>
           &#x3C;param-name>hsqldb-databases&#x3C;/param-name>
           &#x3C;param-value>sampledata@../../data/hsqldb/sampledata&#x3C;/param-value>
       &#x3C;/context-param>
   &#x3C;!-- [END HSQLDB DATABASES] -->
   </code></pre>
5. Remove the `hsqldb-starter` section from the `/pentaho/WEB-INF/web.xml` file:

   <pre class="language-xml" data-overflow="wrap"><code class="lang-xml">&#x3C;!-- [BEGIN HSQLDB STARTER] --> 
   &#x3C;listener> 
   &#x3C;listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener&#x3C;/listener-class> 
   &#x3C;/listener> 
   &#x3C;!-- [END HSQLDB STARTER] -->
   </code></pre>
6. Remove the `SystemStatusFilter`:

   <div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p><strong>Note:</strong> The <code>SystemStatusFilter</code> filter is not part of the samples. The filter shows error status messages that are only useful for development and testing purposes, and should be removed from a production system.</p></div>

   <pre class="language-xml" data-overflow="wrap"><code class="lang-xml">&#x3C;filter>
       &#x3C;filter-name>SystemStatusFilter&#x3C;/filter-name>
       &#x3C;filter-class>com.pentaho.ui.servlet.SystemStatusFilter&#x3C;/filter-class>
       &#x3C;init-param>
           &#x3C;param-name>initFailurePage&#x3C;/param-name>
           &#x3C;param-value>InitFailure&#x3C;/param-value>
           &#x3C;description>This page is displayed if the PentahoSystem fails to properly initialize.&#x3C;/description>
       &#x3C;/init-param>
   &#x3C;/filter>
   </code></pre>
7. Remove the filter mapping for the `SystemStatusFilter`:

   ```xml
   <filter-mapping>
       <filter-name>SystemStatusFilter</filter-name>
       <url-pattern>/*</url-pattern>
   </filter-mapping>
   ```
8. Save and close the `web.xml` file.
9. Delete the `/pentaho-server/data/` directory.

   The `/pentaho-server/data/` directory contains a sample database, control scripts for that database, the environment settings it needs to run, and SQL scripts to initialize a new repository.
10. Restart the Pentaho Server, then sign into the Pentaho User Console with the administrator username and password, go to the Browse Files page, and perform the following steps:
    1. In the **Folders** pane, expand the **Public** folder and click to highlight the folder containing the Steel Wheels sample data. Click **Move to Trash** in the **Folder Actions** pane and confirm the deletion.
    2. Highlight the folder containing the Pentaho Operations Mart sample data. Click **Move to Trash** in the **Folder Actions** pane and confirm the deletion.

The Pentaho Server instance is now cleaned of sample data and content.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.pentaho.com/pdia-admin/manage-the-pentaho-system/manage-the-pentaho-server/remove-sample-data-from-the-pentaho-server.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
