RulesOverwriteCellsOnLoad is NOT working
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
RulesOverwriteCellsOnLoad is NOT working
Hi, all
My version is 10.2.2 FP7, I put a numeric value into a cell, e.g. 888 and then applied a rule to get value from another cell, e.g. 999.
The parameter RulesOverwriteCellsOnLoad is not in the config file and I restart the server, disable the rule, the original value 888 is still there.
According to https://www.ibm.com/support/knowledgece ... nload.html It should be true if this parameter is not present in the configuration file.
Even if I put RulesOverwriteCellsOnLoad=T into config file and reboot, the original value 888 is still there.
And then I put RulesOverwriteCellsOnLoad=F into config file and reboot, the original value 888 is still there.
It looks like RulesOverwriteCellsOnLoad has no effect at all, am I doing something wrong here? Thanks.
My version is 10.2.2 FP7, I put a numeric value into a cell, e.g. 888 and then applied a rule to get value from another cell, e.g. 999.
The parameter RulesOverwriteCellsOnLoad is not in the config file and I restart the server, disable the rule, the original value 888 is still there.
According to https://www.ibm.com/support/knowledgece ... nload.html It should be true if this parameter is not present in the configuration file.
Even if I put RulesOverwriteCellsOnLoad=T into config file and reboot, the original value 888 is still there.
And then I put RulesOverwriteCellsOnLoad=F into config file and reboot, the original value 888 is still there.
It looks like RulesOverwriteCellsOnLoad has no effect at all, am I doing something wrong here? Thanks.
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: RulesOverwriteCellsOnLoad is NOT working
I can confirm same situation on PAL 2.0.6. Has anyone really got this parameter working as expected?
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: RulesOverwriteCellsOnLoad is NOT working
Anyone can give advice?
-
- Regular Participant
- Posts: 159
- Joined: Fri Aug 12, 2016 10:02 am
- OLAP Product: tm1
- Version: 10.2.0 - 10.3.0
- Excel Version: 2010
Re: RulesOverwriteCellsOnLoad is NOT working
TM1SERVER_APP_version=TM1SERVER_APP-AW64-ML-RTM-11.0.6.71-0
WORKED FINE.
write some data in cube. append on this slice rule savedataall restart.
RulesOverwriteCellsOnLoad=F data save after disable rule
RulesOverwriteCellsOnLoad=T data loss after disable rule
WORKED FINE.
write some data in cube. append on this slice rule savedataall restart.
RulesOverwriteCellsOnLoad=F data save after disable rule
RulesOverwriteCellsOnLoad=T data loss after disable rule
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: RulesOverwriteCellsOnLoad is NOT working
hi, Drg
I have same version as yours but not working.
What I have done is, set RulesOverwriteCellsOnLoad=T first, savedataall and reboot.
create a simple cube with simple value, attach a rule for copying value from "3" cell, savedataall and reboot after rebooting, disable the rule,
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: RulesOverwriteCellsOnLoad is NOT working
and those two original values "1" and "2" are still there
What's wrong here???
-
- Regular Participant
- Posts: 159
- Joined: Fri Aug 12, 2016 10:02 am
- OLAP Product: tm1
- Version: 10.2.0 - 10.3.0
- Excel Version: 2010
Re: RulesOverwriteCellsOnLoad is NOT working
I have read the documentation and I understand its name as shown in the picture below.
Another question that I found an interesting feature is that it is marked with the third option. I suppose this is updated with the update of the cube and in combat situations it will lead you according to the documentation.
Another question that I found an interesting feature is that it is marked with the third option. I suppose this is updated with the update of the cube and in combat situations it will lead you according to the documentation.
-
- Regular Participant
- Posts: 159
- Joined: Fri Aug 12, 2016 10:02 am
- OLAP Product: tm1
- Version: 10.2.0 - 10.3.0
- Excel Version: 2010
Re: RulesOverwriteCellsOnLoad is NOT working
Yes today we update to 2.0.7
Other configs.
[TM1S]
ServerLogging=F
SecurityPackageName=Kerberos
IntegratedSecurityMode=1
UseSSL=T
ServerName=HauptAbu1
DataBaseDirectory=D:\PAModels\HauptAbu1
AdminHost=
PortNumber=
ClientMessagePortNumber=
Savetime=
Downtime=
LicenseMetricTime=
ProgressMessage=True
AuditLogOn=T
AuditLogMaxFileSize= 100 MB
AuditLogUpdateInterval=60
PersistentFeeders=F
ParallelInteraction=T
IPVersion=ipv4
ServerCAMIPVersion=ipv4
AllowSeparateNandCRules=T
DistributedPlanningOutputDir=tunit
ForceReevaluationOfFeedersForFedCellsOnDataChange=T
RunningInBackground=T
LoggingDirectory=
Other configs.
[TM1S]
ServerLogging=F
SecurityPackageName=Kerberos
IntegratedSecurityMode=1
UseSSL=T
ServerName=HauptAbu1
DataBaseDirectory=D:\PAModels\HauptAbu1
AdminHost=
PortNumber=
ClientMessagePortNumber=
Savetime=
Downtime=
LicenseMetricTime=
ProgressMessage=True
AuditLogOn=T
AuditLogMaxFileSize= 100 MB
AuditLogUpdateInterval=60
PersistentFeeders=F
ParallelInteraction=T
IPVersion=ipv4
ServerCAMIPVersion=ipv4
AllowSeparateNandCRules=T
DistributedPlanningOutputDir=tunit
ForceReevaluationOfFeedersForFedCellsOnDataChange=T
RunningInBackground=T
LoggingDirectory=
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: RulesOverwriteCellsOnLoad is NOT working
Appreciated your testing! I found my root cause now. It is because of PersistentFeeders. I have that enabled and obviously, after disabling, RulsOverwriteCellsOnLoad works as expected.Drg wrote: ↑Fri May 17, 2019 10:17 am I have read the documentation and I understand its name as shown in the picture below.
Another question that I found an interesting feature is that it is marked with the third option. I suppose this is updated with the update of the cube and in combat situations it will lead you according to the documentation.
123.png
I noticed your third testing. Yes, it did happen to me as well and I have done further testing on that. Once they are zeros before rebooting with RulsOverwriteCellsOnLoad=F, if you write some new values to same cells, these old rule-overwritten values won't come back after rebooting. Seems that they have been deleted permanently. I am guessing IBM is using some "roll-back" mechanism to cache these old values somewhere for rolling back. Anyway, it is good to know.
-
- MVP
- Posts: 3661
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: RulesOverwriteCellsOnLoad is NOT working
That's interesting. RulsOverwriteCellsOnLoad should be independent of PersistentFeeders! That this doesn't work when PersistentFeeders is switched on might say something to the recent bugs where (persistent) feeders deleted data on server load
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: RulesOverwriteCellsOnLoad is NOT working
That is my original thought too. But what I tell is if you have PersistentFeeders switched on in 10.2.2 FP7, this parameter still doesn't work after testing.