KB484790: Cloud-based Live Connect dossiers display an error when saved in the environment

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Description

When a cloud-based dossier fails to execute after uploading the local dossier to the server, you may receive the following error message:
CITY_CTR_SLS LU_CALL_CTR (2 tables)_0: (QueryEngine encountered error: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [28000:20032: on SQLHANDLE] [Strategy][DSI] (20032) Required setting 'RefreshToken_Enc' is not present in the connection settings.. ).
 
This error is experienced with the following gateways:

• Google BigQuery
• Eloqua
• Service Now
• Shopify
• Hubspot
• Square
• Marketo
• Paypal
• Concur

Steps to reproduce

• Connect it to an environment via Workstation.
• Create a live dossier for the above mentioned gateways with a connection string filled in with credentials (tokens).
  

• Save this live dossier to the environment.
• No data is returned for the uploaded dossier. The error shows up, or the Credential Input dialog pops up.
  Error message:
  CITY_CTR_SLS LU_CALL_CTR (2 tables)_0: (QueryEngine encountered error: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [28000:20032: on SQLHANDLE] [Strategy][DSI] (20032) Required setting 'RefreshToken_Enc' is not present in the connection settings.. )
  Credential Input dialog:
  

Workaround

• Find and execute the newly uploaded dossier in the environment.
• Click Edit Dataset and Edit Table.
  

• Edit the data source.
  

• Re-enter the

  RefreshToken

  in the Connection String field.
  

• Click Save.
  The dossier should work as expected.