on 02-05-2015 6:36 PM
Hi superhero's,
I have a calculation view that is script based and combines a bunch of ce_olap_views and ce_projections, does some ce_aggregations and ce_union_all. Nothing too extraordinary and it is validating successfully and activating succesfully however when trying data preview I get this error;
column store error: search table error: [23008] Can't create plan for join query
I haven't found much related to this error when searching Al Gore's world wide web so I was wondering if any of my super friends have seen this before or have any guesses what to look into next?
Thanks,
-Patrick
Maybe stupid sounding question but: can you re-activate all the views successfully?
Sounds as if there is something broken in the view-structures.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok thanks for your suggestions guys. It looks like reactivating one of the source views being called by the calc view worked. Of course it was the very last view that I tried to reactivate that did the trick!
-Patrick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Instead of data preview, can you see if the SQL select from this view works instead?
Regards,
Justin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.