Planning Analytics

Dear IBM-Community,

We are using PAfE and when trying to open one of our files it happens that the Excel Add-Ins are not loading properly leaving the file in an inconsistent state.
Concretely, two of three Add-Ins are loaded. I have attached screenshots.
This doesn't happen every time - we have not been able to identify the pattern yet.
Event Logs and Excel Logs don't show any issues.

Has anyone ever experienced anything like that?
Do you have ideas what the reason could be behind this?

PAfE Version: 2.0.84.2
Excel Version: 2208 (16.0.15601.20446)

#PAfE #PlanningAnalyticsforMicrosoftExcel #excel #add-in #GettingStarted 

------------------------------
-- Veki
------------------------------

Hi Veki,

I notice that one of the add-ins is linked to a UNC/shared folder.
Are other users linked to this too?
The add-in should be creating local temporary files and necessary folders but there could be something locked or blocked.

Have you tried removing the add-ins and then copying the .XLL file to your desktop or local folder and opening from there, or adding as an add-in?

Dear IBM-Community,

We are using PAfE and when trying to open one of our files it happens that the Excel Add-Ins are not loading properly leaving the file in an inconsistent state.
Concretely, two of three Add-Ins are loaded. I have attached screenshots.
This doesn't happen every time - we have not been able to identify the pattern yet.
Event Logs and Excel Logs don't show any issues.

Has anyone ever experienced anything like that?
Do you have ideas what the reason could be behind this?

PAfE Version: 2.0.84.2
Excel Version: 2208 (16.0.15601.20446)

#PAfE #PlanningAnalyticsforMicrosoftExcel #excel #add-in #GettingStarted 

------------------------------
-- Veki
------------------------------

Hi and thanks so much for your reply,

One more piece of info: The users are opening the Excels over a Citrix client and the error does not happen everytime. We couldn't figure out a pattern yet - it appears erratic - sometimes it's loaded correctly, sometimes not. Closing the client and reconnecting again most times fixes the issue.

To your remarks:
- yes, about 600 users have access to that UNC folder and the Add-In is loaded from that path for everyone. 
- Which temporary files and folders do you mean exactly that the Add-In should create and where?
- Do you know about any log files that could show what is happening during the loading?

Thanks for your help again and looking forward to any ideas/hints.

BR

Hi Veki,

I notice that one of the add-ins is linked to a UNC/shared folder.
Are other users linked to this too?
The add-in should be creating local temporary files and necessary folders but there could be something locked or blocked.

Have you tried removing the add-ins and then copying the .XLL file to your desktop or local folder and opening from there, or adding as an add-in?

Dear IBM-Community,

We are using PAfE and when trying to open one of our files it happens that the Excel Add-Ins are not loading properly leaving the file in an inconsistent state.
Concretely, two of three Add-Ins are loaded. I have attached screenshots.
This doesn't happen every time - we have not been able to identify the pattern yet.
Event Logs and Excel Logs don't show any issues.

Has anyone ever experienced anything like that?
Do you have ideas what the reason could be behind this?

PAfE Version: 2.0.84.2
Excel Version: 2208 (16.0.15601.20446)

#PAfE #PlanningAnalyticsforMicrosoftExcel #excel #add-in #GettingStarted 

------------------------------
-- Veki
------------------------------

My Citrix experience is limited but what was always an issue was how IT configured the application.
Sometimes users shared the same logs and other folders creating complete chaos.

PAfE should create the local files and logs in %localappdata%\Cognos\Office Connection
If the folders and files exist and are being updated by the users then that is a good start.
If the folders and files are not there, could be that they are linked to a default user or something, will be accessed by all users and create issues.

Start with that and hopefully the logs otherwise hopefully others can post more useful insights.

Hi and thanks so much for your reply,

One more piece of info: The users are opening the Excels over a Citrix client and the error does not happen everytime. We couldn't figure out a pattern yet - it appears erratic - sometimes it's loaded correctly, sometimes not. Closing the client and reconnecting again most times fixes the issue.

To your remarks:
- yes, about 600 users have access to that UNC folder and the Add-In is loaded from that path for everyone. 
- Which temporary files and folders do you mean exactly that the Add-In should create and where?
- Do you know about any log files that could show what is happening during the loading?

