Cognos Analytics

Hi Everyone, 

I am new to the community.  I just upgraded my sandbox environment to 11.1.7 FP 1.  We are having a problem with External Data, and I'm not sure if it is because of the upgrade, or a problem with my sandbox environment.  We can pull in Excel 97-2003 Worksheets (.xls) okay, but if I try to pull in an Excel 2007 Worksheet (.xlsx) it is failing.  In the report they are getting an error indicating that the login failed.  If I try to add a file through Manage External Data I'm just getting a blank error box.  In the log files I see error messages indicating a failure with a message of "org.apache.poi.ooxml.POIXMLTypeLoader".  

Has anyone else been able to access Excel 2007 Worksheets as an external data source?  Any ideas on what I should try?

Thanks,
Jeff


------------------------------
Jeff Turgeon
------------------------------

#CognosAnalyticswithWatson

Looks like an issue in the version of Apache POI. Suggest you open a ticket with customer support.

------------------------------
NIGEL CAMPBELL
------------------------------

Original Message:
Sent: Thu October 22, 2020 10:54 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

Hi Everyone, 

I am new to the community.  I just upgraded my sandbox environment to 11.1.7 FP 1.  We are having a problem with External Data, and I'm not sure if it is because of the upgrade, or a problem with my sandbox environment.  We can pull in Excel 97-2003 Worksheets (.xls) okay, but if I try to pull in an Excel 2007 Worksheet (.xlsx) it is failing.  In the report they are getting an error indicating that the login failed.  If I try to add a file through Manage External Data I'm just getting a blank error box.  In the log files I see error messages indicating a failure with a message of "org.apache.poi.ooxml.POIXMLTypeLoader".  

Has anyone else been able to access Excel 2007 Worksheets as an external data source?  Any ideas on what I should try?

Thanks,
Jeff


------------------------------
Jeff Turgeon
------------------------------

#CognosAnalyticswithWatson

Thank you Nigel!  I have opened a case with customer support.  I just upgraded a second environment last night, and we are having the same problem there.

------------------------------
Jeff Turgeon
------------------------------

Original Message:
Sent: Fri October 23, 2020 09:56 AM
From: NIGEL CAMPBELL
Subject: 11.1.7 FP1 External Data

Looks like an issue in the version of Apache POI. Suggest you open a ticket with customer support.

------------------------------
NIGEL CAMPBELL

Original Message:
Sent: Thu October 22, 2020 10:54 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

Hi Everyone, 

I am new to the community.  I just upgraded my sandbox environment to 11.1.7 FP 1.  We are having a problem with External Data, and I'm not sure if it is because of the upgrade, or a problem with my sandbox environment.  We can pull in Excel 97-2003 Worksheets (.xls) okay, but if I try to pull in an Excel 2007 Worksheet (.xlsx) it is failing.  In the report they are getting an error indicating that the login failed.  If I try to add a file through Manage External Data I'm just getting a blank error box.  In the log files I see error messages indicating a failure with a message of "org.apache.poi.ooxml.POIXMLTypeLoader".  

Has anyone else been able to access Excel 2007 Worksheets as an external data source?  Any ideas on what I should try?

Thanks,
Jeff


------------------------------
Jeff Turgeon
------------------------------

#CognosAnalyticswithWatson

In case anyone else comes across this issue, IBM agrees that this is a bug in 11.1.7 FP1 and they have created an APAR to address the issue.

------------------------------
Jeff Turgeon
------------------------------

Original Message:
Sent: Thu October 22, 2020 10:54 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

Hi Everyone, 

I am new to the community.  I just upgraded my sandbox environment to 11.1.7 FP 1.  We are having a problem with External Data, and I'm not sure if it is because of the upgrade, or a problem with my sandbox environment.  We can pull in Excel 97-2003 Worksheets (.xls) okay, but if I try to pull in an Excel 2007 Worksheet (.xlsx) it is failing.  In the report they are getting an error indicating that the login failed.  If I try to add a file through Manage External Data I'm just getting a blank error box.  In the log files I see error messages indicating a failure with a message of "org.apache.poi.ooxml.POIXMLTypeLoader".  

Has anyone else been able to access Excel 2007 Worksheets as an external data source?  Any ideas on what I should try?

Thanks,
Jeff


------------------------------
Jeff Turgeon
------------------------------

#CognosAnalyticswithWatson

Thank you for posting about this issue. We just encountered this in 11.1.7 FP1. 

@Jeff Turgeon, can you share the APAR ID and link if one is available?

Thanks!

------------------------------
Wendi Lewis
------------------------------

Original Message:
Sent: Wed October 28, 2020 09:16 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

In case anyone else comes across this issue, IBM agrees that this is a bug in 11.1.7 FP1 and they have created an APAR to address the issue.

------------------------------
Jeff Turgeon

