Author Topic: Bug: File Path too short  (Read 4285 times)

skiwi

  • EA Practitioner
  • ***
  • Posts: 1949
  • Karma: +42/-82
    • View Profile
Bug: File Path too short
« on: March 03, 2014, 10:11:34 am »
In an elements properties, under Related . Files

I tried pasting the delightful URL
http://www.minedu.govt.nz/NZEducation/EducationPolicies/InternationalEducation/ForProvidersOfInternationalEducation/ExportEdIndustryDevFundAndLevy/CollectionOfTheExportEducationLevy/CollectionOfExportEducationLevyFromPrivateTrainingEstablishmentsThatDoNotRecieveGovernmentFunding.aspx
and got an error that the field is too small.

To adequately represent scheme://domain:port/path?query_string#anchor
requires 4.624 characters by my calculations

Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 7533
  • Karma: +94/-17
    • View Profile
Re: Bug: File Path too short
« Reply #1 on: March 03, 2014, 10:55:01 am »
Unfortunately, it's a restriction of our database schema, which has only been updated for indexes since version 4.0. I wouldn't expect a change any time soon.
Eve

support@sparxsystems.com

Helmut Ortmann

  • EA User
  • **
  • Posts: 939
  • Karma: +41/-1
    • View Profile
Re: Bug: File Path too short
« Reply #2 on: March 04, 2014, 01:38:32 am »
Try using an local path to short the path length.

Settings, Local Directories and Paths,...

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

qwerty

  • EA Guru
  • *****
  • Posts: 12234
  • Karma: +346/-280
  • I'm no guru at all
    • View Profile
Re: Bug: File Path too short
« Reply #3 on: March 04, 2014, 05:27:34 am »
Quote
In an elements properties, under Related . Files

I tried pasting the delightful URL
http://www.minedu.govt.nz/NZEducation/EducationPolicies/InternationalEducation/ForProvidersOfInternationalEducation/ExportEdIndustryDevFundAndLevy/CollectionOfTheExportEducationLevy/CollectionOfExportEducationLevyFromPrivateTrainingEstablishmentsThatDoNotRecieveGovernmentFunding.aspx
and got an error that the field is too small.

To adequately represent scheme://domain:port/path?query_string#anchor
requires [highlight]4.624 [/highlight]characters by my calculations

 
That's a long URL indeed. Looks like you're trying to send mails to your web server ;-)

q.

Nizam Mohamed

  • EA User
  • **
  • Posts: 190
  • Karma: +0/-0
    • View Profile
Re: Bug: File Path too short
« Reply #4 on: March 04, 2014, 03:20:22 pm »
Did you consider using a tagged value instead.
NB - Type URL does not support more than 255 either, Try using memo

skiwi

  • EA Practitioner
  • ***
  • Posts: 1949
  • Karma: +42/-82
    • View Profile
Re: Bug: File Path too short
« Reply #5 on: June 17, 2014, 12:51:12 pm »
Suckered into this again.

The point about a URL is that its clickable.

Time the database schema was updated, perhaps.

As for the length


Local path doesn't like URLs (please select relative path first) = kludgy, but ta
Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 7533
  • Karma: +94/-17
    • View Profile
Re: Bug: File Path too short
« Reply #6 on: June 17, 2014, 02:54:12 pm »
Quote
I wouldn't expect a change any time soon.
Eve

support@sparxsystems.com

Graham_Moir

  • EA User
  • **
  • Posts: 729
  • Karma: +8/-12
    • View Profile
Re: Bug: File Path too short
« Reply #7 on: June 17, 2014, 06:59:46 pm »
Have I missed something?  Wouldn't the simplest answer be to use a service like tinyurl.com.  You get a short URL so you can add clickable links and it automatically redirects to the target you want.

skiwi

  • EA Practitioner
  • ***
  • Posts: 1949
  • Karma: +42/-82
    • View Profile
