#48 R2.5.0e: Conversion Rate Type

R2.5.0
closed-fixed
Jorg Janke
5
2004-02-13
2004-02-09
Jorg Janke
No

When trying to add a new Conversion Rate Type, you
get the error:

===========> SaveError - Internal Error: Unable to
construct a Datum from the specified input

Cause: Data Definition error - Created & Updated of
C_ComversionType are TIMESTAMP(6) - should be DATE.

Fix: Run the follwing SQL commands:

ALTER TABLE C_CONVERSIONTYPE MODIFY CREATED
NULL;
ALTER TABLE C_CONVERSIONTYPE MODIFY UPDATED
NULL;
UPDATE C_CONVERSIONTYPE SET CREATED=NULL,
UPDATED=NULL;
ALTER TABLE C_CONVERSIONTYPE MODIFY CREATED
DATE DEFAULT SYSDATE;
ALTER TABLE C_CONVERSIONTYPE MODIFY UPDATED
DATE DEFAULT SYSDATE;
UPDATE C_CONVERSIONTYPE SET CREATED=SYSDATE,
UPDATED=SYSDATE;
ALTER TABLE C_CONVERSIONTYPE MODIFY CREATED
NOT NULL;
ALTER TABLE C_CONVERSIONTYPE MODIFY UPDATED
NOT NULL;

Discussion

  • Jorg Janke
    Jorg Janke
    2004-02-09

    Logged In: YES
    user_id=87038

    Please make sure that you have:
    - Connection Dialog: de-select HTTP Tunnel
    - Preferences: de-select Objects on Server

    This is fixed in 2.5.1

     
  • Jorg Janke
    Jorg Janke
    2004-02-13

    • status: open --> closed-fixed