Unable to Register view
-
- Posts: 57
- Joined: Fri Sep 17, 2010 11:57 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Unable to Register view
Hi
I am getting an error in the Message log when I run the chore consisting several processes.
'Error: Prolog procedure line (16) : unable to register view'
This error is in the process intialising and destroying view. Line 16 in the prolog procedure is Viewcreate(cubeName,viewname).
Could anybody have any idea?
regards,
Abi
I am getting an error in the Message log when I run the chore consisting several processes.
'Error: Prolog procedure line (16) : unable to register view'
This error is in the process intialising and destroying view. Line 16 in the prolog procedure is Viewcreate(cubeName,viewname).
Could anybody have any idea?
regards,
Abi
- Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: Unable to Register view
Hi,
I assume you get this message because you're trying to create a view that already exists. If you want to recreate the view use ViewDestroy followed by ViewCreate.
Michel
I assume you get this message because you're trying to create a view that already exists. If you want to recreate the view use ViewDestroy followed by ViewCreate.
Michel
-
- Posts: 57
- Joined: Fri Sep 17, 2010 11:57 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Unable to Register view
I am just trying to update the cube by running the chore. Everytime time you run the process it will be created and destroyed ?Michel Zijlema wrote:Hi,
I assume you get this message because you're trying to create a view that already exists. If you want to recreate the view use ViewDestroy followed by ViewCreate.
Michel
- Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: Unable to Register view
If recreating the view is part of the cube update process, than yes, the view will be recreated every time you run the chore.Abinaya wrote: I am just trying to update the cube by running the chore. Everytime time you run the process it will be created and destroyed ?
Are you creating the view as a datasource to another process or as a ZeroOut view or for other reasons?
Michel
-
- Posts: 57
- Joined: Fri Sep 17, 2010 11:57 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Unable to Register view
As part of zeroout view. because the error log is coming in the zero Out process.Michel Zijlema wrote:If recreating the view is part of the cube update process, than yes, the view will be recreated every time you run the chore.Abinaya wrote: I am just trying to update the cube by running the chore. Everytime time you run the process it will be created and destroyed ?
Are you creating the view as a datasource to another process or as a ZeroOut view or for other reasons?
Michel
- Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: Unable to Register view
Basic question still is: is the view you try to create destroyed before creation? If not, then this is the cause of your error message - the reason being that you're trying to create a view that already exists.
Michel
Michel
-
- Posts: 40
- Joined: Mon Mar 01, 2010 2:53 pm
- OLAP Product: TM1
- Version: 9.5 9.5.1 9.5.2
- Excel Version: 2007
Re: Unable to Register view
Hi Abi,Michel Zijlema wrote:Basic question still is: is the view you try to create destroyed before creation? If not, then this is the cause of your error message - the reason being that you're trying to create a view that already exists.
Michel
To complete Michel's argument, try
Code: Select all
IF (ViewExists(CUBENameBlabla, ViewNameBlabla) = 1);
ViewDestroy(CUBENameBlabla, ViewNameBlabla) ;
ENDIF;
ViewCreate(CUBENameBlabla, ViewNameBlabla) ;
Cheers!
Claude.
Cheers!
--
Claude-Sebastien Jean
Senior Consultant in Information Technology
Keyrus Canada
www.keyrus.ca
--
Claude-Sebastien Jean
Senior Consultant in Information Technology
Keyrus Canada
www.keyrus.ca
-
- Posts: 57
- Joined: Fri Sep 17, 2010 11:57 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Unable to Register view
thanks. It solved the problem.
-
- Site Admin
- Posts: 1453
- Joined: Wed May 28, 2008 9:09 am
Re: Unable to Register view
You can simplify this a little. ViewDestroy doesn't error if the view doesn't exist so you don't need the if test.
-
- Posts: 3
- Joined: Tue Nov 03, 2015 10:48 pm
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Unable to Register view
I just ran into an error on Planning Analytics local 2.0.2 IF4:
Unable to register view "<1>" in cube "<2>"
I tried a few different things; in the end I believe the error was caused by the length of my view name. I was making the view name unique by appending parameters, which normally isn't a problem, however this particular TI process takes enough parameters to be an issue. I have instead made it unique by appending a timestamp.
Unable to register view "<1>" in cube "<2>"
I tried a few different things; in the end I believe the error was caused by the length of my view name. I was making the view name unique by appending parameters, which normally isn't a problem, however this particular TI process takes enough parameters to be an issue. I have instead made it unique by appending a timestamp.
- orlando
- Community Contributor
- Posts: 167
- Joined: Fri Aug 04, 2017 8:27 am
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: Office 365
Re: Unable to Register view
that might be a problem of the windows max path lengthscjshown wrote: ↑Tue Dec 19, 2017 10:09 pm I just ran into an error on Planning Analytics local 2.0.2 IF4:
Unable to register view "<1>" in cube "<2>"
I tried a few different things; in the end I believe the error was caused by the length of my view name. I was making the view name unique by appending parameters, which normally isn't a problem, however this particular TI process takes enough parameters to be an issue. I have instead made it unique by appending a timestamp.
https://msdn.microsoft.com/en-us/librar ... px#maxpath
- wilsonric
- Posts: 15
- Joined: Mon Jan 10, 2011 4:36 am
- OLAP Product: TM1
- Version: 2.0.9
- Excel Version: 365 MSO 16-0-13127
- Location: Sydney, Australia
Re: Unable to Register view
Error: Prolog procedure line (110): Unable to register view "<1>" in cube "<2>"
We have found that another process (or even the same process) is currently using that view.
For example we have a process that updates our GL cube.
At monthend the accountants are loading journals into the ERP system, then running the GL cube update process to upload data from the ERP to the GL cube.
The accounting team have access to this upload process, so they often try and run it at the same time, resulting in this error.
They would not agree to limiting access to this upload process, so our work around was to install TM1 Top on all their machines, so they can reference this at monthend.
The error still occurs (less than before) but at least we can tell them to keep an eye on TM1 Top.
We have found that another process (or even the same process) is currently using that view.
For example we have a process that updates our GL cube.
At monthend the accountants are loading journals into the ERP system, then running the GL cube update process to upload data from the ERP to the GL cube.
The accounting team have access to this upload process, so they often try and run it at the same time, resulting in this error.
They would not agree to limiting access to this upload process, so our work around was to install TM1 Top on all their machines, so they can reference this at monthend.
The error still occurs (less than before) but at least we can tell them to keep an eye on TM1 Top.
Regards,
Richard
Richard
- orlando
- Community Contributor
- Posts: 167
- Joined: Fri Aug 04, 2017 8:27 am
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: Office 365
Re: Unable to Register view
Thanks for the reply - after three years
Then the process can run happily in parallel.
best regards,
see you in three years
orlando
Why don't you make the name of the view dynamic - e.g. with a timestamp or the name of the user who starts the process?wilsonric wrote: ↑Wed Feb 03, 2021 1:08 am The accounting team have access to this upload process, so they often try and run it at the same time, resulting in this error.
They would not agree to limiting access to this upload process, so our work around was to install TM1 Top on all their machines, so they can reference this at monthend.
Then the process can run happily in parallel.
best regards,
see you in three years
orlando