Anaplan Connect Export stops writing after 30 minutes.

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):

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!

Accepted answers

pyrypeura

Hi,

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

All comments

pyrypeura

Hi,

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

LukasRooseleers

Hi,

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

pyrypeura

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

LukasRooseleers

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

Happy to hear you got this solved!

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…