JDBC Producer: Table does not exist or PDB is incorrect

asked 2018-10-03 06:20:50 -0500

Gaur
1 ●1 ●1

updated 2018-10-04 23:36:43 -0500

Hello, I'm pulling data from IBM DB2 using JDBC Consumer and writing to SAP HANA using JDBC Producer but getting error message "Table 'xxxxx' does not exist or PDB is incorrect. Make sure the correct PDB was specified". I have tried lower case, upper case table names and by just pulling one column but it doesn't work. All records are landing in error records output. Appreciate direction. BR//Gaur

edit retag flag offensive close merge delete

Comments

How did you configure JDBC Producer ?

Shruthi ( 2018-10-03 23:29:53 -0500 )edit

Pretty much same as yours. Cant attach a link, just learned I need >10 points for that lol Here are the details: JDBC Connection String: jdbc:sap://$host$:port/$Schemaname$ Schema Name: $Schemaname$ Table Name: Project Column: id SDC Field: /id Data Type: INTEGER

Gaur ( 2018-10-04 01:56:17 -0500 )edit

I have updated my answer please check

Shruthi ( 2018-10-05 00:17:30 -0500 )edit

add a comment

answered 2018-10-04 00:20:37 -0500

Shruthi

165 ●17 ●24 ●31 http://seedolabs.com/

updated 2018-10-05 00:16:07 -0500

Configure 'JDBC Producer' as following, image description

You need to check few things here:

Does the table 'Project' exist? You should create the table in the mentioned DB before running the pipeline. JDBC will not create it. Also name your table in small letters(change 'Project' to 'project')
Check you JDBC driver matches the server. Use 5.1.x driver.
Try not to set anything in the 'Schema Name' configuration in the JDBC Producer, let this be blank since you are setting schemaname/database in the 'JDBC connection string'.

Refer https://groups.google.com/a/streamset... for more details

Comments

Thanks for your reply. I have tried by creating table in target in small and capital letter both but didn't help. driver and schema name setting as you mentioned didnt help either. BR//Gaur

Gaur ( 2018-10-08 05:41:32 -0500 )edit

add a comment

JDBC Producer: Table does not exist or PDB is incorrect

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

JDBC Producer: Table does not exist or PDB is incorrect edit

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

JDBC Producer: Table does not exist or PDB is incorrect