on 12-09-2014 9:09 AM
Hi All,
I am trying to create a dynamic column table inside the procedure.
Generated create sql is something like below.
Create column schema1.dynamic_tab as
(
Select tmp.col1,tmp.col2,tab1.col3,tab1.col4,tab2.col5,tmp.col6,tmp.col7 ..... from
(select col1,col2, sum(case statement) as col6, avg(case statement ) as col7 ..... from MAIN_TABLE group by col1,col2) as tmp
left outer join
TABLE1 as tab1
on tab1.key1 = tmp.key1
left outer join
TABLE2 as tab2
on
tab2.key3 = tmp.key3
)
This SQL works perfectly fine if I try to create a row base column , But fails to create column table . throws below error.
Could not execute<<sql query >>...' in 4.835 seconds .
[129]: transaction rolled back by an internal error: TrexUpdate failed on table <<table name>>with error: exception 1999:
ims_search_api/LateMatColumn.cpp:649
exception in LateMatColumnSource
;location=zdxcea2:30003, rc=1999 - enforce TX rollback
Any one faced it before ? Is it running out of memory ??
I am able to create a row based table and then run alter statement to convert into column table .
For the delta load on same table I cannot run the insert statement and throws the same error for insert statement on column table
Thanks in advance.
Regards,
Suman
You can check the indexserver trace for details. It is possible that you run into a late materialization related issue. Can you have a look at SAP Note 1975448 and test if setting late_materialization_threshold and late_materialization_threshold_for_insert to high values or -1 resolves the issue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all
Did you resolve the issue, and I came across the same error ,
[129]: transaction rolled back by an internal error: TrexUpdate failed on table 'LMS_LF:LMS_LF_VERTICES' with error: Xerces parser error., rc=10102 - enforce TX rollback
but only in a certain HANA system, so could you offer me your solution of this error. Many thanks.
Best Rgards,
Yanyan
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.