Unable to pull views in TM1 Cafe

Post Reply
rni
Posts: 7
Joined: Tue Feb 07, 2017 2:48 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2010

Unable to pull views in TM1 Cafe

Post by rni » Fri Sep 08, 2017 6:58 am

Hi All,

When I try to pull some views from the package, It shows 'working' but then nothing appears (not even an error message). This happens only for some views and remaining are opening without any issue.
Also all the views open in TM1 web url. Only Cafe is causing trouble.
Anyone faced such a situation before?

Thanks in Advance :)

Edward Stuart
Community Contributor
Posts: 186
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester

Re: Unable to pull views in TM1 Cafe

Post by Edward Stuart » Fri Sep 08, 2017 8:02 am

What is listed in the logs?

rni
Posts: 7
Joined: Tue Feb 07, 2017 2:48 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2010

Re: Unable to pull views in TM1 Cafe

Post by rni » Fri Sep 08, 2017 10:25 am

The log file goes something like this:


# 2017/09/08 10:35:15.524
[Severity=Information]
[Exit] HideLoadingForm()
[Thread=1, Background=True, Pool=False]
[ms=0]
> Framework.AsyncCall.SendException(Object obj)
> Framework.AsyncCall.ExceptionCallback(Exception ex)
> Framework.AsyncItem`3.OnError(Exception ex)
> CognosOfficeReporting.CallWrapper`3.onError(Exception error, Tag tag)
< CognosOfficeReporting.CUILoadingForm.HideLoadingForm()
m_LoadingFormRefCounter = -1
Visible = False

# 2017/09/08 10:35:16.757
[Severity=Verbose]
[Entry] SelectNode(TreeNode node)
[Thread=1, Background=True, Pool=False]
> CognosOfficeReporting.MultiSelectTreeView.OnMouseDown(MouseEventArgs e)
> CognosOfficeReporting.MultiSelectTreeView.SelectNode(TreeNode node)

# 2017/09/08 10:35:16.760
[Severity=Verbose]
[Entry] ToggleNode(TreeNode node, Boolean bSelectNode)
[Thread=1, Background=True, Pool=False]
> CognosOfficeReporting.MultiSelectTreeView.OnMouseDown(MouseEventArgs e)
> CognosOfficeReporting.MultiSelectTreeView.SelectNode(TreeNode node)
> CognosOfficeReporting.MultiSelectTreeView.ToggleNode(TreeNode node, Boolean bSelectNode)

# 2017/09/08 10:35:16.762
[Severity=Verbose]
[Exit] ToggleNode(TreeNode node, Boolean bSelectNode)
[Thread=1, Background=True, Pool=False]
[ms=0]
> CognosOfficeReporting.MultiSelectTreeView.OnMouseDown(MouseEventArgs e)
> CognosOfficeReporting.MultiSelectTreeView.SelectNode(TreeNode node)
< CognosOfficeReporting.MultiSelectTreeView.ToggleNode(TreeNode node, Boolean bSelectNode)

# 2017/09/08 10:35:16.764
[Severity=Verbose]
[Entry] OnBeforeSelect(TreeViewCancelEventArgs e)
[Thread=1, Background=True, Pool=False]
> CognosOfficeReporting.MultiSelectTreeView.OnMouseDown(MouseEventArgs e)
> CognosOfficeReporting.MultiSelectTreeView.SelectNode(TreeNode node)
> CognosOfficeReporting.MultiSelectTreeView.OnBeforeSelect(TreeViewCancelEventArgs e)

# 2017/09/08 10:35:16.767
[Severity=Verbose]
[Exit] OnBeforeSelect(TreeViewCancelEventArgs e)
[Thread=1, Background=True, Pool=False]
[ms=0]
> CognosOfficeReporting.MultiSelectTreeView.OnMouseDown(MouseEventArgs e)
> CognosOfficeReporting.MultiSelectTreeView.SelectNode(TreeNode node)
< CognosOfficeReporting.MultiSelectTreeView.OnBeforeSelect(TreeViewCancelEventArgs e)

