autstat Support

Hi Thomas,

I hope you could be with this one.

Debugging information:

Microsoft Windows
Version 6.1 (Build 7601: Service Pack 1)
Copyright 2009 Microsoft Corporation. All rights Reserved


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

locale:
[1] LC_COLLATE=English_United States.1252
[2] LC_CTYPE=English_United States.1252
[3] LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C
[5] LC_TIME=English_United States.1252

attached base packages:
[1] stats graphics grDevices utils datasets methods base

loaded via a namespace (and not attached):
[1] Rcpp_0.12.5 spdep_0.6-11 cluster_2.0.4 splines_3.3.1
[5] gmodels_2.16.2 MASS_7.3-45 lattice_0.20-33 multcomp_1.4-6
[9] minqa_1.2.4 plyr_1.8.4 grid_3.3.1 nlme_3.1-128
[13] TH.data_1.0-8 coda_0.19-1 deldir_0.1-12 gtools_3.5.0
[17] lme4_1.1-12 survival_2.39-4 agricolae_1.2-4 AlgDesign_1.1-7.3
[21] Matrix_1.2-6 nloptr_1.0.4 codetools_0.2-14 sandwich_2.3-4
[25] sp_1.2-4 gdata_2.17.0 estimability_1.2 klaR_0.6-12
[29] LearnBayes_2.15 boot_1.3-18 combinat_0.0-8 expm_0.999-1
[33] mvtnorm_1.0-6 zoo_1.7-14
> installed.packages()["rscproxy",]
Package LibPath
"rscproxy" "C:/Program Files/R/R-3.3.1/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.1/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"

Here is the error:

[3048] statconnDCOM Installation path is "C:\Program Files\statconn\DCOM"
[3048] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=0023B46C, installpath=C:\Program Files\statconn\DCOM, licensepath=C:\Program Files\statconn\DCOM
[3048] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files\statconn\DCOM
[3048] BDX: DateTime enabled
[3048] BDX: Special .NET features enabled
[3048] BDX: x86 support (32bit) enabled
[3048] BDX: x64 support (64bit) enabled
[3048] H&S: Closing Splash Screen
[3048] ~SplashImpl
[3048] CStatConnector::initBDXForConnector() vtbl-object@1007A000
[3048] connector: R
[3048] DLL: rscproxy.dll
[3048] environment: R_HOME
[3048] registry key: Software\R-core\R
[3048] registry value: InstallPath
[3048] version key:
[3048] version value:
[3048] binary dir: bin/i386
[3048] connector: RPre2.12
[3048] DLL: rscproxy.dll
[3048] environment: R_HOME
[3048] registry key: Software\R-core\R
[3048] registry value: InstallPath
[3048] version key:
[3048] version value:
[3048] binary dir: bin
[3048] connector: Rold
[3048] DLL: rproxy.dll
[3048] environment: R_HOME
[3048] registry key: Software\R-core\R
[3048] registry value: InstallPath
[3048] version key:
[3048] version value:
[3048] binary dir: bin
[3048] connector: SciLab
[3048] DLL: sciproxy.dll
[3048] environment: SCILAB_HOME
[3048] registry key: Software\Scilab\%s
[3048] registry value: SCIPATH
[3048] version key: Software\Scilab
[3048] version value: LASTINSTALL
[3048] binary dir: bin
[3048] sc_proxy_find_connector: found "R"
[3048] sc_proxy_find_connector: found "R"
[3048] sc_proxy_load log follows!
[3048] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[3048] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[3048] sc_proxy_load: use "R_HOME"
[3048] adding <E:\PBTools Workspace\RPackages\R-3.0.2\bin/i386> to path <C:\ProgramData\Oracle\Java\javapath;C:\Program Files\MEGA6;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files\Google\Google Apps Migration\;C:\Program Files\Skype\Phone\;E:\PBTools Workspace\RPackages\R-3.0.2\library\rJava\jri;E:\PBTools Workspace\RPackages\R-3.0.2\bin\i386>
[3048] new path is C:\ProgramData\Oracle\Java\javapath;C:\Program Files\MEGA6;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files\Google\Google Apps Migration\;C:\Program Files\Skype\Phone\;E:\PBTools Workspace\RPackages\R-3.0.2\library\rJava\jri;E:\PBTools Workspace\RPackages\R-3.0.2\bin\i386;E:\PBTools Workspace\RPackages\R-3.0.2\bin/i386
[3048] proxy "R_HOME" via Environment variable "E:\PBTools Workspace\RPackages\R-3.0.2": failed
[3048] Look up "R" in the registry
[3048] sc_proxy_load: use registry key "Software\R-core\R"
[3048] looking up registry key at "HKCU\Software\R-core\R\InstallPath"
[3048] looking up registry key at "HKLM\Software\R-core\R\InstallPath"
[3048] adding <C:\Program Files\R\R-3.3.1\bin/i386> to path <C:\ProgramData\Oracle\Java\javapath;C:\Program Files\MEGA6;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files\Google\Google Apps Migration\;C:\Program Files\Skype\Phone\;E:\PBTools Workspace\RPackages\R-3.0.2\library\rJava\jri;E:\PBTools Workspace\RPackages\R-3.0.2\bin\i386;E:\PBTools Workspace\RPackages\R-3.0.2\bin/i386>
[3048] new path is C:\ProgramData\Oracle\Java\javapath;C:\Program Files\MEGA6;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files\Google\Google Apps Migration\;C:\Program Files\Skype\Phone\;E:\PBTools Workspace\RPackages\R-3.0.2\library\rJava\jri;E:\PBTools Workspace\RPackages\R-3.0.2\bin\i386;E:\PBTools Workspace\RPackages\R-3.0.2\bin/i386;C:\Program Files\R\R-3.3.1\bin/i386
[3048] No Debugging of rproxy
[5152] Invalid parameter passed to C runtime function.

