Topic
  • No replies
AmyKel
AmyKel
1 Post

Pinned topic Data Studio Web Console Import Feature - Not Working

‏2013-09-20T14:16:14Z |

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][102][10040][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!.

Updated on 2013-09-23T14:44:23Z at 2013-09-23T14:44:23Z by AmyKel