Roger Sliva created NIFI-8524:
---------------------------------
Summary: PutDatabaseRecord fails when inserting or updating a CHAR
column
Key: NIFI-8524
URL: https://issues.apache.org/jira/browse/NIFI-8524
Project: Apache NiFi
Issue Type: Bug
Affects Versions: 1.13.2
Environment: RHEL 7.4 using OpenJDK 11 with mssql-jdbc-9.2.1.jre11.jar
Reporter: Roger Sliva
PutDatabaseRecord fails when inserting or updating into a SQL Server 12+ table
with a CHAR(1) column.
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from UNKNOWN to
CHAR is unsupported.
This works in 1.11.4
When the CHAR columns are converted to VARCHAR the fail does not occur.
From nifi-app.log:
2021-05-05 09:43:13,938 ERROR [Timer-Driven Process Thread-10]
o.a.n.p.standard.PutDatabaseRecord
PutDatabaseRecord[id=88544076-0170-1000-abaf-0ff508f882b1] Failed to put
Records to database for
StandardFlowFileRecord[uuid=07ecd86b-9568-4f3f-a7e9-03b59a1069be,claim=StandardContentClaim
[resourceClaim=StandardResourceClaim[id=1620232684227-3, container=default,
section=3], offset=272241,
length=539],offset=0,name=6eee14cb-6c23-497e-b01a-84875d76c810,size=539].
Routing to failure.: com.microsoft.sqlserver.jdbc.SQLServerException: The
conversion from UNKNOWN to CHAR is unsupported.
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from UNKNOWN to
CHAR is unsupported.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234)
at
com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1112)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(SQLServerPreparedStatement.java:1588)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(SQLServerPreparedStatement.java:1507)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:529)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:529)
at jdk.internal.reflect.GeneratedMethodAccessor375.invoke(Unknown Source)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at
org.apache.nifi.controller.service.StandardControllerServiceInvocationHandler.invoke(StandardControllerServiceInvocationHandler.java:254)
at
org.apache.nifi.controller.service.StandardControllerServiceInvocationHandler.access$100(StandardControllerServiceInvocationHandler.java:38)
at
org.apache.nifi.controller.service.StandardControllerServiceInvocationHandler$ProxiedReturnObjectInvocationHandler.invoke(StandardControllerServiceInvocationHandler.java:240)
at com.sun.proxy.$Proxy150.setObject(Unknown Source)
at
org.apache.nifi.processors.standard.PutDatabaseRecord.executeDML(PutDatabaseRecord.java:736)
at
org.apache.nifi.processors.standard.PutDatabaseRecord.putToDatabase(PutDatabaseRecord.java:841)
at
org.apache.nifi.processors.standard.PutDatabaseRecord.onTrigger(PutDatabaseRecord.java:487)
at
org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27)
at
org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1173)
at
org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:214)
at
org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:117)
at org.apache.nifi.engine.FlowEngine$2.run(FlowEngine.java:110)
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
at
java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