It seems you have set R_HOME in your global environment and it points to a different R version. Please delete R_HOME and try again.

Thomas

Hi Thomas,

I am kinda new to this thing. How can I delete R_HOME?

Thanks,
Bart

The question is: how did you set R_HOME?

I can only tell you, that on your computer, in the user account that you are using to start the "Basic Test", R_HOME is set:

----- proxy "R_HOME" via Environment variable "E:\PBTools Workspace\RPackages\R-3.0.2": failed

Maybe you should ask the person who installed and (mis)configured your computer. I would guess, "PBTools" did this on installation.

Yeah I suppose it was because of the previous installation.
I tried removing the environment variables and started to run RExcel. I got a message saying:
Run time Error '91':
Object variable or With block variable not set

Here'd the debugging info:
[1824] statconnDCOM Installation path is "C:\Program Files\statconn\DCOM"
[1824] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=0027FEC4, installpath=C:\Program Files\statconn\DCOM, licensepath=C:\Program Files\statconn\DCOM
[1824] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files\statconn\DCOM
[1824] BDX: DateTime enabled
[1824] BDX: Special .NET features enabled
[1824] BDX: x86 support (32bit) enabled
[1824] BDX: x64 support (64bit) enabled
[1824] H&S: Closing Splash Screen
[1824] ~SplashImpl
[1824] CStatConnector::initBDXForConnector() vtbl-object@1007A000
[1824] connector: R
[1824] DLL: rscproxy.dll
[1824] environment: R_HOME
[1824] registry key: Software\R-core\R
[1824] registry value: InstallPath
[1824] version key:
[1824] version value:
[1824] binary dir: bin/i386
[1824] connector: RPre2.12
[1824] DLL: rscproxy.dll
[1824] environment: R_HOME
[1824] registry key: Software\R-core\R
[1824] registry value: InstallPath
[1824] version key:
[1824] version value:
[1824] binary dir: bin
[1824] connector: Rold
[1824] DLL: rproxy.dll
[1824] environment: R_HOME
[1824] registry key: Software\R-core\R
[1824] registry value: InstallPath
[1824] version key:
[1824] version value:
[1824] binary dir: bin
[1824] connector: SciLab
[1824] DLL: sciproxy.dll
[1824] environment: SCILAB_HOME
[1824] registry key: Software\Scilab\%s
[1824] registry value: SCIPATH
[1824] version key: Software\Scilab
[1824] version value: LASTINSTALL
[1824] binary dir: bin
[1824] sc_proxy_find_connector: found "R"
[1824] sc_proxy_find_connector: found "R"
[1824] sc_proxy_load log follows!
[1824] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[1824] sc_proxy_load: sc_proxy_find_connector(,<R>) done
[1824] Look up "R" in the registry
[1824] sc_proxy_load: use registry key "Software\R-core\R"
[1824] looking up registry key at "HKCU\Software\R-core\R\InstallPath"
[1824] looking up registry key at "HKLM\Software\R-core\R\InstallPath"
[1824] adding <C:\Program Files\R\R-3.3.1\bin/i386> to path <C:\ProgramData\Oracle\Java\javapath;C:\Program Files\MEGA6;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files\Google\Google Apps Migration\;C:\Program Files\Skype\Phone\>
[1824] new path is C:\ProgramData\Oracle\Java\javapath;C:\Program Files\MEGA6;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files\Google\Google Apps Migration\;C:\Program Files\Skype\Phone\;C:\Program Files\R\R-3.3.1\bin/i386
[1824] No Debugging of rproxy
[1824] CStatConnector::Close()
[1824] CStatConnector::~CStatConnector()



