autstat Support

Hi,

I downloaded scExcelFull1.1-0B2_HomeStudent_x86.exe and installed scExcel for the first time. When I try to connect to R from within Excel via the scExcel Add-in, I get the error message:

Code:

Error creating R connection object, error code 2147745841
Debug info: licensing: license expired
If you are using the foreground server, please make sure R is running and rcom is loaded

Please let me know if I made a mistake or I missed a step. The debugging information is below.

1.: My Windows version is 1809 (Build 17763.3887)

2.: R version and version of packages

Code:

> R.Version()$version.string
[1] "R version 4.0.5 (2021-03-31)"
> sessionInfo()
R version 4.0.5 (2021-03-31)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows 10 x64 (build 17763)

Matrix products: default

Random number generation:
 RNG:     Mersenne-Twister 
 Normal:  Inversion 
 Sample:  Rounding 
 
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     

loaded via a namespace (and not attached):
[1] compiler_4.0.5
> installed.packages()["rscproxy",]
                             Package                              LibPath 
                          "rscproxy" "C:/Program Files/R/R-4.0.5/library" 
                             Version                             Priority 
                             "2.3-1"                                   NA 
                             Depends                              Imports 
                                  NA                                   NA 
                           LinkingTo                             Suggests 
                                  NA                                   NA 
                            Enhances                              License 
                                  NA            "statconn PUBLIC LICENSE" 
                     License_is_FOSS                License_restricts_use 
                                  NA                                   NA 
                             OS_type                               MD5sum 
                                  NA                                   NA 
                    NeedsCompilation                                Built 
                                  NA                              "4.0.2" 
> installed.packages()["rcom",]
                                   Package 
                                    "rcom" 
                                   LibPath 
      "C:/Program Files/R/R-4.0.5/library" 
                                   Version 
                                   "3.2-1" 
                                  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 
                                   "4.0.2" 

3.:

Code:

Application is run as Administrator
R 32 Bit: 32bit version installed in <C:\Program Files\R\R-4.0.5>, current version <4.0.5>
R 64 Bit: 64bit version installed in <C:\Program Files\R\R-4.0.5>, current version <4.0.5>
Package <rscproxy> for 32 Bit R, version <2.3-1>, installed in <C:/Program Files/R/R-4.0.5/library> was built for R version <4.0.2> - OK
Package <rcom> for 32 Bit R, version <3.2-1>, installed in <C:/Program Files/R/R-4.0.5/library> was built for R version <4.0.2> - OK
Package <rscproxy> for 64 Bit R, version <2.3-1>, installed in <C:/Program Files/R/R-4.0.5/library> was built for R version <4.0.2> - OK
Package <rcom> for 64 Bit R, version <3.2-1>, installed in <C:/Program Files/R/R-4.0.5/library> was built for R version <4.0.2> - OK
statconnDCOM 32 Bit: 32bit version installed in <C:\Program Files (x86)\autstat\Excel\statconnDCOM\i386>, current version <3.6-3B0>
statconnDCOM 64 Bit: not found

6.: LicenseTest

Code:

Run-time error '-2147221456 (80040030)':
Method '~' of object '~' failed

DebugView

Code:

[5060] statconnDCOM Installation path is "C:\Program Files (x86)\autstat\Excel\statconnDCOM\i386"
[5060] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=0080633C, installpath=C:\Program Files (x86)\autstat\Excel\statconnDCOM\i386, licensepath=C:\Program Files (x86)\autstat\Excel\statconnDCOM\i386
[5060] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B690, version=1, path=C:\Program Files (x86)\autstat\Excel\statconnDCOM\i386
[5060] BDX_get_vtbl2: error 0 loading license file for "Testing"
[5060] CStatConnector::initBDXForConnector() vtbl-object@00520054
[5060] CStatConnector::~CStatConnector()
[11948] [M42UEM_UI] [Debug] [MainWindow.ActivateWindowDisposal] No main window disposal done (free memory 2755 MB is greater than limit of 1024 MB)! Waiting another 600sec before checking for window disposal
[11948] [M42UEM_UI] [Debug] [MainWindow.ActivateWindowDisposal] No main window disposal done (free memory 2755 MB is greater than limit of 1024 MB)! Waiting another 600sec before checking for window disposal
[5060] SCTools.dll: thread detach
[5060] SCTools.dll: process detach starts
[5060] SCTools.dll: process detach ends

Dear Tobias,

sorry for the troubles. The license file installed with the current software is outdated.

Please go to the scExcel download area and download a new license file (Updated license file for scExcel (February 2023))

Store the license file on your disk, then run the autstat test and maintenance tool (statconnRSetupTest.exe) from the bin folder in the statconnDCOM installation folder. This is typically c:\Program Files (x86)\autstat\Excel\statconnDCOM\i386\bin. Take care to run the tool as Administrator and then use the option to install the license file. The tool should do the rest.

Best regards,
Thomas

Dear Thomas,

thank you very much! It's now working!