Skip to Content
avatar image
Former Member

How can we use analytical function in SQL Scripted CA View

Hello,

Can some one assist me here with the bellow error.

When i create a CA View (Scripted) with the SQL analytical function, the view gets activated successfully. But when i run the view it give me the below error.

With out the analytical function it give me the results.

Analytical function used:

min (case when type = 'Credits' then '9999-12-31' else "DUE_DATE" end ) over (partition by SERIAL_NO ) as due_date_min_serial

I am not doing any insert it just select the records.

Error message:

SAP DBTech JDBC: [274]: inserted value too large for column: [274] "_SYS_BIC"."XXXXX.XX.XX.XX.XXX/CA_XX_FAXXC_SEARCH_TEST/proc": line 353 col 1 (at pos 8308): [274] (range 3) inserted value too large for column exception: inserted value too large for column: Failed in "" column with the value End Customer (please check lines: 353, 358)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 16, 2017 at 09:29 AM

    What type has the result column of the "min" function in the calc. view output parameter description? I assume that it is something like NVARCHAR(8), das DUE_DATE seems to be date in format YYYYMMDD. If that is the case the value 9999-12-31 (which has a length of 10) does not fit into the result.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Florian Pfeffer

      Let me know what other info your looking at.

      This CA view pulls the data from a Stored procedure.(my requirements is to sort and group together on serial number)