topic Re: excel file edit via office throw error: excel couldn't find file in Codebeamer

excel file edit via office throw error: excel couldn't find file

MM_10991077 — Tue, 22 Oct 2024 07:55:56 GMT

Hello all,

user wants to edit excel file document using office and gets below error:

Office editor is installed ver. 2.0

Delete browser cache is not helping now (it helped one day ago).

Tried on Edge and Chrome browser.
No error visible in Codebeamer log.

any idea?

update:

after check of cboffice_launcher.log in C:\Users\<username>\AppData\Local\Temp\

I have realized that ":" is missing after https

22-Oct-24 9:44:33 AM - ----------------------------------
22-Oct-24 9:44:33 AM - Starting cbOffice Launcher - 1.03
22-Oct-24 9:44:33 AM - Original url: cboffice://https//Server-Name/cb/officeedit/C4iKYBjM8zG4bQPkoyks2fekME6LC0JlqSdZTboB7cQ/Trigger%5FMessages%5Ffor%5FInbound.xls
22-Oct-24 9:44:33 AM - Service Url: https//Server-Name/cb/officeedit/C4iKYBjM8zG4bQPkoyks2fekME6LC0JlqSdZTboB7cQ/Trigger%5FMessages%5Ffor%5FInbound.xls
22-Oct-24 9:44:33 AM - File type: .xls
22-Oct-24 9:44:33 AM - Command: %comspec% /c assoc .xls > "C:\Users\userXYZ\AppData\Local\Temp\radC7736.tmp"
22-Oct-24 9:44:33 AM - Command: %comspec% /c ftype Excel.Sheet.8 > "C:\Users\userXYZ\AppData\Local\Temp\radA7F62.tmp"
22-Oct-24 9:44:33 AM - Associated Program: C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE
22-Oct-24 9:44:33 AM - Start associated command: %comspec% /c "C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE" https//Server-Name/cb/officeedit/C4iKYBjM8zG4bQPkoyks2fekME6LC0JlqSdZTboB7cQ/Trigger%5FMessages%5Ffor%5FInbound.xls

any idea how to fix it ?

thank you

Re: excel file edit via office throw error: excel couldn't find file

alfonso_c — Tue, 22 Oct 2024 10:36:00 GMT

Hello @MM_10991077 , I can reproduce a similar issue on MS Edge: Word document opens, but it's blank. Local log:

10/22/2024 12:21:31 PM - ---------------------------------- 10/22/2024 12:21:31 PM - Starting cbOffice Launcher - 1.03 10/22/2024 12:21:31 PM - Original url: cboffice://http//localhost:8080/officeedit/ciFjBQjnt6uPxTa%5Fv2kZhLwneoH2LPxor7bYp49dfBc/issue-desc-1099.docx 10/22/2024 12:21:31 PM - Service Url: http//localhost:8080/officeedit/ciFjBQjnt6uPxTa%5Fv2kZhLwneoH2LPxor7bYp49dfBc/issue-desc-1099.docx 10/22/2024 12:21:31 PM - File type: .docx 10/22/2024 12:21:31 PM - Command: %comspec% /c assoc .docx > "C:\Users\acrisci\AppData\Local\Temp\radC59CA.tmp" 10/22/2024 12:21:31 PM - Command: %comspec% /c ftype Word.Document.12 > "C:\Users\acrisci\AppData\Local\Temp\radBA0D6.tmp" 10/22/2024 12:21:31 PM - Associated Program: C:\Program Files\Microsoft Office\Root\Office16\WINWORD.EXE 10/22/2024 12:21:31 PM - Start associated command: %comspec% /c "C:\Program Files\Microsoft Office\Root\Office16\WINWORD.EXE" http//localhost:8080/officeedit/ciFjBQjnt6uPxTa%5Fv2kZhLwneoH2LPxor7bYp49dfBc/issue-desc-1099.docx

The Start associated command: %comspec% /c "C:\Program Files\Microsoft Office\Root\Office16\WINWORD.EXE" http//localhost:8080/ does not look correct.

I tested on Mozilla Firefox and Google Chrome and it worked well, the last line also correctly produced http:// instead of http//. I continue to investigate and will post updates if I have any. In the meantime, please feel free to raise a support ticket to get further assistance.

Re: excel file edit via office throw error: excel couldn't find file

MaKo — Fri, 25 Oct 2024 09:38:46 GMT

Also on our system, recently users report same error that file cannot be found.

Re: excel file edit via office throw error: excel couldn't find file

PK_11894474 — Fri, 25 Oct 2024 11:07:50 GMT

Hi All,

I think I found a solution for the problem the URL seems to be wrong.

I updated the "C:\Program Files\codebeamer Office Launcher\cboffice_launcher.vbs" file adding the following 2 lines.

to line 30 and 31

url = Replace(url, "https//", "https://")
url = Replace(url, "https/", "https://")

After this change office_launcher started working as before.

Kind Regards,

Peter

Re: excel file edit via office throw error: excel couldn't find file

alfonso_c — Thu, 31 Oct 2024 09:13:54 GMT

Thanks for sharing this possible approach, I can see this has been recently reported to our Engineering Team, more information is at this page: MS Excel file opened with "Edit Via Office" from Documents tab shows error "'Sorry, we couldn't find https/<hostname>:<port>/cb/officeedit/<some_hashcode>/<filename>.xlsx.Is it possible it was moved, renamed or deleted?'"

Re: excel file edit via office throw error: excel couldn't find file

MM_10991077 — Thu, 31 Oct 2024 09:30:55 GMT

Hello Alfonso,
workaround works for me but it is not suitable for our company.
Problem is that majority of our users do not have admin right on their computer and cannot edit vbs.
Proper solution would be to release a new office editor installer and then all companies can deploy it over their users.
thank you

Re: excel file edit via office throw error: excel couldn't find file

PK_11894474 — Thu, 31 Oct 2024 09:39:46 GMT

Hi,

I think the change can be rolled out using a domain logon script. In this way when the user logs in, the change can be added to it's system the same way as mounting a new network drive.

https://learn.microsoft.com/en-us/troubleshoot/windows-server/user-profiles-and-logon/assign-logon-script-profile-local-user

https://www.edugeek.net/forums/windows-7/105015-how-replace-files-windows-7-pcs-logon-perhaps.html

I hope it helps!

Kind Regards,

Peter