TM1 Forum

Hi,
using Cognos TM1 v9.5 I am regularly having problems with single cube. All of the processes for recreating dimensions are correctly build, but the process of updating cube returns error.

In TM1 tm1server.log file there is error message: And in TM1ProcessError_20110214030108_MY_CUBE.log file is an error: All of the processes are run every day at night and I have found out that this problem ONLY appears every day AFTER end-of weekend (each Monday) and every day AFTER some national holiday. It is possible that this error appears because there is no NEW data stored in warehouse at "error day".

It looks like a cube is being DELETED despite I have no delete command (like recreate) in my process. In the process of loading data I use the following in Turbo Integrator:
1. Datasource Type: ODBC (this is DB2 database).
2. On Variables tab I have Contents=Element for every dimension and Data for data field.
3.1. Maps | Cube | Cube Action=Update Cube
3.2. I have checked "Zero Out Portion" in "Edit View" button I have left all of the settings default and just saved the view - I want to delete all the data from cube (or mark it with zeros).
4. Maps | Cube | Data Action=Store Values
5. on Maps | Dimensions there is nothing special just mapping dimensions on Dimensions tab and data elements on Data tab.
6. on Advance tab I haven't changed anything - all default.

I am wondering why every MONDAY I have a problem with this process. At the moment I have 10 cubes in production and one single process that I am having problems with it every Monday. Any idea what is wrong? Is this some kind of bug? Or am I doing something wrong?

P.S. Work-around: I have created special purpose process that I am executing at the "error day", process is the same as described above except on Maps | Cube |Cube Action=Create Cube; then I have to manually run this process; because cube was deleted in the night I need to create rules and views.
Regards

What does the code say where you are assigning a string value to the variable "MY_CUBE"? That's where your problem is.

tomok, sorry, I don't understand you question. I don't get any error in TM1 Architect and process is running without any error for a week, but every Monday I get this "Cube does not exist" error.

I have attached print-screens of MY_CUBE process. Please see attachment. Am I doing something wrong?

It looks like the cube PROD_MARZE gets deleted outside of your process, so that when it gets executed it cannot find it and falls over on the first line of code. Are you aware of any other process in your environment that would be deleting this cube periodically?

My thoughts are the same. Namely that if this process is running daily OK except for Monday and it is failing on Monday because the cube has been deleted then the problem is not in this process but in another process/chore that is running sometime between when this process runs on Sunday and when it runs on Monday.

Also if this is supposed to be a production system then I would advise against using any wizard generated code period.

On this cube there are running the following processes:
1. processes to recreate dimensions - all of them having "recreate dimension" option
2. above process that loads data into cube

The error "Cube Not Found" is appearing every Monday and every day after national holiday! All of the jobs running from chore are daily jobs. This are days that no data are refreshed in warehouse database. So it looks to me that some of operation is deleting too much, I am suspecting deleting from zero out view (Prolog command: VIEWZEROOUT command). Is there any other way to all data from cube except using ZeroOut option and using view? I am just trying to do something different to see if error still appears.

Let me just add that you are not providing all the relevant information. This particular error message: Is telling me that TM1 is looking for a cube that is literally named "MY_CUBE". According to the screen shots of your TI code, the cube in questions is named "PROD_MARZE" so right there I know there is something missing here. I know TM1 can do some crazy things but there is no way that it can turn "PROD_MARZE" into "MY_CUBE" unless you have some statements programmed into your TI that does that. Go back through your processes and check all the ones that work against this cube. Better yet, do a text search of your data directory for the string "MY_CUBE" and let us know what you find.

tomok, in my first post I just tried to simplify the sample and have just written MY_CUBE and *manually* replaced PROD_MARZE string with MY_CUBE everywhere it was written just for purpose of simplifying a sample for this forum. So instead MY_CUBE there is actually real name PROD_MARZE. So there is no MY_CUBE in production.

Sorry for confusing, I was trying to simplify, but I see I created bigger mess.

