Project

General

Profile

Tasks #12148

Live Server Update

Added by Rijas P over 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
Immediate
Assignee:
Ijas Ahammed
Start date:
10/28/2023
Due date:
% Done:

100%

Estimated time:

Description

Dear Ijaz,

Please update the live server with the latest work updated in our test server.

History

#1

Updated by Ijas Ahammed about 1 year ago

  • Assignee changed from Ijas Ahammed to Noufal K

Please update the live server with the latest 8.3 Tag version.

Noufal K  Please advise.

#2

Updated by Ijas Ahammed about 1 year ago

  • Assignee changed from Noufal K to Ijas Ahammed
#3

Updated by Rijas P about 1 year ago

  • Priority changed from Urgent to Immediate

Dear Ijaz,

Please plan to update the test server with Product admin fix.

#4

Updated by Rijas P about 1 year ago

Dear Ijas,

We have tested the latest work in test server. Please plan the update our live server tomorrow Between 02.30 to 04:30 IST

#5

Updated by Ijas Ahammed about 1 year ago

  • Assignee changed from Ijas Ahammed to Sharil Ali

Dear Sharilka, Please update on Monday before 9:30 AM IST.

#6

Updated by Sharil Ali about 1 year ago

  • Assignee changed from Sharil Ali to jidhin kp

Jidhin

Please schedule it at 7am IST on Monday using jenkins.

Sharju

Please verify the update using checklist.

#7

Updated by jidhin kp about 1 year ago

  • Status changed from New to In Progress
  • Assignee changed from jidhin kp to Sharjuban P

Scheduled at 7 AM IST Tomorrow
Ical.jar copied to home dir:

#8

Updated by jidhin kp about 1 year ago

  • Assignee changed from Sharjuban P to jidhin kp
#9

Updated by jidhin kp about 1 year ago 

Sql List: 
1596_StockRequisition_API_License.sql 
 1600_Alter_App_Sales_Common_Settings.sql  
 1601_Alter_RouteTrip_GPSData.sql 
 1602_API_IsSalesRep_LicenseControl.sql

Alter SQL List :

1600_Alter_App_Sales_Common_Settings.sql:ALTER TABLE U_APP_SALES_SETTINGS
1600_Alter_App_Sales_Common_Settings.sql:ALTER TABLE U_APP_COMMON_SETTINGS
1600_Alter_App_Sales_Common_Settings.sql:ALTER TABLE U_APP_COMMON_SETTINGS
1600_Alter_App_Sales_Common_Settings.sql:ALTER TABLE U_APP_COMMON_SETTINGS
1600_Alter_App_Sales_Common_Settings.sql:VALUES (0, adempiere.nextid(53081,'N'), 0, now(), 100,'Run script upto 1599..', 'Sahla', 'Y', '1600_Alter_App_Sales_Common_Settings.sql',
1600_Alter_App_Sales_Common_Settings.sql:'Posibolt', '360', 'R', now(), 100, 'N', '1600_Alter_App_Sales_Common_Settings.sql');
1601_Alter_RouteTrip_GPSData.sql:ALTER TABLE C_Routetrip
1601_Alter_RouteTrip_GPSData.sql:ALTER TABLE C_Routetrip ADD COLUMN salesrep_id numeric(10,0);
1601_Alter_RouteTrip_GPSData.sql:ALTER TABLE C_Routetrip
1601_Alter_RouteTrip_GPSData.sql:VALUES (0, adempiere.nextid(53081,'N'), 0, now(), 100,'Run script upto 1600..', 'Sahla', 'Y', '1601_Alter_RouteTrip_GPSData.sql',
1601_Alter_RouteTrip_GPSData.sql:'Posibolt', '360', 'R', now(), 100, 'N', '1601_Alter_RouteTrip_GPSData.sql');
#10

Updated by jidhin kp about 1 year ago

#11

Updated by jidhin kp about 1 year ago

#12

Updated by jidhin kp about 1 year ago

#13

Updated by jidhin kp about 1 year ago

#14

Updated by jidhin kp about 1 year ago

#15

