JamieMews Posted January 19, 2023 Share Posted January 19, 2023 All of our R Script reports are showing an error and have stopped working, (Error copied from .Out file) "Error in load(name, envir = .GlobalEnv) : embedded nul in string: 'Request ID,Cancellation Reason,Category Name,Closed By Team,Closed By Username,Closure Category Name,Date Closed,Date Logged,Date Resolved,Description,Request Resolve By,Reopened By Team,Reopened By Username,Resolved By Team,Resolved By Username,Site,Status,Request Type,Within Resolve Time,Customer ID\r\n"CH00040594","","Change","IT Systems Team","","Change>Completed",03 Nov 20 09:32:30,03 Nov 20 09:10:47,,"TempDB keeps filling OS volume and it should reside on Data / Log volumes",,"","","","","","status.closed","Change Request",,""\r\n"CH00040596","","Change","IT Systems Team: Change Management","","Change>Completed",03 Nov 20 09:25:22,03 Nov 20 09:23:06,,"Exchange 2016 is currently running CU 9 dated April 2018. Functionality within the EAC has now been lost and can no longer switch between O365 and On-Prem.",,"","","","","","status.closed","Change Request",,""\r\n"CH00040690","","Change"," Calls: sys.load.image -> load Execution halted" We think it started sometime after 17th Jan 20:00 Working off when the last time we had a successful Request ID. This report error is also included on Reports that dont contain any data from the "Requests" table. (e.g. Pulling Asset Data) Link to comment Share on other sites More sharing options...
James Ainsworth Posted January 23, 2023 Share Posted January 23, 2023 Hi @JamieMews I was interested to know if you have made any headway with this or if it is still an issue? I'm afraid that I don't personally have knowledge of R Script and can't say at this point if the issue is with the script or Hornbill. The only thing that jumped out to me is there there are some set of commas that don't include quotes between them and others that do. Only a guess, but is one of these expecting a string or at least a space using quotes, but instead they are being seen as nul? Link to comment Share on other sites More sharing options...
JamieMews Posted February 1, 2023 Author Share Posted February 1, 2023 I took the names of our users out of the error. This issue is still on going, I dont understand why a report for an Asset is showing an error for a CR. Maybe our instance is bugged. Link to comment Share on other sites More sharing options...
JamieMews Posted February 3, 2023 Author Share Posted February 3, 2023 We have managed to resolved the issue We ran this command on the R Workspace using CMD --no-restore 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now