Here is the R output:
> R.Version()$version.string
[1] "R version 3.3.1 (2016-06-21)"
> sessionInfo()
R version 3.3.1 (2016-06-21)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows 7 (build 7601) Service Pack 1

locale:
[1] LC_COLLATE=English_United States.1252
[2] LC_CTYPE=English_United States.1252
[3] LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C
[5] LC_TIME=English_United States.1252

attached base packages:
[1] stats graphics grDevices utils datasets methods base

loaded via a namespace (and not attached):
[1] Rcpp_0.12.5 spdep_0.6-11 cluster_2.0.4 splines_3.3.1
[5] gmodels_2.16.2 MASS_7.3-45 lattice_0.20-33 multcomp_1.4-6
[9] minqa_1.2.4 plyr_1.8.4 grid_3.3.1 nlme_3.1-128
[13] TH.data_1.0-8 coda_0.19-1 deldir_0.1-12 gtools_3.5.0
[17] lme4_1.1-12 survival_2.39-4 agricolae_1.2-4 AlgDesign_1.1-7.3
[21] Matrix_1.2-6 nloptr_1.0.4 codetools_0.2-14 sandwich_2.3-4
[25] sp_1.2-4 gdata_2.17.0 estimability_1.2 klaR_0.6-12
[29] LearnBayes_2.15 boot_1.3-18 combinat_0.0-8 expm_0.999-1
[33] mvtnorm_1.0-6 zoo_1.7-14
> installed.packages()["rscproxy",]
Package LibPath
"rscproxy" "C:/Program Files/R/R-3.3.1/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.1/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"

Please be consistent: the debugging information you sent has nothing to do with RExcel. The debugging information was generated using the "Basic Test" program installed with statconnDCOM.

You did not say _ANYTHING_ about success or failure of this program. The output looks as if the "Basic Test" has succeeded.

Oh I see. If that is the case then I guess statconnDCOM is configured well now based on the debugging info of "Basic Test".
I just have to figure out now what's wrong with RExcel. Thanks a lot.

There is a forum for RExcel, you can use it to post your question there. Maybe the RExcel author will take care.