View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|12221||Development||Tokens||public||2017-03-22 13:53||2017-03-25 11:14|
|Target Version||Fixed in Version|
|Summary||12221: Import Token Issue.|
We have a survey which contains around 200K tokens in the database table.
The Process is stuck in function createTokens($iSurveyID) in TokenDynamic Model. And after that, no further execution takes place for a long time.
|Tags||No tags attached.|
Did you try increasing your PHP's max_execution_time value? By default it's 30 seconds. I've had to increase this when working with large sets of tokens in the past. You can also just click generate tokens again when it times out. Eventually, it will generate them all. If you can't change your PHP settings, you can break the file up and do it in batches. My computer takes about 40 seconds to generate tokens for 200,000 participants and most of the time is just from database inserts.
The import token is from cron batch. And I didn't think that it will need to increase max_execution_time.
Can you be more specific about the cron batch? What is the command you're running?
In Cron batch which generate the tokens. It is perfectly working on the survey in which the number of records is less around 50K or less but it is only not working for a single survey having records >200K in the table. When trying to import more number of tokens in that survey it will failed or taking more time.
For reference attaching you the import_token file which i am using.
import_tokens.php (20,511 bytes)
Well, you are using an old unsupported version. I'm also not sure which way you are trying to import now, your self-coded import function, or the normal application one.
|2017-03-22 13:53||kkumarsantosh||New Issue|
|2017-03-24 00:55||mfavetti||Note Added: 43318|
|2017-03-24 08:24||kkumarsantosh||Note Added: 43321|
|2017-03-24 19:02||mfavetti||Note Added: 43339|
|2017-03-25 09:22||kkumarsantosh||File Added: import_tokens.php|
|2017-03-25 09:22||kkumarsantosh||Note Added: 43342|
|2017-03-25 11:14||c_schmitz||Assigned To||=> c_schmitz|
|2017-03-25 11:14||c_schmitz||Status||new => feedback|
|2017-03-25 11:14||c_schmitz||Note Added: 43345|