Export datagrid

Hello,

I use version 2.0

When I want to export a report to CSV or excel I do not receive email. I am trying to find the error, it is not in the mail sending since the maillog does not exist any connection attempt.

And when running php app / console akeneo: batch: list-jobs always comes out the same export_template entity_export_template_to_csv_2017_04_27_15_07_41_5901ed1d9dd696_65773040

How could I debug or track the search to find the error?Hello,

I use version 2.0

When I want to export a report to CSV or excel I do not receive email. I am trying to find the error, it is not in the mail sending since the maillog does not exist any connection attempt.

And when running

Shell

php app/console akeneo:batch:list-jobs

1	php app/console akeneo:batch:list-jobs

always comes out the same

Shell

export_template entity_export_template_to_csv_2017_04_27_15_07_41_5901ed1d9dd696_65773040

1	export_template entity_export_template_to_csv_2017_04_27_15_07_41_5901ed1d9dd696_65773040

How could I debug or track the search to find the error?

Topic

[thinh2010Participant]

did you run the message queue to execute the batch jobs?

PHP

app/console oro:message-queue:consume -vvv

1	app/console oro:message-queue:consume -vvv

[Alan Culvi BertomeuParticipant]

Hello,

While I click to export to CSV and EXCEL up to 5 minutes waiting

Shell

[debug] Properties: array ( 'oro.message_queue.client.topic_name' => 'oro.cron.run_command', 'oro.message_queue.client.processor_name' => 'oro_message_queue.client.route_message_processor', 'oro.message_queue.client.queue_name' => 'oro.default', ) [debug] Payload: '{"command":"oro:cron:imap-sync","arguments":[]}' [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search" [info] Message processed: oro.message_queue.consumption.ack [debug] [SignalExtension] Caught signal: 2 [debug] [SignalExtension] Interrupt consumption [debug] [SignalExtension] Interrupt execution

1 2 3 4 5 6 7 8 9 10 11 12 13 14

[debug] Properties: array (   'oro.message_queue.client.topic_name' => 'oro.cron.run_command',   'oro.message_queue.client.processor_name' => 'oro_message_queue.client.route_message_processor',   'oro.message_queue.client.queue_name' => 'oro.default', ) [debug] Payload: '{"command":"oro:cron:imap-sync","arguments":[]}' [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search" [info] Message processed: oro.message_queue.consumption.ack [debug] [SignalExtension] Caught signal: 2 [debug] [SignalExtension] Interrupt consumption [debug] [SignalExtension] Interrupt execution

and this

Shell

[debug] Properties: array ( 'oro.message_queue.client.topic_name' => 'oro.cron.run_command', 'oro.message_queue.client.processor_name' => 'oro_message_queue.client.route_message_processor', 'oro.message_queue.client.queue_name' => 'oro.default', ) [debug] Payload: '{"command":"oro:cron:email-body-sync","arguments":[]}' [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search" [info] Message processed: oro.message_queue.consumption.ack [debug] Switch to a queue oro.default

1 2 3 4 5 6 7 8 9 10 11 12

[debug] Properties: array (   'oro.message_queue.client.topic_name' => 'oro.cron.run_command',   'oro.message_queue.client.processor_name' => 'oro_message_queue.client.route_message_processor',   'oro.message_queue.client.queue_name' => 'oro.default', ) [debug] Payload: '{"command":"oro:cron:email-body-sync","arguments":[]}' [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "default" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "config" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "message_queue_job" [debug] [DoctrineClearIdentityMapExtension] Clear identity map for manager "search" [info] Message processed: oro.message_queue.consumption.ack [debug] Switch to a queue oro.default

[thinh2010Participant]

Maybe this is the first time you run the message queue, so that there are many jobs in queue and it takes time to handle all of them.

You can run the message queue and wait until it display:

PHP

[debug] Switch to a queue oro.default [info] Pre receive Message [info] Idle [debug] Switch to a queue oro.default [info] Pre receive Message

1 2 3 4 5

[debug] Switch to a queue oro.default [info] Pre receive Message [info] Idle [debug] Switch to a queue oro.default [info] Pre receive Message

it mean all the jobs are executed, you can export and see immediately in the log message queue.

another way if the message queue run too long, that is delete all jobs in database (not recommend, but by this way you can test the export function immediately)

delete all records in table oro_message_queue

I hope this help.

[Alan Culvi BertomeuParticipant]

OK thanks.

¿You know why cached/dev files are saved instead of cache/prod if the export runs in production?

[Alan Culvi BertomeuParticipant]

I answer myself.

Shell

app/console oro:message-queue:consume --env=prod -vvv

1	app/console oro:message-queue:consume --env=prod -vvv

Thank you

[Author]

Replies