Project

General

Profile

Tasks #8741

Mini server - Sales regions not displaying in Sales History

Added by Rijas P about 2 years ago. Updated 8 months ago.

Status:
Closed
Priority:
High
Assignee:
Rijas P
Start date:
12/23/2022
Due date:
% Done:

100%

Estimated time:
Spent time:
0.50 h

Description

Dear Muzammil,

In mini server, Sales regions not listing in Sales history/Sales report.

Files

WhatsApp Image 2022-12-13 at 7.14.30 PM.jpeg (182 KB) WhatsApp Image 2022-12-13 at 7.14.30 PM.jpeg Rijas P, 12/23/2022 01:16 PM

History

#1

Updated by Rijas P about 2 years ago

Dear Muzammil,

Reminder.

#2

Updated by MUZAMMIL S almost 2 years ago

  • Assignee changed from MUZAMMIL S to Rijas P

please share anydesk access of mini server.

#3

Updated by MUZAMMIL S almost 2 years ago

admin@EUROCENTRAL:~/ExportSetup> psql -U adempiere -d posiboltdb -h 10.11.0.6
psql.bin (9.5.12, server 9.5.15)
Type "help" for help.

posiboltdb=# select count(*) from c_salesregion where ad_client_id=1000000;
count
-------
95
(1 row)

posiboltdb=# \q
admin@EUROCENTRAL:~/ExportSetup> psql -U adempiere -d euro
psql.bin (9.5.12)
Type "help" for help.

euro=# select count(*) from c_salesregion where ad_client_id=1000000;
count
-------
95
(1 row)

#4

Updated by MUZAMMIL S almost 2 years ago

  • Assignee changed from Rijas P to Mohamed Suhail

sales region count is same in both central and mini server.

#5

Updated by Mohamed Suhail almost 2 years ago

  • Status changed from New to Resolved
  • Assignee changed from Mohamed Suhail to MUZAMMIL S
  • % Done changed from 0 to 100

MUZAMMIL S wrote:

sales region count is same in both central and mini server.

euro=# select ad_tree_id from ad_tree where treetype ='SR' and ad_client_id=1000000;
ad_tree_id
------------
1000013
(1 row)

euro=# select count(*) from ad_treenode where ad_tree_id=1000013;
count
-------
96
(1 row)

posiboltdb=# select count(*) from ad_treenode where ad_tree_id=1000013;
count
-------
2
(1 row)

Ad_TreeNode table was not synced between central and mini servers

Synced now

MUZAMMIL S, please check

#6

Updated by MUZAMMIL S almost 2 years ago

  • Assignee changed from MUZAMMIL S to Rijas P

Mohamed Suhail wrote:

MUZAMMIL S wrote:

sales region count is same in both central and mini server.

euro=# select ad_tree_id from ad_tree where treetype ='SR' and ad_client_id=1000000;
ad_tree_id
------------
1000013
(1 row)

euro=# select count(*) from ad_treenode where ad_tree_id=1000013;
count
-------
96
(1 row)

posiboltdb=# select count(*) from ad_treenode where ad_tree_id=1000013;
count
-------
2
(1 row)

Ad_TreeNode table was not synced between central and mini servers

Synced now

MUZAMMIL S, please check

Verified in mini server.

Rijas,
Please check.

#7

Updated by Rijas P almost 2 years ago

  • Status changed from Resolved to Closed

Found fixed..

#8

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