ASCII-import lots of data

Discussion about recent product features & solutions!
2 posts • Page 1 of 1
NikolayLevchenko
Posts:74
Joined: Wed May 10, 2017 3:34 pm

ASCII-import lots of data

Post by NikolayLevchenko »

Hi,

I am generating the whole database with all the config with external tool and then import it into WinCC OA with ASCII manager.

I have about 100'000 rows in the import file and I noticed that:
1) import sarts quite quickly but then slows down and stops after approx 60'000 lines
2) I get "Blocking Manager WCCILdata(0) detected. No heartbeat since 30 seconds." in the log
3) I can see in the console that Database Manager goes to state 3
4) If I leave it, after about an hour the process actually finishes


I suspect I am somehow overloading the event or data managers but I'm not sure what's the best way to deal with it. I tried changing "maxBcmBufferSize" from default (10'000) to 100'000 but that did not seem to change the behaviour at all.
Any other advice?

leoknipp
Posts:2928
Joined: Tue Aug 24, 2010 7:28 pm

Re: ASCII-import lots of data

Post by leoknipp »

Importing an ASCII file with more than 100.000 lines is normally not a problem but it should not lead into a blocking manager.
That the import is slowing down is normally not a problem. It is related to the fact that the database gets bigger and bigger while importing the file.

For detailed analysis please get in contact with your common WinCC OA support and attach the logfiles and the ASCII file you tried to import.

Best Regards
Leopold Knipp
Senior Support Specialist

2 posts • Page 1 of 1