Updated by jidhin kp about 1 year ago

  • Status changed from In Progress to Resolved
  • Assignee changed from jidhin kp to System Admins Team
#16

Updated by jidhin kp about 1 year ago

Euro Live Updated to 8.3.15(28150-PT)

#17

Updated by Ijas Ahammed about 1 year ago

  • Status changed from Resolved to Re-opened

Please update this evening with the latest 8.4 tag version. 

Break Time: Between 03:30 to 04.00 IST

#18

Updated by Sharil Ali about 1 year ago

  • Assignee changed from System Admins Team to Jabir Hussain

Jabir

Please copy the files and scripts as we discussed and update as suggested bu Ijaz.

#19

Updated by Jabir Hussain about 1 year ago

noted

#20

Updated by Jabir Hussain about 1 year ago

Euro live updated to 8.4.2(28097-PT).


sql list:-

1549_AD_Message.sql
1578_COLUMN_IN_DISCOUNT_SCHEMA_BREAK.sql
1583_Create_M_DiscountSchema_Condition_table.sql
1584_CreateColumn_in_C_OrderLine.sql
1587_Create_DS_Break_Column_in_C_OrderLine.sql
1588_Convert_DiscountSchemas_From_BPGroups.sql
1595_Sku_Re-orderReport.sql
1597_UPDATE_ADCOLUMN_DISCOUNTSCHEMABREAK.sql
1598_Stock_Transfer_preference.sql
1599_Alter_BarcodeMap.sql

alter sql :-

1578_COLUMN_IN_DISCOUNT_SCHEMA_BREAK.sql:ALTER TABLE m_discountschemabreak ADD COLUMN Group1 VARCHAR (255) , ADD COLUMN Group2 VARCHAR (255) ; 
1584_CreateColumn_in_C_OrderLine.sql:ALTER TABLE adempiere.C_OrderLine
1587_Create_DS_Break_Column_in_C_OrderLine.sql:ALTER TABLE adempiere.C_OrderLine
1599_Alter_BarcodeMap.sql:VALUES (0, adempiere.nextid(53081,'N'), 0, now(), 100,'Run script up to 1599..', 'Safwan', 'Y', '1599_Alter_BarcodeMap.sql',
1599_Alter_BarcodeMap.sql:'Posibolt Performance', '7.7', 'R', now(), 100, 'N', '1599_Alter_BarcodeMap.sql');
#21

Updated by Jabir Hussain about 1 year ago

Used option 9 for both mini and backup

sqls run in central and backup

Updated Adempiere.jar and adempiereRoot.jar and ical.jar in the backup importer folder

#22

Updated by Jabir Hussain about 1 year ago

  • Assignee changed from Jabir Hussain to System Admins Team
#23

Updated by Sharil Ali about 1 year ago

  • Assignee changed from System Admins Team to Ijas Ahammed
#24

Updated by Ijas Ahammed about 1 year ago

  • Status changed from Re-opened to Resolved
  • Assignee changed from Ijas Ahammed to Rijas P
#25

Updated by Rijas P about 1 year ago

  • Status changed from Resolved to Closed
#26

Updated by Noufal K about 1 year ago

  • Status changed from Closed to In Progress
Please run below sql in euro mini server and restart it(after shop hours).

ALTER TABLE m_discountschemabreak ADD COLUMN Group1 VARCHAR (255) , ADD COLUMN Group2 VARCHAR (255) ;
ALTER TABLE C_Orderline ADD COLUMN isFreeItem character(1) DEFAULT 'N'::bpchar;
ALTER TABLE C_OrderLine ADD COLUMN M_DiscountSchema_ID numeric(10,0), ADD CONSTRAINT fk_M_DiscountSchema_ID   FOREIGN KEY (M_DiscountSchema_ID)   REFERENCES adempiere.M_DiscountSchema (M_DiscountSchema_ID);
#27

Updated by Sharjuban P about 1 year ago

  • Assignee changed from Rijas P to System Admins Team

Ran sql in miniserver

Restart pending

#28

Updated by Sharil Ali about 1 year ago

  • Assignee changed from System Admins Team to Ajin P

