SQL error: Exporting report ‘[report name]’, Incorrect string value

SQL error: Exporting report ‘[report name]’, Incorrect string value

Info
When you see the error message "SQL error: Exporting report '[report name]', Incorrect string value" in your PMA Hub under Exports > SQL > View Logs, it indicates that your MySQL server is unable to process certain characters in your data.

Error

"SQL error: Exporting report '[report name]', Incorrect string value"


Cause

This error occurs due to a character set incompatibility between Power My Analytics exports and your MySQL server. This means your data contains characters that aren't supported by your server's default character set.

Solution

To fix this issue, you'll need to change your MySQL server's character set to utf8mb4.

Alert
This procedure requires administrator access to your MySQL server and can only be performed by you or your database administrator. Power My Analytics support cannot make these changes to your database for you.

Step 1: Access Your MySQL Server

Connect to your MySQL server with administrator privileges using your preferred method (command line, SSH, or administration tool).

Step 2: Change the Server Character Set

Run the following command to change the server's character set:

mysqld --character-set-server=utf8mb4

After modifying the configuration file, restart your MySQL server for the changes to take effect.

Step 3: Verify the Changes

You can verify that the character set has been changed by running:

SHOW VARIABLES LIKE 'character_set%';

The character_set_server variable should now show utf8mb4.

Step 4: Retry Your Export

Return to your Power My Analytics hub and run your export again. Check the logs to verify that it has completed successfully.

    • Related Articles

    • How to Export to Azure SQL Database

      Exporting your marketing data to Azure SQL allows you to integrate it with various applications and run complex data queries. This guide will walk you through the process of setting up and managing your Azure SQL exports using Power My Analytics. A ...

    • How to Use the SQL Connector

      Power My Analytics now offers an SQL connector in addition to our Hosted SQL solution. This article will help you get started with using our SQL connector and set up a MSSQL or MySQL query. Connect to your server in the Hub Select Sources in the left ...

    • Error: Exporting report '[report name]', the owner of the report has left the organization. Please assign a new owner.

      This article explains what to do when you encounter an error message indicating that a report owner has left your organization when attempting to export to BigQuery. Error Message Error: Exporting report '[report name]', the owner of the report has ...

    • Power My Analytics' Sovereign SQL Warehouse Solution

      Power My Analytics offers a Sovereign SQL Warehouse solution with the Custom plan. This article will help you learn about its uses and how to get started. The Sovereign SQL Warehouse gives you complete ownership of your data by storing it in your own ...

    • Troubleshooting Data Exports

      Power My Analytics allows Custom plan subscribers to export marketing data from Data Builder reports to destinations like BigQuery, MySQL, Azure SQL Database, PostgreSQL, Amazon S3, and FTP. This article is a central index of troubleshooting ...