Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

PutSQL : "Index 5 is out of range" exception when table has less than 5 columns

PutSQL : "Index 5 is out of range" exception when table has less than 5 columns

New Contributor

Whenever I use PutSQL to insert a row into a table with less than 5 columns, I will get the following exception:

PutSQL[id=01591000-e111-1311-7842-39030b6ba896] Cannot update database for StandardFlowFileRecord[uuid=5889833a-055e-4604-9a49-6620b9e6122a,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1488648682725-7, container=default, section=7], offset=1011872, length=95],offset=0,name=35675244216615,size=95] due to com.microsoft.sqlserver.jdbc.SQLServerException: The index 5 is out of range.; routing to failure: com.microsoft.sqlserver.jdbc.SQLServerException: The index 5 is out of range.

Has anyone encountered this before?

Nifi version: 1.0.0

DB: MS SQL Server 2012

JDBC Driver: Microsoft JDBC Driver 6.0