Error in migration script executing v 2.1z

[Mousumi Bhowmick]

Hii,

During migration from v 2.1 to version 3.1 while executing i2.1.z  postgres sql script it throwing following error. There is not dual statement in postgresql.

Please suggest.

SELECT register_migration_script('201411061604_IDEMPIERE-2230.sql') FROM dual

;

psql:i2.1z/postgresql/201411061604_IDEMPIERE-2230.sql:61: ERROR:  function uuid_generate_v4() does not exist
LINE 1: SELECT uuid_generate_v4()::char(36)
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT uuid_generate_v4()::char(36)
CONTEXT:  PL/pgSQL function generate_uuid() line 3 at RETURN
SQL statement "INSERT INTO ad_migrationscript
            (isapply, scriptroll, ad_migrationscript_uu,
             status, projectname, releaseno,
             name, filename, ad_client_id,
             ad_org_id, created, createdby,
             updated, updatedby, isactive,
             ad_migrationscript_id)
        VALUES
            ('Y', 'N', generate_uuid(),
             'CO', 'iDempiere', (select releaseno from ad_system),
             p_script, 'postgresql/'||p_script, 0,
             0, now(), 100,
             now(), 100, 'Y',
             nextidfunc(53081,'N'))"
PL/pgSQL function register_migration_script(character varying) line 17 at SQL statement

Regards,

Mousumi Bhowmick

[Heng Sin Low]

you need to install the uuid extension for postgresql.

https://www.tigerdata.com/learn/postgresql-extensions-uuid-ossp

**************************************************************************************************

PLEASE READ: The information contained in this e-mail is confidential  and intended 

for the named  recipient(s)  only. If  you are not  an intended recipient of this  e-mail 

please  notify the sender immediately and delete your copy  from your  system. Our 

company accepts no liability for any damage sustained as a result of viruses in this 

e-mail or any attachment(s) to it.

**************************************************************************************************

--
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 visit https://groups.google.com/d/msgid/idempiere/e00380d0-000b-4174-a704-bc20781b02a4n%40googlegroups.com.

[Mousumi Bhowmick]

Thanks for your reply. 

Installed but didnt work. Any other way?

[Carlos Antonio Ruiz Gomez]

What didn't work, what's the new error?

[Mousumi Bhowmick]

Same error is coming.

[Carlos Antonio Ruiz Gomez]

If is the same error then you didn't install the extension or something went wrong about that.

[Mousumi Bhowmick]

  The order of execution within a folder like i2.1z/postgresql is alphabetical by file name or order by which sequence?