Skip to Content
0
Former Member
Jan 27, 2015 at 09:29 AM

to_date error

447 Views

I've created a view and filtered it to produce a single row result.

LIFNR_Account_Number_of_Vendor

AEDAT_Shipment_Last_Changed

10033970

20091215

The AEDAT field is a nvarchar(8) at database source (HANA), and a varchar(8) in the Info Steward View Output Schema.

Now, I need to change this value to a date type, so I did this in the field mapping:

to_date(Views.Shipment_Header_TOTAL.AEDAT_Last_Changed_on, 'yyyymmdd')


That validates perfectly, but when I preview data, everything falls apart.

The error message is jibberish to me, and I cannot see any meaningful clues.

Can anyone shed some light on what's occurring ?

Many Thanks

Simon

Data Services execution failed for EX1_FAIL_AS_DATE. Error :
(14.2) 01-26-15 12:10:23 (R) (8432:2660)
DBS-054003: |Data flow vviewdf_9763_45370f99_2057_4b7d_b26b_8f1cf3dda52b|Reader vviewQuery9763_1
SELECT query <SELECT * FROM "_SYS_BIC"."DS_VIEW_4A1B1"> failed.
The database error message is <SQL submitted to database <> resulted in error
<
[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;
129 transaction rolled back by an internal error:
[129] transaction rolled back by an internal error:
column store error:
search table error: [2981] function is not implemented (, yet);calcToQo: expression
>.
The SQL submitted is <SELECT * FROM "_SYS_BIC"."DS_VIEW_4A1B1">.>.(14.2) 01-26-15 12:10:23 (E) (8432:2660) DBS-054003: |Data flow vviewdf_9763_45370f99_2057_4b7d_b26b_8f1cf3dda52b|Reader vviewQuery9763_1 SELECT query <*****> failed. The database error message is <*****>. This message contains some internal system details which have been hidden for security.
If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account. (COR-10690)