Thanks for your help again and looking forward to any ideas/hints.

BR

Hi Veki,

I notice that one of the add-ins is linked to a UNC/shared folder.
Are other users linked to this too?
The add-in should be creating local temporary files and necessary folders but there could be something locked or blocked.

Have you tried removing the add-ins and then copying the .XLL file to your desktop or local folder and opening from there, or adding as an add-in?

Dear IBM-Community,

We are using PAfE and when trying to open one of our files it happens that the Excel Add-Ins are not loading properly leaving the file in an inconsistent state.
Concretely, two of three Add-Ins are loaded. I have attached screenshots.
This doesn't happen every time - we have not been able to identify the pattern yet.
Event Logs and Excel Logs don't show any issues.

Has anyone ever experienced anything like that?
Do you have ideas what the reason could be behind this?

PAfE Version: 2.0.84.2
Excel Version: 2208 (16.0.15601.20446)

#PAfE #PlanningAnalyticsforMicrosoftExcel #excel #add-in #GettingStarted 

------------------------------
-- Veki
------------------------------

certain Windows GPO (group policies) can interefere with addin loading, would compare the policies in effect on a working vs nonworking environment. there is some product logging that may be helpful but would also consult Office Trust Center logs.

My Citrix experience is limited but what was always an issue was how IT configured the application.
Sometimes users shared the same logs and other folders creating complete chaos.

PAfE should create the local files and logs in %localappdata%\Cognos\Office Connection
If the folders and files exist and are being updated by the users then that is a good start.
If the folders and files are not there, could be that they are linked to a default user or something, will be accessed by all users and create issues.

Start with that and hopefully the logs otherwise hopefully others can post more useful insights.

Hi and thanks so much for your reply,

One more piece of info: The users are opening the Excels over a Citrix client and the error does not happen everytime. We couldn't figure out a pattern yet - it appears erratic - sometimes it's loaded correctly, sometimes not. Closing the client and reconnecting again most times fixes the issue.

To your remarks:
- yes, about 600 users have access to that UNC folder and the Add-In is loaded from that path for everyone. 
- Which temporary files and folders do you mean exactly that the Add-In should create and where?
- Do you know about any log files that could show what is happening during the loading?

Thanks for your help again and looking forward to any ideas/hints.

BR

Hi Veki,

I notice that one of the add-ins is linked to a UNC/shared folder.
Are other users linked to this too?
The add-in should be creating local temporary files and necessary folders but there could be something locked or blocked.

Have you tried removing the add-ins and then copying the .XLL file to your desktop or local folder and opening from there, or adding as an add-in?

Dear IBM-Community,

We are using PAfE and when trying to open one of our files it happens that the Excel Add-Ins are not loading properly leaving the file in an inconsistent state.
Concretely, two of three Add-Ins are loaded. I have attached screenshots.
This doesn't happen every time - we have not been able to identify the pattern yet.
Event Logs and Excel Logs don't show any issues.

Has anyone ever experienced anything like that?
Do you have ideas what the reason could be behind this?

PAfE Version: 2.0.84.2
Excel Version: 2208 (16.0.15601.20446)

#PAfE #PlanningAnalyticsforMicrosoftExcel #excel #add-in #GettingStarted 

------------------------------
-- Veki
------------------------------

My Citrix experience is limited but what was always an issue was how IT configured the application.
Sometimes users shared the same logs and other folders creating complete chaos.

PAfE should create the local files and logs in %localappdata%\Cognos\Office Connection
If the folders and files exist and are being updated by the users then that is a good start.
If the folders and files are not there, could be that they are linked to a default user or something, will be accessed by all users and create issues.

Start with that and hopefully the logs otherwise hopefully others can post more useful insights.

Hi and thanks so much for your reply,

One more piece of info: The users are opening the Excels over a Citrix client and the error does not happen everytime. We couldn't figure out a pattern yet - it appears erratic - sometimes it's loaded correctly, sometimes not. Closing the client and reconnecting again most times fixes the issue.

To your remarks:
- yes, about 600 users have access to that UNC folder and the Add-In is loaded from that path for everyone. 
- Which temporary files and folders do you mean exactly that the Add-In should create and where?
- Do you know about any log files that could show what is happening during the loading?

Thanks for your help again and looking forward to any ideas/hints.

