Jump to content

Attachments error on migration from SupportWorks to Hornbill


Recommended Posts

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.

Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...