Generate Model Template

Environment

None

Attachments

2
  • 14 Jul 2023, 08:23 AM
  • 13 Jul 2023, 12:26 PM

Web links

Activity

Show:

Nicolas Micoud February 13, 2024 at 2:34 PM

If PR (https://github.com/idempiere/idempiere/pull/2244 ) is ok, I’ll update the documentation to reflect this change

Nicolas Micoud February 13, 2024 at 2:29 PM

Can be useful to execute the process for several tables

Nicolas Micoud July 17, 2023 at 4:34 AM

Hi
Sure, using the plugin is fine

Regards,

Nicolas

Carlos Ruiz July 14, 2023 at 9:12 AM

as thought the problem is in line 59:

INSERT INTO AD_Column (AD_Column_ID,Version,Name,AD_Table_ID,ColumnName,FieldLength,IsKey,IsParent,IsMandatory,IsTranslated,IsIdentifier,IsEncrypted,AD_Reference_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,AD_Element_ID,IsUpdateable,IsSelectionColumn,EntityType,IsAlwaysUpdateable,AD_Column_UU,IsToolbarButton) VALUES (215880,0.0,'AD_ModelGeneratorTemplate_UU',200387,'AD_ModelGeneratorTemplate_UU',36,'N','N','N','N','N','N',200231,0,0,'Y',TO_TIMESTAMP('2023-07-10 09:15:47','YYYY-MM-DD HH24:MI:SS'),10,TO_TIMESTAMP('2023-07-10 09:15:47','YYYY-MM-DD HH24:MI:SS'),10,203816,'Y','N','D','N','c6a5fbd5-9cb6-49dd-9e94-e1781f9a6662','N') ;

the thing is that sqlplus is running in a transaction (different than psql which auto-commits by default) and the “create table” issues an implicit commit and throws a commit error because the line 59 is wrong.

Now, I found this is reproducible also in postgresql because we are inserting a column with reference UUID in release-10 when that reference is from release-11

I’m finding very difficult to maintain release-10 because the release-11 has too many changes, so lately I’m limiting the scope mostly to just bug fixes.

My suggestion is to leave this functionality for release-11 - moving the scripts to iD11 folder

Is that OK? I think in the meantime you can keep using the plugin.

Carlos Ruiz July 14, 2023 at 8:30 AM

it’s a 12c instance - but is weird - if I execute the statement alone it works, so maybe is another statement which is failing?

Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created July 7, 2023 at 4:25 PM
Updated July 4, 2024 at 9:36 PM
Resolved May 16, 2024 at 6:55 PM