topic Re: The following error occurred: (Connector error: Invalid row status 5 at 4) in Data Movement & Streaming

The following error occurred: (Connector error: Invalid row status 5 at 4)

Bernard_rosencrantz — Wed, 19 Mar 2025 23:06:21 GMT

Hi, over the weekend something changed in my database I kept getting this error when I try to load the data:

The following error occurred:

(Connector error: Invalid row status 5 at 4).

I assume I have faulty data in my database and want qlik to ignore it. The database has a lot of entries so it is impossible for me to go through the database and find the value.

The database is a Mongodb

Data load script:

LIB CONNECT TO 'MongodbXXXXXYYYYYY'; // I had to hide this

LOAD _id,
status,

[posts]:
SELECT [_id],
status,

FROM XXXX.YYYY; //had to hide this

Re: The following error occurred: (Connector error: Invalid row status 5 at 4)

Albert_Candelario — Mon, 30 Jan 2023 07:36:43 GMT

Hello @Bernard_rosencrantz ,

Thanks for posting.

Have you tried to load a limited amount of rows of your BD and open the scrip in debug mode? If not, I would suggest giving it a shot:

Debug the data load script | Qlik Cloud Help

Cheers,

Albert

Re: The following error occurred: (Connector error: Invalid row status 5 at 4)

Solvica — Wed, 19 Apr 2023 14:38:54 GMT

Hello @Bernard_rosencrantz ,

did you get it working? I am facing the same issue using PostgreSQL.

Thanks.

Pavel

Re: The following error occurred: (Connector error: Invalid row status 5 at 4)

prinzchristian — Mon, 04 Sep 2023 14:02:57 GMT

Wurde hier bereits eine Lösung gefunden - Habe das gleiche Verhalten über den PostgreSQL on Prem wie auch in der SaaS?

Vielen Dank! 🙂

Re: The following error occurred: (Connector error: Invalid row status 5 at 4)

Solvica — Tue, 05 Sep 2023 05:29:59 GMT

Hi, in our case it has been caused by having invalid date format in the database (something like 15.08.20023) - we had to fix these records and then it worked fine.

Pavel

Re: The following error occurred: (Connector error: Invalid row status 5 at 4)

prinzchristian — Tue, 05 Sep 2023 05:31:28 GMT

Vielen Dank! 🙂
Dann werde ich mich mal in die DB stürzen und die Sätze identifizieren.