Troubleshooting
Problem
When running a column analysis status in Activity Status pane shows "Error Encountered". iasServer.log/iasServer-server1.log contains the following: Error [IBM-IA-SERVER] [] PXProcessor.java:80 ColumnAnalysisTask89569188: Job status -> 1: Error creating DS job Warn [IBM-IA-SERVER] [] IA Job Status
Symptom
- Information Analyzer console will show:
- DataStage Director client will show:
- Note the "Not compiled" status for BaseProfileLoad1_ColumnAnalysisTask* job
- <WAS_IS_PROFILE>/iasServer.log shows the following:
- Error [IBM-IA-SERVER] [] PXProcessor.java:80 ColumnAnalysisTask89569188: Job status -> 1: Error creating DS job
Warn [IBM-IA-SERVER] [] IA Job Status
------------------------------------------------------------------------------
| Job Execution Status -> ColumnAnalysisTask89569188 |
| JOB TYPE : com.ascential.investigate.ca.job.BaseProfileJob |
| JOB PROCESSOR : com.ascential.investigate.utils.jobs.osh.PXProcessor |
|----------------------------------------------------------------------------|
| Data Stage> ANALYZERPROJECT@SERVER_NAME:31538, credentialMapping=false |
| Scratch Data Source> iadb@server_name:port# (DATABASE) |
| [] pre-process completed (0 sec) |
| [] main-process failed (1 sec) |
| [] post-process failed (0 sec) |
| |
| Job run *FAILURE* in 1 seconds. |
------------------------------------------------------------------------------
Resolving The Problem
Drop the data source and load it again
- Open Information Analyzer console, select Home > Configuration > Sources
- Click data source on the left side of the pane that error was encountered--UNKNOWN used for demonstration
- Click delete on the right pane side of the pane to delete and follow prompts to delete data source.
- Add data source again. See "Configuring IBM InfoSphere Information Analyzer" in related information section below for more information.
- Set the Update Existing Tables option on the column analysis pane to "No" and run column analysis again to verify if previous columns that generated "Error Encountered" instead of "Analyzed".
NOTE: If Column Analysis was previously run, tables for the column might already exist. Use this option and select Yes. If you choose No and tables exist with user analysis decisions, those analysis decisions (such as valid or invalid values, selected data type or length) will be lost
- Perform previous steps to run column analysis again. See "Running a column analysis job" in related information section below for more information.
Related Information
[{"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.7;8.5;8.1;8.0.1","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21607307