How many active chores do you have in your model? Is it possible for you to go through them and list all the processes involved? If there aren't too many, you could post the code in the Prolog, Metadata, Data and Epilog tabs of these processes so that we can help you pinpoint which other process deletes the cube, as this is what it looks like is happening with what we know right now.

qml, I have 7 chores in production this core is the first chore that is run every single day and all other chores are also run every single day. By the way, today in the morning the same problem reappeared and today is not a Monday and it is also not a fist day after a holiday - so my theory is broken. Yesterday everything was OK, so all the chores that run after THE chore are not effecting the problem. Bellow are the processes inside THE chore in the order of executing. Sections are: Prolog, Metadata, Data, Epilog.

PROCESS: PROD_MARZE_CAS_FAKTURE
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_CAS_FAKTURE');
DIMENSIONSORTORDER('PROD_MARZE_CAS_FAKTURE','ByInput','ASCENDING','ByInput','ASCENDING');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_CAS_FAKTURE','',DATUM_FAKTURA,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_CAS_FAKTURE','',DIM,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_CAS_FAKTURE','',LETO,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_CAS_FAKTURE','',MESEC,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_CAS_FAKTURE',DIM,LETO,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_CAS_FAKTURE',LETO,MESEC,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_CAS_FAKTURE',MESEC,DATUM_FAKTURA,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_CAS_POGODBE
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_CAS_POGODBE');
DIMENSIONSORTORDER('PROD_MARZE_CAS_POGODBE','ByInput','ASCENDING','ByInput','ASCENDING');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_CAS_POGODBE','',DATUM_POGODBA,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_CAS_POGODBE','',DIM,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_CAS_POGODBE','',LETO,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_CAS_POGODBE','',MESEC,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_CAS_POGODBE',DIM,LETO,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_CAS_POGODBE',LETO,MESEC,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_CAS_POGODBE',MESEC,DATUM_POGODBA,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_IZDELEK
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_IZDELEK');
DIMENSIONSORTORDER('PROD_MARZE_IZDELEK','ByInput','ASCENDING','ByInput','ASCENDING');
ATTRDELETE('PROD_MARZE_IZDELEK','IDENT_ALIAS');
ATTRINSERT('PROD_MARZE_IZDELEK','','IDENT_ALIAS','A');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_IZDELEK','',IDENT,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_IZDELEK','',DIM,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_IZDELEK','',NAZIZDEL,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_IZDELEK',DIM,NAZIZDEL,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_IZDELEK',NAZIZDEL,IDENT,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
ATTRPUTS(IDENT_ALIAS,'PROD_MARZE_IZDELEK',IDENT,'IDENT_ALIAS');
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_KOMERCIALIST
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_KOMERCIALIST');
DIMENSIONSORTORDER('PROD_MARZE_KOMERCIALIST','ByInput','ASCENDING','ByInput','ASCENDING');
ATTRDELETE('PROD_MARZE_KOMERCIALIST','KOMERCIALIST_ALIAS');
ATTRINSERT('PROD_MARZE_KOMERCIALIST','','KOMERCIALIST_ALIAS','A');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_KOMERCIALIST','',KOMERCIALIST,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_KOMERCIALIST','',DIM,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_KOMERCIALIST',DIM,KOMERCIALIST,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
ATTRPUTS(KOMERCIALIST_ALIAS,'PROD_MARZE_KOMERCIALIST',KOMERCIALIST,'KOMERCIALIST_ALIAS');
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_KUPEC

