Information Analyzer data sampling error
Posted: Tue Jun 08, 2010 10:00 am
Hi Experts,
I have done column analysis successfully on one source table using Information Analyzer.Now when I open Primary key analysis tab and try to run "Create data sample" task, I get the below error.
IA-Handler: Start new handler task 41
Sampling enabled
=================
executeEngineInfo.getSampleNthValue = 0
executeEngineInfo.getSamplePercent = 5.0
executeEngineInfo.getSampleSeed = 1276012653429
executeEngineInfo.getSampleSize = 2000
executeEngineInfo.getSampleType = 2
executeEngineInfo.isSampleUsed = true
Job 41: DataSample12654719: Creating datastage job
Job 41: DataSample12654719: starting job run
Job 41: DataSample12654719: job status is running
Job 41: DataSample12654719: aborted
Job failure log
============
Event 1: pxbridge(1): [IIS-CONN-DAAPI-000063] Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 2: pxbridge(1): [IIS-CONN-ODBC-000033] An error occurred while dropping the existing table. Statement = {0}
Event 3: main_program: Fatal Error: [IIS-CONN-ODBC-000034] An error occurred while creating the table. Statement = {0}
Job failed:CleanUpDataSample
Job 41: DataSample12654719: job deleted
IA-Handler: Handler task 41 failed: processing time of 26 seconds.
Kindly help.
I have done column analysis successfully on one source table using Information Analyzer.Now when I open Primary key analysis tab and try to run "Create data sample" task, I get the below error.
IA-Handler: Start new handler task 41
Sampling enabled
=================
executeEngineInfo.getSampleNthValue = 0
executeEngineInfo.getSamplePercent = 5.0
executeEngineInfo.getSampleSeed = 1276012653429
executeEngineInfo.getSampleSize = 2000
executeEngineInfo.getSampleType = 2
executeEngineInfo.isSampleUsed = true
Job 41: DataSample12654719: Creating datastage job
Job 41: DataSample12654719: starting job run
Job 41: DataSample12654719: job status is running
Job 41: DataSample12654719: aborted
Job failure log
============
Event 1: pxbridge(1): [IIS-CONN-DAAPI-000063] Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 2: pxbridge(1): [IIS-CONN-ODBC-000033] An error occurred while dropping the existing table. Statement = {0}
Event 3: main_program: Fatal Error: [IIS-CONN-ODBC-000034] An error occurred while creating the table. Statement = {0}
Job failed:CleanUpDataSample
Job 41: DataSample12654719: job deleted
IA-Handler: Handler task 41 failed: processing time of 26 seconds.
Kindly help.