autstat Support

Even after installing the new beta version of statconnDCOM I still get the error message. Ironically this happens after the add-inn correctly opened an R Window, and I see the loading screen of statconn. Once I click on the close button - I guess I have to click on, right? because if I don't I can't do anything else anyway - I get the aforementioned error message in Excel. "There seems to be no R process connected to Excel".
I can now continue on producing this error message by clicking "connect R" in Excel.

I deinstalled and reinstalled R, RExcel and statconn according to wiki descriptions (twice, for good measure, including rebooting the computer a few times as well). But that hasn't helped.

Someone else here also reported I'm guessing the same error in another thread, so it's not just me.


Here's the debug information:

Windows 7
Version 6.1 (Build 7601: Service Pack 1)


> R.Version()$version.string
[1] "R version 3.3.2 (2016-10-31)"
> sessionInfo()
R version 3.3.2 (2016-10-31)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1

locale:
[1] LC_COLLATE=German_Germany.1252 LC_CTYPE=German_Germany.1252
[3] LC_MONETARY=German_Germany.1252 LC_NUMERIC=C
[5] LC_TIME=German_Germany.1252

attached base packages:
[1] stats graphics grDevices utils datasets methods base
> installed.packages()["rscproxy",]
Package
"rscproxy"
LibPath
"C:/Users/xxxxxxx/Documents/R/win-library/3.3"
Version
"2.1-1"
Priority
NA
Depends
NA
Imports
NA
LinkingTo
NA
Suggests
NA
Enhances
NA
License
"statconnDCOM PUBLIC LICENSE"
License_is_FOSS
NA
License_restricts_use
NA
OS_type
NA
MD5sum
NA
NeedsCompilation
NA
Built
"3.3.0"
> installed.packages()["rcom",]
Package
"rcom"
LibPath
"C:/Users/xxxxxx/Documents/R/win-library/3.3"
Version
"3.1-3"
Priority
NA
Depends
"R (>= 3.3.0), rscproxy (>= 2.1-1), utils"
Imports
NA
LinkingTo
"rscproxy"
Suggests
NA
Enhances
NA
License
"file LICENSE"
License_is_FOSS
NA
License_restricts_use
NA
OS_type
"windows"
MD5sum
NA
NeedsCompilation
NA
Built
"3.3.0"



DbgView output when using the Server 01 Basic test
[2296] statconnDCOM Installation path is "C:\Program Files (x86)\statconn\DCOM"
[2296] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=006C8DBC, installpath=C:\Program Files (x86)\statconn\DCOM, licensepath=C:\Program Files (x86)\statconn\DCOM
[2296] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\statconn\DCOM
[2296] BDX: DateTime enabled
[2296] BDX: Special .NET features enabled
[2296] BDX: x86 support (32bit) enabled
[2296] BDX: x64 support (64bit) enabled
[2296] askserver #1
[2296] askserver #2
[2296] askserver #3
[2296] H&S: Closing Splash Screen
[2296] ~SplashImpl
[2296] CStatConnector::~CStatConnector()
[3452] SCClient Information: 1 :
[3452] NamedTimer: OnTimerTick timeToRemindRequired, next period interval = 216000 milliseconds (Microsoft.SoftwareCenter.Client.Common.NamedTimer at OnTimerTick)


Text from StatConnector Test Window
Loading StatConnector Server... Done
Initializing R...Function call failed

Error Message from window called Test1 that opens when I click on the close button of the TESTING ONLY window
Run-time error '-2147023170 (800706be)': Automation error

Dear Christina,

from the information you provided, I can see that rscproxy is installed to

"C:/Users/xxxxxxx/Documents/R/win-library/3.3"

It seems, rscproxy (and also rcom) have not been installed correctly.

See http://autstat.com/index.php/Support/topic/3.html for the installation instructions.

rscproxy and rcom should be in the R installation directory.

Could you please try again and let us know if it works now!

Thomas

Hi Thomas,

unfortunately that doesn't help.

