<- Back to Tasks

sq 4.129 sqcli.exe -run file=c:/tmp/exportbatch.txt out of memory error

Hi,

I tried to export 372 the statistics of 373 portfolios with 
sqcli.exe -run file=c:/tmp/exportbatch.txt




exportbatch.txt contains:
-project action=status name=Retester
-databank action=export project=Retester name=Results file=c:\tmp\DatabankExport.csv view="Default - Portfolio"


I got the errormessage
Loading strategies to databank 'Results' failed - Memory usage is too high (90%). Please increase available memory or reduce memory usage.
Loaded 245 strategies to databank Results




------------
My computer have 64 GB.
I set the sq to 60 GB.




How can I increase the memory for the sqcli.exe cmd ?
I want to export all statistics for all 373 portfolios.


Is this a bug ?





Attachments
2 in database are 373 portfolios.png
2 in database are 373 portfolios.png
(274.34 KiB)
exportbatch.txt
exportbatch.txt
(151 B)
1sqcli_exe_output_memory too low.png
1sqcli_exe_output_memory too low.png
(39.02 KiB)
sq config.cfx
sq config.cfx
(3.36 KiB)
  • Votes +1
  • Project StrategyQuant X
  • Type Bug
  • Status Fixed
  • Priority Normal

History

t
#1

tnickel

04.11.2020 17:16

Task created

t
#2

tnickel

04.11.2020 17:24

Attachment 3 sqcli uses 32 bit version of Strategyquant.png added

3 sqcli uses 32 bit version of Strategyquant.png
3 sqcli uses 32 bit version of Strategyquant.png
(83.58 KiB)

I found out that the sqcli uses the 32 Bit version of Strategyquant, Why ?

This can be the reason ?


t
#3

tnickel

06.11.2020 20:06
Voted for this task.
TT
#4

Tamas

11.11.2020 15:57

Status changed from New to Fixed

Attachment image-0.png added

image-0.png
image-0.png
(653.32 KiB)
Fixed, thanks for reporting it.
t
#5

tnickel

12.11.2020 22:28

Attachment garbage collector GC overheat limit exeeded.png added

garbage collector GC overheat limit exeeded.png
garbage collector GC overheat limit exeeded.png
(34.77 KiB)
In SQ 4.130 RC1 it is not solved.

It is possible that this bugfix is not in the 4.130 RC1 ?



t
#6

tnickel

12.11.2020 22:46
ok now it works.

I found the new config file

sqcli.config


I use the following config and it works now.

option -Djava.net.useSystemProxies=true

option -Djava.net.preferIPv4Stack=true

option -Xmx55g

option -XX:+UseParallelGC



Votes: +1

Drop files to upload

or

choose files

Max size: 5MB

Not allowed: exe, msi, application, reg, php, js, htaccess, htpasswd, gitignore

...
Wait please