Skip to Content
author's profile photo Former Member
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

1 Answer

  • Posted on 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)