App Broker Knowledge Base | Flexera Community Support

Enabling the App Portal API

Summary To enable App Portal API usage, the API must be turned on within the site's integration settings. Synopsis To enable App Portal API usage, the API must be turned on within the site's integration settings under Admin | Site Management | Settin...

Error Log Shows Execute Permission Was Denied on the Object 'Fngetsitenumber'

SummaryResolve the execute permission error being thrown.SymptomsIn the databaseCalls_Error.log file the following exception may be seen: The EXECUTE permission was denied on the object 'fn_GetAppState', database 'CM_CAS', schema 'dbo'. The EXECUTE p...

"HTTP Error 503 Service un-available" when accessing App Portal.

Summary"HTTP Error 503 Service un-available" when accessing App Portal.SymptomsWhen accessing App Portal the following error message is displayed in the browser;"HTTP Error 503 Service un-available", this message is present in multiple browsers for d...

How to upgrade the existing catalog items, deployments, and requests after SCCM migrated from 2012 to Configuration Manager (Current Branch)

SummaryThis Knowledge Base article will explain why the existing catalog items' deployment is not showing after the System Center Configuration Manager is migrated from SCCM 2007/2012 to the current System Center Configuration Manager.SynopsisExistin...

Error "Machine Policy refresh failed"

Summary "Machine Policy refresh failed" error on application request Symptoms Error: "Machine Policy refresh failed" error on application request and following log can be confirmed in RunPolicy.log -- <![LOG[Error running policy for schedule on compu...

Implementation Not Part of Windows Platform FIPS Algorithms

SummaryThe database schema upgrade can fail with an error regarding FIPS found within the ESD_Error_Log.txtSymptomsDuring an upgrade, the database schema upgrade can fail with an error regarding FIPS on Windows. The specific error can look something ...

Server Error in '/ESD' Application. The source contains no DataRows.

SummaryThe error is encountered when accessing the admin security or catalog security tabSymptomsThe following error might be encountered when accessing either of the following tabs: Admin | Site Management | Admin SecurityAdmin | Site Management | C...

Filtering the List of Available Devices when Using 'Request On Behalf Of'

SummaryThis article describes how to filter the list of available devices which are displayed when checking out using 'Request On Behalf Of'. In particular, the provided query will only list active devices.SynopsisThis article provides information o...

Server Error in '/ESD' Application. There is no row at position 0

SummaryError is thrown when an invalid license collection is specifiedSymptomsWhen accessing the Admin -> Site Management -> Settings tab. the following error is thrown: CauseThe error is caused when an invalid SCCM collection is specified at either ...

Backup the App Portal Database

SummaryThe following steps can be taken to backup the App Portal database.SynopsisTo restore App Portal to a previous state, a backup of the database is required. In general, it is considered a best practice to regularly back up the database. In addi...

Error During Upgrade from App Portal 2015 to 2015 R2 or 2016

SummaryError: Cannot insert the value NULL into column 'NoteDate', table 'AppPortal.dbo.WD_RequestNotes'; column does not allow nulls. INSERT fails.SymptomsDuring an upgrade from 2015 to 2015 R2 or 2016, the database upgrade fails producing the follo...

User is Prompted for Credentials when Accessing App Portal Site Using FQDN

SummaryTo avoid being prompted for credentials, it is necessary to add the App Portal site to the Local Intranet zone in IE>SymptomsWhen accessing the App Portal site using a Fully Qualified Domain Name (FQDN), the user accessing the site is prompted...

How to cascading drop down list questions in App Portal

SummaryThis article will provide with some help to configure cascading drop down list questions in App PortalSynopsisThe scenario case is to set up: Question26 where the dropdown list is populated from a web service call WS1 Question27...

XML Parsing Error Causes DataSync to Fail

SummaryIf the asset being imported contains an ampersand in the name, an XML parsing error is thrown and the DataSync failsSymptomsNot all users and computers get imported within App Portal and the DataSync.log file shows the following exception:Erro...

Adding Additional Hardware Requirements

SummaryAdditional hardware requirements can be added in the Configuration Manager Console.SynopsisIn App Portal, each catalog item can specify a hardware requirement that must be satisfied in order for the catalog item to be made available for check-...

Error Encountered: Access Denied when Updating web.config File During Upgrade

SummaryWhen upgrading App Portal, an ?Access Denied when updating web.config file? error may be encounteredSymptomsWhen upgrading App Portal, an ?Access Denied when updating web.config file? error may be encountered when running the App Portal upgrad...

Error when Attempting to Test ServiceNow Status Values

SummaryWhen setting up ServiceNow integration in App Broker, it is necessary to specify ServiceNow Request State Mapping values. The Administration Guide implies that the status labels should be used.. In actuality, the status values should be used....

App Broker Catalog Items Not Syncing with ServiceNow

SummaryThe ESD service caches settings, including service now connection settings. If the settings are changed in the main App Portal site, then it may be necessary to restart the ESD Service.SymptomsUpon saving ServiceNow Integration settings in App...

How App Portal Determines the Client Time Zone

Summary This article explains how App Portal determines the client time zone Synopsis App Portal determines the Client Time Zone by obtaining the CurrentTimeZone from SCCM for a given device. Discussion The following query is run against the SCCM dat...

How to resolve the "No -- -connection string was found" error

SummaryResolving the errors like No CM12 connection string was found in the datasync.logSymptomsWhen a new user(not yet synced in to App Portal database) cannot log in to App Portal and errors like the following come up in the datasync.log every time...