Error: : org.postgresql.util.PSQLException: ERROR: relation "ad_session_sq" does not exist Position: 16

[Crispian Blackbourn]

Hi all,

I have idempiere version 5 running on an ubuntu 18 server. Today I changed the system to enable native sequencing in the system client and now cannot log back in. I get the following error

any ideas please?

 Error: : org.postgresql.util.PSQLException: ERROR: relation "ad_session_sq" does not exist
Position: 16

Thanks in anticipation

Crispian

[Carlos Antonio Ruiz Gomez]

Hi Crispian, did you run the process Enable Native Sequence ?

iDempiere version 5, wow, that's 5 years old

Regards,

Carlos Ruiz

El 11/9/22 a las 19:28, 'Crispian Blackbourn' via iDempiere escribió:

[Crispian Blackbourn]

Hi Carlos,

hope you're well?

No I didn't run the process  :-/ 

Is there a way to do that given that I can't get in to the application at the moment?

And yes 5 is old - it's a little test set up I've left running to reference when I'm brainstorming :-)

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/52e62204-6d6e-31f2-28b3-b2a3a497d88a%40gmail.com.

[Saulo Gil]

Hello,

I'd recommend to execute the following database query before (re)starting the service:

update ad_sysconfig set value = 'N' where name = 'SYSTEM_NATIVE_SEQUENCE';

Best regards,

Saulo Gil | Orbital Software  | +54 911 3049 4237

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

[Crispian Blackbourn]

Hi Saulo,

Thanks for the help -  managed to get it going after a couple of attempts.

Took a full reboot to take effect.

Thank you again

Regards

Crispian 

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/0100018331a465f5-b04eb36a-3938-4695-9f44-283cb744f8f6-000000%40email.amazonses.com.