none
CopyData wizard UserError: the operation has timed out., activityID:XXXXXXX

    Question

  • I am connecting to NETEZZA Table which is around 1.5 TB and has 25 columns
    In the copy wizard i get "UserError: the operation has timed out., activityID:XXXXXXX during selection of source
    could not load schema for tables: "XXXXXXXX"

    I have tried other table which has less data and they work without any problem.

    What could be going wrong. Are there any setting in IR that need to be tweaked ?


    • Edited by N S S Thursday, April 26, 2018 4:52 PM
    Thursday, April 26, 2018 4:52 PM

All replies

  • Hi NSS,

    This could be a performance issue regarding to preview data from Netteza, since it's for preview purpose, do you mind previewing that data with a limited rows, say "select * from nettezatable limit 10"? We're working on improving user experience per such cases.

    Thanks,

    Eva

    Saturday, April 28, 2018 3:58 AM
  • Hi Eva,

    But Preview is compulsory when I want to copy data from there. FYI our company is suffering from this as well.

    Wednesday, June 6, 2018 1:02 PM
  • Preview is not compulsory. Only schema is compulsory when use copy wizard.
    Wednesday, June 6, 2018 1:46 PM