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

[Bernard_rosencrantz]

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

[Albert_Candelario]

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

[Solvica]

Hello @Bernard_rosencrantz ,

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

Thanks.

Pavel

[prinzchristian]

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

Vielen Dank! 🙂 

[Solvica · Accepted solution]

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

[prinzchristian]

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