PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 Where: unnamed portal parameter $4 #6408

anoopvarma-2000-p · 2025-02-05T14:05:57Z

anoopvarma-2000-p
Feb 5, 2025

In my mirth connect (version 4.5.2), I have an HTTP Listener as source and I have 2 API end points managed by code in the transformer.
The source HTTP listener settings are:

Message Content: Plain Body
Binary MIME Type: application/zip
No DB access in the source or destination
If all the transformers are disables, still the error occurs.

When I try to access the API from postman, I get the following error:

PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00
  Where: unnamed portal parameter $4

The server log shows 2 exceptions as given below:

[2025-02-05 18:09:00.473]  ERROR  (com.mirth.connect.connectors.http.HttpReceiver:523): Error receiving message (HTTP Listener "Source" on channel 282ab002-b993-44be-b785-6d45911e45df).
com.mirth.connect.donkey.server.channel.ChannelException: 
	at com.mirth.connect.donkey.server.channel.Channel.dispatchRawMessage(Channel.java:1376)
	at com.mirth.connect.donkey.server.channel.SourceConnector.dispatchRawMessage(SourceConnector.java:194)
	at com.mirth.connect.donkey.server.channel.SourceConnector.dispatchRawMessage(SourceConnector.java:172)
	at com.mirth.connect.connectors.http.HttpReceiver$RequestHandler.handle(HttpReceiver.java:382)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:190)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
	at org.eclipse.jetty.server.Server.handle(Server.java:516)
	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
	at java.base/java.lang.Thread.run(Unknown Source)Caused by: com.mirth.connect.donkey.server.channel.ChannelException: 
	at com.mirth.connect.donkey.server.channel.Channel.dispatchRawMessage(Channel.java:1325)
	... 27 moreCaused by: com.mirth.connect.donkey.server.data.DonkeyDaoException: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00  Where: unnamed portal parameter $4
	at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertContent(JdbcDao.java:296)
	at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMessageContent(JdbcDao.java:208)
	at com.mirth.connect.donkey.server.data.buffered.BufferedDao.executeTasks(BufferedDao.java:119)
	at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:93)
	at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:80)
	at com.mirth.connect.donkey.server.channel.Channel.dispatchRawMessage(Channel.java:1295)
	... 27 moreCaused by: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00  Where: unnamed portal parameter $4
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:152)
	at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertContent(JdbcDao.java:293)
	... 32 more

[2025-02-05 18:09:00.472]  ERROR  (com.mirth.connect.donkey.server.channel.Channel:1375): Error processing message in channel TechBD Flatfile CSV Workflow (282ab002-b993-44be-b785-6d45911e45df).
com.mirth.connect.donkey.server.channel.ChannelException: 
	at com.mirth.connect.donkey.server.channel.Channel.dispatchRawMessage(Channel.java:1325)
	at com.mirth.connect.donkey.server.channel.SourceConnector.dispatchRawMessage(SourceConnector.java:194)
	at com.mirth.connect.donkey.server.channel.SourceConnector.dispatchRawMessage(SourceConnector.java:172)
	at com.mirth.connect.connectors.http.HttpReceiver$RequestHandler.handle(HttpReceiver.java:382)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:190)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
	at org.eclipse.jetty.server.Server.handle(Server.java:516)
	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
	at java.base/java.lang.Thread.run(Unknown Source)Caused by: com.mirth.connect.donkey.server.data.DonkeyDaoException: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00  Where: unnamed portal parameter $4
	at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertContent(JdbcDao.java:296)
	at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMessageContent(JdbcDao.java:208)
	at com.mirth.connect.donkey.server.data.buffered.BufferedDao.executeTasks(BufferedDao.java:119)
	at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:93)
	at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:80)
	at com.mirth.connect.donkey.server.channel.Channel.dispatchRawMessage(Channel.java:1295)
	... 27 moreCaused by: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00  Where: unnamed portal parameter $4
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:152)
	at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertContent(JdbcDao.java:293)
	... 32 more

While searching for this issue, I saw a suggestion to use msg.replace(/\x00/g, ""); // Remove NULL bytes in the transformer.
I have tried this, but the issue still exists.

Please help to find out the issue.

Thank you.

pacmano1 · 2025-02-27T23:27:24Z

pacmano1
Feb 27, 2025
Collaborator

You are probably going to need to post the sample channel that replicates this.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 Where: unnamed portal parameter $4 #6408

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 1 comment

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 Where: unnamed portal parameter $4 #6408

Uh oh!

Uh oh!

anoopvarma-2000-p Feb 5, 2025

Replies: 1 comment

Uh oh!

pacmano1 Feb 27, 2025 Collaborator

anoopvarma-2000-p
Feb 5, 2025

pacmano1
Feb 27, 2025
Collaborator