Skip to main content
Solved

JDBC PIPE LINE NOT RUNING,SHOWS ME ERROR LIKE: JDBC_16 - Table '' does not exist or PDB is incorrect. Make sure the correct PDB was specified

  • November 16, 2022
  • 2 replies
  • 112 views
lakshmi_narayanan_t
Discovered Fame

I facing a issue on running JDBC pipeline ,it shows the below error ,I tried so many things  from the google but no use anybody can solve .

 

Best answer by AkshayJadhav

Hello @lakshmi_narayanan_t  - Thank you for reaching out to StreamSets Community. I’ve seen this issue cropping up because of the partition definition in the table, Could you please let us know:

  1. Tables are created with partitions?
  2. Are we connecting to Postgres DB?
  3. Confirm the DataCollector version?

Thank you - AkshayJ

View original
Mel
1 person likes this
  • Mel
    Mel
Did this topic help you find an answer to your question?

2 replies

AkshayJadhav
StreamSets Employee
Forum|alt.badge.img
  • AkshayJadhavStreamSets Employee
  • StreamSets Employee
  • 101 replies
  • Answer
  • November 16, 2022

Hello @lakshmi_narayanan_t  - Thank you for reaching out to StreamSets Community. I’ve seen this issue cropping up because of the partition definition in the table, Could you please let us know:

  1. Tables are created with partitions?
  2. Are we connecting to Postgres DB?
  3. Confirm the DataCollector version?

Thank you - AkshayJ

lakshmi_narayanan_t
1 person likes this
  • lakshmi_narayanan_t
    lakshmi_narayanan_t
lakshmi_narayanan_t
Discovered Fame

The problem was solved due to the inside  of my  JDBC connection string database name is entered wrong and then changed the database name correctly the error is gone.

thank you

lakshmi_narayanan_t
1 person likes this
  • lakshmi_narayanan_t
    lakshmi_narayanan_t

Reply


Terms & Conditions