Hey everyone,
after upgrading the App Portal from 2020R1 to 2021R2 everything seemed fine at first glance.
But when we try to create a software catalog item with an already existing device collection (ConfigMgr) it fails with "Column "IsCollectionLess" does not belong to table dtParameters" in the CreateESDObject.log
1. We cant seem to find the mentioned table dtParameters, where is it from?
2. What do we need to do to create software catalog items with existing collection?
Thanks in advance
Feb 04, 2022 08:04 AM
Hey CharlesW,
Thank you very much for your support and offer to help via a screen sharing session. We did some more testing today and it seems we identified the error.
As it turns out, the error was not caused by something in the App Portal, but by missing permissions for the SCCM Web Service User.
The error message “Column “IsCollectionLess” does not belong to table dtParameters” wasn’t relay helpful in this case, at it seemed the error originated from the mentioned App Portal table.
Sorry for the inconveniences and, again, thank you very much for your support.
Feb 14, 2022 04:33 AM
Can you confirm that you upgraded the ESD Web Service to 2021 R2? It sounds as if the web service may not have been upgraded, based on the error.
The "dtParameters" mentioned in the error is likely referring to the content in the Parameters column in WD_SiteToAdvert.
NOTE: As it stands now if you use "select existing collection" functionality, you need to select a collection that does not already have a deployment attached.. In this case, App Broker will create the deployments. This somewhat limits its usefulness, in my opinion.
Feb 04, 2022 12:08 PM
Hey CharlesW, thank you for your quick reply.
We already did upgrade the Web Service to 2021R2 on the ConfigMgr Site and changed the application pool to an authorized ConfigMgr user.
Your note with using existing collections indeed limits its usefulness as our collections already have deployments. We still will check the WD_SiteToAdvert table, any hints or clues what might cause this error or how we solve it?
Many thanks.
Feb 07, 2022 01:34 AM
I'm having some problem trying to track this down since I'm not able to reproduce.. Can you provide me with the exact log statement taken directly from CreateESDObjects.log? I'm particularly interested in any exceptions if there are any. Even a screen capture showing the log entries may help.
Feb 07, 2022 01:21 PM
Sure, here you can find some screenshots:
Error Log of the App Portal GUI:
Error Log of CreateESDObjects.log:
Full Error:
Could not create collection / advertisement on {Servername} Column 'IsCollectionLess' does not belong to table dtParameters. at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at AppPortal.Infrastructure.Repositories.CmRepository.CreateApplicationEsdObject(PackageEsdObject package, String server, String cmLimitingCollection, String programTypeText)
Like mentioned before we upgraded the Webservivr on the SCCM Server and testing the deployment settings returns a valid configuration. Hope this helps identifying our issue.
Many thanks.
Feb 08, 2022 02:40 AM
Thanks. That helps to narrow down exactly where the problem is occurring, though I do not see why it is occurring. Perhaps I'm grasping at straws here, but can you tell me the name of the application you are selecting? I've seen odd behavior before when choosing an application that contained special characters in the name. In addition, can you tell me the name of the collection that you are selecting? Finally, can you tell me if you are creating the catalog item using the catalog item wizard, or if you are using "New Software Catalog item"..
Feb 08, 2022 11:01 AM
We tried using the new catalog item wizard as well as adding deployments to already existing catalog items, both results in the same error. We also tried different applications/collections, here is an example:
Application: Adobe_AcrobatDCPro_x86_20.006.20042-0002_MUL
Collection: Adobe_AcrobatDCPro_x86_20.006.20042-0002_MUL_INSTALL (TEST)
Hope this helps, thank you very much for your support.
Feb 10, 2022 02:12 AM
Hey CharlesW,
Thank you very much for your support and offer to help via a screen sharing session. We did some more testing today and it seems we identified the error.
As it turns out, the error was not caused by something in the App Portal, but by missing permissions for the SCCM Web Service User.
The error message “Column “IsCollectionLess” does not belong to table dtParameters” wasn’t relay helpful in this case, at it seemed the error originated from the mentioned App Portal table.
Sorry for the inconveniences and, again, thank you very much for your support.
Feb 14, 2022 04:33 AM