I have a job which tests whether a table exists or not, and it not then it creates the table with an SQL step.
On the first run it does not find the table and creates it, however on any subsequent run the Table Exists fails to detect the table and tries to create the table again with the following error : Table 'test' already exists
I'm using PDI v184.108.40.206-343, mariadb-java-client-3.1.2.jar and openjdk 11.0.18
pls could you run job with higher logging level (Detailed or Debug). This have to work. :-)
Or you check table and create in another schema.
What is the database you are working with? Do you have a way to capture the SQL that Pentaho is generating (either on the server itself or using WireShark or similar)?I seem to remember we had this problem at one point and ended up coding up a SQL query to ask the DB's system tables if the user table existed (returned a 0 or 1) and then put in a filter step either to direct the flow to creation of the table or to a Dummy step.
A proud part of Hitachi Vantara
© Hitachi Vantara Corporation. All Rights Reserved.