AdminStudio - Application Manager - Backlog not downloading exe's or checking new content

[Williamhuynh]

Hi All,

New user of Package Feed and finding issues when attempting to check for new versions of products and downloading products. So far seems to be isolated to Exe's? Can't seem to attach screenshots but here is the log outputs below:

Process started at: Tuesday, September 21, 2021 - 09:13:59

Starting execution for selection application(s)...

Starting download of a package: AcroRdr20171700830051_MUI.exe

A required process for this task failed.

1 of 1 package automation completed.

Started loading application list.

Application list loaded successfully.

Process completed at: Tuesday, September 21, 2021 - 09:14:08

Package is Acrobat Reader 2017 Reader Classic Track - MUI 17.008.30051_EXE

[kmantagi · Accepted solution]

I am suspecting that the downloading of packages from Package Feed Module is being blocked on this machine. Could you please check the following:

1. Downloading of files (msi/exe packages in this case) is allowed on your machine

2. Package Feed Module connects to this url - https://dl.csi7.secunia.com/ to download the packages. Please make sure this url is whitelisted on your machine for successful downloads.

Thanks

[Williamhuynh]

We can download MSI's. Is there anywhere to check logs for more detail on the 'task failure'?

I'll in parallel check with our proxy team to ensure the URL is whitelisted.

[kmantagi]

AdminStudioHost.log and ISCMIDE.log files will have detailed logs. You will be able to find these log files at the paths mentioned below. Please note these paths are for AdminStudio 2021, if you are on a different version of AdminStudio, then the year in the path will change:

C:\Program Files (x86)\AdminStudio\2021\Common\AdminStudioHost.log

C:\Program Files (x86)\AdminStudio\2021\Common\ISCMIDE.log

Based on the logs in your earlier post, it appears you may be attempting to import packages from the Backlog tab, could you please try importing an EXE package from the Package Feed wizard in the Home Tab, I want to check if this issue is isolated to the Backlog tab alone:

 I hope there are no security policies running on your machine to block EXE downloads.

Thanks 

[Williamhuynh]

Downloading exe's through package feed import has resulted in the following error message: "Download failed. The remote server returned an error: (403) Forbidden.

ISCMIDE.log:
10:30:50 0 Debug: CSoftRepCheckOutTable::ExecuteQuery-The MoveFirst call failed: 265926
09:04:12 0 Debug: CMainFrame::GetActiveConnectionString() - GetConnectionString failed
les (x86)\AdminStudio\2021\Common\ISCMIDE.exe (Process Id: 106196, Thread Id: 109020)
09:05:27 : Version 21.0.0 Build 6041
09:05:27 : User lang: English, System lang: English
09:05:27 : Reportlevel: 0
09:05:27 : Username: P782931a (is local admin), Workstation: NNAB714036
09:05:27 : -----------------------------------------------------------------------------
09:06:00 0 Debug: CDBConnection::ExecuteSQL failed...
09:06:00 0 Debug: CDBConnection::SetLastError 80040E07: The statement has been terminated.
09:06:04 0 Debug: Connecting to SQL Server:
Server Collation: Latin1_General_CI_AS
Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) - 12.0.6433.1 (X64)
Oct 31 2020 02:54:45
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
09:06:04 0 Debug: Validating loaded module versions...

AdminStudioHost.log:

09:04:31 ERROR: AdminStudio.PackageAutomation.PackageFeedInvoker+<DownloadPackage>d__15.MoveNext - Download failed : DevExpress.Xpo.DB.Exceptions.UnableToOpenDatabaseException: Unable to open database. Connection string: 'data source=;integrated security=SSPI;initial catalog=NAB-Production;'; Error: 'System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:2,State:0,Class:20' ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception: The system cannot find the file specified
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
--- End of inner exception stack trace ---
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase()
at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
at DevExpress.Xpo.DB.MSSqlConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateProviderFromString(String connectionString, AutoCreateOption autoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.DB.DataStoreBase.QueryDataStore(String providerType, String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at AdminStudio.SCCM.Model.DatabaseService.<>c__DisplayClass46_0.<GetConnectionDetails>b__0(ConnectionDetails x)
at AdminStudio.Utilities.ConcurrentExtensionMethods.TryGetAddNewValue[TKey,TValue](ConcurrentDictionary`2 dictionary, TKey key, Func`2 updateValueProc)
at AdminStudio.SCCM.Model.DatabaseService.GetConnectionDetails(IFNConnectionInfo connectionInfo)
at AdminStudio.SCCM.Model.DatabaseService.get_DataLayer()
at AdminStudio.SCCM.Model.DatabaseService.get_Session()
at AdminStudio.SCCM.Model.DatabaseService.FindObject[T](CriteriaOperator filter, Boolean loadInTransaction)
at AdminStudio.ApplicationFramework.DataAccessLayer.DataLayerBase.FindObject[T](CriteriaOperator filter, Boolean loadInTransaction)
at AdminStudio.PackageFeed.Service.PackageFeedCatalogLayer.ASPackageFeedCatalogLayer.GetPackageFeedApplicationData(Int64 packageFeedId)
at AdminStudio.PackageFeed.Service.PackageFeedCatalogLayer.ASPackageFeedCatalogLayer.GetPackageFeedDownloadPath(Int64 packageFeedId, PackageFeedViewModel application)
at AdminStudio.PackageAutomation.PackageFeedInvoker.<DownloadPackage>d__15.MoveNext()
09:04:31 ERROR: AdminStudio.PackageAutomation.Actions.ImportAutomationAction.DownloadPackage - File doesn't exists at
09:04:31 ERROR: AdminStudio.PackageAutomation.Actions.ImportAutomationAction.DownloadPackage - File doesn't exists at
09:04:31 ERROR: AdminStudio.ApplicationFramework.Controller.Tasks.BaseTask.RunTask - at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase()
at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
at DevExpress.Xpo.DB.MSSqlConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateProviderFromString(String connectionString, AutoCreateOption autoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.DB.DataStoreBase.QueryDataStore(String providerType, String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at AdminStudio.SCCM.Model.DatabaseService.<>c__DisplayClass46_0.<GetConnectionDetails>b__0(ConnectionDetails x)
at AdminStudio.Utilities.ConcurrentExtensionMethods.TryGetAddNewValue[TKey,TValue](ConcurrentDictionary`2 dictionary, TKey key, Func`2 updateValueProc)
at AdminStudio.SCCM.Model.DatabaseService.GetConnectionDetails(IFNConnectionInfo connectionInfo)
at AdminStudio.SCCM.Model.DatabaseService.get_DataLayer()
at AdminStudio.SCCM.Model.DatabaseService.BeginNonTransaction()
at AdminStudio.SCCM.Model.DatabaseService.Execute[T](GenericFunctionReturnsValueType`1 function)
at AdminStudio.ApplicationFramework.DataAccessLayer.DataLayerBase.Execute(GenericFunctionReturnsValueType`1 function)
at AdminStudio.PackageAutomation.AutomationDataLayer.SaveAutomationExecutionStatus(AutomationStatus status, Int32 inventoryProductId)
at AdminStudio.PackageAutomation.AutomationDataLayer.SaveExecutionStatus(ReportMessage reportMessage)
at AdminStudio.ApplicationFramework.Controller.Tasks.PackageFeedAutomationTask.ExecuteTasks(Boolean threadSafe, BasePlugin pluginInstance)
at AdminStudio.ApplicationFramework.Controller.Tasks.BaseTask.RunTask(BasePlugin pluginInstance, AvailablePlugins ap)
09:04:31 ERROR: AdminStudio.ApplicationFramework.Controller.Tasks.BaseTask.RunTask - at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase()
at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
at DevExpress.Xpo.DB.MSSqlConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateProviderFromString(String connectionString, AutoCreateOption autoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.DB.DataStoreBase.QueryDataStore(String providerType, String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at AdminStudio.SCCM.Model.DatabaseService.<>c__DisplayClass46_0.<GetConnectionDetails>b__0(ConnectionDetails x)
at AdminStudio.Utilities.ConcurrentExtensionMethods.TryGetAddNewValue[TKey,TValue](ConcurrentDictionary`2 dictionary, TKey key, Func`2 updateValueProc)
at AdminStudio.SCCM.Model.DatabaseService.GetConnectionDetails(IFNConnectionInfo connectionInfo)
at AdminStudio.SCCM.Model.DatabaseService.get_DataLayer()
at AdminStudio.SCCM.Model.DatabaseService.BeginNonTransaction()
at AdminStudio.SCCM.Model.DatabaseService.Execute[T](GenericFunctionReturnsValueType`1 function)
at AdminStudio.ApplicationFramework.DataAccessLayer.DataLayerBase.Execute(GenericFunctionReturnsValueType`1 function)
at AdminStudio.PackageAutomation.AutomationDataLayer.SaveAutomationExecutionStatus(AutomationStatus status, Int32 inventoryProductId)
at AdminStudio.PackageAutomation.AutomationDataLayer.SaveExecutionStatus(ReportMessage reportMessage)
at AdminStudio.ApplicationFramework.Controller.Tasks.PackageFeedAutomationTask.ExecuteTasks(Boolean threadSafe, BasePlugin pluginInstance)
at AdminStudio.ApplicationFramework.Controller.Tasks.BaseTask.RunTask(BasePlugin pluginInstance, AvailablePlugins ap)

[kmantagi]

@Williamhuynh 

A quick look at the logs seem to show some issue with connection to the SQL Server. Please check if connection between Application Manager and SQL Server is good.

This is the default location where the packages from Package Feed Module get downloaded, please check if you find all the packages at this location:

C:\Program Files (x86)\AdminStudio Shared\Package Feed Downloads 

Meanwhile, I am sending these logs to our engineering team to look further into this issue. Could you please submit a support case by navigating to Support -> Open New Case.

[Williamhuynh]

Thanks for all your help kmantagi, proxy team has whitelisted - https://dl.csi7.secunia.com/ and its working via backlog now

[kmantagi]

I am glad to know it is working and you are all set now 🙂