SAM Software Model creation error for Microsoft Teams Shared Devices

[Joni Wootton]

Receive the following error when attempting to create a new software model: 

Publisher and Product manufacturer do not match. 

This is for Microsoft Teams Shared Devices. 

Has anyone else had issues with this? 

[Tanushree Maiti]

Hi @Joni Wootton 

Refer KB: KB0720661 Error: Publisher and Product manufacturer do not match - Invalid Insert 

Resolution

PART 1:

1) For the software you are trying to create, go to the core_company table.

2) Find the company(manufacturer) for that product

3) Search for all records in that table to see if you have duplicates for that company

4) Add the 'normalization' column to the list view so you can see the value for that field (see sample below).

5) Notice that only one of the 4 has field normalization = true. If you are getting the error, you may have more than one. 

6) To fix this, one way is to Export XML on those records 
- In the XML modify the value inside the tags <canonical>true</canonical> to <canonical>false</canonical> for all of the records EXCEPT one of them (I would pick the one that is newest as the one you want to keep as true, if it is false then leave it as is). Note: You will not be able to change that value through the UI. 

7) Import that XML back into that table. This will change the values for you. 

PART 2:

1) Next, we have to be sure that the software publisher record points to that core company record where we have normalization = true.

2) Go to software publisher table (samp_sw_publisher.list)

3) Find the publisher in question. Open the record and do a 'Show XML' of that record. 

4) The value inside the tags "<manufacturer>[sys_id]</manufacturer>" should be pointing to the core company record where we have normalization = true. 

5) If it is not update the field so it does point to the right record. 

Example: <manufacturer display_value="TechSmith">0eb2f545db426740fb54fd7aae961931</manufacturer>

6) Save this record.

Now you should be able to create the software model record. 

[Tanushree Maiti]

Hi @Joni Wootton 

Check this KB as well:

KB0961268 Issues with invalid Publisher and Manufacturer in Software Asset Management Professional 

Resolution

Apart from fixing the root cause mentioned in each KB article, you would need to execute the script to fix the incorrect data on Software Models, Software Discovery Models, Software Installs, etc.
Please import attached file (sysauto_script_eb0355e065513010fa9b1e02edc28a2d.xml) to your instance.
You should then find the scheduled script execution named "Core Company Fix Script" in sysauto_script table (Run = On Demand).
Execute the script. Note: Run in global domain if instance is domain separated.

If needed, observe the output in syslog table.  

Once the scheduled script is executed, verify that Publishers and Core companies are mapped correctly in Publisher table.

Verify Software Models, Software Discovery Models, Software Installs etc are updated correctly. If Normalized Publisher/Publisher field is not set correctly, then run below mentioned script:

Please import attached file (sysauto_script_9785060487a15110293c31173cbb3539.xml) to your instance.
You should then find the scheduled script execution named "Fix Core Company References" in sysauto_script table (Run = On Demand).

Execute the script. Note: Run in global domain if instance is domain separated.