Re: Bug: File Path too short
« Reply #8 on: June 18, 2014, 07:10:08 am »
Quote
Wouldn't the simplest answer be to use a service like tinyurl.com.
Well yes, you are correct, but that is (another) work around (a bit like adding images to this forum).

Instead Sparx could add a new table to the schema with a decent length, and, say, use, both fields, I'm sure they have the technical capability to make it backwardly compatible, and no doubt there would be other areas that could benefit (e.g. longer tags).

Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 7533
  • Karma: +94/-17
    • View Profile
Re: Bug: File Path too short
« Reply #9 on: June 18, 2014, 08:55:15 am »
I wasn't here when the last schema update was done. I know only two things. The first is that it was tiny. The second is that it is still haunting the people involved.

That's why I recommend using whatever workaround you need to, because this isn't going to prompt a schema change.
Eve

support@sparxsystems.com

davidkrethallen

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Bug: File Path too short
« Reply #10 on: December 20, 2020, 09:40:45 am »
I also have this issue. I am trying to deep-link to a powerpoint slide in Office 365. As more people move to the web, this will become more annoying.
I get that this won't get fixed ASAP. But how do we get it on the backlog for consideration by the development team. It should at least be logged and the opportunity explored.

skiwi

  • EA Practitioner
  • ***
  • Posts: 1949
  • Karma: +42/-82
    • View Profile
Re: Bug: File Path too short
« Reply #11 on: December 21, 2020, 01:03:20 pm »
Quote
I wouldn't expect a change any time soon.
Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

qwerty

  • EA Guru
  • *****
  • Posts: 12234
  • Karma: +346/-280
  • I'm no guru at all
    • View Profile
Re: Bug: File Path too short
« Reply #12 on: December 21, 2020, 08:57:12 pm »
The "soon" is superfluous.

q.

Uffe

  • EA Practitioner
  • ***
  • Posts: 1859
  • Karma: +132/-14
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Re: Bug: File Path too short
« Reply #13 on: December 21, 2020, 11:42:35 pm »
Have I missed something?  Wouldn't the simplest answer be to use a service like tinyurl.com.  You get a short URL so you can add clickable links and it automatically redirects to the target you want.
There are good reasons why you wouldn't want to use such a service. Security and robustness spring immediately to mind. The existence of such services is not something that can be relied upon, and therefore not a reason for this bug to persist.

Taking off in a slightly different direction, what if users just change the schema themselves?

The handling of the t_secuser.UserLogin size issue, which in 15.6.1556 prompted the change Security User login names will now truncate to the database field length rather than a fixed value, to accommodate users extending the field in the Database, suggests that user hacking of the schema is encouraged and the tool will, where necessary, be updated to handle such hacks.

This situation appears to be identical -- an nvarchar that is too short for the purpose. So is this an occasion where hacking is encouraged?

Or will this hack have bad consequences which will not be accomodated in future releases?


/Uffe
My theories are always correct, just apply them to the right reality.

timoc

  • EA User
  • **
  • Posts: 153
  • Karma: +10/-0
    • View Profile
Re: Bug: File Path too short
« Reply #14 on: December 27, 2020, 11:03:02 pm »
Seems like schema changes are allowed, even in point releases - as we just had one for last 15.2 (1557) release (that seems to include the hack above). Possibly this could be fixed in the next point release?

Another 'work around' option that Sparx could consider, is to extend the 'Hyperlink Target Objects' to include something like the javascript: uri type (https://tools.ietf.org/html/draft-hoehrmann-javascript-scheme-03'') to generate the target addresses. e.g referencing a script in the library that generates the URL on demand or similar.

This approach could potentially solve other issues, such as situaitons where you want to map to different things depending on the project and environment.  Staging vs Production, or model versions are a few examples.   
Something like:
Code: [Select]
javascript:GeneratePath('Produciton')

« Last Edit: December 27, 2020, 11:37:15 pm by timoc »