History Database Error
Hello Team,
the first few database errors in case of to small import window, etc. have been solved.
There's another really big issue. I've imported a 4,5GB Tick Data file into the database (also tried a former working dump from Protrader DB).
After several days of data import it looks like the following:
I've tried the database (and also the import with different files) on different machines.
Everytime you're using a real big file (>1GB) the history does not appear in the database view environment.
The main error i want to report and i think these two "bugs" belong together is, that in the moment you're trieing to start a strategy backtest (Visualized or Quick, always the same) you receive one of the following errors which are switching depending on the time or the weather :-)
****First one ****
(Right timeframe, etc. is choosed, tried with several Ranges etc.)
***
****Second one ***
***
*** Third One ***
Sorry without screenshot: "Error During Simulation"
***
Even scripts that are not coded by myself and are working with smaller databases produce the same set of errors.
What i should tell is, the imported database file worked on every version before, so i think the data is right, also the import shows no further issues (by the way it's really really slow as the file size increases)
If you need any logfiles or anything like that please tell me exactly what is needed and i will provide you with any further data needed.
This issue is active since last few minor updates i think for about 3 or 4 weeks.
Martin Spensberger
-
Spensberger Martin | 21.09.2016
Hello, Martin Spensberger!
Thank you for your request.
We downloaded a database more than 16 GB. It works. We could trade by default strategies.
Are you using the lastest version of program?
Please, check updates, then try to reload database. If you have some issues after that, please give some information to solve your problem:
- what broker you chose.
- what version of PTMC platform you use (32, 64 bit)
About second bug:
- please, tell what number of trades you have in that strategy
Regards, Support PTMC.
Hi Team,
I've never had Problems with a downloaded DB but as I work on the Demo and tick data is incomplete i use my own one.
To verify the database i've uploaded it (don't know whether you need it):
http://81.169.183.109/download/CUSTOM.7z
The Protrader Version i use is 32bit and i also tried to use 64bit version.
I'm always up-to-date and using the latest patch 1.0.34 (Build from 5/30/16) - But this issue exists for the last few patches...think 3-5 weeks ago.
Only the write speed of the DB is worse than ever since the last patch which i think is caused by the way the file is created.
In older Protrader version the DB Import has written small files of 5-30 kb and put i into the DB file, now it writes the entire DB file as cache file to put around 200kb into it.
The way a Protrader-downloaded DB is saved and working also differs from a custom created symbol(see pictures), so i think this is a problem specifically for custom symbols.
In this case this ends up in 46TB written data for a 4,5GB DB and somewhat like 9 Days to process this. Half of this timeframe is used by write to disk operations but the full possible performance is not used by protrader (running on a Ramdisk)
Only to prove that there is nothing wrong with our import file(which worked for ages):
In reference to what number of trades we have, there's no trade executed. Just counting and file writing operations. But the simulation doesn't start at all so it doesn't matter.
If you need any further information to reproduce that problem, please let me know.
Best Regards
Martin Spensberger
