I'm trying to import jobs from my Task Center database into the Web Console. We're trying to migrate from 9.5 to 10.1. When I click on import, it can connect to the database and it selects the list of jobs I want to import however it doesn't import them. I get the following error:
_ImportFromTaskCenterLog__ (209) Sep 20, 2013 8:49:17 AM ERROR Error in JobManagerService.importTasks() com.ibm.datatools.common.repository.mgr.RepositoryException: com.ibm.db2.jcc.am.SqlDataException: Error for batch element #1: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.63.81 [Batch operation exception. Operation failed on the 0th statement. -1 rows were inserted/updated. SQL state = null; error code = -4229; error Message = [jcc][t4][3.63.81] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null, SQL Exception. SQL state = 22001; error code = -302; error Message = Error for batch element #1: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.63.81]
It can see the jobs, I can select them to import them but it doesn't import them.
I have over 200 jobs in Task Center so I don't want to manually rebuild each one. I need the Import function to work if at all possible.
Any assistance you can provide would be appreciated!.