I've created a view and filtered it to produce a single row result.
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:
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 ?
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:
 transaction rolled back by an internal error:
column store error:
search table error:  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)