chriscorcoran Posted November 11, 2020 Share Posted November 11, 2020 Just refreshing a report this morning and getting the following erro, nothing I know of has changed. I have set myself a new API key just in case but I still get ADO.NET: R script error. Error: Argument 'txt' must be a JSON string, URL or file. Execution halted Any ideas? Link to comment Share on other sites More sharing options...
chriscorcoran Posted November 11, 2020 Author Share Posted November 11, 2020 I did notice a new script posted in git so I have tried thet but now get We encountered an error while trying to connect. Details: "Unable to translate bytes [E2][80] at index 0 from specified code page to Unicode." Tested on two seperate reports that use R and both fail with the same error. Link to comment Share on other sites More sharing options...
chriscorcoran Posted November 11, 2020 Author Share Posted November 11, 2020 My bad, typical man, hadnt read through readme, I forgot the issue of Details: "Unable to translate bytes [E2][80] at index 0 from specified code page to Unicode. is caused by UTF-8, chnaged it to ISO-8859-1 This will usually be "UTF-8", but if you have issues returning data with certain characters (the Windows E2 80* characters are the usual culprits) then choose a different character set to use, ie: "ISO-8859-1" Link to comment Share on other sites More sharing options...
chriscorcoran Posted November 11, 2020 Author Share Posted November 11, 2020 spoke to soon getting the following when I updated the script in my source settings OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)). Link to comment Share on other sites More sharing options...
chriscorcoran Posted November 11, 2020 Author Share Posted November 11, 2020 I have gone back to the report it is using in Hornbill and when I export the csv the report is corrupt. Looks fine in preview. Are there issues with the reporting? Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted November 11, 2020 Share Posted November 11, 2020 HI @chriscorcoran Is this the same as your problem? Link to comment Share on other sites More sharing options...
chriscorcoran Posted November 11, 2020 Author Share Posted November 11, 2020 @Paul Alexander thanks, thats what I'm seeing. 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