Bulk cache upload is not working for Maria DB (Adapter: MySQL 5.5) as cache target data source even after enabling "Enable Native Loading"
Article ID: KB0081683
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.5, 7.0.6 |
Description
- Please enable the cache debug logging using the below debug properties.
- Open <<CIS Installation Dir>>/conf/server/log4j.properties, add these 2 lines at the end of the file and restart CIS server:
log4j.logger.com.compositesw.cdms.ds.jdbc.cache.BulkLoadableCache=DEBUG
- Open cache resource and click "Refresh Now" button in caching tab
- Verify cs_server.log file and you should be able to find the actual error which is causing the issue.
Issue/Introduction
Bulk cache upload is not working for Maria DB (Adapter: MySQL 5.5) as cache target data source even after enabling "Enable Native Loading"
Environment
TEST
Resolution
- In this case, we have found the below error in the logs
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: The used command is not allowed with this MariaDB version
- After researching the above error, we have found that its related 'local_infile' configuration. The 'local_infile' conf was set to 'OFF" and after changing it to 'ON', the cache refresh is working fine.
- Please refer the below forum for more details about the solution:
Feedback
Yes
No
Powered by
