autstat Support

Hi, last week I downloaded scExcel (Home & Student licence) and it was working fine for a day or two, but now all of a sudden it says licence has expired (if I tick R type to be "Default Background") or if I tick R type to be "Foreground" it gives the following error message

"Error creating R connection object, error code 2147745840. Debug info: if you are using foreground server, please make sure R is running and rcom is loaded"

I do have R 32-bit running at the Foreground and my Excel is 2016 32-bit and I do have both rcom and rscproxy loaded as they both appear in the list of packages when i run the formula search()

Any ideas please

Thanks

Dear Oleg,

sounds strange for me. Can you please provide a DebugView log when starting the R connection (background server).

Best wishes,
Thomas

Hi Thomas, not sure whether it's possible to provide a Log as there is a button called "Log" - the only place I can think of to get the Log from - it's greyed out at all times, so that it's disabled, and cannot be operated nor selected by the user

http://autstat.com/index.php/Support/topic/23.html

Hi Thomas,

I have the same problem like oleg.

here is my Debug view, after following all the steps, you provided @ http://autstat.com/index.php/Support/topic/23.html.

1)
Windows version: 1709 (Build 16299.309)

2)
R.Version()$version.string
[1] "R version 3.4.3 (2017-11-30)"
> sessionInfo()
R version 3.4.3 (2017-11-30)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows 10 x64 (build 16299)

Matrix products: default

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

other attached packages:
[1] rcom_3.1-5 rscproxy_2.2-0

loaded via a namespace (and not attached):
[1] compiler_3.4.3
> installed.packages()["rscproxy",]
Package LibPath
"rscproxy" "C:/Program Files/R/R-3.4.3/library"
Version Priority
"2.2-0" 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.4.2"


installed.packages()["rcom",]
Package
"rcom"
LibPath
"C:/Program Files/R/R-3.4.3/library"
Version
"3.1-5"
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.4.0"
>

3)
Application is run as Administrator
R 32 Bit: 32bit version installed in <C:\Program Files\R\R-3.4.3>, current version <3.4.3>
R 64 Bit: 64bit version installed in <C:\Program Files\R\R-3.4.3>, current version <3.4.3>
Package <rscproxy> for 32 Bit R, version <2.2-0>, installed in <C:/Program Files/R/R-3.4.3/library> was built for R version <3.4.2> - OK
Package <rcom> for 32 Bit R, version <3.1-5>, installed in <C:/Program Files/R/R-3.4.3/library> was built for R version <3.4.0> - OK
Package <rscproxy> for 64 Bit R, version <2.2-0>, installed in <C:/Program Files/R/R-3.4.3/library> was built for R version <3.4.2> - OK
Package <rcom> for 64 Bit R, version <3.1-5>, installed in <C:/Program Files/R/R-3.4.3/library> was built for R version <3.4.0> - OK
statconnDCOM 32 Bit: 32bit version installed in <C:\Program Files\R\Excel\Excel\statconnDCOM>, current version <3.6-0B9>
statconnDCOM 64 Bit: not found

6)
[12228] statconnDCOM Installation path is "C:\Program Files (x86)\autstat\Excel\statconnDCOM"
[12228] BDXImpl_init(licensee=SExcel4, connector=R, parameters=(null), objptr=027E3B04, installpath=C:\Program Files (x86)\autstat\Excel\statconnDCOM, licensepath=C:\Program Files (x86)\autstat\Excel\statconnDCOM
[12228] BDX_get_vtbl2: conn=R, licensee=SExcel4, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\autstat\Excel\statconnDCOM
[12228] BDX: DateTime enabled
[12228] BDX: Special .NET features enabled
[12228] BDX: x86 support (32bit) enabled
[12228] BDX: i386 support requested
[12228] BDX: #2/1522450800/1523004790
[12228] CStatConnector::initBDXForConnector() vtbl-object@00000000
[12228] CStatConnector::~CStatConnector()


Debug View when starting the R connection (background server)

[11340] statconnDCOM Installation path is "C:\Program Files (x86)\autstat\Excel\statconnDCOM"
[11340] BDXImpl_init(licensee=SExcel4, connector=R, parameters=dm=2, objptr=0272397C, installpath=C:\Program Files (x86)\autstat\Excel\statconnDCOM, licensepath=C:\Program Files (x86)\autstat\Excel\statconnDCOM
[11340] BDX_get_vtbl2: conn=R:dm=2, licensee=SExcel4, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\autstat\Excel\statconnDCOM
[11340] BDX: DateTime enabled
[11340] BDX: Special .NET features enabled
[11340] BDX: x86 support (32bit) enabled
[11340] BDX: i386 support requested
[11340] BDX: #2/1522450800/1523005196
[11340] CStatConnector::initBDXForConnector() vtbl-object@00000000

I hope that this is useful.

Best Regards,

Dario

Hi Dario,

thanks, now I can see what the problem is. Will upload a new version of the software before Monday.

Best wishes,
Thomas

Hi Thomas,

that's great. Do I find the new version in the download area?

Best Regards,

Dario

Will be there tomorrow morning

Hi Thomas, hope you are well and having a stress-free week. I uninstalled the previous scExcel and downloaded "new" scExcel today from the same address as before, here it is

http://autstat.com/index.php/download-rexcel4-beta.html

but I am still getting the same error

would you still like my Debug View?

Thanks

Hi Thomas, I just downloaded ScExcel4 and get error message

"Error creating R connection object, error code 2147746132. Debug info: if you are using the foreground server, please make sure R is running and rcom is loaded"

Oleg, you won't get this error message from downloading scExcel :-)

There must be something missing in your post, cannot really help you

oh sorry, "rcom" was not in my R. It all works now. Thanks for that

Great!