Forum Discussion

Laflet's avatar
Laflet
Cloud Apps
08-09-2023

Corrupted data cube

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

When I open it I get the following:

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

 

I can't import over it:

 

Any Ideas on removing it?

Data Models

3 Replies

Replies have been turned off for this discussion
  • ScheurK's avatar
    ScheurK
    Cloud Apps
    08-21-2023

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

    • ScheurK's avatar
      ScheurK
      Cloud Apps
      11-07-2023

      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