BR

Hi Veki,

I notice that one of the add-ins is linked to a UNC/shared folder.
Are other users linked to this too?
The add-in should be creating local temporary files and necessary folders but there could be something locked or blocked.

Have you tried removing the add-ins and then copying the .XLL file to your desktop or local folder and opening from there, or adding as an add-in?

Dear IBM-Community,

We are using PAfE and when trying to open one of our files it happens that the Excel Add-Ins are not loading properly leaving the file in an inconsistent state.
Concretely, two of three Add-Ins are loaded. I have attached screenshots.
This doesn't happen every time - we have not been able to identify the pattern yet.
Event Logs and Excel Logs don't show any issues.

Has anyone ever experienced anything like that?
Do you have ideas what the reason could be behind this?

PAfE Version: 2.0.84.2
Excel Version: 2208 (16.0.15601.20446)

#PAfE #PlanningAnalyticsforMicrosoftExcel #excel #add-in #GettingStarted 

------------------------------
-- Veki
------------------------------

Hey,

Thank you for your input!

We managed to identify the issue. We have VBA code that in certain cases is supposed to completely close the Excel Application. However, sometimes this isn't executed properly and while it looks like the application has been closed, we can see an Excel process still running in Task Manager. As long as we don't kill this process, the Add-Ins is not loaded correctly.

Have you ever experienced or observed anything like that?

Thank you again and all the best,

------------------------------
------------------------------
Vedrana Tomic
Business Partner
PM Factory Consulting
Vienna
------------------------------

Original Message:
Sent: Tue May 16, 2023 09:30 AM
From: George Tonkin
Subject: PAfE Excel Add-Ins not loading properly

My Citrix experience is limited but what was always an issue was how IT configured the application.
Sometimes users shared the same logs and other folders creating complete chaos.

PAfE should create the local files and logs in %localappdata%\Cognos\Office Connection
If the folders and files exist and are being updated by the users then that is a good start.
If the folders and files are not there, could be that they are linked to a default user or something, will be accessed by all users and create issues.

Start with that and hopefully the logs otherwise hopefully others can post more useful insights.

------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg

Original Message:
Sent: Tue May 16, 2023 09:19 AM
From: Vedrana Tomic
Subject: PAfE Excel Add-Ins not loading properly

Hi and thanks so much for your reply,

One more piece of info: The users are opening the Excels over a Citrix client and the error does not happen everytime. We couldn't figure out a pattern yet - it appears erratic - sometimes it's loaded correctly, sometimes not. Closing the client and reconnecting again most times fixes the issue.

To your remarks:
- yes, about 600 users have access to that UNC folder and the Add-In is loaded from that path for everyone. 
- Which temporary files and folders do you mean exactly that the Add-In should create and where?
- Do you know about any log files that could show what is happening during the loading?

Thanks for your help again and looking forward to any ideas/hints.

BR

------------------------------
-- Veki

Original Message:
Sent: Tue May 16, 2023 07:54 AM
From: George Tonkin
Subject: PAfE Excel Add-Ins not loading properly

Hi Veki,

I notice that one of the add-ins is linked to a UNC/shared folder.
Are other users linked to this too?
The add-in should be creating local temporary files and necessary folders but there could be something locked or blocked.

Have you tried removing the add-ins and then copying the .XLL file to your desktop or local folder and opening from there, or adding as an add-in?

------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg

Original Message:
Sent: Tue May 16, 2023 06:24 AM
From: Vedrana Tomic
Subject: PAfE Excel Add-Ins not loading properly

Dear IBM-Community,

We are using PAfE and when trying to open one of our files it happens that the Excel Add-Ins are not loading properly leaving the file in an inconsistent state.
Concretely, two of three Add-Ins are loaded. I have attached screenshots.
This doesn't happen every time - we have not been able to identify the pattern yet.
Event Logs and Excel Logs don't show any issues.

Has anyone ever experienced anything like that?
Do you have ideas what the reason could be behind this?

PAfE Version: 2.0.84.2
Excel Version: 2208 (16.0.15601.20446)

#PAfE #PlanningAnalyticsforMicrosoftExcel #excel #add-in #GettingStarted 

------------------------------
-- Veki
------------------------------

------------------------------
-- Veki
------------------------------