> 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/troubleshooting-overview-cp/general-issues.md). # General issues Common software issues associated with the Pentaho suite. ## JDBC driver issues Before you begin troubleshooting suspected JDBC driver issues, make sure that the correct JDBC driver JARs are installed in the correct locations. You could install your drivers with our JDBC Distribution Tool to ensure they are placed in the correct locations. Also, make sure there are no conflicting driver versions installed. Confirm with your database or driver vendor if you suspect you have JDBC driver compatibility issues. See the **Install Pentaho Data Integration and Analytics** document for details. The Pentaho Server needs the appropriate driver to connect to the database that stores your data. You can download drivers from your database vendor's website. Check the **JDBC drivers reference** in the Try Pentaho Data Integration and Analytics document for a list of supported drivers and links to vendor websites. Perform the following steps to install the appropriate driver for your Pentaho Server: 1. Stop the Pentaho Server. 2. Copy your driver into this location: `/server/pentaho-server/tomcat/lib`. 3. Start the Pentaho Server. ## Data conversion issues with MySQL driver 5.0.8 The MySQL JDBC driver version 5.0.8 may cause data conversion errors in the Pentaho Server. For example, SQL statements that convert a numeric field to a string are returned as a string in version 5.0.7, but return as a byte array in version 5.0.8. To solve this problem, you must replace the `mysql-connector-java-5.0.8.jar` with the `mysql-connector-java-5.0.7.jar` in your client tool or application server's `lib` folder ## Fixing JTDS varchar(Max) limitations in MSSQL 2005 Creating a report that uses a column of type varchar(MAX) may result in a `net.sourceforge.jtds.jdbc.ClobImpl@83cf00` error when using the JTDS SQL Server driver. This is caused by inherent limitations in older versions of the JTDS driver. Additionally, the SQL Server JDBC driver version 1.2.2828 also has issues accessing a varchar(MAX) column. The solution is to upgrade the MSSQL 2005 JDBC driver to version 1.0.809.102 or later. Download and install the file from Microsoft.com, then restart your MSSQL server. --- # 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 dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.pentaho.com/pdia-admin/troubleshooting-overview-cp/general-issues.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. 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.