TM1 Forum

Hi All,

I have a calculation which references a value calculated in another cube. I have setup a feeder in the source cube to feed the calculation:

Destination Cube:

['Calc'] = DB('SourceCube','Calc');

Source Cube:

['Calc'] => DB('DestinationCube','Calc');

which to me seems logical enough and has been working ok, the problem i have is that i shut down my TM1 server and when i restart it doesn't load and appear in my server explorer window. If i remove or comment out the Feeder the server loads properly and appears in my server explorer. The weird thing is I've since rebuilt the feeder using the DB button in the rules editor (just to check i had the dimensions in the right order) and it checks the syntax and saves fine, it's only when i go to restart the server that it breaks and stops the whole server, when i look at the message log I see:

FATAL tm1.lock IX Conflict Encountered during single threaded operation in CheckReadOnlyConflict

Does anyone know what is going on? As I say this was working up until today and TM1 allowed me to save the problem feeder

Cheers

Dubs

I think I've solved this- I was using multiple processors when loading the server so switched that back to one and it has loaded and the feeder works.

I think this is a bug, will try and do some more testing to verify.

Cheers

Dubs

How often is the calculation updated? Do you need live updates? If not use TI to transfer and calculate the dat ainstead, then you'll be able to switch multi-thread loading back on,

Jim.

Hi Jim,

It is a real-time rule which needs to recalc everytime the data is refreshed. The calcs are all done in a calcs cube because doing them on the output cube used for reports slows it down to a crawl due to the amount of calcs/feeders being used.

Some of these calcs need to be done at the consolidation levels of my hierarchy so im having to use inter-cube feeders and calcs to get these represented in the output cube due to the fact that you cannot load data into a consolidation point so I think I'll just have to live without the multi-thread loading fow now.

Thanks for the suggestion

Dubs

Hi dubs

Multi Threaded Server Load can only be used if you don't have any conditional feeders. At least that's the documented limitation.
As your feeder example is simplified I cannot say whether that is the case for you. I am also not sure whether this limitation also applies on simple inter cube feeders but apparently that is what you found out.

Cheers

Hi Gregor,

I wasn't using conditional feeders so think it may be something to do with an inter-cube feeder issue. The bizarre thing is that somehow my cfg file was changed back to use 3 processors yet it doesn't seem to corrupt when the server is restarted, so it seems its intermittant!

Will post any further finding.

Many Thanks

Dubs