SQL Bad Grammar on Import

bcadmin · Post by **bcadmin** » Tue Sep 02, 2008 7:42 pm

Hi,

I receive the following error when attempting to import 25k addresses into Openemm via a CSV file.

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [CREATE TEMPORARY TABLE cust_1_exist1_tmp13_tbl AS (SELECT customer_id FROM cust_1_tmp13_tbl WHERE datasource_id=0)]; nested exception is java.sql.SQLException: Table 'openemm.cust_1_tmp13_tbl' doesn't exist

The openemm user (agnitas) has all permissions required from within mysql to create temporary tables.

The environment is Centos 5.2, Openemm 5.5.0, MySQL 5.0.45 - This is a fresh install with no previous database upgrade.

Thoughts?

Thanks,

Bcadmin

Post by **maschoff** » Mon Sep 08, 2008 9:44 am

Sorry, we have problems to reproduce this error. Can you reproduce the problem? If so, could you provide us with an import file so that we can replicate your import?