TM1 Contributor Slice to Excel

[karan2345]

When i try to do a slice to excel from TM1 Contributor, I am getting the below given error. Any idea about what it is trying to convey?

Operation Failed
System has encountered a problem while handling your request.
Please try again.
If you keep having trouble, please contact your system administrator for assistance.

[moby91]

The "Operation Failed" message is just that, a message that an operation failed. Except that it does not deliver any information at all. Thus it is useless when it comes to investigate and to resolve the issue.

In addition to the "Operation Failed" message, did you get any additional information ?

Did you check the TM1 server message logfile tm1server.log, the TM1 Web logfile tm1web.log and the Excel Report Server logfile TM1ExcelService.log for warnings and error messages whose timestamp match the time the operation in TM1 Web was triggered and failed ?

Note:
By default the messages in the TM1 logfiles are using the GMT time. Thus take into account the difference between your local time and the GMT time.


If there are no matching warnings and error messages in the TM1 logfiles, you have to reconfigure the TM1 Web logfile tm1web.log and the Excel Report Server logfile TM1ExcelService.log for Debug Level Logging before you test again.


On how to configure the TM1 Web logfile tm1web.log for Debug Level Logging see the manual TM1 9.5.2 Web User Guide, Chapter 7: "Administering IBM Cognos TM1 Web", Paragraph: "Using IBM Cognos TM1 Web Logging", Sub-Paragraph: "IBM Cognos TM1 Web Log", page 120 to 122, or check the corresponding IBM website ->

http://publib.boulder.ibm.com/infocente ... Log_N5194C
TM1 9.5.2 Web User Guide
Administering IBM Cognos TM1 Web > Using IBM Cognos TM1 Web Logging >

IBM Cognos TM1 Web Log

The IBM Cognos TM1 Web log records messages for IBM Cognos TM1 Web activity and errors. The log file is an ASCII text file that you can open in any text editor, such as Microsoft Windows Notepad.


On how to configure the Excel Report Server logfile TM1ExcelService.log for Debug Level Logging see the manual TM1 9.5.2 Web User Guide, Chapter 7: "Administering IBM Cognos TM1 Web", Paragraph: "Using IBM Cognos TM1 Web Logging", Sub-Paragraph: "TM1 Excel Services Log", page 122 to 124, or check the corresponding IBM website ->

http://publib.boulder.ibm.com/infocente ... Log_N51A61
TM1 9.5.2 Web User Guide
Administering IBM Cognos TM1 Web > Using IBM Cognos TM1 Web Logging >

Excel Services Log

The TM1 Excel Services log records messages for the TM1 Excel Service - an application that runs in the background to handle IBM Cognos TM1 Web requests for converting Excel files into XML format. The TM1 Excel Services log file is an ASCII text file that you can open in any text editor, such as Microsoft Windows Notepad.


Reconfigure the TM1 Web logfile tm1web.log and the Excel Report Server logfile TM1ExcelService.log for Debug Level Logging as outlined in the TM1 Documentation.

Afterwards recycle (stop&restart) TM1 Web (by recycling the Windows Service "IIS Admin" which will force recycling the Windows Service "WWW Publish Service" driving TM1 Web) and the Excel Report Server TM1ExcelService.exe (by recycling the Windows Service "TM1ExcelService.exe").

Then test again and check for warnings and error messages in the logfiles related to the failed operation.

[moby91]

When i try to do a slice to excel from TM1 Contributor, I am getting the below given error. Any idea about what it is trying to convey?

Operation Failed
System has encountered a problem while handling your request.
Please try again.
If you keep having trouble, please contact your system administrator for assistance.

Did you check the IBM Technotes 1470424 yand 1452585 ?

http://www-01.ibm.com/support/docview.w ... wg21470424
Exporting from TM1 Contributor to Excel or PDF on Windows 2008

http://www-01.ibm.com/support/docview.w ... wg21452585
Timeout Error exporting to Excel or PDF from TM1 Contributor

[karan2345]

When i try to do a slice to excel from TM1 Contributor, I am getting the below given error. Any idea about what it is trying to convey?

Operation Failed
System has encountered a problem while handling your request.
Please try again.
If you keep having trouble, please contact your system administrator for assistance.

Did you check the IBM Technotes 1470424 yand 1452585 ?

http://www-01.ibm.com/support/docview.w ... wg21470424
Exporting from TM1 Contributor to Excel or PDF on Windows 2008

http://www-01.ibm.com/support/docview.w ... wg21452585
Timeout Error exporting to Excel or PDF from TM1 Contributor

Thanks works now, however doesnt works on the server where tm1 is installed, it pops up some page and then nothing happens, I checked from the other machine and it works fine. I think this could be something to do with IE setting i will check that out.

Thanks a lot sir.

[Ah3U]

When i try to do a slice to excel from TM1 Contributor, I am getting the below given error. Any idea about what it is trying to convey?

Operation Failed
System has encountered a problem while handling your request.
Please try again.
If you keep having trouble, please contact your system administrator for assistance.

Did you check the IBM Technotes 1470424 yand 1452585 ?

http://www-01.ibm.com/support/docview.w ... wg21470424
Exporting from TM1 Contributor to Excel or PDF on Windows 2008

http://www-01.ibm.com/support/docview.w ... wg21452585
Timeout Error exporting to Excel or PDF from TM1 Contributor

it doesn't work for me.. any other suggestion ?