#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_KUPEC');
DIMENSIONSORTORDER('PROD_MARZE_KUPEC','ByInput','ASCENDING','ByInput','ASCENDING');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_KUPEC','',FAKTURA,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_KUPEC','',DIM,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_KUPEC','',CELINA,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_KUPEC','',NAZDRSLO,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_KUPEC','',KRNAZ,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_KUPEC','',POGODBA,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_KUPEC',DIM,CELINA,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_KUPEC',CELINA,NAZDRSLO,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_KUPEC',NAZDRSLO,KRNAZ,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_KUPEC',KRNAZ,POGODBA,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_KUPEC',POGODBA,FAKTURA,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_LME_FORMULA
****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_LME_FORMULA');
DIMENSIONSORTORDER('PROD_MARZE_LME_FORMULA','ByInput','ASCENDING','ByInput','ASCENDING');
ATTRDELETE('PROD_MARZE_LME_FORMULA','LME_FORMULA_ALIAS');
ATTRINSERT('PROD_MARZE_LME_FORMULA','','LME_FORMULA_ALIAS','A');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_LME_FORMULA','',LME_FORMULA,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_LME_FORMULA','',DIM,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_LME_FORMULA',DIM,LME_FORMULA,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
ATTRPUTS(LME_FORMULA_ALIAS,'PROD_MARZE_LME_FORMULA',LME_FORMULA,'LME_FORMULA_ALIAS');
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROD_MARZE_MERA
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_MERA');
DIMENSIONSORTORDER('PROD_MARZE_MERA','','','ByInput','ASCENDING');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_MERA','',MERA,'n');
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_NACIN_OBDELAVE
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_NACIN_OBDELAVE');
DIMENSIONSORTORDER('PROD_MARZE_NACIN_OBDELAVE','ByInput','ASCENDING','ByInput','ASCENDING');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_NACIN_OBDELAVE','',NACIN_OBDELAVE,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_NACIN_OBDELAVE','',DIM,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_NACIN_OBDELAVE',DIM,NACIN_OBDELAVE,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_POGODBE
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_POGODBE');
DIMENSIONSORTORDER('PROD_MARZE_POGODBE','ByInput','ASCENDING','ByInput','ASCENDING');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_POGODBE','',POGODBE,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_POGODBE','',DIM,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_POGODBE',DIM,POGODBE,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_SISTEM
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_SISTEM');
DIMENSIONSORTORDER('PROD_MARZE_SISTEM','ByInput','ASCENDING','ByInput','ASCENDING');
ATTRDELETE('PROD_MARZE_SISTEM','PROD_MARZE_SISTEM');
ATTRINSERT('PROD_MARZE_SISTEM','','PROD_MARZE_SISTEM','A');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_SISTEM','',CHILD_ID,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_SISTEM','',PARENT_ID,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_SISTEM',PARENT_ID,CHILD_ID,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
ATTRPUTS(PARENT,'PROD_MARZE_SISTEM',PARENT_ID,'PROD_MARZE_SISTEM');
ATTRPUTS(CHILD,'PROD_MARZE_SISTEM',CHILD_ID,'PROD_MARZE_SISTEM');
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements***

