Al: Multi-part identifier *** could not be found / WebClient-Search

[BartBourgeois]

Hi All,

With the 2019-Spring release an error is thrown when using the "Search" in the webclient.

Very similar to issue #4069 except this one triggers only on the "Search" function.

Specs:

• Docker Image = microsoft/bcsandbox:be
• platform 14.0.29530.31296
• Application 31430 (BE Dynamics NAV 14.0)
  => Same for the W1 Application

Conditions:

• Using the "Multi-Field" Search on a page
• Using a search term that yields no search results (does work it their is any result)
• Table behind page is extended
• Fields from the extension(s) must be visible on the page

Debug Info:

• Application Event Log
• SQL Server Trace
  MultiPartSearchIssue.zip

When no search results are found, BC triggered an extra query "SELECT TOP 1 NULL FROM ....".
This query seems to be missing the JOIN statements to include the extension tables.

Thanks in advance.

[waldo1001]

This is a pressing issue - which doesn't seem to get any traction?

[atoader]

Hi @waldo1001 ! We apologize for the delay in responding. We are working hard on fixing bugs, building new features, and optimizing existing ones. I will forward this to the client team, but for the future, and especially for urgent issues that are not related to the development experience, please report bugs through collaborate or through customer support. This GitHub is only serviced by one team and it focuses on issues related to the development experience.

[StijnBt]

We are experiencing this problem as well. Please advise.

[ASDEV2019]

We just experienced this issue on BC14 Spring Release on Item list where we extended item table, and this error shows during the search function.

[kine]

Same for me, same error, on docker, on production in online...

[KennieNP]

We have a fix and expect to HF prod clusters today or tomorrow

[stefanoPrimo]

Same here!
any updates?

[alessandrovecchio]

Same here too!
any updates?

[KennieNP]

AFAIK, prod clusters were patched last week. Do you still experience issues on this?

[StijnBt]

@Kenn

AFAIK, prod clusters were patched last week. Do you still experience issues on this?

I guess you are talking about BC SaaS, what about the OnPrem versions?

[KennieNP]

This has been patched also in the on-prem version of the 2019 Wave 1
release (April). Will be available in the next CU

Best,
Kennie

On Thu, 6 Jun 2019 at 09:19, StijnBt [e-mail] wrote:

@kenn https://github.com/kenn

AFAIK, prod clusters were patched last week. Do you still experience
issues on this?

I guess you are talking about BC SaaS, what about the OnPrem versions?

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
https://github.com/microsoft/AL/issues/4916?email_source=notifications&email_token=ABXE6S2SMKLR2CJESLWKPCLPZC27TA5CNFSM4HHJRU6KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODXB6WPA#issuecomment-499379004,
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABXE6SZ3UBYB5JQGNYVL3FLPZC27TANCNFSM4HHJRU6A
.

--

---

Kennie Nybo Pontoppidan

Email: kennie.[email protected]

Twitter: @KennieNP

www and cv: http://pontop.dk

[kenn]

@StijnBt I'd appreciate if you don't mention my ID here.

[AntonInckle]

Hi, please can anyone confirm if this is fixed in one of the v13 CUs?

[atoader]

@AntonInckle the issue has been fixed in the latest CUs of the 2019 Spring release. If you are still encountering this problem on older releases, please open a request for hotfix following the standard process.
You can find further guidance in our FAQs: https://github.com/Microsoft/AL/wiki/Frequently-Asked-Questions#i-found-an-issue-in-a-version-of-the-product-that-is-not-the-latest-what-do-i-do