You can translate the question and the replies:

INSERT Operation fails with multiple records and the now() function

I'm performing a simple Insert Operation with multiple records using the now() function. insert into "ViewName" ("Id", "Name", "EmailAddress", "EmailDtm") values ('1', 'joe', 'joe@denodo.com', now()), ('2', 'joe', 'joe@denodo.com', now()) It throws an error: Error executing view: {0} When inserting just a single row, like below, the insert is successful. insert into "ViewName" ("Id", "Name", "EmailAddress", "EmailDtm") values ('1', 'joe', 'joe@denodo.com', now()) Is there an issue with using the now() function inside of an Insert Operation with multiple records? Any help would be appreciated.
user
13-04-2021 17:39:24 -0400

1 Answer

Hi, In case I get an error when inserting rows to the underlying database I would perform the following checks: * I would check the vdp.log file in the **<DENODO_HOME>/logs/vdp** folder to see if there are any errors recorded related to the insert operation. * Also, I would check if it is possible to perform insert operation with multiple records directly in the database. Suppose if you still need help and if you are a valid support user then you can raise a support case on [Denodo Support Site](https://support.denodo.com/) so that our support team can help you Hope this helps!
Denodo Team
15-04-2021 07:26:17 -0400
You must sign in to add an answer. If you do not have an account, you can register here