Styjun

How long would it take to cross the Channel in 1890's?

Inverse-quotes-quine

Why is C++ initial allocation so much larger than C's?

Can White Castle?

Find the probability that the 8th woman to appear is in 17th position.

How can I politely work my way around not liking coffee or beer when it comes to professional networking?

Links to webpages in books

How do I respond to requests for a "guarantee" not to leave after a few months?

Require advice on power conservation for backpacking trip

Why did pressing the joystick button spit out keypresses?

Does Marvel have an equivalent of the Green Lantern?

What is the origin of Scooby-Doo's name?

How dangerous are set-size assumptions?

Vanishing of certain coefficients coming from Coxeter groups

Can humans ever directly see a few photons at a time? Can a human see a single photon?

Why do some games show lights shine thorugh walls?

Is it damaging to turn off a small fridge for two days every week?

Why do all the teams that I have worked with always finish a sprint without completion of all the stories?

Hand soldering SMD 1206 components

Are all instances of trolls turning to stone ultimately references back to Tolkien?

Folding basket - is there such a thing?

What's currently blocking the construction of the wall between Mexico and the US?

What are the penalties for overstaying in USA?

Does squid ink pasta bleed?

Duplicate entry for primary key error for kettke transformation(job)

Date format and data extract from Pentaho Kettle SpoonPentaho Data Integration: Error HandlingDuplicating a job in Pentaho Data Integration for different connectionsError initializing UserDefinedJavaClassNot able to get system data at the end of transformation stepPentaho Error: Duplicate entry for non primary keyUnexpected error occurred while launching entryPDI: Output only if no errorsPentaho Error: Duplicate entry for key 'PRIMARY'Recursive lookup to find ultimate parent of any parent-child relationship using pentaho

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have 1-table input 1-row filter 1-table output in my spoon transformation. I put this transformation in a Job.

I am getting error:

" Caused by: java.sql.BatchUpdateException: Duplicate entry '1000' for
key 'PRIMARY'

I have checked the input table but there it has only one entry for primary key = 1000. can someone tell me what is going wrong here?

Thank you

pentaho kettle pentaho-spoon pentaho-data-integration

share|improve this question

edited Mar 25 at 12:18

Tomka Koliada

1,26222 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 9:38

Naresh VadlaNaresh Vadla

1033 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The error indicates that it occurs on the table output step. Are you sure the entry doesn't exist already in the output table?
  
  – Etienne Ott
  Mar 25 at 10:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  based on my transformation design, if the table input has only one entry for primary key then table output should have only one entry. I have checked there is only one entry in table input. but still table output is inserting it again, pls find my transformation here lh3.googleusercontent.com/-hC76HYdt-mE/XJnhBi3L8DI/AAAAAAAAnKU/… "transformation"
  
  – Naresh Vadla
  Mar 26 at 8:18
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is the output table cleared/truncated before each run of the transformation? The table output step, in contrast to the insert/update step, does not check if the output table already contains the row to write and will fail when the database server complains about the violated constraint on the primary key (as it is not unique). If the transformation should run multiple times, then an insert/update step would be better.
  
  – Etienne Ott
  Mar 26 at 8:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you. This is the first time i am running the transformation. table is truncated and then running the transformation.
  
  – Naresh Vadla
  Mar 26 at 10:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Okay, those were my first two guesses as to what's wrong. Could you update the question with the code of the transformation? An image isn't helping much. You can find out the code by opening the kettle file (.ktr) with a text editor and copying the entire XML content. PLEASE make sure to edit out the database connection credentials.
  
  – Etienne Ott
  Mar 26 at 10:56
  
  

  
  
  
  

 | 
show 3 more comments

0

I have 1-table input 1-row filter 1-table output in my spoon transformation. I put this transformation in a Job.

I am getting error:

" Caused by: java.sql.BatchUpdateException: Duplicate entry '1000' for
key 'PRIMARY'

I have checked the input table but there it has only one entry for primary key = 1000. can someone tell me what is going wrong here?

Thank you

pentaho kettle pentaho-spoon pentaho-data-integration

share|improve this question

edited Mar 25 at 12:18

Tomka Koliada

1,26222 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 9:38

Naresh VadlaNaresh Vadla

1033 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The error indicates that it occurs on the table output step. Are you sure the entry doesn't exist already in the output table?
  
  – Etienne Ott
  Mar 25 at 10:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  based on my transformation design, if the table input has only one entry for primary key then table output should have only one entry. I have checked there is only one entry in table input. but still table output is inserting it again, pls find my transformation here lh3.googleusercontent.com/-hC76HYdt-mE/XJnhBi3L8DI/AAAAAAAAnKU/… "transformation"
  
  – Naresh Vadla
  Mar 26 at 8:18
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is the output table cleared/truncated before each run of the transformation? The table output step, in contrast to the insert/update step, does not check if the output table already contains the row to write and will fail when the database server complains about the violated constraint on the primary key (as it is not unique). If the transformation should run multiple times, then an insert/update step would be better.
  
  – Etienne Ott
  Mar 26 at 8:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you. This is the first time i am running the transformation. table is truncated and then running the transformation.
  
  – Naresh Vadla
  Mar 26 at 10:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Okay, those were my first two guesses as to what's wrong. Could you update the question with the code of the transformation? An image isn't helping much. You can find out the code by opening the kettle file (.ktr) with a text editor and copying the entire XML content. PLEASE make sure to edit out the database connection credentials.
  
  – Etienne Ott
  Mar 26 at 10:56
  
  

  
  
  
  

 | 
show 3 more comments

I have 1-table input 1-row filter 1-table output in my spoon transformation. I put this transformation in a Job.

I am getting error:

" Caused by: java.sql.BatchUpdateException: Duplicate entry '1000' for
key 'PRIMARY'

I have checked the input table but there it has only one entry for primary key = 1000. can someone tell me what is going wrong here?

Thank you

pentaho kettle pentaho-spoon pentaho-data-integration

share|improve this question

edited Mar 25 at 12:18

Tomka Koliada

1,26222 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 9:38

Naresh VadlaNaresh Vadla

1033 bronze badges

share|improve this question

edited Mar 25 at 12:18

Tomka Koliada

1,26222 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 9:38

Naresh VadlaNaresh Vadla

1033 bronze badges

share|improve this question

edited Mar 25 at 12:18

Tomka Koliada

1,26222 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 9:38

Naresh VadlaNaresh Vadla

1033 bronze badges

edited Mar 25 at 12:18

Tomka Koliada

1,26222 gold badges88 silver badges2828 bronze badges

edited Mar 25 at 12:18

Tomka Koliada

1,26222 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 9:38

Naresh VadlaNaresh Vadla

1033 bronze badges

asked Mar 25 at 9:38

Naresh VadlaNaresh Vadla

1033 bronze badges