Show hint on Bridge Online driver error with Data Hub: "Please contact Invantive Support or use another table"

Ideas (en)
, ,
1

When loading on-premise database, Data Hub can be used with Bridge Online. When the incorrect table name is specified, a confusing error can occur such as:

2022-02-04 07:27:20.089 Information itgendhb044: Run SQL statement: create or replace table EOL_Industry@sqlserver
as
select * from Exactonlinexml.XML.[Activitysectors@Eol]@bol
2022-02-04 07:27:20.090 Information itgensql264: Invantive SQL statement gestart.
2022-02-04 07:27:20.188 Warning itgendhb173: Context: create or replace table EOL_Industry@sqlserver as select * from Exactonlinexml.XML.[Activitysectors@Eol]@bol
2022-02-04 07:27:20.232 Error itgencun016: Fout itgenoda042: The requested OData URL could not be found on the Invantive Bridge Online server.

The remote server returned an error: (404) Not Found.
Please contact Invantive Support or use another table.
https://bridge-online.cloud/acme-exact-online/odata4/Exactonlinexml.XML.Activitysectors@Eol
2022-02-04 07:27:20.235 Error itgenoda042: System.Net.WebException

It would be more user friendly when the hint would direct the user to meaningful alternatives, such as using correct casing.

2

The release 22.0.30 will provide suggestions for other (accessible) databases on Invantive Bridge Online on a typo. However, currently there is no realistic way to achieve hints on wrong URLs for a specific table. The idea will be studied again not earlier than 2023.