TM1 Forum

Nothing is changed to the user that runs the TM1 service and a TM1-Save works fine. It's just that when I try to run (or edit) a TI-process that uses an ODBC-connection the system hangs. I guess the messages in the windows event log occur when the server is restarted after I had to manually stop the...

On the client side we use Office 2007 on XP, on the server it's 2003 R2.
During the upgrade we will up that to Office 2013 on Windows 8 and Server 212 R2.

In the windows event viewer I only see errors like The description for Event ID ( 0 ) in Source ( tm1sd ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag t...

I have changed the SQL query to something simple like "SELECT 1,2,3;" A stored view is no option in our environment. I tried the ODBC trace (see my post on 9 May 10:48) but without any results. We are going to upgrade in a few weeks but I am afraid that (if it's indeed an ODBC problem) it ...

The system hang at Security > Client/Groups seems to be resolved (for now) but the import problem remains, so maybe it is indeed an ODBC problem.
I am out of ideas how I can determine what causes the problem and how it can be solved... Who can help ?

Thanks for your info, I tried that but sadly that did not work either : An empty log-file is created but when I start the import-process nothing is logged. I tried manually setting the trace flag to 1 and machine wide tracing both to no avail. I guess that means that the problem occurs before TM1 tr...

I added the following line to the tm1s-log.properties file log4j.logger.TM1.Sql=DEBUG That doesn't seem to do anything. When I start a process it still hangs with only a info in tm1server.log that the process is executed. So I thought maybe it interferes with the other lines in tm1s-log.properties l...

I've also cleared with our IT that there was no change in the network environment

I guess that would not work because I do not connect with Oracle but with Teradata. Nevertheless I've tried the following three options separately to no avail ...
UseSQLFetch=T
UseSQLFetchScroll=T
UseSQLExtendedFetch=T

I don't see such a button, I guess that is not present in version 9.1 SP 3

I see no related messages in tm1server.log The ODBC connection works fine outside TM1 (Teradata SQL Assistant). The query returns data in just a second, it's a simple query on 1 table : Select Case When Groep = 1 Then 'Actie' When Groep = 2 Then 'Overig' Else 'Bestelling' End Groep, Cast((Actiecode ...

Hello Forum, Since yesterday we see server hang problems when we try to execute a importprocess. Sometimes it is then needed the user restarts Excel to make cubes accessible to him again (sadly without releasing the TM1 user connection, so that's no practical solution). Sometimes closing Excel is no...

If a dimension has less than sixteen elements its coordinates will only need one level of the tree. If there are e.g. between 4096 (16^3) and 65535 (16^4 - 1) they will need four. Each level of the tree adds to the space taken up, although it is in no way linear. It will depend on how the cells are...

Thanks four your quick responses ! We don't have TM1RunTI, I guess that's around since 9.5.2 but we still use 9.1. (Sorry I didn't know about the RFA, I've update the profile info). TIExecute looks promising but maybe a bit too complicated to setup for just one process. As a (temporary) quickfix/wor...

Hello Forum, Is there a way to add new elements to a dimension on the fly during the import of new data using a process worksheet instead of TI ? I would like to be able to add new elements to a dimension on the fly during the import of new data. I know that by using a TI process this can be achieve...

Hello Forum, One of our users had KEY_ERR errors in a slice from TM1. When I open the same Excel-sheet on my PC the data appears without errors. The user can query the cubes using the Server Explorer and make snapshots without problems, but when she tries to save a slice she gets KEY_ERR errors. I t...

I understand, but for now we would like to have a quick solution without issues (e.g. no other user-interface for end users) because we do not have much time/capacity at the moment to address this problem. Our support managers leaves by the end of the year :(, so we are looking for an easy solution ...

Never mind, I was using the Search but I have found the Load button

Hello Forum, We have TM1 version 8.2 running on a Windows 2000 server with SP4. But the server crashes regularly. We would like to upgrade the server to Windows 2003 in order to get a more stable environment Is that possible and easy with the 8.2 version ? Are there any issues we should be aware of ...

...and another fool who used Save in stead of Send...
A Question : where do I find my "draft" so I can send it ?
Or is it gone and I have to retype it ?