# 2017/09/08 10:35:16.770
[Severity=Verbose]
[Entry] OnAfterSelect(TreeViewEventArgs e)
[Thread=1, Background=True, Pool=False]
> CognosOfficeReporting.MultiSelectTreeView.OnMouseDown(MouseEventArgs e)
> CognosOfficeReporting.MultiSelectTreeView.SelectNode(TreeNode node)
> CognosOfficeReporting.MultiSelectTreeView.OnAfterSelect(TreeViewEventArgs e)

# 2017/09/08 10:35:16.773
[Severity=Verbose]
[Exit] OnAfterSelect(TreeViewEventArgs e)
[Thread=1, Background=True, Pool=False]
[ms=0]
> CognosOfficeReporting.MultiSelectTreeView.OnMouseDown(MouseEventArgs e)
> CognosOfficeReporting.MultiSelectTreeView.SelectNode(TreeNode node)
< CognosOfficeReporting.MultiSelectTreeView.OnAfterSelect(TreeViewEventArgs e)

# 2017/09/08 10:35:16.777
[Severity=Verbose]
[Exit] SelectNode(TreeNode node)
[Thread=1, Background=True, Pool=False]
[ms=17]
> CognosOfficeReporting.MultiSelectTreeView.OnMouseDown(MouseEventArgs e)
< CognosOfficeReporting.MultiSelectTreeView.SelectNode(TreeNode node)

# 2017/09/08 10:35:18.070
[Severity=Information]
[Entry] ShowLoadingForm(Boolean allowCancel)
[Thread=1, Background=True, Pool=False]
> CognosOfficeReporting.ApplicationView.CUIManager_MouseUp(Object sender, MouseEventArgs e)
> CognosOfficeReporting.ApplicationPresenter.View_DragEnd(Object sender, MouseEventArgs e)
> CognosOfficeReporting.UIManager.DragEnd(Object sender, MouseEventArgs e)
> CognosOfficeReporting.MapUI.DragEnd(ScreenMouseEventArgs e)
> CognosOfficeReporting.LoadingForms.CallWithRetry(In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker onCancel)
> CognosOfficeReporting.CUILoadingForm.CallWithRetry(In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker onCancel)
> CognosOfficeReporting.CallWrapper`3..ctor(CUILoadingForm form, In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker cancel)
> CognosOfficeReporting.CUILoadingForm.ShowLoadingForm(Boolean allowCancel)

# 2017/09/08 10:35:18.080
[Severity=Information]
[Exit] ShowLoadingForm(Boolean allowCancel)
[Thread=1, Background=True, Pool=False]
[ms=8]
> CognosOfficeReporting.ApplicationView.CUIManager_MouseUp(Object sender, MouseEventArgs e)
> CognosOfficeReporting.ApplicationPresenter.View_DragEnd(Object sender, MouseEventArgs e)
> CognosOfficeReporting.UIManager.DragEnd(Object sender, MouseEventArgs e)
> CognosOfficeReporting.MapUI.DragEnd(ScreenMouseEventArgs e)
> CognosOfficeReporting.LoadingForms.CallWithRetry(In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker onCancel)
> CognosOfficeReporting.CUILoadingForm.CallWithRetry(In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker onCancel)
> CognosOfficeReporting.CallWrapper`3..ctor(CUILoadingForm form, In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker cancel)
< CognosOfficeReporting.CUILoadingForm.ShowLoadingForm(Boolean allowCancel)
m_LoadingFormRefCounter = 1

# 2017/09/08 10:35:18.234
[Severity=Information]
[Entry] HideLoadingForm()
[Thread=1, Background=True, Pool=False]
> Framework.AsyncCall.SendComplete(Object ignored)
> Framework.AsyncCall.CompleteCallback()
> Framework.AsyncItem`3.OnComplete()
> CognosOfficeReporting.CallWrapper`3.onComplete(Out result, Tag tag)
> CognosOfficeReporting.CUILoadingForm.HideLoadingForm()

# 2017/09/08 10:35:18.243
[Severity=Information]
[Exit] HideLoadingForm()
[Thread=1, Background=True, Pool=False]
[ms=3]
> Framework.AsyncCall.SendComplete(Object ignored)
> Framework.AsyncCall.CompleteCallback()
> Framework.AsyncItem`3.OnComplete()
> CognosOfficeReporting.CallWrapper`3.onComplete(Out result, Tag tag)
< CognosOfficeReporting.CUILoadingForm.HideLoadingForm()
m_LoadingFormRefCounter = 0
Visible = False

# 2017/09/08 10:35:18.248
[Severity=Information]
[Entry] ShowLoadingForm(Boolean allowCancel)
[Thread=1, Background=True, Pool=False]
> Framework.AsyncCall.SendComplete(Object ignored)
> Framework.AsyncCall.CompleteCallback()
> Framework.AsyncItem`3.OnComplete()
> CognosOfficeReporting.CallWrapper`3.onComplete(Out result, Tag tag)
> CognosOfficeReporting.MapUI.GetTreeNodeData_Complete(Object dragData, SheetCoordinate sc)
> CognosOfficeReporting.WorkbookMapper.DropView(CDLAnalysis report, SheetCoordinate sc)
> CognosOfficeReporting.LoadingForms.CallWithRetry(In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker onCancel)
> CognosOfficeReporting.CUILoadingForm.CallWithRetry(In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker onCancel)
> CognosOfficeReporting.CallWrapper`3..ctor(CUILoadingForm form, In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker cancel)
> CognosOfficeReporting.CUILoadingForm.ShowLoadingForm(Boolean allowCancel)

# 2017/09/08 10:35:18.258
[Severity=Information]
[Exit] ShowLoadingForm(Boolean allowCancel)
[Thread=1, Background=True, Pool=False]
[ms=7]
> Framework.AsyncCall.SendComplete(Object ignored)
> Framework.AsyncCall.CompleteCallback()
> Framework.AsyncItem`3.OnComplete()
> CognosOfficeReporting.CallWrapper`3.onComplete(Out result, Tag tag)
> CognosOfficeReporting.MapUI.GetTreeNodeData_Complete(Object dragData, SheetCoordinate sc)
> CognosOfficeReporting.WorkbookMapper.DropView(CDLAnalysis report, SheetCoordinate sc)
> CognosOfficeReporting.LoadingForms.CallWithRetry(In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker onCancel)
> CognosOfficeReporting.CUILoadingForm.CallWithRetry(In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker onCancel)
> CognosOfficeReporting.CallWrapper`3..ctor(CUILoadingForm form, In args, DoWork`2<Out,In> method, OnComplete`2<Out,Tag> complete, OnError`1<Tag> error, RetryTest retry, Tag tag, MethodInvoker cancel)
< CognosOfficeReporting.CUILoadingForm.ShowLoadingForm(Boolean allowCancel)
m_LoadingFormRefCounter = 1

Drg
Posts: 51
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Unable to pull views in TM1 Cafe

Post by Drg » Wed Sep 13, 2017 7:55 am

maybe you data in vie so big and you need config CAFE for this dataset?

try change params in cafe ->IBM cognos -> parapmetars -> ibm cognos analysis

rni
Posts: 7
Joined: Tue Feb 07, 2017 2:48 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2010

Re: Unable to pull views in TM1 Cafe

Post by rni » Wed Sep 13, 2017 8:33 am

Thanks for your suggestions. Looks like we had a compatibility issue. TM1 was upgraded to Fix Pack 7, but Cafe was still in Fix Pack 4. :P

Post Reply