[NIFI-4924] PutDatabaseRecord throws ArrayIndexOutOfBoundsException when there is more than one table with the same name on the database (in different schemas)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.5.0
• Fix Version/s: 1.13.0
• Component/s: Extensions
• Environment: ubuntu 16.04 ; nifi 1.5.0 ; db2 v10.5.0.7 ; JDBC driver db2jcc4-10.5.0.6
• Assignee: Unassigned
• Reporter: Marcio Sugar
• Created: 02/Mar/18 18:32
• Updated: 22/Jun/21 14:07
• Resolved: 22/Jun/21 14:07

Description

I'm trying to copy data from one table on DB2 database "A" to the same table on another DB2 database "B". Schemas are identical.

My flow is simply a QueryDatabaseTable reading from "A" and connected to a PutDatabaseRecord writing to "B". The latter uses and AvroReader controller. Each processor uses its own DBCPConnectionPool since "A" and "B" are on different instances.

I get errors like this when my AvroReader is set to use the 'Schema Text' property: 

PutDatabaseRecord[id=e3905091-0161-1000-028c-982c192bf16f] org.apache.nifi.processors.standard.PutDatabaseRecord$$Lambda$438/1366813796@deb42 failed to process due to org.apache.nifi.processor.exception.ProcessException: Failed to process StandardFlowFileRecord[uuid=58ce220f-2b43-4875-bdb4-c704b093f9d7,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1519955790257-2, container=default, section=2], offset=175623, length=174960],offset=0,name=255478043043373,size=174960] due to java.lang.ArrayIndexOutOfBoundsException: -40; rolling back session: Failed to process StandardFlowFileRecord[uuid=58ce220f-2b43-4875-bdb4-c704b093f9d7,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1519955790257-2, container=default, section=2], offset=175623, length=174960],offset=0,name=255478043043373,size=174960] due to java.lang.ArrayIndexOutOfBoundsException: -40 

Issue Links

• is duplicated by: NIFI-8172 PutDatabaseRecord ignores schema name when getting primary keys