QueryMoreThanOneRecordsFound on iDempiere

When I want save a journal line record, iDempiere don't let me save it, then it send me the next error message:

09:48:28.492-----------> MJournalLine.save: beforeSave - X_GL_JournalLine[0] [5641]
org.adempiere.exceptions.DBException: QueryMoreThanOneRecordsFound
    at org.compiere.model.Query.firstOnly(Query.java:349)
    at org.compiere.model.MAccount.get(MAccount.java:220)
    at org.compiere.model.MJournalLine.getOrCreateCombination(MJournalLine.java:441)
    at org.compiere.model.MJournalLine.beforeSave(MJournalLine.java:297)
    at org.compiere.model.PO.save(PO.java:2066)
    at org.compiere.model.GridTable.dataSavePO(GridTable.java:2223)
    at org.compiere.model.GridTable.dataSave(GridTable.java:1549)
    at org.compiere.model.GridTab.dataSave(GridTab.java:1007)
    at org.adempiere.webui.adwindow.ADTabpanel.dataSave(ADTabpanel.java:1614)
    at org.adempiere.webui.adwindow.CompositeADTabbox.dataSave(CompositeADTabbox.java:863)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.onSave0(AbstractADWindowContent.java:2185)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.onSaveCallback(AbstractADWindowContent.java:2178)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.access$19(AbstractADWindowContent.java:2147)
    at org.adempiere.webui.adwindow.AbstractADWindowContent$29.onCallback(AbstractADWindowContent.java:2121)
    at org.adempiere.webui.adwindow.AbstractADWindowContent$29.onCallback(AbstractADWindowContent.java:1)
    at org.adempiere.webui.adwindow.validator.WindowValidatorManager$ChainCallback.start(WindowValidatorManager.java:124)
    at org.adempiere.webui.adwindow.validator.WindowValidatorManager.fireWindowValidatorEvent(WindowValidatorManager.java:103)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.onSave(AbstractADWindowContent.java:2129)
    at org.adempiere.webui.adwindow.AbstractADWindowContent.onSave(AbstractADWindowContent.java:2079)
    at sun.reflect.GeneratedMethodAccessor1135.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

This error is because there are too many repeated accounting combinations. The solution is to inactivate all these repeated combinations. For example:

update c_validcombination
    set isactive = 'N'
where c_validcombination.account_id = 1001469;