Here is what happens when I run the installation in R with admin rights (I don't get any error messages):

> options(install.packages.check.source = "no")
> install.packages(c("rscproxy","rcom"),repos="http://www.autstat.com/download",lib=.Library,type="win.binary")
versuche URL 'http://www.autstat.com/download/bin/windows/contrib/3.3/rscproxy_2.1-1.zip'
Content type 'application/zip' length 72400 bytes (70 K
downloaded 70 KB

versuche URL 'http://www.autstat.com/download/bin/windows/contrib/3.3/rcom_3.1-3.zip'
Content type 'application/zip' length 400985 bytes (391 K
downloaded 391 KB

Paket ‘rscproxy’ erfolgreich ausgepackt und MD5 Summen abgeglichen
Paket ‘rcom’ erfolgreich ausgepackt und MD5 Summen abgeglichen

Die heruntergeladenen Binärpakete sind in
C:\Users\xxxxxxxxx\AppData\Local\Temp\RtmpGUWCm3\downloaded_packages
> library(rcom)
Lade nötiges Paket: rscproxy
> comRegisterRegistry()
NULL
>


If I check afterwards again where the packages have been installed: hasn't changed. That might be the reason for my problems if the files should be somewhere else.

> installed.packages()["rscproxy",]
Package
"rscproxy"
LibPath
"C:/Users/xxxxx/Documents/R/win-library/3.3"
Version
"2.1-1"
Priority
NA
Depends
NA
Imports
NA
LinkingTo
NA
Suggests
NA
Enhances
NA
License
"statconnDCOM PUBLIC LICENSE"
License_is_FOSS
NA
License_restricts_use
NA
OS_type
NA
MD5sum
NA
NeedsCompilation
NA
Built
"3.3.0"
> installed.packages()["rcom",]
Package
"rcom"
LibPath
"C:/Users/xxxxxx/Documents/R/win-library/3.3"
Version
"3.1-3"
Priority
NA
Depends
"R (>= 3.3.0), rscproxy (>= 2.1-1), utils"
Imports
NA
LinkingTo
"rscproxy"
Suggests
NA
Enhances
NA
License
"file LICENSE"
License_is_FOSS
NA
License_restricts_use
NA
OS_type
"windows"
MD5sum
NA
NeedsCompilation
NA
Built
"3.3.0"

Please uninstall rcom and rscproxy first. Then verify, that the software really has been uninstalled (Look into the folder and see if rscproxy and rcom directories are gone).

How did you run R as administrator?

Christina,

a patch is available under "Download". Please download the StatConnectorSrv.exe and replace the original StatConnectorSrv.exe (typically in c:\Program Files (x86)\statconn\DCOM\bin) with the new one.

Then run the test again and post the DbgView output file.

Thanks.

Okay, uninstalled - had to do it twice, because the files had been installed in two locations, in the documents directory and in the R installation library; in any case, after deinstallation the directories were no longer in the folder.
Reinstalled. Now they are only in the correct directory. But the problem still stands. Same error.

To run as admin, I right clicked R and selected "Als Administrator ausführen".

> installed.packages()["rscproxy",]
Package LibPath
"rscproxy" "C:/Program Files/R/R-3.3.2/library"
Version Priority
"2.1-1" NA
Depends Imports
NA NA
LinkingTo Suggests
NA NA
Enhances License
NA "statconnDCOM PUBLIC LICENSE"
License_is_FOSS License_restricts_use
NA NA
OS_type MD5sum
NA NA
NeedsCompilation Built
NA "3.3.0"
> installed.packages()["rcom",]
Package
"rcom"
LibPath
"C:/Program Files/R/R-3.3.2/library"
Version
"3.1-3"
Priority
NA
Depends
"R (>= 3.3.0), rscproxy (>= 2.1-1), utils"
Imports
NA
LinkingTo
"rscproxy"
Suggests
NA
Enhances
NA
License
"file LICENSE"
License_is_FOSS
NA
License_restricts_use
NA
OS_type
"windows"
MD5sum
NA
NeedsCompilation
NA
Built
"3.3.0"

Thanks! Please try the patch I provided for you (won't solve the problem, but should tell us, where it is).

Just to make sure: Which version of R (32 and/or 64 Bit) do you have installed?

Thomas

Hey Thomas,

I have both 32 and 64 version of R installed, but I only use the 32 bit one and I should have also installed all other components only for 32 Bit.

I did run the test patch. These are the results:

Just clicking the R in the Testwindow:

[4996] statconnDCOM Installation path is "C:\Program Files (x86)\statconn\DCOM"
[4996] ##--1.1##
[4996] ##1##
[4996] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=006AA4CC, installpath=C:\Program Files (x86)\statconn\DCOM, licensepath=C:\Program Files (x86)\statconn\DCOM
[4996] ##2##
[4996] ##3##
[4996] ##4##
[4996] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\statconn\DCOM
[4996] BDX: DateTime enabled
[4996] BDX: Special .NET features enabled
[4996] BDX: x86 support (32bit) enabled
[4996] BDX: x64 support (64bit) enabled
[4996] askserver #1
[4996] askserver #2
[4996] askserver #3
[4996] H&S: Closing Splash Screen
[4996] ~SplashImpl
[4996] CStatConnector::~CStatConnector()


I still get the "run time error '-2147023170 (800706be)': Automation error" message after I click on the close button in the "TEST ONLY".
In the StatConnector Test window it says:
Loading StatConnector Server... Done
Initializing R...Function call failed

Using the R32 button (gives same error message in the end):
[2960] statconnDCOM Installation path is "C:\Program Files (x86)\statconn\DCOM"
[2960] ##--1.1##
[2960] ##1##
[2960] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=006C6B4C, installpath=C:\Program Files (x86)\statconn\DCOM, licensepath=C:\Program Files (x86)\statconn\DCOM
[2960] ##2##
[2960] ##3##
[2960] ##4##
[2960] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\statconn\DCOM
[2960] BDX: DateTime enabled
[2960] BDX: Special .NET features enabled
[2960] BDX: x86 support (32bit) enabled
[2960] BDX: x64 support (64bit) enabled
[2960] askserver #1
[2960] askserver #2
[2960] askserver #3
[2960] H&S: Closing Splash Screen
[2960] ~SplashImpl
[2960] CStatConnector::~CStatConnector()

sorry to bother you again, but the next try is a special tracing-enabled sctools.dll. Same directory in the installation path.

Available from the download page, please run your test again and send the DbgView output. Hope we now know, where the problem starts.

Hi Thomas, there is no new file for me on the download page.

You're right. The download manager settings did now allow DLL files. Fixed. You should see the file now.

Okay. New Test.

R
[9428] statconnDCOM Installation path is "C:\Program Files (x86)\statconn\DCOM"
[9428] ##--1.1##
[9428] ##1##
[9428] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=005B6DDC, installpath=C:\Program Files (x86)\statconn\DCOM, licensepath=C:\Program Files (x86)\statconn\DCOM
[9428] ##2##
[9428] ##3##
[9428] ##4##
[9428] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\statconn\DCOM
[9428] BDX: DateTime enabled
[9428] BDX: Special .NET features enabled
[9428] BDX: x86 support (32bit) enabled
[9428] BDX: x64 support (64bit) enabled
[9428] ##--3.0.0##
[9428] askserver #1
[9428] askserver #2
[9428] askserver #3
[9428] ##--3.0.1##
[9428] ##--3.1##
[9428] H&S: Closing Splash Screen
[9428] ~SplashImpl
[9428] CStatConnector::~CStatConnector()


R32
[7664] statconnDCOM Installation path is "C:\Program Files (x86)\statconn\DCOM"
[7664] ##--1.1##
[7664] ##1##
[7664] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=00646D34, installpath=C:\Program Files (x86)\statconn\DCOM, licensepath=C:\Program Files (x86)\statconn\DCOM
[7664] ##2##
[7664] ##3##
[7664] ##4##
[7664] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\statconn\DCOM
[7664] BDX: DateTime enabled
[7664] BDX: Special .NET features enabled
[7664] BDX: x86 support (32bit) enabled
[7664] BDX: x64 support (64bit) enabled
[7664] ##--3.0.0##
[7664] askserver #1
[7664] askserver #2
[7664] askserver #3
[7664] ##--3.0.1##
[7664] ##--3.1##
[7664] H&S: Closing Splash Screen
[7664] ~SplashImpl
[7664] CStatConnector::~CStatConnector()

seems, we're coming near the place where it fails. Another SCTools.dll is available for download. Please use this one and try again.

R
[5988] statconnDCOM Installation path is "C:\Program Files (x86)\statconn\DCOM"
[5988] ##--1.1##
[5988] ##1##
[5988] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=00656E1C, installpath=C:\Program Files (x86)\statconn\DCOM, licensepath=C:\Program Files (x86)\statconn\DCOM
[5988] ##2##
[5988] ##3##
[5988] ##4##
[5988] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\statconn\DCOM
[5988] BDX: DateTime enabled
[5988] BDX: Special .NET features enabled
[5988] BDX: x86 support (32bit) enabled
[5988] BDX: x64 support (64bit) enabled
[5988] ##--3.0.0##
[5988] askserver #1
[5988] askserver #2
[5988] askserver #3
[5988] ##--3.0.1##
[5988] ##--3.1##
[5988] ##4.0.1##
[5988] ##6.0.0##
[5988] ##6.0.1##
[5988] ##6.0.0##
[5988] ##6.0.1##
[5988] ##6.0.3##
[5988] ##6.0.4##
[5988] H&S: Closing Splash Screen
[5988] ##5.0##
[5988] ~SplashImpl
[5988] ##5.1##
[5988] ##4.0.2##
[5988] ##4.0.3##
[5988] CStatConnector::~CStatConnector()

R32
[3704] statconnDCOM Installation path is "C:\Program Files (x86)\statconn\DCOM"
[3704] ##--1.1##
[3704] ##1##
[3704] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=005DB3EC, installpath=C:\Program Files (x86)\statconn\DCOM, licensepath=C:\Program Files (x86)\statconn\DCOM
[3704] ##2##
[3704] ##3##
[3704] ##4##
[3704] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\statconn\DCOM
[3704] BDX: DateTime enabled
[3704] BDX: Special .NET features enabled
[3704] BDX: x86 support (32bit) enabled
[3704] BDX: x64 support (64bit) enabled
[3704] ##--3.0.0##
[3704] askserver #1
[3704] askserver #2
[3704] askserver #3
[3704] ##--3.0.1##
[3704] ##--3.1##
[3704] ##4.0.1##
[3704] ##6.0.0##
[3704] ##6.0.1##
[3704] ##6.0.0##
[3704] ##6.0.1##
[3704] ##6.0.3##
[3704] ##6.0.4##
[3704] H&S: Closing Splash Screen
[3704] ##5.0##
[3704] ~SplashImpl
[3704] ##5.1##
[3704] ##4.0.2##
[3704] ##4.0.3##
[3704] CStatConnector::~CStatConnector()

ok, once again. Think we got this nasty bug. And it seems to be a timing/multithreading issue only occuring at a few machines. Should happen faster now...

New SCTools.dll available for download