Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

SQL query failing while importing work items from csv file

Hi everyone,

I am consistently running into a problem while importing work items using the built-in importer through Eclipse. I have imported probably 2000+ work items without incident, but a number of work items across many of the csv files I have been using throw the following error:

Could not create work item from <file>.csv (Line 2)
CRJAZ0368I A SQL query failed to execute properly on the server.
stmt = select t1.ITEM_ID, t1.STATE_ID from MODEL.CATEGORY t1 where ((t1.PROJECT_AREA_ITEM_ID = ?) and (t1.INTERNAL_CATEGORY_ID = ?)

I have asked the DB admin to look into the issue, but she claims that the particular command runs without issue when she fills in values. I have only seen this happen for maybe 5 work items in total, while other work items of the same exact type, with the same map file, import without issue.

Does anyone know where I could look to find more info about this, or has anyone experienced this before?

Thanks,
- Josh

0 votes



One answer

Permanent link
Hello Joshua,
Definietely you should look into ccm.log file on your server. It should contain more details what and why exactly failed on the server.

Let me know if it helps for you.

Best regards,
Krzysztof Kazmierczyk

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 173
× 43
× 37

Question asked: Mar 05 '13, 2:28 p.m.

Question was seen: 6,926 times

Last updated: Jul 23 '13, 3:12 a.m.

Confirmation Cancel Confirm