Issue Description
Part of creating a MongoDB datasource involves using a schema tool and uploading the resulting file to the repository via 'Add Resource > File > MongoDB JDBC Schema (See Data Sources in Administrator guide)
A mysql customer was receiving an error while attempting these steps. Logs showed "java.lang.AssertionError: Last packet not finished" and "Broken Pipe" errors.
The customer was using mariaDB jdbc driver, but the mysql driver gave support better clues with a "Packet for query is too large (3021321 > 1048576)" error
Resolution
TIBCO JasperReports® Server is trying to upload the file as an individual "blob" or similar and it is too large for out-of-box mysql settings.
The workaround is to set a larger 'max_allowed_packet' variable within your database server configuration. This type of message from Mysql is not uncommon, it seen in other "actions" involving large files:
Ref. Case 01482430
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now