GPSS 1.3.5 issues - Not a valid JSON message
search cancel

GPSS 1.3.5 issues - Not a valid JSON message

book

Article ID: 296491

calendar_today

Updated On:

Products

VMware Tanzu Greenplum

Issue/Introduction

Message which is coming up:

Aborting operation regardless of REJECT LIMIT value. Last error was: Not a valid json message
 
2020-05-24 06:34:09.772563 UTC,"gploader","tto",p7789,th-2345678900,"14.66.3.445","71234",2020-05-24 06:34:19 UTC,763422,con352266,cmd22,seg-1,,dx2035674,x763422,sx1,"ERROR","40M00","All 1000 first rows in this segment were rejected. Aborting operation regardless of REJECT LIMIT value. Last error was: Not a valid json message (seg14 slice 6 14.66.3.445:7001 pid=33266)","External table gpkafkaloadext_456h3th45hdg9h4337r23y85d99475gt 



Environment

Product Version: 5.23

Resolution

Run the following statements:
on etl server:    gpss --version
in psql:        select gpfmt_version();

They should be the same. If not, please perform the following command to make sure they are the same and test again.
In psql:         drop extension gpss;
              create extension gpss;