Skip to main content
To homepage To homepage
Solved

Error when filtering columns BC Online

  • October 17, 2024
  • 7 replies
  • 52 views
D
Contributor
Forum|alt.badge.img

Using the TimeXtender Dynamics 365 Business Central - Online connector, I'm having trouble filtering columns in the ODX. With all columns selected everything is fine, but once I make a selection in columns I get the error below when running the Transfer Task. Any ideas on why this is happening and how to fix it? (TX Version 6XXX)

 

Executing table customer:
failed with error:
Exception Type: System.InvalidOperationException
Message: Sequence contains no matching element
             Stack Trace: at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)
                          at TimeXtender.ODX.Account.BC365CustomDataSource.ExecutionHelper.GetIncrementalLoadPartitionSetups(AccountBC365CustomDataSource accountBC365CustomDataSource, TableModel tableModel)
                          at TimeXtender.ODX.Account.BC365CustomDataSource.AccountBC365CustomDataSource.GetIncrementalLoadSetups(TableModel tableModel)
                          at DataSourceEngine.Custom.CustomSourceEngine.GetIncrementalLoadSetups(TableModel tableModel)
                          at DataStorageEngine.DataLakeGen2.DataLakeGen2StorageEngine.<>c__DisplayClass33_2.<TransferDataAsync>b__5(Action`2 waitUntil)

Best answer by Thomas Lind

Hi @dennishanssen 

Sorry I was wrong, I thought it said the company table. You should be able to use the Customer table.

Anyway, with that selection you are removing the most important field, DW_Account.

This field along with No. is what usually will be the Primary Keys of the table.

 

View original
    Did this topic help you find an answer to your question?

    7 replies

    Thomas Lind
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • 1070 replies
    • October 17, 2024

    Hi @dennishanssen 

    What sort of table was it and what was the field you removed? These tables are general so we can maybe replicate the behavior.

    D
    Contributor
    Forum|alt.badge.img
    • dennishanssen
    • Author
    • Contributor
    • 5 replies
    • October 17, 2024

    @Thomas Lind I tried the Customer table, selecting fields No, Name and Country.

    Thomas Lind
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • 1070 replies
    • October 17, 2024

    Hi @dennishanssen 

    Don’t use that one. It seems to never work. Use General Ledger Entry instead.

    That is what Insight Software (formerly known as Jet) uses for all their template projects.

    D
    Contributor
    Forum|alt.badge.img
    • dennishanssen
    • Author
    • Contributor
    • 5 replies
    • October 17, 2024

    @Thomas Lind Thank you. That's a little odd, as loading the full table seems to work. I can't check now but does this include al Customer info similar to the Customer table?

    Thomas Lind
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • 1070 replies
    • Answer
    • October 17, 2024

    Hi @dennishanssen 

    Sorry I was wrong, I thought it said the company table. You should be able to use the Customer table.

    Anyway, with that selection you are removing the most important field, DW_Account.

    This field along with No. is what usually will be the Primary Keys of the table.

     

    Christian Hauggaard
    Community Manager
    Forum|alt.badge.img+5

    @dennishanssen can you please try to include the fields that Thomas mentions above? does this resolve the error?

    D
    Contributor
    Forum|alt.badge.img
    • dennishanssen
    • Author
    • Contributor
    • 5 replies
    • October 23, 2024

    @Christian Hauggaard @Thomas Lind adding DW_Account to the selection resolved the issue, thank you.

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings