How to resolve Issues Related to iBook / External Excel

 Previous  Home  Next

Users can perform all excel operations from iBook of Process Runner. User can also use any external file as a data source. While using iBook/External Excel in Process Runner, user may encounter some errors/issues. This section will provide guidelines to troubleshoot problems and possible remedies to correct them.

 

Note: Process Runner will work only with Locally installed MS Excel.

 

Suggested Solution:

Follow the steps given below to resolve the errors related to iBook/External Excel in Process Runner.

 

1.Close all the sessions of Process Runner.

2.Start Excel as you would normally start.

3.In case if 'Document Recovery Pane' is displayed in excel, please recover all the files.

4.Exit all the instances of Excel.

5.Go to 'Task Manager' (CTRL + ALT + DELETE and select Task Manager). Go to Processes tab.

6.Ensure that there is no Excel or Process Runner instance is running. If so, select 'Excel.exe' or 'ProR.exe' and click on 'End Process'.

7.Start the Process Runner and enable 'Always open new Excel instance for external Excel' and 'Always open new Excel instance for iBook' functionality from Options.

8.Make sure to perform the steps mentioned in the image below.

 

Excel_issues

 

9.After applying the above settings, start Process Runner and check the following:

a.External issues related to Excel are resolved or not

b.iBook is functioning appropriately or not.

 

If the issue is still encountered, then kindly follow the steps mentioned below:

i.Close all open instances of Process Runner and Microsoft Excel.

ii.Open Process file with Process Runner in which the issue is encountered.

iii.Click on 'iBook' tab.

iv.Click on 'Excel Menus On/Off' to turn on the Excel Menu and click again to turn it off.

v.Double click on any cell inside iBook and Excel lock will be released.

vi.'Run' process file.

 

excel_item_1

 

The above section of document deals to troubleshoot the errors that are mentioned within the below toggle

hmtoggle_plus1Possible Errors

•FM:48 Error During load sheet name

FM: 48 Invalid Index. (Exception from HRESULT: 0x8002000B) (DISP_E_BADINDEX))

 

badindex-error

 

•FM:73 Process Runner

FM: 73 Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Workbook'. This operation is failed because the QueryInterface call on the COM component for the interface with IID '{000208DA-0000-0000-C000-000000000046}' failed due to '{000208DA-0000-0000-C000-000000000046}' failed due to following error : Library not registered. (Exception from HRESULT: 0x800280 1D (TYPE_E_LIBNOTREGISTERED)).

 

LIBNOTR

 

•Microsoft Excel

Document with name “TempXL.xlsx” is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that's currently open, or rename one of the documents.

 

docerror

 

Microsoft Excel is waiting for another application to complete an OLE action.

 

Microsoft_OLE

 

•FM:49 Process Runner

FM: 49 The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))

 

srevercall

 

•X-103: DsoFramerControl

System.Runtime.InteropServices.COMException (0x80041108): Cannot access document when in modal condition.

 

dsoframe_error1

 

•A-148: Prepare to Open iBook

Error while opening iBook. The remote procedure call failed (Exception from HRESULT: 0x800706BE)

 

error148

 

Error while opening iBook. Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to following error: 80040154

 

iBook2err

 

 

If the error is not resolved, kindly refer ' How to resolve Excel issues with Process Runner '

 

For further assistance, Please write us your query with the error screen-shot at support@innowera.com

 

 

Next:

TX Message Settings in iNETConnector to get proper SAP return message