Attachments error on migration from SupportWorks to Hornbill

[Caroline]

I've done multiple migrations (SWRequestImport tool) over the last few weeks and today I'm getting errors and attachments are not migrating. Does this relate to the recent update Service Manager (2246)?

 

2021/06/22 16:54:06 [ERROR] Added file data but unable to set Content Location on [SR00002801] for File Content [F0011944 - General Question - Please find attached query on question reference 3136_.msg]: The text size provided (309 characters) is greater than the maximum allowable size of 256 characters for column h_contentlocation
 

We are due to kick off our final migration on Thursday, so this is a major issue for us.

[Guest Mary]

Hi @Caroline

33 minutes ago, Caroline said:

The text size provided (309 characters) is greater than the maximum allowable size of 256 characters for column h_contentlocation

The above indicates the value you have mapped to the h_contentlocation field in Hornbill contains 309 characters but the h_contentlocation field can hold a maximum of 256 characters. 

[Caroline]

Thanks for the reply Mary. To clarify, I have not made any changes to the mapping and it was importing attachments without error until yesterday. There's no h_contentlocation field in my conf.json so I've no idea how it is mapping to this, we only define the source file path for attachement, no other attachment related config that I can find.

 

However the recent update to Service Manager (2246) states: 

• The attachment procedure has been updated in line with the server changes to enhance the storage and security of attachments.

[Steve G]

Hi @Caroline,

We'll take a look at this issue this afternoon and will let you know how we get on.

Cheers,

Steve

[Steve G]

Hi @Caroline,

The utility now been updated to support these changes in the platform, and can be downloaded from Github.

Cheers,

Steve

[Caroline]

Thanks for the quick turnaround on this one, it is working and we were able to successfully migrate last night.