Advance Analysis Workbook Error ID-111006 on Refre...

We're currently on version 1.4.4.2737. I've created the advanced analysis office workbook using BOBJ connection and stored it on my PC. Next time when I open the workbook from PC and try to refresh it, it asks for BOBJ credential and then executes and I get attached message. No dump found in SAP BI (ST22).

If I create the workbook using SAP BI (Enter Skip on BOBJ credential popup) and then tried to reopen it, Refresh works perfectly fine.

Any idea why it gives error while refreshing the workbook on PC created using BOBJ connection?

Thanks,

Milind

SAP Managed Tags:
SAP Analysis for Microsoft Office

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hello Milind - a lot of disconnect errors you are showing are fixed in support pack 6 (e.g. 1.4 SP 6) - would it be possible to update your version of Analysis Office to that version and try this again?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Tammy ,

We are presently using 1.4.9.3240 .I have an issue when I try to pull seven mesures which are tenure feilds in my scenario and which have maximum of 8 decimals ie (10892443.484) and have filtered with backgroud filters which are restricted data which should bring a result of 450 records approximately. But, analysis Throws an error with this samll data .

The Error Log for this is as below

- Error: General .NET Exception:
Exception from HRESULT: 0x800401A8
   at Microsoft.Office.Interop.Excel.WorkbookClass.get_Worksheets()
   at com.sap.ip.bi.pioneer.addins.xlwrap.WorkbookWrapBase.<get_Worksheets>b__4()
   at com.sap.ip.bi.pioneer.excel.utils.EaExcelAccessor.AccessXlReturn[TResult](CrOfficeAccessorDelegate`1 opCallback)
| 2015-02-16T19:28:22 | com.sap.ip.bi.pioneer.excel.utils.EaExcelAccessor.AccessXlReturn() ()
- Error: Application Exception (ID 103042)
Nested Exception. See inner exception for details below.
   at com.sap.ip.bi.pioneer.core.main.CrSession.CallbackStart()
   at com.sap.ip.bi.pioneer.excel.main.EaSession.CallbackStart()
   at com.sap.ip.bi.pioneer.controls.main.CnSession.CallbackStart(CoUseWaitCursorEnum iWaitCursor)
   at com.sap.ip.bi.pioneer.excel.main.EaSession.CallbackStartAmodal(CoCultureSwitchPack iPack, CoUseWaitCursorEnum iWaitCursor)
   at com.sap.ip.bi.pioneer.controls.main.CnSession.CallbackWrapForOfficeEvents(CallbackWrapDelegate iDelegate, CnCallbackErrorSeverity iSeverity, CoUseWaitCursorEnum iWaitCursor)

>> General .NET Exception:
Exception from HRESULT: 0x800401A8
   at Microsoft.Office.Interop.Excel.WorkbookClass.set_Saved(Boolean RHS)
   at com.sap.ip.bi.pioneer.addins.xlwrap.WorkbookWrapBase.<>c__DisplayClass15.<set_Saved>b__14()
   at com.sap.ip.bi.pioneer.excel.utils.EaExcelAccessor.AccessXlVoid(CrOfficeAccessorDelegate opCallback)
   at com.sap.ip.bi.pioneer.addins.xlwrap.WorkbookWrapBase.set_Saved(Boolean value)
   at com.sap.ip.bi.pioneer.excel.views.EaViewManagerSession.OnProcessingFinished(Object iSender, CoProcessingFinishedEventArgs iEventArgs)
| 2015-02-16T19:28:25 | com.sap.ip.bi.pioneer.common.messagehandling.CoMessenger.WriteToLog() ()
- Critical: 111007 #msl.excp.norestart | 2015-02-16T19:28:25 | com.sap.ip.bi.pioneer.common.messagehandling.CoMessenger.WriteToLog() ()
- Verbose: Set DoNotUpdateSsoTickets to true for workbook | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.excel.main.EaSession.RemoveWorkbook() ()
- Verbose: Set DoNotUpdateSsoTickets to false for workbook | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.excel.main.EaSession.RemoveWorkbook() ()
- Error: General .NET Exception:
Exception from HRESULT: 0x800401A8
   at Microsoft.Office.Interop.Excel.WorkbookClass.get_Name()
   at com.sap.ip.bi.pioneer.addins.xlwrap.WorkbookWrapBase.<get_Name>b__f()
   at com.sap.ip.bi.pioneer.excel.utils.EaExcelAccessor.AccessXlReturn[TResult](CrOfficeAccessorDelegate`1 opCallback)
| 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.excel.utils.EaExcelAccessor.AccessXlReturn() ()
- Error: General .NET Exception:
Exception from HRESULT: 0x800401A8
   at Microsoft.Office.Interop.Excel.WorkbookClass.get_Worksheets()
   at com.sap.ip.bi.pioneer.addins.xlwrap.WorkbookWrapBase.<get_Worksheets>b__4()
   at com.sap.ip.bi.pioneer.excel.utils.EaExcelAccessor.AccessXlReturn[TResult](CrOfficeAccessorDelegate`1 opCallback)
| 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.excel.utils.EaExcelAccessor.AccessXlReturn() ()
- Verbose: Enter Cleanup | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.common.Help.CoHelp.StopF1HookIntern() ()
- Verbose: Leave Cleanup | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.common.Help.CoHelp.StopF1HookIntern() ()
- Verbose: EaTaskpane.setVisible: 0 | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.addins.xl.EaTaskpane.set_Visible() ()
- Verbose: Found context menu for Normal mode at index 28 | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.controls.cbar.EaExcelContextMenu.GetExcelNormalContextMenu() ()
- Verbose: Found context menu for Normal mode at index 28 | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.controls.cbar.EaExcelContextMenu.GetExcelNormalContextMenu() ()
- Verbose: Found context menu for Page Break Preview mode at index 31 | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.controls.cbar.EaExcelContextMenu.GetExcelPageBreakContextMenu() ()
- Verbose: Set DoNotUpdateSsoTickets to true for workbook | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.excel.main.EaSession.ShutDown() ()
- Verbose: Windows temporary directory C:\Users\hrangarajan\AppData\Local\Temp is writeable | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.controls.opendialogs.command.CnOpenSaveCommandsHelper.TryCleanupCache() ()
- Verbose: Destroying Application with ID defaultsessionanchor | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.core.logging.CrBicsLoggingLocation.log() ()
- Warning: Event was started, but not completed\: 255486 ms: Get provider result set (13040) | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.core.logging.CrBicsLoggingLocation.log() ()
- Information: [0] Try to find a service implementation for type SERVER_STATISTIC | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.core.logging.CrBicsLoggingLocation.log() ()
- Warning: [-1] No applicable service implementation found for type SERVER_STATISTIC. | 2015-02-16T19:28:26 | com.sap.ip.bi.pioneer.core.logging.CrBicsLoggingLocation.log() ()
- Verbose: Set DoNotUpdateSsoTickets to false for workbook | 2015-02-16T19:28:28 | com.sap.ip.bi.pioneer.excel.main.EaSession.ShutDown() ()
- Verbose: not NULL | 2015-02-16T19:28:28 | com.sap.ip.bi.pioneer.core.main.CrSession.SetInstance() ()

Hema - please apply the latest 1.4 SP10 patch 1 - and if the error continues please open a new thread or contact SAP Support.

Ask a Question

Top Q&A Solution Author

User

Count