After almost 12 hours of looking for logic, I am going to look for assistance.
Server running on 10.2.2 base (corporate environment, upgrade to FP4 been pending for months)
The cube has 11 dimensions and various rules, feeders etc. as you would expect
If I navigate to a leaf area and type in a value - server crashes - client gets a connection error.
No information in the TM1Server.log
Configures tm1s-log.properties and set to DEBUG - reams of infor, server ready, then nothing further.
Crash happens if you dirty the cube via Perspectives, Architect or Web
A data spread however seems to be fine-repating or clearing.
Nothing in TM1S.Log either after crash. The cube is flagged to log and does log the data spreads and clears.
I deleted, recreated the cube, added the rules back on uploaded the data from an extract on the dev box - all seems fine. Copied the cube back to UAT, deleted all.feeders, restarted, entered a value - bang!
Any ideas besides going to FP4 which seems to work on local dev box?
Server crash after data entry
-
- Community Contributor
- Posts: 247
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Server crash after data entry
I've had a similar issue which turned out to be a corrupt attribute, have you recreated the elements? Are you seeing issues with other cubes?
- gtonkin
- MVP
- Posts: 1192
- 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: Server crash after data entry
Thanks for the input Edward. Other cubes are fine. All but 3 dimensions are shared so going to start by deleting the attributes from the non-shared dims first.
- gtonkin
- MVP
- Posts: 1192
- 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: Server crash after data entry
Stopped server, Deleted the }ElementAttributes cubes, restarted server, added data to cube - "Data spread failed" then "(SystemServerConnectionInvalid) : Server connection error - server dead!
- gtonkin
- MVP
- Posts: 1192
- 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: Server crash after data entry
Have deleted the cube, recreated on the server where it was an issue, restored data, rules, views etc.
For now, all seems fine.
What I am wondering now is if by deleting the cube on the "defective" system, the relevant control cubes and possibly logs were updated/aligned correctly.
The only thing that comes to mind now is that I had not removed all the logs but had made sure that before restoring the cube each time, the server had been started and stopped normally.
Any other ideas as to what to check-concerned that this could just happend again so do not want to assume fixed. Thanks for any ideas.
For now, all seems fine.
What I am wondering now is if by deleting the cube on the "defective" system, the relevant control cubes and possibly logs were updated/aligned correctly.
The only thing that comes to mind now is that I had not removed all the logs but had made sure that before restoring the cube each time, the server had been started and stopped normally.
Any other ideas as to what to check-concerned that this could just happend again so do not want to assume fixed. Thanks for any ideas.
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Server crash after data entry
No idea if this is still the case but at one time if you had a circular reference that was enabled conditional on some data entry, and if the circularity involved multiple cubes then the server didn't detect it and blew up with stack full.
As I said I have no idea if this is still the case.
As I said I have no idea if this is still the case.
- gtonkin
- MVP
- Posts: 1192
- 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: Server crash after data entry
Thanks Duncan - I definitely had a case where something like this happened:Duncan P wrote:... if you had a circular reference that was enabled conditional on some data entry, and if the circularity involved multiple cubes then the server didn't detect it and blew up with stack full.
Entry for Attrition %, Attrition calculated based on Average Balance, Average balance calculated as (Opening Balance + Closing Balance)/2
Closing Balance is a rollup of Opening Balance, New Sales, Attrition. Circular reference!
These however are all in the same cube but the stack definitely blew-numerous error messages in the logs.
I guess the question then is, what did you do to resolve after having it blow up? I fixed the rule, exported and recreated the cube then imported again. For now, touch wood, all is fine.
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: Server crash after data entry
Sorry, I may not all the specific here, but why do you need to calculate Avg Balance with the rule? Cant you just use weighting to get your avg balance: avg: opening + 0.5 / closing 0.5Entry for Attrition %, Attrition calculated based on Average Balance, Average balance calculated as (Opening Balance + Closing Balance)/2
Regards
- gtonkin
- MVP
- Posts: 1192
- 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: Server crash after data entry
I have some N level rules to do currency translations across 12 currencies and have opted for rule derived rather than using consolidations at this stage.EvgenyT wrote:... Cant you just use weighting to get your avg balance: avg: opening + 0.5 / closing 0.5 ...
Thanks however for the suggestion.