We would greatly appreciate any assistance from the Dynamics community. Has anybody experienced this before?
Backstory: We constructed within the Microsoft Dynamics CRM Unified Service Desk system, an application built for call centers that allows Dynamics CRM to interact with other applications that call center employees may need to use.
Version of CRM: 1612 (8.2.1.176) on premise
Version of USD: (2.2.2.806) 64 Bit - Installed on Windows 10 workstation.
Subject to the "community and forum: USD knowledge article search box - (USD hosted control... That is out of the box KA search in the USD)
Environment: The workstations are hardened with GPO's and other local security policies.
Scenario: When we import X number of Knowledge Articles (KA's) into CRM, we then audit the system to verify that all are accounted for.
Investigation:
The counts by language from CRM advanced find match what is expected by language.
The KA data from USD KA search hosted control is retrieved from CRM table documentindex (This is confirmed by running SQL profiler). This is a table generated by Microsoft Full-text search. If you do a wild card search I am not sure the counts from these two tables will match 100%.
TO recreate the bug/defect/issue:
- Import a number of KA’s into CRM
- Startup USD with the KM search box
- Type an asterisk (*) into the search bar
- Choose desired language from the dropdown list just below the search bar
- View the " results found"
1. The knowledge article CRM import job completed successfully. The counts by language from CRM advanced find match what are expected by language.
2. The KA data from CRM advanced find is retrieved from CRM table KnowledgeArticleBase (This is confirmed by running SQL profiler).
3. The KA data from USD KA search hosted control is retrieved from CRM table documentindex (This is confirmed by running SQL profiler). This is a table generated by Microsoft Full-text search.
4. Full-text search is installed as part of Dynamics 365 and is not maintained / customized by project team. Will need help from Microsoft to determine cause of count mismatch.