TM1 Forum

There's a bit of conjecture over whether the limit is 32k, 64k or something in between. It does depend whether unicode character sets are used or not, but whatever the exact ceiling the size limit is still going to apply to the DatasourceQuery query variable. Thanks for the info. I am still within ...

Hi, why you dont create a SQL View and just import the View? You can also build 2-6 or more views and combine them to one view for the import. Thats how we handle big SQL Statements to bring it into a Importable format for TM1. BR 1 - Need to keep the logic in TM1 for further changes and additions ...

Per this thread, a TM1 string cannot be > 32k so that would limit an ODBCOutput statement. https://www.tm1forum.com/viewtopic.php?f=3&t=14179&p=70027&hilit=tm1+string+size#p70027 My Query is not for ODBCOutput. Rather it is for SQL when importing data to TM1. Actuall I do not need to put all SQL qu...

Hello,

Is there any limit about the length of the final SQL statement that is passed from Turbo Integrator process to an Oracle DB?
Thanks in advance for any responses.

Regards

There is no special messages in the tm1server log. There is no message about memory issue. No errors at all. It suddenly goes down. In TM1Top, we can see that the last operation was a cube view being oped by a user. Issue is not specific to any cubes or any views. It intermittently happens when a us...

Hello, In one of our large PROD TM1 servers, the TM1 server keep crashing intermittently when a user tries to open views, especially when opening larger cube views that exceed view memory limit. Crash happens almost every day. Anyone else observing similar issues? Since the server is too large, I ca...

Hello, Anyone upgraded to PA 2.0.9x in PROD environments? If so, have you seen any major issues in this version? From my point of view, I have the following concerns: - Removal of TM1 Operations Console, and not having any TM1 server monitoring tool for non-admin users, except TM1Top. - Change of be...

I now realized that IBM's PA demo environment is not 2.0.9.1. It is an IF of 2.0.9. Hence it does not have this fix there. Will check it in 2.0.9.1 separately.

ykud wrote: ↑

Sun Jun 14, 2020 11:20 pm

What version of PA you're on? It was a bug we saw in one of the 2.0.6 IFs for tm1web, it should be fixed in 2.0.9.1

we observed the problem in 2.0.9.1 in IBM demo server and in 2.0.8 in our client.

I just found this: https://www.ibm.com/support/pages/apar/PH16537?myns=apar&mynp=DOCTYPEstatus&mync=E&cm_sp=apar-_-DOCTYPEstatus-_-E PH16537: TI-PROCESS WITH VALID BUT EMPTY MDX VIEW AS DATA SOURCE THROWS MAJOR ERROR AND ABORTS When a TI process has as DatasourceType='VIEW' and the view is a MDX vie...

Thanks for the comments. Could you note of the APAR number for the fix you get in 2.0.6 so that we can refer to the same issue and tell them it is appearing in the latest version as well. When we tested this in 2.0.8, we saw that this problem is there as well. Ah, I can see you raised in a couple of...

Action buttons to move to a different websheet does not work when the websheet of the action button is originally opened via TM1Web URL API.

TM1 Drill functionality does not work when cube view is opened via TM1Web URL API

Hello, We have a problem with URL API and actions buttons in TM1Web. When a websheet is opened via URL API, the action buttons that open other websheets or other sheets of the same tm1workbook does not work. Anyone avare of this issue? What is the solution? I need to get websheet opened via URL API ...

mce wrote: ↑

Tue Jun 02, 2020 11:43 pm

Such a tool that is not able to integrate its own data from its different databases. TM1 server A cannot read data from TM1 server B in a very simple and straightforward mechanism. That is a shame.

In between...

I am also in favor of option 2. I do not understand how come IBMers can avoid adding this type of a very basic and must have functionality. Such a tool that is not able to integrate its own data from its different databases. TM1 server A cannot read data from TM1 server B in a very simple and straig...

I just found this document:
https://www.ibm.com/support/pages/tm1se ... C%E3%82%8B

Hello,
I see this error in tm1server logs in version PA 2.0.7. What could be the reason for this?
Regards,

similar issue after so many years.
PH17265: TM1 SERVER CRASH DUE TO CORRUPT SUBSET
at
https://www.ibm.com/support/pages/node/3799731

Hello,

Does anyone know how to change Gateway Ports for PAW in Linux RHEL?
We keep getting errors about PA-Gateway?

Regards,