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  of  sub tasks. (TSK-10047)
<i> 2012-01-30 12:06:21.525 Summary of task [ColumnProfiling 2012.01.30 12:05:38] with  subtask(s) executed. (TSK-10005)
<i> 2012-01-30 12:06:21.532  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)
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.