Ajin

Please check with UAE team and plan the restart tonight if it is on or before 11pm IST.

#29

Updated by Ajin P about 1 year ago

Noted

#30

Updated by Ajin P about 1 year ago

mini server restarted.

#31

Updated by Ajin P about 1 year ago

  • Assignee changed from Ajin P to System Admins Team
#32

Updated by Sharjuban P about 1 year ago

  • Assignee changed from System Admins Team to Ajin P

Ajin

Please plan to restart euro miniserver tonight after shop hours

#33

Updated by Noufal K about 1 year ago

  • Assignee changed from Ajin P to System Admins Team

Please plan and update mini server and run export setup in both central and mini.

#34

Updated by Sharil Ali about 1 year ago

  • Assignee changed from System Admins Team to Jabir Hussain

Jabir

Please copy the files and scripts to mini server

Ajin

Please update the mini server after 10.30 pm IST tonight.

#35

Updated by Jabir Hussain about 1 year ago

noted

#36

Updated by Jabir Hussain about 1 year ago

  • Assignee changed from Jabir Hussain to System Admins Team

copied the files and scripts to mini server as zip, named 29Nov23.zip

#37

Updated by Ajin P about 1 year ago

  • Assignee changed from System Admins Team to Ajin P

noted

#38

Updated by Ajin P about 1 year ago

  • Assignee changed from Ajin P to System Admins Team

They are still busy with their sales, cant update server today.

#39

Updated by Sharil Ali about 1 year ago

  • Assignee changed from System Admins Team to Ajin P

Ajin

Please try tonight.

Sharju

Please update tomorrow morning before 10am if Ajin cant update tonight

#40

Updated by Ajin P about 1 year ago

Noted

#41

Updated by Ajin P about 1 year ago

Euro mini updated to 8.4.2(28097-PT).

sql list:-

1549_AD_Message.sql                               1593_alter_barcodeMap.sql
1578_COLUMN_IN_DISCOUNT_SCHEMA_BREAK.sql          1595_Sku_Re-orderReport.sql
1583_Create_M_DiscountSchema_Condition_table.sql  1596_StockRequisition_API_License.sql
1584_CreateColumn_in_C_OrderLine.sql              1597_UPDATE_ADCOLUMN_DISCOUNTSCHEMABREAK.sql
1587_Create_DS_Break_Column_in_C_OrderLine.sql    1598_Stock_Transfer_preference.sql
1588_Convert_DiscountSchemas_From_BPGroups.sql    1599_Alter_BarcodeMap.sql
1590_OutstandingCustomer_Process.sql              
1591_API_PaymentStatus.sql                        
1592_API_GetAllDraftedStocktransfer.sql

#42

Updated by Ajin P about 1 year ago

  • Assignee changed from Ajin P to System Admins Team

Pending work:-
Need to run Import and Export setup in Central server as current next =0.

#43

Updated by Amal P about 1 year ago

ran export import setup as current next = 0.

error when ran exportsetup,

TrxReplicationStatus table exists
Creation of Tabel AD_ReplicationSequence
org.postgresql.util.PSQLException: ERROR: column "ad_client_id" of relation "trxreplicationstatus" already exists
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:283)
at org.icalibrator.replication.exp.ReplicationExportSetup.createReplicationTables(ReplicationExportSetup.java:363)
at org.icalibrator.replication.exp.ReplicationExportSetup.main(ReplicationExportSetup.java:289)
Updated CLIENT_ACCOUNTING :0
Made processor: C_AcctProcessor isactive ='N'3

#44

Updated by Amal P about 1 year ago

updation completed.

#45

Updated by Sharjuban P about 1 year ago

  • Assignee changed from System Admins Team to Ijas Ahammed
#46

Updated by Ijas Ahammed about 1 year ago

  • Status changed from In Progress to Closed
#47

Updated by SHAIJAL EDAVANA 8 months ago

  • Tracker changed from Bug to Tasks
  • Project changed from Euro Novelties to Temp Projects
  • Category deleted (Others)

Also available in: Atom PDF