Skip to Content
0

KPI AddBatchInsert Mode - SQL Error

Jan 31, 2017 at 10:34 PM

29

avatar image
Former Member

Hello trying to use AddBatchInsert mode on the KPI Query, it throws the following error message. Am I missing something.

SQL error has occurred on query The SQL statement "INSERT INTO MIIG_GOAL (FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD7,KPI_HOUR, KPI_DAY, KPI_WEEK, KPI_MONTH, KPI_YEAR , KPI_QUARTER , KPI_MINUTE) VALUES(?,?,?,?,?,?,16, 30, 5, 1, 2017), 'Q1', 26)" contains the syntax error[s]: - 1:182 - Intermediate-SQL syntax error: not exactly one row value constructor in VALUES
- 1:188 - Intermediate-SQL syntax error: a VALUES clause must be a list of value expressions, NULL or DEFAULT
- 1:192 - Intermediate-SQL syntax error: a VALUES clause must be a list of value expressions, NULL or DEFAULT
- 1:192 - SQL syntax error: the token ")" was not expected here

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers