Report Manager PSA ETL Failure -ConnectWise Manage

Last Modified

Mon Apr 24 14:19 GMT 2023

Description

Since Upgrading to Report Manager 5.0, the PSA ETL is failing with the below error, as seen in the C:\Program Files (x86)\N-able Technologies\Report Manager\logs\PSAETL.log:
  
The PSA ETL Failed with the following exception.
ConnectWise ManageScript. Data Export Failed: System.Net.WebException: The remote server returned an error: (404) Not Found.
 at ST_6425705651a74b5eba44c78f1a3515c8.csproj.ScriptMain.CreateCompanyTable(ConnectWiseServer cw, String name, SqlConnection conn)
 at ST_6425705651a74b5eba44c78f1a3515c8.csproj.ScriptMain.Main()

Environment

  • Report Manager 5.0

Solution

  1. Report Manager 5.0 utilizes the new RESTAPI in ConnectWise Manage .
  2. In ConnectWise Manage you will need to allow REST API access and generate the KEYS for the ConnectWise Manage Integration User configured into N-able N-central 's PSA Integration.
  3. To view the  N-able N-central PSA configuration, browse to the System or SO level > Administration > PSA configuration > Configure PSA Integration > Integration credentials.
  4. For further details, see below!

From N-able N-central Online Help:

Updated integration with ConnectWise

N-able N-central has been updated to leverage the latest version of the REST APIs provided by ConnectWise. Migrating to these new REST-based APIs addresses a number of limitations with the older SOAP-based APIs that were used in the past, and provide a platform on which to build new functionality in later releases.

One excellent side benefit of moving to the REST APIs is that the Export Profiles have been updated to let you choose from any “Status?? option for Configurations – in older versions of N-able N-central you could only choose the Active or Inactive statuses.

As ConnectWise is planning to deprecate their older, SOAP-based APIs in mid-2017,  N-able strongly recommends that all users update N-able N-central to use the new REST APIs. This is a trivial change to make, and can be done from the Administration > PSAIntegration > Configure PSA Integration menu. Note that you must be running v2017.2 (or newer) of ConnectWise to start using the new REST-based APIs.
 

How to obtain the new ConnectWise API Keys

The new API Member must have the AdministratorRole ID to generate the API Keys.

  1. Login to your ConnectWise Manage account using the desktop client.
  2. Navigate to System > Members and click the API Member tab.
  3. Create a new API Only Member.
  4. Generate the API Keys.
  5. Enter a Description for the API Keys.
  6. Save your changes, and make sure that you copy both the Public and Private key – you’ll need them in just a minute.

  7. In N-able N-central, at either the SO or System level, navigate to Administration > PSA Integration > Configure PSA Integration.

  8. In the API Credentials section, enter the Public Key and the Private Key into their respective fields.

  9. Save your changes.