Project

General

Profile

Tasks #11339

Update Euro live server

Added by Peer Thanesh over 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
High
Assignee:
Start date:
08/09/2023
Due date:
% Done:

90%

Estimated time:

Description

Noufal Bhai,
Please approve to update Euro live server with latest tag version

History

#1

Updated by Noufal K over 1 year ago

approved.

#2

Updated by Sharil Ali over 1 year ago

  • Assignee changed from System Admins Team to Peer Thanesh

Thanesh

When we can plan the update?can we plan tonight at 10.30pm IST?

Noufal

I assume it is latest 8.3 tag.

#3

Updated by Peer Thanesh over 1 year ago

  • Assignee changed from Peer Thanesh to System Admins Team

Please do it tonight. Update the mini servers also

#4

Updated by Sharil Ali over 1 year ago

  • Assignee changed from System Admins Team to Ajin P

Ajin

Please schedule central server update at 10.30pm tonight using jenkins.

Ashiq

Please verify the update using checklist.

#5

Updated by Ajin P over 1 year ago

Noted

#6

Updated by Peer Thanesh over 1 year ago

Please update the central server first, Later we can do the mini server

#7

Updated by Ajin P over 1 year ago

#8

Updated by Ajin P over 1 year ago

  • Status changed from New to In Progress
  • Assignee changed from Ajin P to Ashiq K

Files built in 8.3.7(27619-PT).

Sql list:-

1549_AD_Message.sql          1586_Alter_Voucher_Tables.sql       1591_API_PaymentStatus.sql
1585_Update_SMSTemplate.sql  1589_paymentHistory_preference.sql

Alter sqls:-

1586_Alter_Voucher_Tables.sql:ALTER TABLE C_Voucher_Redeem 
1586_Alter_Voucher_Tables.sql:ALTER TABLE C_Voucher
1586_Alter_Voucher_Tables.sql:VALUES (0, adempiere.nextid(53081,'N'), 0, now(), 100, 'Voucher related changes', 'Sahla', 'Y', '1586_Alter_Voucher_Tables.sql',
1586_Alter_Voucher_Tables.sql:'Posibolt', '360', 'R', now(), 100, 'N', '1586_Alter_Voucher_Tables.sql');
#9

Updated by Ashiq K over 1 year ago

  • Assignee changed from Ashiq K to System Admins Team

Euro central updated to version 8.3.7(27619-PT)

#10

Updated by Sharjuban P over 1 year ago

  • Assignee changed from System Admins Team to Peer Thanesh
#11

Updated by Peer Thanesh over 1 year ago

  • Assignee changed from Peer Thanesh to System Admins Team

Sharil Bhai
Kindly update the Euro mini server tonight

#12

Updated by Sharil Ali over 1 year ago

  • Assignee changed from System Admins Team to ajmal P

Ajmal

Please schedule update at 10.30pm IST using jenkins.

#13

Updated by ajmal P over 1 year ago

noted

#14

Updated by ajmal P over 1 year ago

  • Status changed from In Progress to Resolved
  • Assignee changed from ajmal P to System Admins Team

euromini updated to 8.3.7(27619-PT)

1549_AD_Message.sql          1586_Alter_Voucher_Tables.sql       1591_API_PaymentStatus.sql
1585_Update_SMSTemplate.sql  1589_paymentHistory_preference.sql

export setup error in central and mini

sql: INSERT INTO ad_replicationsequence(UniqueId, SequenceNo) VALUES ('euromini_posiboltdb_exporter_Heartbeat',0)
Exp_ServerProcesses table exists
sql: INSERT INTO exp_serverprocess (ad_client_id,ad_process_id,className) VALUES (1000000,103,'org.adempiere.server.rpl.imp.PriceListProcess')
sql: INSERT INTO exp_serverprocess (ad_client_id,ad_process_id,className) VALUES (1000000,500,'org.adempiere.server.rpl.imp.StockClearImportProcess')
sql: INSERT INTO exp_serverprocess (ad_client_id,ad_process_id,className) VALUES (1000000,501,'org.adempiere.server.rpl.imp.StockTransferImportProcess')
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

#15

Updated by Sharil Ali over 1 year ago

  • Assignee changed from System Admins Team to Peer Thanesh
#16

Updated by Peer Thanesh over 1 year ago

  • Status changed from Resolved to Closed
#17

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