TM1 Forum

Could you put the SQL insert statement into a variable and ASCIIOutput the variable into a file. Make sure that you set DatasourceASCIIQuoteCharacter to '' in the prolog. Then you will see exactly what it is sending. Also it would be useful to see in detail what the characteristics of each field in ...

Could you also include a "describe" of the SQL table and a picture of the variables tab of the process so that we can see how the TM1 variables and the SQL fields are defined?

The key thing with manually editing .pro files (apart from don't ) is to ensure that the line count for each code section is correctly shown in the header row for that section. Each code section is identified by a header row with two numbers, the first identifying which section it is and the second ...

The calculation threshold affects when individual calculated or aggregated cells are stored in the calculation cache, which is completely separate from the view cache, which is controlled by the VMM and VMT parameters. In reality they are related as if you have cached stargates it can make individua...

I presume you turned monitoring on for the server and waited a minute then refreshed.

Remember - take backups before you change anything, and don't get sucked in to spending too much time.

https://xkcd.com/356/

One thing you could do is to look into some working .cub files with a hex editor and see if there is a common byte pattern at the front, which would probably be some sort of internal file format/version stamp. If you find that all the valid .cub files start with the same few bytes you could look at ...

Given that the server died, and that these are messages from the server log, it seems quite likely that "TM1.Client" means that this is an error raised by a server class for handling the interaction with the client. One way to test this would be to increase the log level of TM1.Client (to ...

I have a vague memory that the new "In cube calculation" feature of Performance Modeler has a slightly different syntax, but that it generates normal rule statements under the cover. Perhaps there is an IBMer or IBM Partner out there who is familiar with demonstrating it and can confirm or...

Stanislav2 wrote:Can you please point me to some documentation how to do this?

This is the best post on the forum about logging stargates.

If the exact value you are seeing is 4.94066e-324 then check whether you have (or have ever had) UNDEFVALS in the cube rule. This is the value TM1 uses to represent a null cell when UNDEFVALS is specified.

[EDIT] and BTW another interesting link

I think you need ISUND.

or an alternative picklist cube rule might be ...

Excellent. Looks as if the new job has taught me something useful after all.

So how is the picklist defined? If it is in a picklist cube then when you write to a cell you are executing the rule in the picklist cube to determine the possible options for the cell. There are circumstances (infinite recursion used to be one) in which that can kill the server.

The way the rule is written it seems that you are calculating the ratio for "all regions" and applying it to every region. Is this what you had intended? Have you done a trace as suggested by tomok to check that this is the actual statement that is being used for the cell in question? In o...

Read through this post and everything linked from it. This is a common problem discussed in this forum frequently.

Here is an interesting link http://www-01.ibm.com/support/knowledgecenter/SS7JFU_6.1.0/com.ibm.websphere.express.doc/info/exp/ae/tprf_tunejvm_v61.html The particularly interesting bit is here -Xmn This setting controls how much space the young generation is allowed to consume on the heap. Properly t...

Try this

It is possible that there is not actually a memory leak, but instead that a large amount of memory has been allocated to Tomcat and the Java run-time is not doing garbage collection because it doesn't need to. Is there any way you can find and post the Java start-up options?