[CI_CMDB_Rel] CI name string limit (32) on importing Relationships - help needed!

[samkompfner]

Hello,

        wondering if anyone has come across this issue, and if so, how they overcame it.

Our naming convention has CIs with names > 32 characters, but when I try to import relationships between them, they are truncated, the names are stored in the ci_cmdb_rel table, truncated down to 32 characters. This causes the relationships to fail.

For example, my import set:

But what is actually stored in the table:

Now, I understand that ServiceNow stores the SYS_ID of each CI, not the Display Name, but what is shown (and what is imported) IS the Display Name.

(from http://wiki.servicenow.com/index.php?title=Reference_Fields#gsc.tab=0   )

This to me is a design flaw. Do I really have to limit my CI names to 32 characters?

[samkompfner]

I don't think it is a custom one - I wouldn't know how to create a custom one!

It was just one from the following out-of-the-box list (I am using the Developer instance at the moment):

[sergiu_panaite]

Let me try it on my developer instance. I'll let you know later today.

[sergiu_panaite]

Would you be able to provide the example XLS file so I don't have to build from scratch one ?

[samkompfner]

Hi Sergiu, I have attached an XLSX file which has 2 tabs - tab 1 to import the CIs (class Business Services), and tab 2 to import the Relationships (to the CI_CMDB_Rel table). Thank you for testing this

[sergiu_panaite]

Just did it on my own instance and works fine, see below:

If you use a developer instance, can you tell me the instance name? I could have a look directly in your instance.

Regards,

Sergiu