Company: Link Technologies
Case No: L08630. Project: 08.20: LinkSOFT Version 8.2
Logged By: Vineet (Link Business Solutions) on 26 Jun 2017 03:24PM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 6.00 (Weight: 6.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Vineet
Resolve By: Friday, 30 June 2017 12:00 AM [2489 days since logged date]
Status: Closed
Subject: Unable to Activate Sales Order with More than 2000 Lines
Summary:    

We have come across an issue where Jiwa is unable to process Sales Orders having more that 2000 Lines. Jiwa gives out of Memory Error when trying to activate these sales orders This matter was reported by LunaEva and upon enquiring with Jiwa, they have advised us to move some lines to a separate Sales Order. I have verified this on client database and confirm that the Sales are for one day only. This can be verified using the LunaEva Database setup on QA4 for the below Sales Orders.

DB Detail:

LINOSFT DB Name: CLIENT-LUNAEVA-LINKSOFT
JIWA DB Name: CLIENT-LUNAEVA-JIWA 

Sales Orders with Issue:

  • 0000019196
  • 0000019711
  • 0000020197
  • 0000023863
Jiwa's Response in relation to the above issue:

Email 1:

Beth Blok commented:

Vineet - even when I enabled a standard plugin to group the sales order journal in 7.00.175 I also get the out of memory issue.  I will be referring this onto the programming team to see if there is anything that can be done.  I'll update you when the team gets back to me.

Email 2:

Beth Blok commented:

Hi Vineet - the programming team had advised it is not possible to correct this in the current 32-bit application even in 7.00.175.  Only suggestion is to move some of the lines to another sales order and then process both. 

 
Audit Notes:
27 Jun 201710:15AM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-06-2017 10:15 AM

Add a configuration limit to POS JIWA integration on the number of lines per sales order. Default it to 1500.


27 Jun 201710:16AM Comment 2 by Alvis (Link Technologies) Case 8630 added to project 8.13
28 Jun 201709:13AM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 28-06-2017 09:13 AM Time Taken: 2.00
Development work for this case has been completed.
The change will be available in version: 8.13
Documentation update required(Yes/No. Add change details below): 
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Added a global configuration in POS for "JIWA Sales Order Line Limit". Default value is 1500
  2. Changed procedure LT_JIWA_ProcessTransaction to factor the limit above when creating the sales order.

Documentation details:
  

03 Jul 201701:58PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 03-07-2017 01:58 PM Time Taken: 1.00
System test completed, please proceed with UAT. 

05 Jul 201704:43PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 05-07-2017 04:43 PM Time Taken: 3.00
1. Was this test completed using Demo / New / Other database?  Demo with 813 Beta 1 in QA 1
2. Did the test pass or fail? Passed
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? N/A
4. Data verified, saved, edit, delete/void? N/A
5. Documentation update required? Yes
Additional Details (Risks, issues, special conditions required for this test to pass etc):

The following test was done.

  1. We setup an environment with Integration and Replication.
  2. "JIWA Sales Order Line Limit" config was set to 300. the Configuration should be set at the HQ.
  3. Processed a sales of 400 lines.
  4. The Sales Order lines was successfully created into Sales Order. Each sales order has a unique Sales Order No.
  5. There is no difference in the sales order reference or description.

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08630 in the subject line of all emails regarding this issue.

Document size: 6.5 KB
For call complaints, please contact the Managing Director of the company using this form.