Generate Model Template
Activity
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 @Carlos Ruiz
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?
https://groups.google.com/g/idempiere
https://groups.google.com/g/idempiere/c/_GEmq1A3GLo