Page 1 of 1

Unable to Register view

Posted: Mon Mar 07, 2011 9:35 am
by Abinaya
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

Re: Unable to Register view

Posted: Mon Mar 07, 2011 9:42 am
by Michel Zijlema
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

Re: Unable to Register view

Posted: Mon Mar 07, 2011 10:01 am
by Abinaya
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
I am just trying to update the cube by running the chore. Everytime time you run the process it will be created and destroyed ?

Re: Unable to Register view

Posted: Mon Mar 07, 2011 10:09 am
by Michel Zijlema
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 ?
If recreating the view is part of the cube update process, than yes, the view will be recreated every time you run the chore.
Are you creating the view as a datasource to another process or as a ZeroOut view or for other reasons?

Michel

Re: Unable to Register view

Posted: Mon Mar 07, 2011 10:20 am
by Abinaya
Michel Zijlema wrote:
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 ?
If recreating the view is part of the cube update process, than yes, the view will be recreated every time you run the chore.
Are you creating the view as a datasource to another process or as a ZeroOut view or for other reasons?

Michel
As part of zeroout view. because the error log is coming in the zero Out process.

Re: Unable to Register view

Posted: Mon Mar 07, 2011 10:52 am
by Michel Zijlema
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

Re: Unable to Register view

Posted: Mon Mar 07, 2011 2:27 pm
by csjean
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
Hi Abi,

To complete Michel's argument, try

Code: Select all

IF (ViewExists(CUBENameBlabla, ViewNameBlabla) = 1);
  ViewDestroy(CUBENameBlabla, ViewNameBlabla) ;
ENDIF;

ViewCreate(CUBENameBlabla, ViewNameBlabla) ;
It should resolve your issue if the problem is the existence of the view that you are trying to create.

Cheers!

Claude.

Re: Unable to Register view

Posted: Sat May 28, 2011 2:10 am
by Abinaya
thanks. It solved the problem.

Re: Unable to Register view

Posted: Sat May 28, 2011 8:17 am
by David Usherwood
You can simplify this a little. ViewDestroy doesn't error if the view doesn't exist so you don't need the if test.

Re: Unable to Register view

Posted: Tue Dec 19, 2017 10:09 pm
by cjshown
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.

Re: Unable to Register view

Posted: Wed Dec 20, 2017 10:40 am
by orlando
cjshown 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.
that might be a problem of the windows max path lengths
https://msdn.microsoft.com/en-us/librar ... px#maxpath

Re: Unable to Register view

Posted: Wed Feb 03, 2021 1:08 am
by wilsonric
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.

Re: Unable to Register view

Posted: Wed Feb 03, 2021 10:11 am
by orlando
Thanks for the reply - after three years :lol:
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.
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?
Then the process can run happily in parallel.

best regards,
see you in three years ;)
orlando

Re: Unable to Register view

Posted: Tue Feb 09, 2021 5:51 am
by wilsonric
Yep - good idea!