Solved: No Such ConfigItemID

[RBehr]

I have imported a number of Configuration Items.

Now, when I come to perform the update again (a few updates and some new CIs), I get the following:

Code: Select all

Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	Can't import entity 310: Error when adding the new config item version.
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	No such ConfigItemID (5673)!
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	Can't import entity 309: Error when adding the new config item version.
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	No such ConfigItemID (5672)!
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	Can't import entity 308: Error when adding the new config item version.
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	No such ConfigItemID (5671)!
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	Can't import entity 307: Error when adding the new config item version.
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	No such ConfigItemID (5670)!
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	Can't import entity 306: Error when adding the new config item version.
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	No such ConfigItemID (5669)!
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	Can't import entity 305: Error when adding the new config item version.
Mon Nov 28 11:06:35 2011	error	OTRS-CGI-10	No such ConfigItemID (5668)!
... all the way down to entity 1

There are 3554 lines in the import fie, but the system log shows only 310 import attempts.

If the number in brackets refers to the actual id column in table ConfigItem, then the error is obvious, since my id numbers don't go that high. Where is OTRS getting the ConfigItemID from and why can it not match it?

[RBehr]

Every time I attempt to run this, the number in brackets gets higher. Why would this be?

[crythias]

auto increment in the database...

[RBehr]

Yes, I reset that (in configitem_counter) to the highest id in table configitem + 1, but this did not resolve it. Should I reset this to zero?

[crythias]

I don't know that will help. It appears that you're importing items without config item IDs so they're being auto-assigned. As you've already said that you know your ConfigItemIDs, it would seem reasonable to expect that what you're importing should have them attached.

This, however, is just a guess, but is based on the context you provided.

[RBehr]

Understood.

I know the IDs, but I am not using them in the import template. I have set another field as the identifier (the import template doesn't expose ConfigItemID anyway). So, although I know the IDs and table structures, I am not working outside the OTRS framework. Just trying to import in the usual way. If we pretend I know nothing about the database schema, what would cause the error I describe for an "ordinary" user?

[RBehr]

Crythias, somebody, help!

This issue remains, we are unable to update our CIs.

To re-state the problem. A text file, in a format which was working, is not not being imported. Each row returns the error (to the SysLog):

Code: Select all

Can't import entity x: Error when adding the new config item version.
No such ConfigItemID (y)!

Where x is the line number of the import file and y is an ever-increasing number apparently generated by the system.

[RBehr]

This was a problem of my own making. Please see http://forums.otrs.org/viewtopic.php?f= ... 012#p50388 for both the cause and the solution.