Tuesday, August 10, 2021

Buggish: The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.

One of those moments where I just want to pull my hair out. I had this working last night, and suddenly stopped working. I just spent the last several hours troubleshooting the error: tried different configurations, parameters, figure out how to use Fiddler, several google searches, etc.

The problem/answer was basically that I was using the wrong slashes. The path should be using forward slashes '/' not back slashes '\' and without rdl.

\Folder1\ReportName

Psychology

To give myself the tiniest of credit, I initially solved this while rushing to pick up my daughter. It's a lame excuse but I think it important to why I didn't remember what I did. It worked and I left figuring I could return to see my work.

I think I left my project running and stopped the debugging, so I didn't see what values I ended putting in. This probably wouldn't have helped because I probably wouldn't have looked at the direction of the slash. I figured I had it in the code because I got tired of entering the data so I hard-coded the initial value.

I assumed that was correct and maybe I just put in the wrong path. I tried several paths like http://SsrsServer/ReportServer, http://SsrsServer/Reports/, http://Ssrs/Reports/browse, /folder1/reportName, /folder1/reportName.rdl, and also sorts of permutations of paths and file names.

I do not know why I didn't even check the slashes as that should have been one of the first things to check. To make it worse, I do not know why I even thought of it so suddenly. After this entire ordeal, I recall how I figured it out in the first place was because I used the http path then removed the beginning part. Because it used forward slashes, this fixed my problem.

Sometimes I really find how amazing my brain is at forgetting things.

No comments:

Post a Comment