Configuration of JDBC Multitable Consumer initial offset

asked 2019-09-18 10:12:12 -0600

larsole gravatar image

updated 2019-09-18 14:09:34 -0600

metadaddy gravatar image


I have tried and tried to do this, but i can't make it correct. I get the error

JDBC Multitable Consumer ETSETTRA
JDBC_64 - Invalid intial Offset configuration. Missed Columns: (none), Non Existing Columns: APBPK,APCPK,APDPK,BO5PK,BO8PK,BOAPK,BODPK,BOSPK,BPDPK,CN9_PK,DB2PK,FPNPK,I012_PK,I014_PK,MD2PK,MS9_PK,MVRPK,OS1_PK,OS9_PK,PD2_PK,PD3_PK,PPCPK,RM8_PK,RMD_PK,RMP_PK,RMY_PK,S0141PK,SPHPK,SRHPK,SSDPK,TVE_PK . : Table Configs 47
JDBC_66 - No Tables matches the configuration in the origin. : Table Configs

Allthough I am 1000000% sure it is the right columns. Is there any examples of this any where?

edit retag flag offensive close merge delete


How have you set up the table configuration(s)?

metadaddy gravatar imagemetadaddy ( 2019-09-18 17:19:03 -0600 )edit

Like % for tables and WEB|TOL|TEMP for tables to avoid? Or what do you mean?

larsole gravatar imagelarsole ( 2019-09-18 17:21:01 -0600 )edit

It seems not to be able to find the PK's in the tables? Does it use the data dictionary for this?

larsole gravatar imagelarsole ( 2019-09-18 17:21:56 -0600 )edit

It retrieves the schema via the JDBC driver. By default, primary keys are used as offset columns. If you want to use a different column, you need to enable 'Override Offset Columns' and then supply the offset column name for that table configuration.

metadaddy gravatar imagemetadaddy ( 2019-09-18 17:56:04 -0600 )edit

So it is probably a user right problem. Where can I see the necessary rights for the user I am using to connect with

larsole gravatar imagelarsole ( 2019-09-18 23:32:32 -0600 )edit