My Oracle Support Banner

DIM Error: "Syntax Error in CREATE TABLE Statement" when Writing to Microsoft Access with ODI (Doc ID 847187.1)

Last updated on AUGUST 19, 2021

Applies to:

Hyperion Data Integration Management - Version 9.2.0.3.00 and later
Information in this document applies to any platform.
6.1.15

Symptoms

When running an Interface that writes to a Microsoft Access database using IKM Access Incremental Update, the following error is displayed:

Syntax error in CREATE TABLE statement

The generated SQL code is:

create table C$_0TABLENAME
(
C1_COL1 VARCHAR(50) ,
C2_COL2 VARCHAR(50)
)

The full error is:
-3551 : 37000 : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.prepareStatement(Unknown Source)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.