0027494: Error on installation ORA-00910: specified length too long for its datatype

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0027494

Modules

Apartment Rental Contract Management

public

2014-08-28 17:48

Reporter

rafaroda

Assigned To

jonalegriaesarte

Priority

normal

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0027494: Error on installation ORA-00910: specified length too long for its datatype

Description

Error on module installation on Oracle ORA-00910: specified length too long for its datatype

Steps To Reproduce

When installing module, Oracle ORA-00910: specified length too long for its datatype when trying to create OBARCNT_ENQUIRY since column EMAIL_LOG NVARCHAR2(4000) is bigger than the 2000 allowed by Oracle.

CREATE TABLE OBARCNT_ENQUIRY
      (
       OBARCNT_ENQUIRY_ID VARCHAR2(32) NOT NULL,
       AD_CLIENT_ID VARCHAR2(32) NOT NULL,
       AD_ORG_ID VARCHAR2(32) NOT NULL,
       ISACTIVE CHAR(1) DEFAULT 'Y' NOT NULL,
       CREATED DATE DEFAULT SYSDATE NOT NULL,
       CREATEDBY VARCHAR2(32) NOT NULL,
       UPDATED DATE DEFAULT SYSDATE NOT NULL,
       UPDATEDBY VARCHAR2(32) NOT NULL,
       C_DOCTYPE_ID VARCHAR2(32) NOT NULL,
       DOCUMENTNO NVARCHAR2(30) NOT NULL,
       OBARCNT_ENQUIRY_CATEGORY_ID VARCHAR2(32) NOT NULL,
       C_BPARTNER_ID VARCHAR2(32) NOT NULL,
       DOCSTATUS VARCHAR2(60) NOT NULL,
       STARTDATE DATE NOT NULL,
       ENDDATE DATE NOT NULL,
       CAPACITY NUMBER(10,0) NOT NULL,
       AD_LANGUAGE VARCHAR2(6),
       DESCRIPTION NVARCHAR2(2000),
       BILLED_BPARTNER_ID VARCHAR2(32),
       EMAIL_LOG NVARCHAR2(4000),
       PROCESSING CHAR(1) DEFAULT 'N' NOT NULL,
       ACTION CHAR(1) DEFAULT 'N' NOT NULL,
       ADD_RESOURCE_PICK CHAR(1) DEFAULT 'N' NOT NULL,
       NIGHTS NUMBER(10,0),
       BOOKINGLINK VARCHAR2(2000),
       CHILDREN_UNDER NUMBER,
       CHILDREN_ABOVE NUMBER
      )

Proposed Solution

Change EMAIL_LOG NVARCHAR2(4000) by EMAIL_LOG NVARCHAR2(2000)

Additional Information