topic update 3.2 to 4.0 tab alf_node col order in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/update-3-2-to-4-0-tab-alf-node-col-order/m-p/31562#M16320 <HTML><HEAD></HEAD><BODY><P>Hallo,</P><P></P><P>i am running 3.2 CE and would upgrade to next step (4.0.d).</P><P>But after restart tab alf_node has wrong order on columns.</P><P></P><P>Details:</P><P>To debug i run following script:</P><P>----</P><P>while [ 1 -eq 1 ]; do<BR />date;echo \\\d alf_node| $psql $opt | grep -n _id<BR />sleep 120;<BR />done</P><P>---</P><P></P><P>1. After create table alf_node col locale_id not exist:</P><P>---</P><P>Mon Sep 26 19:13:07 UTC 2016<BR />3: store_id | bigint | not null<BR />5: transaction_id | bigint | not null<BR />7: type_qname_id | bigint | not null<BR />8: acl_id | bigint |</P><P>---</P><P></P><P>2. After first start alfresco running schema-update. Result:</P><P>--</P><P>Mon Sep 26 20:25:09 UTC 2016<BR />3: store_id | bigint | not null<BR />5: transaction_id | bigint | not null<BR />7: type_qname_id | bigint | not null<BR />8: acl_id | bigint | <BR />14: locale_id | bigint | not null default 1</P><P>---</P><P>But this is wrong.</P><P>According to org.hibernate.dialect.PostgreSQLDialect/AlfrescoCreate-RepoTables.sql</P><P>should be:&nbsp; col8=locale_id</P><P>----</P><P># more AlfrescoCreate-RepoTables.sql</P><P>...</P><P>CREATE TABLE alf_node<BR />(<BR /> id INT8 NOT NULL,<BR /> version INT8 NOT NULL,<BR /> store_id INT8 NOT NULL,<BR /> uuid VARCHAR(36) NOT NULL,<BR /> transaction_id INT8 NOT NULL,<BR /> node_deleted BOOL NOT NULL,<BR /> type_qname_id INT8 NOT NULL,<BR /> locale_id INT8 NOT NULL,<BR /> acl_id INT8,<BR /> audit_creator VARCHAR(255),<BR /> audit_created VARCHAR(30),<BR /> audit_modifier VARCHAR(255),<BR /> audit_modified VARCHAR(30),<BR /> audit_accessed VARCHAR(30),<BR /> PRIMARY KEY (id),</P><P>---</P><P></P><P>3. so i received following error:</P><P></P><P></P><P>---</P><P>2016-09-26 17:55:58,056 WARN [domain.schema.SchemaBootstrap] [main] Schema validation found 15 potential problems, results written to: /opt/alfresco-4.0.d/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Pre-Upgrade-5348831433842333714.txt</P><P></P><P># more /opt/alfresco-4.0.d/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Pre-Upgrade-5348831433842333714.txt | head -5<BR />Difference: expected column .alf_node.locale_id.order="8", but was .alf_node.locale_id.order="14"<BR />Difference: expected column .alf_node.acl_id.order="9", but was .alf_node.acl_id.order="8"<BR />Difference: expected column .alf_node.audit_creator.order="10", but was .alf_node.audit_creator.order="9"<BR />Difference: expected column .alf_node.audit_created.order="11", but was .alf_node.audit_created.order="10"<BR />Difference: expected column .alf_node.audit_modifier.order="12", but was .alf_node.audit_modifier.order="11"</P><P>---</P><P></P><P>Whats going wrong?</P><P>Howto fix this?</P><P></P><P></P><P>regards Harry</P><P></P><P>(der mit dem neuen Portal so seine Probleme hat...)</P><P></P><P></P><P>[1] <A href="https://migration33.stage.lithium.com/docs/DOC-6102">Alfresco Community 4.0.d Release Notes</A>&nbsp;</P><P>&nbsp;&nbsp; Table 'alf_node': Locale in which node was last edited is recorded. 'locale_id' column added and foreign key referencing 'alf_locale.id'.</P></BODY></HTML> Mon, 26 Sep 2016 20:52:26 GMT halehm 2016-09-26T20:52:26Z update 3.2 to 4.0 tab alf_node col order https://connect.hyland.com/t5/alfresco-archive/update-3-2-to-4-0-tab-alf-node-col-order/m-p/31562#M16320 Hallo,i am running 3.2 CE and would upgrade to next step (4.0.d).But after restart tab alf_node has wrong order on columns.Details:To debug i run following script:----while [ 1 -eq 1 ]; dodate;echo \\\d alf_node| $psql $opt | grep -n _idsleep 120;done---1. After create table alf_node col locale_id n Mon, 26 Sep 2016 20:52:26 GMT https://connect.hyland.com/t5/alfresco-archive/update-3-2-to-4-0-tab-alf-node-col-order/m-p/31562#M16320 halehm 2016-09-26T20:52:26Z Re: update 3.2 to 4.0 tab alf_node col order https://connect.hyland.com/t5/alfresco-archive/update-3-2-to-4-0-tab-alf-node-col-order/m-p/31563#M16321 <HTML><HEAD></HEAD><BODY><P>Hi Harry,</P><P></P><P>some guys came accross a similar problem at the following topic:</P><P><A href="https://migration33.stage.lithium.com/thread/175408">Upgradation from 3.4d to 4.0d</A>&nbsp;</P><P>I hope the solution in one of the posts (from "buster") is going to help you as well.</P><P></P><P>Regards,</P><P>Levin</P></BODY></HTML> Tue, 27 Sep 2016 07:38:32 GMT https://connect.hyland.com/t5/alfresco-archive/update-3-2-to-4-0-tab-alf-node-col-order/m-p/31563#M16321 lulrich 2016-09-27T07:38:32Z