Console "oro:migration:data:load" failed

[byhoratiss]

When I try to load the demo data through fixtures I get this:

php app/console oro:migration:data:load --fixtures-type=demo --env=dev                                                       [11:56:32]
Loading "demo" data fixtures ...
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadBusinessUnitData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadLeadSourceData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadGroupData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadUserData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadUsersData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadAccountData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadChannelData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadB2bCustomerData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadContactGroupData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadContactData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadCallData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadLeadsData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadCampaignData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadEmailData
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadEmailTemplates
  > loading OroCRM\Bundle\DemoDataBundle\Migrations\Data\Demo\ORM\LoadEmbeddedFormData



  [Doctrine\DBAL\DBALException]
  An exception occurred while executing 'SELECT t0.id AS id1, t0.username AS username2, t0.email AS email3, t0.name_prefix AS name_prefix4, t0.first_name AS first_name5, t0.middl
  e_name AS middle_name6, t0.last_name AS last_name7, t0.name_suffix AS name_suffix8, t0.birthday AS birthday9, t0.enabled AS enabled10, t0.salt AS salt11, t0.password AS passwor
  d12, t0.confirmation_token AS confirmation_token13, t0.password_requested AS password_requested14, t0.last_login AS last_login15, t0.login_count AS login_count16, t0.createdAt
  AS createdat17, t0.updatedAt AS updatedat18, t0.business_unit_owner_id AS business_unit_owner_id19, t0.status_id AS status_id20, t0.organization_id AS organization_id21, t0.ava
  tar_id AS avatar_id22 FROM oro_user t0 WHERE t0.id = ?' with params [94]:
  SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block






  [PDOException]
  SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block



oro:migration:data:load [--fixtures-type[="..."]] [--dry-run] [--bundles[="..."]] [--exclude[="..."]] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-s|--shell] [--process-isolation] [-e|--env="..."] [--no-debug] [--jms-job-id="..."] [--current-user="..."] [--current-organization="..."] [--disabled-listeners="..."] command

Any ideas?

[byhoratiss]

Now I have it working.
I've forgot about executing the Query on PostgreSQL Database.
I've discovered this through https://github.com/orocrm/crm-application#postgresql-installation-notes

This could be closed.