Troubleshooting > Troubleshooting DataConnect > Execution failed for create table statement
Was this helpful?
Execution failed for create table statement
 
Error Code
7
Error Message
Error preparing map for execution: Error 25507 opening target 'ODBC 3.5': Exec SQL failed: SQL Statement <CREATE TABLE "<TableName>" ("ColumnName1" datatype, "ColumName2" datatype, "ColumnName3" datatype)>
Description
This error message is displayed for Ingres, Actian X, Actian Warehouse, or Vector databases, when you use a symbol as a prefix in the table name.
Cause/Solution
Cause: You cannot create and run a map that contains a symbol as a prefix in the table name.
Solution: Change the Target table name:
1. Click the Target tab.
2. Change the Target table name.
3. Save and Run the Map.
Related Information
Last modified date: 07/26/2024