Open issues

Importing products hangs on many products
IDEMPIERE-4119
Partial payments or installment payment not working in payment selection
IDEMPIERE-3960
audit log isn't apply for "Charge Account" field
IDEMPIERE-3941
Add ExternalDocumentNo to documents that represent external created documents
IDEMPIERE-3764
Incorrect stop of the schedulers
IDEMPIERE-3676
Costing Records are calculated in some cases from facts instead costdetail/Average PO
IDEMPIERE-3376
Posting doesn't create costing records for lines, when 1 product has error
IDEMPIERE-3359
Wrong Sorting on Date+Time field
IDEMPIERE-3288
Dunning doesn't handle Dunning Date when Generates Statement to backward date.
IDEMPIERE-3028
SECURITY >> Directory: /ADInterface/ listing
IDEMPIERE-3019
RMA: Create Lines from doenst list Voided RMA shipment lines
IDEMPIERE-2948
Merge Entities - keep history
IDEMPIERE-2884
csv export:when child tab in window don't link by key column, let csv export wrong data
IDEMPIERE-2785
call save data from grid tab bypass logic in X_Class.setMethod()
IDEMPIERE-2393
Importing a Data 2Pack can create cross-tenant references
IDEMPIERE-2179
Wrong organization in m_transaction, organization doesnt fit locator
IDEMPIERE-2094
Lookup Record filter result doesnt updated after document action
IDEMPIERE-1841
Autocomplete for field type "Search"
IDEMPIERE-1540
Landed cost inverted if cash based accounting is used
IDEMPIERE-1393
Not invoiced receipts amount not converted to accounting currency causes faulty accounting in Match Invoice.
IDEMPIERE-1289
Modify Access Modifiers of MPayment properties and Methods
IDEMPIERE-4126
Accounting Fact Reconcilation form : add a Select/DeselectAll and ZoomToDocument buttons
IDEMPIERE-4125
missing font icons
IDEMPIERE-4122
As user i would like simple copy column/value on any regular field (show icon on-hover)
IDEMPIERE-4117
Mark server node on start event isProcessing Set to 'N'
IDEMPIERE-4104
[Chosenbox] Multi select don't work in Firefox
IDEMPIERE-4101
kiosk mode screens
IDEMPIERE-4094
combobox auto filter
IDEMPIERE-4093
product as a charge
IDEMPIERE-4092
start background processes on a dedicated service server
IDEMPIERE-4090
virtual columns do not work in csv export
IDEMPIERE-4089
share tab customizations
IDEMPIERE-4088
avoid product dependency on price list
IDEMPIERE-4086
search in the toolbar
IDEMPIERE-4085
Supporting Back ground color expression in print format
IDEMPIERE-4081
should drop constraint when change colulmn (rename, delete, change reference type)
IDEMPIERE-4079
In financial report when calculation is Add Range and operand 1 and operand 2 are same, calculations are wrong
IDEMPIERE-4076
New document has nulls Error in Asset Addition in Idempiere 6.2
IDEMPIERE-4074
In Report source, adding support for User1 and User2
IDEMPIERE-4069
Adding configurable report header
IDEMPIERE-4068
Drawing Under/Over line in report (For highlighting total or showing separator)
IDEMPIERE-4067
Add "Relative Period To" field on Financial report column set to specify range relatively
IDEMPIERE-4066
Making report configurable to reverse value
IDEMPIERE-4065
Adaxa's Finacial Report improvements
IDEMPIERE-4064
legend for fields with css style
IDEMPIERE-4062
print format editor
IDEMPIERE-4059
tab editor: new options for editing and customizing fields (window customization)
IDEMPIERE-4058
dashboard content: config column width proportion and parse context variables on html field
IDEMPIERE-4057
Quick Entry strange behavior
IDEMPIERE-4055
Make Requisition Line Model Order Line - Add UOM, QTY Ordered, Reference, Charge Fields
IDEMPIERE-4042
issue 1 of 807

Importing products hangs on many products

Description

Trying to import about 70,000 products hangs because of an inefficient sql statements in ImportProduct.java.

Original statement
UPDATE I_Product i
SET I_IsImported='E', I_ErrorMsg=I_ErrorMsg||'ERR=UPC not unique,'
WHERE I_IsImported<>'Y'
AND UPC IN (SELECT UPC FROM I_Product ii WHERE i.AD_Client_ID=ii.AD_Client_ID GROUP BY UPC HAVING COUNT > 1)
this statement uses hours and then terminates with error.
Running in less than a second is

UPDATE I_Product i
SET I_IsImported='E', I_ErrorMsg=I_ErrorMsg||'ERR=UPC not unique,'
WHERE I_IsImported<>'Y'
AND exists (SELECT 1 FROM I_Product ii WHERE i.AD_Client_ID=ii.AD_Client_ID and i.i_product_id <> ii.i_product_id and i.upc = ii.upc)

The same is true for the statement checking for duplicate values in 'value' which runs better as
UPDATE I_Product i
SET I_IsImported='E', I_ErrorMsg=I_ErrorMsg||'ERR=Value not unique,'
WHERE I_IsImported<>'Y'
AND exists (SELECT 1 FROM I_Product ii WHERE i.AD_Client_ID=ii.AD_Client_ID and i.i_product_id <> ii.i_product_id and i.value = ii.value)

Environment

None

Status

Assignee

Unassigned

Reporter

Martin Schönbeck

Labels

None

Tested By

None

Components

Affects versions

Priority

Critical
Configure