cancel
Showing results for 
Search instead for 
Did you mean: 

Corrupted data cube

Laflet
9 - Travel Pro
9 - Travel Pro

I have a data cube that is corrupt and I’d like to delete it.

When I open it I get the following:

Laflet_0-1691550889142.png

and when I try to delete it, I get the following:

Laflet_1-1691550980466.png

 

I can't import over it:

Laflet_2-1691551050807.png

 

Any Ideas on removing it?

3 REPLIES 3

ScheurK
9 - Travel Pro
9 - Travel Pro

Got the same error. Can't delete the cube either. 

Laflet
9 - Travel Pro
9 - Travel Pro

@ScheurK Did you find a solution?

 

So I made a ticket a while ago and they gave me instructions:

1) Go to Sisense server:
Run the command:
kubectl -n sisense exec sisense-mongodb-xxxxxxxxxx -it -- bash
(where sisense-mongodb-xxxxxxxx is the name of your mongo pod, you may
type the command out and after ‘sisense-mongodb’ press Tab button, it should complete
the name. If this is not working you may find the mongo pod name by using command
kubectl -n sisense get pods | grep mongo )

2) You should see ‘>’ sign in the beginning of command line. Type
use prismWebDB
And hit Enter

3) In order to re-name duplicated columns type the following commands one by one, hit
Enter between each of them (in my case there were 3 columns)
db.getSiblingDB('prismWebDB').getCollection('datasetTables').updateOne({oid:
"[INSERT_CORRECT_OID]"}, { "$set": { "columns.YY.name": "[NEW_NAME_1]"}});

db.getSiblingDB('prismWebDB').getCollection('datasetTables').updateOne({oid:
"[INSERT_CORRECT_OID]"}, { "$set": { "columns.YY.name": "[NEW_NAME_2]"}});

db.getSiblingDB('prismWebDB').getCollection('datasetTables').updateOne({oid:
"[INSERT_CORRECT_OID]"}, { "$set": { "columns.YY.name": "[NEW_NAME_3]"}});

in which YY is the column number (e.g. 57).
4) After that cube should be available to open in UI