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.

See Correcting and Resubmitting Data

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:

  1. Open Windows Explorer.

  2. Navigate to c:\winnt\system32 directory and locate msxml6.dll.

  3. Right-click the DLL and select Register COM Server. The message DLLRegisterServer in c:\winnt\system32\msxml6.dll succeeded. will appear.

  4. Click OK.

Error Number: 429 Description: ActiveX component can't create object.

Perform the following steps:

  1. Open Windows Explorer.

  2. Navigate to c:\winnt\system32 directory and locate msxml4.dll.

  3. Right-click the DLL and select Register COM Server. The message DLLRegisterServer in c:\winnt\system32\msxml6.dll succeeded. will appear.

  4. Click OK.

Error Number -214722099 Description: Automation error in the dll.

Perform the following steps:

  1. Location and open the file ExcelToCI2007.xlsm.

  2. Press Alt + F11 to open the Microsoft Visual Basic Editor.

  3. Select Tools > Add references.

  4. Deselect anything that begins with Microsoft XML.

  5. Browse for c:\winnt\system32msxml6.dll and click OK.

  6. Select that version of msxml and click OK.

  7. Click Save.

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.