[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]

Which table is that? How did you get to that list? I couldn't find that anywhere (a list of all the relationships)!

My instance is https://dev41040.service-now.com

[sergiu_panaite · Accepted solution]

So relations are imported into cmdb_rel_ci table, which means I can just go here and see what was imported:

ServiceNow

They show correctly in your instance as well, so not sure where the problem is:

[samkompfner]

oh, that particular URL is not one of the 'out-of-the-box' links that I can see on the left hand side menu of SN, that's why I hadn't seen it yet.

https://dev41040.service-now.com/cmdb_rel_ci_list.do?sysparm_query=parent.nameLIKEGateway

Ah - I know why the relationships look correct on that screen - I manually created those relationships, through the BSM, not import. I shall delete them and re-import them.

[sergiu_panaite]

Any table in the platform can be accessed via the type filter text or URL as tablename_list.do. So you won't find every table in the navigator, but that doesn't means you can't access it directly

[samkompfner]

Well, importing from that page (the CI Rel list) works perfectly!

I don't know what that other table I was importing to was doing, but something wasn't right. I am happy now I know the correct way to import relationships! Thank you very much for your help, Sergiu.