Original Message:
Sent: Thu October 22, 2020 10:54 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

Hi Everyone, 

I am new to the community.  I just upgraded my sandbox environment to 11.1.7 FP 1.  We are having a problem with External Data, and I'm not sure if it is because of the upgrade, or a problem with my sandbox environment.  We can pull in Excel 97-2003 Worksheets (.xls) okay, but if I try to pull in an Excel 2007 Worksheet (.xlsx) it is failing.  In the report they are getting an error indicating that the login failed.  If I try to add a file through Manage External Data I'm just getting a blank error box.  In the log files I see error messages indicating a failure with a message of "org.apache.poi.ooxml.POIXMLTypeLoader".  

Has anyone else been able to access Excel 2007 Worksheets as an external data source?  Any ideas on what I should try?

Thanks,
Jeff


------------------------------
Jeff Turgeon
------------------------------

#CognosAnalyticswithWatson

Hi @Wendi Lewis! 

The APAR is PH30937.  I do not have a link for the case yet.  We converted our XLSX files to XLS and updated the packages to accommodate the different file format to allow us to move forward.  Good luck!



------------------------------
Jeff Turgeon
------------------------------

Original Message:
Sent: Thu October 29, 2020 10:45 AM
From: Wendi Lewis
Subject: 11.1.7 FP1 External Data

Thank you for posting about this issue. We just encountered this in 11.1.7 FP1. 

@Jeff Turgeon, can you share the APAR ID and link if one is available?

Thanks!

------------------------------
Wendi Lewis

Original Message:
Sent: Wed October 28, 2020 09:16 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

In case anyone else comes across this issue, IBM agrees that this is a bug in 11.1.7 FP1 and they have created an APAR to address the issue.

------------------------------
Jeff Turgeon

Original Message:
Sent: Thu October 22, 2020 10:54 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

Hi Everyone, 

I am new to the community.  I just upgraded my sandbox environment to 11.1.7 FP 1.  We are having a problem with External Data, and I'm not sure if it is because of the upgrade, or a problem with my sandbox environment.  We can pull in Excel 97-2003 Worksheets (.xls) okay, but if I try to pull in an Excel 2007 Worksheet (.xlsx) it is failing.  In the report they are getting an error indicating that the login failed.  If I try to add a file through Manage External Data I'm just getting a blank error box.  In the log files I see error messages indicating a failure with a message of "org.apache.poi.ooxml.POIXMLTypeLoader".  

Has anyone else been able to access Excel 2007 Worksheets as an external data source?  Any ideas on what I should try?

Thanks,
Jeff


------------------------------
Jeff Turgeon
------------------------------

#CognosAnalyticswithWatson

Thanks Jeff!

------------------------------
Wendi Lewis
------------------------------

Original Message:
Sent: Fri October 30, 2020 10:12 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

Hi @Wendi Lewis! 

The APAR is PH30937.  I do not have a link for the case yet.  We converted our XLSX files to XLS and updated the packages to accommodate the different file format to allow us to move forward.  Good luck!



------------------------------
Jeff Turgeon

Original Message:
Sent: Thu October 29, 2020 10:45 AM
From: Wendi Lewis
Subject: 11.1.7 FP1 External Data

Thank you for posting about this issue. We just encountered this in 11.1.7 FP1. 

@Jeff Turgeon, can you share the APAR ID and link if one is available?

Thanks!

------------------------------
Wendi Lewis

Original Message:
Sent: Wed October 28, 2020 09:16 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

In case anyone else comes across this issue, IBM agrees that this is a bug in 11.1.7 FP1 and they have created an APAR to address the issue.

------------------------------
Jeff Turgeon

Original Message:
Sent: Thu October 22, 2020 10:54 AM
From: Jeff Turgeon
Subject: 11.1.7 FP1 External Data

Hi Everyone, 

I am new to the community.  I just upgraded my sandbox environment to 11.1.7 FP 1.  We are having a problem with External Data, and I'm not sure if it is because of the upgrade, or a problem with my sandbox environment.  We can pull in Excel 97-2003 Worksheets (.xls) okay, but if I try to pull in an Excel 2007 Worksheet (.xlsx) it is failing.  In the report they are getting an error indicating that the login failed.  If I try to add a file through Manage External Data I'm just getting a blank error box.  In the log files I see error messages indicating a failure with a message of "org.apache.poi.ooxml.POIXMLTypeLoader".  

Has anyone else been able to access Excel 2007 Worksheets as an external data source?  Any ideas on what I should try?

Thanks,
Jeff


------------------------------
Jeff Turgeon
------------------------------

#CognosAnalyticswithWatson

HI Jeff,

Do you know if this only impact excel 2007 files or is it impacting any version of excel 2007 and greater?  Thanks.Kay

------------------------------
Kay Vandevanter
------------------------------