Diagnosing and Resolving Errors
This section discusses how to diagnose and resolve errors in client environments.
If you select the check box to create log files when building a template or submitting to the database, two log files are created—one that logs the activity of ExcelToCI2007.xlsm and the other that logs the SOAPTOCI Web Library.
The log for ExcelToCI2007.xlsm is created in the temp directory on the workstation running the Microsoft Excel spreadsheet.
The log for the Web Library, SOAPTOCI<unique_number>.log, is created on the application server in the <PS_CFG_HOME> directory. This file contains both the SOAP request and the SOAP response.
Log files are written for each chunk of data that is sent to the database.
The HTML page displays a complete list of errors and warnings generated in Staging & Submission sheet of the Excel to Component Interface utility. The errors and warnings are displayed in a tabular format. You can click any Error link in the Status column of Staging & Submission sheet to access this page.
The following table lists common errors and error messages and their possible resolutions.
Error Message |
Possible Resolution |
---|---|
Component not correctly registered |
Reinstall Visual Basic 6.0 SP5: Run-Time Redistribution Pack found on the Microsoft download site. |
ActiveX component not correctly registered (Error 336) |
Reinstall Visual Basic 6.0 SP5: Run-Time Redistribution Pack found at the Microsoft downloads website. |
Error Number: -2147024770 Description: Automation error. The specified module could not be found. |
Perform the following steps:
|
Error Number: 429 Description: ActiveX component can't create object. |
Perform the following steps:
|
Error Number -214722099 Description: Automation error in the dll. |
Perform the following steps:
|
Not Authorized (90,6) |
The user who is trying to access the component interface from ExcelToCI does not have access to the component interface. Please provide access using PeopleTools Security. |