Skip to Content

Inserting time stamp into table effecting insertion of other columns

I have a persistance table defined using CD file which contains hierarchy code(String(300)) and a time stamp(UTCTimestamp) coulmns.

I persist data from a temporary table(BOM_OUT) in a procedure.

If i include time stamp in my insert statement it is throwing error that inserted value is too large for hierarchy code column.

I checked the temporary table result the max length of the existing data is 51.

When i insert data without time stamp the data insertion is happening without an error.

In both insertion cases i have the following warning message where i inserted data into BOM_OUT from other temporary tables:

java.sql.SQLWarning: general warning: general warning: Type mismatch for table variable BOM_OUT:Declared type "NVARCHAR(45)" of attribute "HIERARCHY_CODE" not same as assigned type "NVARCHAR(50)"

yeah i have assigned values to BOM_OUT multiple time.

can anyone explain this behavior.

Add comment
10|10000 characters needed characters exceeded

  • Please show your minimal code and data to reproduce the issue. Also, which HANA version are you using? I'm not going to waste my time following a verbal description of what clearly is a coding issue.

  • Get RSS Feed

1 Answer

  • Nov 02, 2018 at 05:20 AM
    -1

    Hi Gopi,

    Based on above information,

    It looks like the order of columns in temp table and in DB table is not matching,

    also could you please cross verify the data types once as well.

    I guess, that should resolve your issue.

    Thanks,

    Jay.

    Add comment
    10|10000 characters needed characters exceeded