MySQL Forums
Forum List  »  NDB clusters

SQLSTATE[HY000]: General error: 1296 Got error 839 'Illegal null attribute' from NDBCLUSTER [updated]
Posted by: Sucre Sucre
Date: May 26, 2022 01:33AM

I was trying to insert a record into a newly created table while got this error message, can anyone tell me why that happened?


Here is my table source:
CREATE TABLE `supcs_recordings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`project_id` bigint NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`updated_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`TYPE` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`owner` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`picked_at` timestamp NULL DEFAULT NULL,
`picked_from` tinyint NOT NULL DEFAULT '0',
`checked` tinyint NOT NULL DEFAULT '0',
`upload_batch` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`uploaded_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`uploaded_at` timestamp NULL DEFAULT NULL,
`CATEGORY` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`WEEK` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`DATE_CALL` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`DTIME` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`DURATION` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`CONTRACT` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`CPD` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`REC_SKILL` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`CON_PHASE` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`TASK_TYPE` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`COUNTER_PARTY` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`PH` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`SITE` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`AGENT` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`EMP_ID` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`BUTL` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`TL_SKILL` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`BUSV` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`DD` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ANS_PARTY` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`CALL_RESULT` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`NOPAY_REASON` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`PTP` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`PH_FROM_NOTE` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`GUID` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`RELEASED_BY_AGENT` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`NEW_NUM` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`AMT` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`INSURED` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`INB_OTB_MAN` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`CONTRACT_NAME` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`SKP_CONTRACT` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ID_CUID` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`TEXT_IDENTIFICATION` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`CODE_CREDIT_STATUS` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ID_GAD` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=ndbcluster AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Sincerely,
Sucre



Edited 2 time(s). Last edit at 05/26/2022 02:08AM by Sucre Sucre.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.