PROCESS: PROD_MARZE_STATUS_LME
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_STATUS_LME');
DIMENSIONSORTORDER('PROD_MARZE_STATUS_LME','ByInput','ASCENDING','ByInput','ASCENDING');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_STATUS_LME','',STATUS_LME,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_STATUS_LME','',DIM,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_STATUS_LME',DIM,STATUS_LME,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_STATUS_NAROCILA
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_STATUS_NAROCILA');
DIMENSIONSORTORDER('PROD_MARZE_STATUS_NAROCILA','ByInput','ASCENDING','ByInput','ASCENDING');
ATTRDELETE('PROD_MARZE_STATUS_NAROCILA','STATUS_NAROCILA_ALIAS');
ATTRINSERT('PROD_MARZE_STATUS_NAROCILA','','STATUS_NAROCILA_ALIAS','A');
#****End: Generated Statements****
#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_STATUS_NAROCILA','',STATUS_NAROCILA,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_STATUS_NAROCILA','',DIM,'c');
DIMENSIONELEMENTINSERT('PROD_MARZE_STATUS_NAROCILA','',SKUPINA_STATUSA_NAROCILA,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_STATUS_NAROCILA',DIM,SKUPINA_STATUSA_NAROCILA,1.000000);
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_STATUS_NAROCILA',SKUPINA_STATUSA_NAROCILA,STATUS_NAROCILA,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
ATTRPUTS(STATUS_NAROCILA_ALIAS,'PROD_MARZE_STATUS_NAROCILA',STATUS_NAROCILA,'STATUS_NAROCILA_ALIAS');
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE_ZLITINA
#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS('PROD_MARZE_ZLITINA');
DIMENSIONSORTORDER('PROD_MARZE_ZLITINA','ByInput','ASCENDING','ByInput','ASCENDING');
#****End: Generated Statements****

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('PROD_MARZE_ZLITINA','',ZLITINA,'n');
DIMENSIONELEMENTINSERT('PROD_MARZE_ZLITINA','',DIM,'c');
DIMENSIONELEMENTCOMPONENTADD('PROD_MARZE_ZLITINA',DIM,ZLITINA,1.000000);
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

PROCESS: PROD_MARZE
#****Begin: Generated Statements***
OldCubeLogChanges = CUBEGETLOGCHANGES('PROD_MARZE');
CUBESETLOGCHANGES('PROD_MARZE', 0);
VIEWZEROOUT('PROD_MARZE','EmptyCube');
#****End: Generated Statements****

#****Begin: Generated Statements***
#****End: Generated Statements****

#****Begin: Generated Statements***
CellPutN(POG_LME_PONDER,'PROD_MARZE',CAS_POGODBE,CAS_FAKTURE,SISTEM,KUPEC,IZDELEK,STATUS_NAROCILA,KOMERCIALIST,POGODBE,LME_FORMULA,STATUS_LME,NA
CIN_OBDELAVE,ZLITINA,'POG LME PONDER');
CellPutN(POG_KOLICINA,'PROD_MARZE',CAS_POGODBE,CAS_FAKTURE,SISTEM,KUPEC,IZDELEK,STATUS_NAROCILA,KOMERCIALIST,POGODBE,LME_FORMULA,STATUS_LME,NACI
N_OBDELAVE,ZLITINA,'POG KOLIÄŒINA');
CellPutN(POG_PONDER,'PROD_MARZE',CAS_POGODBE,CAS_FAKTURE,SISTEM,KUPEC,IZDELEK,STATUS_NAROCILA,KOMERCIALIST,POGODBE,LME_FORMULA,STATUS_LME,NACIN_
OBDELAVE,ZLITINA,'POG PONDER');
CellPutN(FAKT_LME_PONDER,'PROD_MARZE',CAS_POGODBE,CAS_FAKTURE,SISTEM,KUPEC,IZDELEK,STATUS_NAROCILA,KOMERCIALIST,POGODBE,LME_FORMULA,STATUS_LME,N
ACIN_OBDELAVE,ZLITINA,'FAKT LME PONDER');
CellPutN(FAKT_KOLICINA,'PROD_MARZE',CAS_POGODBE,CAS_FAKTURE,SISTEM,KUPEC,IZDELEK,STATUS_NAROCILA,KOMERCIALIST,POGODBE,LME_FORMULA,STATUS_LME,NAC
IN_OBDELAVE,ZLITINA,'FAKT KOLIÄŒINA');
CellPutN(FAKT_PONDER,'PROD_MARZE',CAS_POGODBE,CAS_FAKTURE,SISTEM,KUPEC,IZDELEK,STATUS_NAROCILA,KOMERCIALIST,POGODBE,LME_FORMULA,STATUS_LME,NACIN
_OBDELAVE,ZLITINA,'FAKT PONDER');
CellPutN(PREDELAVA_PONDER,'PROD_MARZE',CAS_POGODBE,CAS_FAKTURE,SISTEM,KUPEC,IZDELEK,STATUS_NAROCILA,KOMERCIALIST,POGODBE,LME_FORMULA,STATUS_LME,
NACIN_OBDELAVE,ZLITINA,'PREDELAVA PONDER');
#****End: Generated Statements****

#****Begin: Generated Statements***
CUBESETLOGCHANGES('PROD_MARZE', OldCubeLogChanges);
#****End: Generated Statements****

I can't see any code that would remove / rebuild the cube, so it must be something else. Maybe you can go through your other chores/processes and search for anything like I really can't think of anything else right now.