Our customer recently updated their BMC Discovery from v23 to v24.2.
After that, the regular Flexera's BMC Adapter stopped working due to the following errors.
1. On the "Inventory adapter" level:
The staging state of the source ADDM staging database is currently set to "failed".
2. In the ADDM extractor log:
: ERROR : *** ERROR: Failed to execute the query configured for this step on the ADDM server: A query was supplied to the ADDM server, but the server has failed to interpret that query.
Core reason:
Here is the exact query in the FnmpADDMSettings.XML:
Solution:
The query appears to be case-sensitive. So, instead of "Version", it should go like this:
LOOKUP version
See the reference documents from BMC:
Sep 09, 2024 10:46 AM - edited Sep 09, 2024 10:48 AM
Hi Chris,
Thanks for suggesting the Idea Portal! Knowing how to share ideas with the Product Team is always good.
In this post, I also share the solution that worked for me.
Changing "LOOKUP Version" to "LOOKUP version" did the trick.
This is a small change, but it took some time to find it. Thus, I decided to share it here.
Sep 10, 2024 03:09 AM
BMC Discovery (ADDM) 24.2 is not yet supported by Flexera One ITAM or current versions of FlexNet Manager Suite, and it looks like the adapter to connect to that system will require an update to support this version.
If you would like support for this version, it may be helpful to log an idea about it in Flexera Ideas. This will help raise it to the attention of the Flexera Product Managers, and also allow other people to vote on it to help assess the level of interest there is in prioritizing this work.
Sep 10, 2024 02:39 AM
Hi Chris,
Thanks for suggesting the Idea Portal! Knowing how to share ideas with the Product Team is always good.
In this post, I also share the solution that worked for me.
Changing "LOOKUP Version" to "LOOKUP version" did the trick.
This is a small change, but it took some time to find it. Thus, I decided to share it here.
Sep 10, 2024 03:09 AM
You should post your finding as an answer, so we can mark it as a solution.
Sep 10, 2024 03:08 AM