Information Steward 4.0 DB2 Profiling Errors

[Former Member]

We cannot getDB2 profiling to complete without error. We are able to view the data in Information Steward but profiling fails with the following. Any ideas on what we might try? Thanks

<i> 2012-01-30 12:06:18.500 Started execution on 2012-01-30 12:06:15. (COR-10014)

[C] 2012-01-30 12:06:18.757 License validation done successfully.

[C] 2012-01-30 12:06:18.783 Acquiring batch lock. (COR-10003)

[C] 2012-01-30 12:06:18.828 Batch lock has been acquired. (COR-10214)

[C] 2012-01-30 12:06:18.985 1 inserts and 0 deletes were rolled back from table InfoProf.MMT_Deployed_Software_Module. (COR-10138)

<i> 2012-01-30 12:06:19.319 Utility processing starts.

<i> 2012-01-30 12:06:19.327 Started Task process ColumnProfiling 2012.01.30 12:05:38 [task ID=376]. (TSK-10025)

<i> 2012-01-30 12:06:19.347 Initializing Subtask queue with information from Task. (TSK-10040)

<i> 2012-01-30 12:06:20.240 Started Subtask process [subtask id=7181], processing table [F0DB27.TMATLMFR]. (TSK-10037)

<i> 2012-01-30 12:06:21.516 Processed [1] of [1] sub tasks. (TSK-10047)

<i> 2012-01-30 12:06:21.525 Summary of task [ColumnProfiling 2012.01.30 12:05:38] with [1] subtask(s) executed. (TSK-10005)

<i> 2012-01-30 12:06:21.532 [1] Subtask(s) executed with errors. (TSK-10007)

<i> 2012-01-30 12:06:21.548 Subtask [run id=1] Table F0DB27.TMATLMFR: while trying to invoke the method java.lang.String.length() of an object loaded from local variable str (TSK-10008)

<i> 2012-01-30 12:06:21.641 Task process finished with errors. Status is set to failed. (TSK-10027)

<i> 2012-01-30 12:06:21.649 Utility processing ended.

[C] 2012-01-30 12:06:21.940 0 inserts and 1 deletes were performed on table InfoProf.MMT_Extended_Text. (COR-10041)

[C] 2012-01-30 12:06:22.125 Batch lock has been released. (COR-10215)

[E] 2012-01-30 12:06:22.136 Utility failed with code 4. (COR-10020)

<i> 2012-01-30 12:06:22.144 Completed execution on 2012-01-30 12:06:22. (COR-10015)

<i> 2012-01-30 12:06:22.151 Elapsed time is 0:06.357 [min:sec.millisec]. (COR-10084)

[former_member612715]

Hi John,

I am facing the same issue here so what did do you to resolve this. I deleted the old connections and created new again but it could not help. Do we need to reinstall Info Steward?

Could you please describe what to do?

[Former Member]

Hi Krishan,

I'm working on this same issue. The only diffrence is that my issue happens after an export and then import into another environment. Like from Dev to QA systems. The QA systems has a different backend so we have to change the server name. Everthing else is the same. I'll be doing some testing today and will update this thread with my findings.

[prashant_saini]

We also had the same issue.  We later discovered that the data in a couple of our source tables was still being loaded.  so the volume was growing while we were doing the profiling.  Once the bulk loads completed, we stopped getting the error. 

[Former Member]

This ended up being a corrupted connection. The connection was replaced and data profiling has resumed.