注册

创建表报6119最后一行附近出现错误,无效的数据类型

ㅤㅤㅤㅤㅤㅤㅤㅤ 2024/10/15 506 3 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:linux
【CPU】:
【问题描述】*:
[执行语句1]:
create table EDW_DATA_EDA.GLOBAL_VEHICLE
(
ID VARCHAR(500) not null,
PLATE_NUMBER VARCHAR(500)
constraint INDEX_GV_PLATE_NUMBER
unique,
PLATE_COLOR DEC(8)
constraint INDEX_GV_PLATE_COLOR
unique,
PLATE_COLOR_NAME VARCHAR(500),
PLATE_TYPE VARCHAR(500),
PLATE_TYPE_NAME VARCHAR(500),
BRAND VARCHAR(500),
MODEL VARCHAR(500),
VEHICLE_TYPE_CODE VARCHAR(500),
VEHICLE_TYPE_NAME VARCHAR(500),
GRADE DEC(8),
GRADE_NAME VARCHAR(500),
COLOR VARCHAR(500),
ENGINE_NUMBER VARCHAR(500),
ENGINE_POWER DEC(8),
CHASSIS_NUMBER VARCHAR(500)
constraint GLOBAL_VEHICLE_CHASSIS_NUMBER
unique,
VIN VARCHAR(500),
SEAT DEC(8),
TONNAGE DEC(10, 3),
TOW_WEIGHT DEC(10, 3),
TOTAL_MASS DEC(10, 3),
FUEL_TYPE VARCHAR(500),
FUEL_NAME VARCHAR(500),
EMISSION_STANDARD VARCHAR(500),
EMISSION_STANDARD_NAME VARCHAR(500),
FUEL_USAGE DEC(8),
PRODUCTION_DATE DATETIME(36,6),
PURCHASE_DATE DATETIME(36,6),
WHEEL_BASE DEC(8),
LENGTH DEC(8),
WIDTH DEC(8),
HEIGHT DEC(8),
AXLE_NUMBER DEC(8),
FILE_NUMBER VARCHAR(500),
REMARK VARCHAR(1500),
COMPANY_ID VARCHAR(500)
constraint INDEX_GV_COMPANY_ID
unique,
COMPANY_NAME VARCHAR(512),
COMPANY_TEL VARCHAR(500),
COMPANY_ADDRESS VARCHAR(500),
COMPANY_LICENSE_NUMBER VARCHAR(500),
AREA_CODE VARCHAR(8)
constraint INDEX_GV_AREA_CODE
unique,
AREA_NAME VARCHAR(500),
LICENSE_NUMBER VARCHAR(256),
LICENSE_WORD VARCHAR(50),
LICENSE_ISSUING_AUTHORITY_CODE VARCHAR(500),
LICENSE_ISSUING_AUTHORITY VARCHAR(500),
LICENSE_ISSUE_DATE DATETIME(36,6),
LICENSE_VALID_PERIOD_FROM DATETIME(36,6),
LICENSE_VALID_PERIOD_END DATETIME(36,6),
INDUSTRY VARCHAR(500),
BUSINESS_SCOPE_CODE VARCHAR(4000),
BUSINESS_SCOPE_NAME VARCHAR(4000),
BSLW_BUSINESS_SCOPE_CODE VARCHAR(4000),
BSLW_BUSINESS_SCOPE_DESC VARCHAR(4000),
ANNUAL_REVIEW_VALID_PERIOD_S TIMESTAMP(29),
ANNUAL_REVIEW_VALID_PERIOD_END TIMESTAMP(29),
ANNUAL_REVIEW_REPLACE_DATE TIMESTAMP(29),
ANNUAL_REVIEW_STATUS DEC(8),
COMPL_MAINT_VALID VARCHAR(500),
COMPL_MAINT_VALID_PERIOD_FROM TIMESTAMP(29),
COMPL_MAINT_VALID_PERIOD_END TIMESTAMP(29),
COMPL_MAINT_STATUS DEC(8),
INSURANCE_VALID_PERIOD_FROM TIMESTAMP(29),
INSURANCE_VALID_PERIOD_END TIMESTAMP(29),
INSURANCE_STATUS DEC(8),
AMOUNT_INSURED DEC(8),
TECH_RATING_VALID_PERIOD_FROM TIMESTAMP(29),
TECH_RATING_VALID_PERIOD_END TIMESTAMP(29),
TECH_LEVEL VARCHAR(500),
TECH_LEVEL_NAME VARCHAR(500),
TANK_CHECK_COMPANY VARCHAR(500),
TANK_CHECK_DATE TIMESTAMP(29),
TANK_CHECK_NEXT_DATE TIMESTAMP(29),
TANK_CHECK_STATUS DEC(8),
LICENSE_REPLACEMENT_NUMBER DEC(8),
FEE_PAYMENT_STATUS DEC(8),
AUDIT_STATUS CHAR(2),
ACCIDENT_RECORD_TIMES DEC(8),
STATUS DEC(8),
STATUS_NAME VARCHAR(500),
USAGE DEC(8),
FIRE_DEVICE CHAR(2),
OPERATOR_STATUS VARCHAR(1),
PLATNAME VARCHAR(500),
PLATFORM_ID VARCHAR(500),
PLATFORM_NAME VARCHAR(500),
OPERATOR VARCHAR(512),
EQUIPMENT_TYPE VARCHAR(500),
EQUIPMENT_COMPANY VARCHAR(500),
SERIAL_NUMBER VARCHAR(500),
SIM_NO VARCHAR(500),
IS_ENGINEERING DEC(8),
HANDOVER_TIME VARCHAR(500),
HANDOVER_ADDRESS VARCHAR(500),
HANDOVER_DIRECTION VARCHAR(500),
INITIAL_RECEIPT_DATE TIMESTAMP(29),
INSURANCE_COMPANY VARCHAR(500),
INSURANCE_NUM VARCHAR(500),
INSURANCE_DATE TIMESTAMP(29),
INSURANCE_THIRD DEC(8),
INSURANCE_PERSONAL DEC(8),
IS_EXPIRED VARCHAR(500),
IS_TRAILER VARCHAR(500),
LICENSE_MEMO VARCHAR(500),
TAX_PRICE DEC(8),
OWNER VARCHAR(500),
OWNER_ID_NUMBER VARCHAR(500),
OWNER_TEL VARCHAR(500),
OWNER_ADDRESS VARCHAR(500),
VIDEO_PLATFORM_NAME VARCHAR(500),
IV_STATUS VARCHAR(1),
IV_EQUIPMENT_COMPANY VARCHAR(500),
IV_EQUIPMENT_TYPE VARCHAR(500),
IV_SERIAL_NUMBER VARCHAR(500),
IV_SIM_NO VARCHAR(500),
IV_PLATFORM_NAME VARCHAR(500),
IV_OPERATOR VARCHAR(500),
IV_INSTALLATION_PROOF_DATE DATETIME(36,6),
IV_GPS_END_DATE DATETIME(36,6),
CREATED_TIME DATETIME(36,6) not null,
UPDATED_TIME DATETIME(36,6) not null,
TECH_RATING_VALID_PERIOD_UP TIMESTAMP(36, 6),
INDUSTRY_SINGLE VARCHAR(50),
constraint CLU_GLOBAL_VEHICLE_PLATE_NUMBER_COLOR unique(PLATE_NUMBER, PLATE_COLOR));
执行失败(语句1)
-6119: 第136 行附近出现错误:
无效的数据类型

1条语句执行失败

回答 0
暂无回答
扫一扫
联系客服