Search found 329 matches

by mce
Thu Jul 02, 2020 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 217

Re: SQL Query Length Limit for TI

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 ...
by mce
Thu Jul 02, 2020 2:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 217

Re: SQL Query Length Limit for TI

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 ...
by mce
Thu Jul 02, 2020 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 217

Re: SQL Query Length Limit for TI

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...
by mce
Thu Jul 02, 2020 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 217

SQL Query Length Limit for TI

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
by mce
Fri Jun 19, 2020 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash in PA 2.0.7
Replies: 3
Views: 160

Re: TM1 Server Crash in PA 2.0.7

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...
by mce
Fri Jun 19, 2020 8:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash in PA 2.0.7
Replies: 3
Views: 160

TM1 Server Crash in PA 2.0.7

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...
by mce
Fri Jun 19, 2020 7:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.9 Upgrade Concerns
Replies: 3
Views: 242

PA 2.0.9 Upgrade Concerns

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...
by mce
Thu Jun 18, 2020 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web URL API and Action Button Issue
Replies: 6
Views: 240

Re: TM1Web URL API and Action Button Issue

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.
by mce
Mon Jun 15, 2020 9:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web - Hyperlink or Action Button to open a Cube View
Replies: 18
Views: 12226

Re: TM1Web - Hyperlink or Action Button to open a Cube View

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.
by mce
Mon Jun 15, 2020 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ISSUE IN MDX VIEW AS DATA SOURCE
Replies: 4
Views: 198

ISSUE IN MDX VIEW AS DATA SOURCE

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...
by mce
Mon Jun 15, 2020 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web URL API and Action Button Issue
Replies: 6
Views: 240

Re: TM1Web URL API and Action Button Issue

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...
by mce
Sun Jun 14, 2020 8:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web - Hyperlink or Action Button to open a Cube View
Replies: 18
Views: 12226

Re: TM1Web - Hyperlink or Action Button to open a Cube View

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. :x :?
by mce
Sun Jun 14, 2020 8:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web - Hyperlink or Action Button to open a Cube View
Replies: 18
Views: 12226

Re: TM1Web - Hyperlink or Action Button to open a Cube View

TM1 Drill functionality does not work when cube view is opened via TM1Web URL API :?
by mce
Sun Jun 14, 2020 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web URL API and Action Button Issue
Replies: 6
Views: 240

TM1Web URL API and Action Button Issue

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 ...
by mce
Tue Jun 02, 2020 11:45 pm
Forum: Enhancements
Topic: Transfer of data between servers
Replies: 6
Views: 333

Re: Transfer of data between servers

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... :)
by mce
Tue Jun 02, 2020 11:43 pm
Forum: Enhancements
Topic: Transfer of data between servers
Replies: 6
Views: 333

Re: Transfer of data between servers

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...
by mce
Mon May 11, 2020 10:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.ClientMessage Could not read message header
Replies: 2
Views: 1682

Re: TM1.ClientMessage Could not read message header

Hello,
I see this error in tm1server logs in version PA 2.0.7. What could be the reason for this?
Regards,
by mce
Sun Mar 29, 2020 8:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crash due to subset corruption
Replies: 10
Views: 3110

Re: Server crash due to subset corruption

similar issue after so many years.
PH17265: TM1 SERVER CRASH DUE TO CORRUPT SUBSET
at
https://www.ibm.com/support/pages/node/3799731
by mce
Fri Dec 06, 2019 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing Gagteway Ports for PAW in Linux
Replies: 1
Views: 224

Changing Gagteway Ports for PAW in Linux

Hello,

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

Regards,