Tm1 Chrased

Post Reply
AnonimusMax
Posts: 60
Joined: Thu Nov 17, 2016 2:13 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Tm1 Chrased

Post by AnonimusMax »

Hi,

I have Persistent
All my client confidential information will be replaced by: confidential
The last executed actions before crash were 2 automatically chores that start a data load.
This load does not contain a bulk lode mode.

27756 [] INFO 2017-02-02 16:48:20.961 TM1.Chore Chore "confidential" time = 0.91 seconds
27756 [] INFO 2017-02-02 16:48:20.961 TM1.Chore Chore "confidential" finished executing
8672 [11a] INFO 2017-02-02 16:49:20.961 TM1.Process Process confidentialexecuted by user "confidential
8672 [11a] ERROR 2017-02-02 16:49:24.773 TM1.Process Process confidential: : Execution was aborted by ProcessQuit Function.
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Data Directory: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Admin Host: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Logging Directory: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Configuration Directory: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Raw Store Directory: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Port: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Client Message Port: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Client Message Port does not accept Tm1Top connections.
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Export Admin Server Certificate: 0
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Admin Server Certificate Authority: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Admin Server SSL Cert ID: tm1adminserver
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server IP Version: ipv4
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server SSL Mode: 1
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Export Server Certificate: 0
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server SSL Certificate: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Certificate Authority: tm1ca_v2.pem
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Client Export Server Certificate: 0
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server DH 512 File: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server DH 2048 File: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Private Key Password File: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Password Key File: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Security Mode: 5
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Use Generic Login Connect Error:
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Server CAM URI: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Server CAM URI Retry Attempts: 1
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Client CAM URI: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Web CAM URI: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Client Ping CAM Passport: confidential
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Start time: Thu Feb 02 2017 09:32:50 PM
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server The server will use Parallel Interaction.
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Server threading mode is thread per connection.
23460 [] INFO 2017-02-02 20:32:50.834 TM1.Server Client Message Port does not accept Tm1Top connections.
23460 [] INFO 2017-02-02 20:32:51.053 TM1.Server MTQ is enabled with 8 threads
23460 [] INFO 2017-02-02 20:32:51.053 TM1.Server Using javaextensions.policy from confidential
23460 [] INFO 2017-02-02 20:32:51.053 TM1.Server Creating Java Virtual Machine with arguments:
23460 [] INFO 2017-02-02 20:32:51.053 TM1.Server -Djava.security.policy=confidential
23460 [] INFO 2017-02-02 20:32:51.053 TM1.Server -Djava.class.path=java_classes;confidential
23460 [] INFO 2017-02-02 20:32:51.053 TM1.Server -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=confidential
23460 [] INFO 2017-02-02 20:32:51.053 TM1.Server end JVM args
30220 [] INFO 2017-02-02 20:32:51.896 TM1.Server --------------------Session Start--------------------
30220 [] INFO 2017-02-02 20:32:51.896 TM1.Server TM1 Build Number: 10.2.20500.75
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Tm1 Chrased

Post by TrevorGoss »

AnonimusMax wrote:Hi,

I have Persistent
All my client confidential information will be replaced by: confidential
The last executed actions before crash were 2 automatically chores that start a data load.
This load does not contain a bulk lode mode.
What does it say in the error logs (if they exist) of the TI that were fired by the chore?

Trevor
User avatar
gtonkin
MVP
Posts: 1199
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Tm1 Chrased

Post by gtonkin »

AnonimusMax wrote:...
30220 [] INFO 2017-02-02 20:32:51.896 TM1.Server TM1 Build Number: 10.2.20500.75
IMHO I would upgrade to FP6 as soon as possible or go back to FP4 - FP5 was plagued by all sorts of issues.
Not saying that it will fix all your issues as you seem to come up with new and improved ones each day but should reduce those that many dev's have avoided.
AnonimusMax
Posts: 60
Joined: Thu Nov 17, 2016 2:13 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Tm1 Chrased

Post by AnonimusMax »

Thank you for the fast response.
They don t exist.
There is a Master Load Process that first runs Dimension update, then updates the cubes , then it does some calculation and after that is exporting a CSV that is bulk load into a Oracle DB ( the csv ).
The Information in coming from ORACLE with an SQL query and based on that i Update the dimension using DimesnionelementinsertDirect and DIMENSIONELEMENTCOMPONENTADDDIRECT ( for All element). Can this be a problem?
I also have persistentFeeders turned to T but i don t think this is the problem...

Thank you
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Tm1 Chrased

Post by TrevorGoss »

AnonimusMax wrote:Thank you for the fast response.
They don t exist.
There is a Master Load Process that first runs Dimension update, then updates the cubes , then it does some calculation and after that is exporting a CSV that is bulk load into
Thank you
There is an aborted process in the start of your server, is that related?


Trevor.
Last edited by TrevorGoss on Fri Feb 03, 2017 10:33 am, edited 1 time in total.
AnonimusMax
Posts: 60
Joined: Thu Nov 17, 2016 2:13 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Tm1 Chrased

Post by AnonimusMax »

I have manually started the Master process that run before the server crashed ( with same input parameters) and it finished with no error.
The processQuit was part of a process that was started by the Master Load Process.
what do you mean by "have you tried starting the server without running the chores at start up?"

The problem is that the server crashed every day, this was not an isolate incident. it usually crashed at night time when the chore that is running the Load master Process was started. But this chore is running all day from 5 to 5 min, and many load were successfully finished by it.
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Tm1 Chrased

Post by TrevorGoss »

AnonimusMax wrote:I have manually started the Master process that run before the server crashed ( with same input parameters) and it finished with no error.
The processQuit was part of a process that was started by the Master Load Process.
what do you mean by "have you tried starting the server without running the chores at start up?"

The problem is that the server crashed every day, this was not an isolate incident. it usually crashed at night time when the chore that is running the Load master Process was started. But this chore is running all day from 5 to 5 min, and many load were successfully finished by it.
Just a guess, but do you turn off logging when you run this load process?
AnonimusMax
Posts: 60
Joined: Thu Nov 17, 2016 2:13 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Tm1 Chrased

Post by AnonimusMax »

No, i do not turn it off...We are able to see the files in the log folder.
Post Reply