Job Code not found

[agghanim]

I've installed the Akeneo connector on 2 instances, one instance is an existing Magento installation 2.4.3-p1 with existing products and extensions. The second instance is a new installation without any content. The second installation works perfectly. In the first installation I can not perform any jobs.

Magento 2.4.3-p1 Akeneo Connector 103.3.1 Akeneo CE 6.0

All configurable options for the connector are the same on both installations.

php bin/magento akeneo_connector:import --code=category
Job code not found

php bin/magento akeneo_connector:import -v
Options:
--code

Available codes:

The TABEL: AKENEO_CONNECTOR_JOB is empty

[agghanim]

Dirty fix, would love to find a proper explanation why this is. But I noticed the table AKENEO_CONNECTOR_JOB was empty. I exported the table structure&data from my working instance to my failing instance and this solved the issue.

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `akeneo_connector_job`;
CREATE TABLE `akeneo_connector_job` (
  `entity_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Job ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `status` varchar(255) NOT NULL DEFAULT 'PENDING' COMMENT 'Status',
  `scheduled_at` datetime DEFAULT NULL COMMENT 'Date scheduled to launch the job',
  `last_executed_date` datetime DEFAULT NULL COMMENT 'Last executed date',
  `last_success_date` datetime DEFAULT NULL COMMENT 'Last date the job was executed correctly',
  `job_class` varchar(255) NOT NULL COMMENT 'Job import class',
  `name` varchar(255) NOT NULL COMMENT 'Job import name',
  `position` int(11) NOT NULL COMMENT 'Job position to priorize launch',
  `last_success_executed_date` datetime DEFAULT NULL COMMENT 'Last executed success date',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Akeneo Connector Job';

INSERT INTO `akeneo_connector_job` (`entity_id`, `code`, `status`, `scheduled_at`, `last_executed_date`, `last_success_date`, `job_class`, `name`, `position`, `last_success_executed_date`) VALUES
(1, 'category', '1',    '2023-03-18 14:35:12',  '2023-03-18 14:36:03',  '2023-03-18 14:36:14',  'Akeneo\\Connector\\Job\\Category', 'Category', 0,  '2023-03-18 14:36:03'),
(2, 'family',   '1',    '2023-03-18 15:21:46',  '2023-03-18 15:22:02',  '2023-03-18 15:22:07',  'Akeneo\\Connector\\Job\\Family',   'Family',   1,  '2023-03-18 15:22:02'),
(3, 'attribute',    '1',    '2023-03-18 15:22:58',  '2023-03-18 15:23:02',  '2023-03-18 15:23:07',  'Akeneo\\Connector\\Job\\Attribute',    'Attribute',    2,  '2023-03-18 15:23:02'),
(4, 'option',   '1',    '2023-03-18 15:23:15',  '2023-03-18 15:24:02',  '2023-03-18 15:24:09',  'Akeneo\\Connector\\Job\\Option',   'Option',   3,  '2023-03-18 15:24:02'),
(5, 'product',  '1',    '2023-03-18 15:24:34',  '2023-03-18 15:25:03',  '2023-03-17 02:40:46',  'Akeneo\\Connector\\Job\\Product',  'Product',  4,  '2023-03-16 23:00:04');