org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction[SQL: 0, 25006]

[Crispian Blackbourn]

Hi Community,

I've been following Jan's Developing iDempiere2.0 - Importing data via CSV tutorial on Youtube.

I've got as far as replicating the tables togeher with their respective windows and the import file loader format (around 14mins in). However, the next stage which is just before you develop the process via a plugin in eclipse, Jan populates the import window with the contents of his csv which is where I get the following error;

org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction[SQL: 0, 25006]

I assume this a database setting and wonder how to get around it?

Thanks in advance

Crispian

[Carlos Antonio Ruiz Gomez]

Please check

https://idempiere.atlassian.net/browse/IDEMPIERE-5509?focusedCommentId=49512

El 7/6/23 a las 12:42, 'Crispian Blackbourn' via iDempiere escribió:

--

[Crispian Blackbourn]

Hi Carlos,

Hope you're well?

Thanks for the information - does this mean I need to reinstall my development environment with a more recent release (i.e after the fix date) or is there a way to undo the 'enable native sequence process?

Thanks again

Crispian

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/ee93856f-b874-8ca8-d7c6-bf268d520200%40gmail.com.

[Crispian Blackbourn]

Hi Carlos,

Got It! I deleted and added the new code snippets as detailed in the ticket.

Sorry for not getting it straight away ;-)

Crispian

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/284080485.1989181.1686205657306%40mail.yahoo.com.