Replies posted by PetriLahtinen

7 Replies

P
Do Gooder
Prateek903Do Gooder
asked in Products (Manufacturing, Products, Engineering)

Error: An existing connection was forcibly closed by the remote host

Hi,Customer’s production environment has Load balancer.TCP Idle Timeout value in load balancer was increased  (from the original 300 s = 5min to 1800 s = 30 min) Originally there was 10 min active communication time + 5 min idle time. Now it is 10+30 min, Which is long enough for generating heavy PDF reports. 

5
P
Sidekick (Employee)
9 months ago
P
Sidekick (Employee)
PetriLahtinenSidekick (Employee)
asked in Finance (Financials)

Solution for taking heavy GL voucher data out for auditors

Interesting option. GDPdU is a German audit file standard. I tested with GEN_LED_VOUCHER_ROW_AV It seems to possible to run the process in App9. The data seems to include all the columns. The order of the columns changes quite much from the source view. Activation of background job is unclear, but I just check App9. I thought that there is a visible External File template, but no.

8
Ralph Gericke
Hero (Employee)
1 year ago
P
Sidekick (Employee)
PetriLahtinenSidekick (Employee)
asked in Finance (Financials)

Solution for taking heavy GL voucher data out for auditors

Hi, PL/SQL developer or some other similar tool is ok. It can be faster or similar. It depends on the user and data. I didn’t find a real difference between PL/SQL developer and Quick report when I tested the query by App owner account. If you can use database tables as a data sources, it could speed up the query.

8
Ralph Gericke
Hero (Employee)
1 year ago
P
Sidekick (Employee)
PetriLahtinenSidekick (Employee)
asked in Finance (Financials)

Solution for taking heavy GL voucher data out for auditors

Hi, Quick report was the final solution.  One report for the voucher data and another for the voucher row data.The auditor was flexible. The amount of columns were reduced quite much. There were also lots of voucher rows with statistical accounts. They were excluded from the data.  Then the  speed of the export was bit better.  Auditor requested some basic data, like list of accounts with description in IFS.Quick reports were run manually and saved as csv. Quick reports had enough parameters to run them  with different conditions depending on the amount of rows per company  and / or per accounting period. External file option was tested, but it was not used. 

8
Ralph Gericke
Hero (Employee)
1 year ago
P
Do Gooder
Prateek903Do Gooder
asked in Products (Manufacturing, Products, Engineering)

Error: An existing connection was forcibly closed by the remote host

This is still unclear case. But I have got some hints it could be related with Load balancer , and it’s parameters.

5
P
Sidekick (Employee)
9 months ago
P
Do Gooder
Prateek903Do Gooder
asked in Products (Manufacturing, Products, Engineering)

Error: An existing connection was forcibly closed by the remote host

Hi,  My customer has the same error in App9.   Did you find a solution for this by increasing a parameter value somewhere? The reason is  a huge size of GL transactions in multi-company environment, I think.  Customer is asked to start archive old GL transactions by the standard functionality.  If there is a solution with more optimal  parameter setup, it would be good to take into use.   

5
P
Sidekick (Employee)
9 months ago
P
Sidekick (Employee)
PetriLahtinenSidekick (Employee)
asked in Finance (Financials)

How to setup more than on Period allocation voucher per company

Thank you  for you reply. Just like I was thinking about the options.  In my case supplier invoice process is fully automated without Supplier invoice workflow. Supplier invoices come as e-invoices to External Supplier Invoices. Approval user must be in user groups for AP. 

2
P
Sidekick (Employee)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings