Forum Discussion

Fabricator101's avatar
Fabricator101
Frequent Visitor
1 year ago
Solved

WebRequestTimeout When Importing Schema From ODBC Source

Hi   We are trying to migrate our tables from Sybase database. While creating copy activity for some of the tables, during import schema in table mappings, we get the following error:   Error cod...
data engineering
Data Pipeline
  • Fabricator101's avatar
    Fabricator101
    1 year ago

    Hi

    The import schema source table has large amount of rows. Due to this fact, import scema fails to gather/sample data types of columns. This in-turn gives web timeout. The solution, that I have found is to use query instead of table name in the source parameter. And do a SELECT TOP 100 * from [table_name]. This will allow the mapping within web time limit. Once mappings are done, change source query to source table name.

Fabricator101's avatar
Fabricator101
Frequent Visitor
1 year ago

Hi

The import schema source table has large amount of rows. Due to this fact, import scema fails to gather/sample data types of columns. This in-turn gives web timeout. The solution, that I have found is to use query instead of table name in the source parameter. And do a SELECT TOP 100 * from [table_name]. This will allow the mapping within web time limit. Once mappings are done, change source query to source table name.