Anaplan Connect Export stops writing after 30 minutes.

Options
Luke95
Luke95
in Integrations and extensibility

Hi,

I have set up export connection to a SQL database. I have 1 connection that takes longer than 30 min to be completed. I have scheduled this one to run overnight. Each time this export is run, it seems that it's timing out exactly after 30 minutes but without a logged timeout error message. See error log (I scheduled this one as an example at 11:30):

image.png

I have read similar topics here. Like this one:

https://community.anaplan.com/discussion/74123/time-out-issues-with-anaplan-connect-v1-4-4-console-while-importing-large-files

I then added -maxretrycount -retrytimeout to my operation:

Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -debug -service %ServiceUrl% -auth %AuthUrl% -via %Proxy% -workspace %WorkspaceId% -model %ModelId% -export %ExportName% -maxretrycount %MRC% -retrytimeout %RTO% -execute -jdbcproperties %JdbcPropFilePath%

Chunksize=20
MRC=15
RTO=60

This doesn't seem to help. Still stops writing after 30 min.

Note: Doesn't timeout when triggered manually. Only if scheduled.

Thanks in advance!

Tagged:

Best Answer

  • pyrypeura
    pyrypeura
    Answer ✓
    Options

    Hi,

    Do you have timeout set to 30mins in your Windows Task Scheduler Schedule?

Answers

  • Luke95
    Luke95
    Options

    Hi,

    Thanks for the quick response. Task Scheduler timeout is set to 1 hour so this should not be the case.

    image.png

  • pyrypeura
    pyrypeura
    Options

    Could you try what happens if you untick that box completely?

  • Luke95
    Luke95
    Options

    I went to the task scheduler trigger. There I looked into the properties » Trigger » Edit. There is another tab where 'Stop task if runs longer than' is displayed. There it was set to 30 min. Changed it to 1 hour and this solved the issue. Many thank @pyrypeura !

  • pyrypeura
    pyrypeura
    Options

    Happy to hear you got this solved!

Categories