Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Logistic regression analysis errors(The R.exe exit code (4294967295) indicated an error.)

Highlighted
Meteoroid

Hello

 

When I executed the attached workflow, I got an error and did not complete the process.
The processing time was 21 minutes and a very long time had passed.
How do you solve it?

 

***

Start: Designer x64: Started running C:\Users\Desktop\Error.yxmd at 05/03/2019 00:13:41
File_Input: Input Data (1): C:\Users\Desktop\creditcard.zip|284807 records were read from "C:\Users\Desktop\creditcard.zip" (creditcard.csv)
File_Output: Browse (2): C:\Users\AppData\Local\Temp\Engine_7812_af48fa24a9c14382bc97a56b2cd6b15a_\Engine_7772_81d4e1a98ace47cea76ac7e21bf3b8c2_.yxdb|284807 records
Info: Create Samples (3): Tool #16: 284807 records were summarized to 1 groups
Info: Create Samples (3): Tool #17: 284807 target records generated 284807 output records
Info: Create Samples (3): Tool #44: 284807 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Create Samples (3): Tool #45: 199365 records were True and 85442 were False
Info: Logistic Regression (4): Tool #34: 199365 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Logistic Regression (4): Logistic Regression: R version 3.4.4 (2018-03-15) - x86_64
Info: Logistic Regression (4): Logistic Regression: rgeos version: 0.3-26, (SVN revision 560)
Info: Logistic Regression (4): Logistic Regression: GEOS runtime version: 3.6.1-CAPI-1.10.1 r0
Info: Logistic Regression (4): Logistic Regression: Linking to sp version: 1.2-7
Info: Logistic Regression (4): Logistic Regression: Polygon checking: TRUE
Info: Logistic Regression (4): Logistic Regression: Attaching package: 'AlteryxPredictive'
Info: Logistic Regression (4): Logistic Regression: The following object is masked from 'package:AlteryxRDataX':
Info: Logistic Regression (4): Logistic Regression: XMSG
Info: Logistic Regression (4): Logistic Regression: Loading required namespace: car
Info: Logistic Regression (4): Logistic Regression: Attaching package: 'inline'
Info: Logistic Regression (4): Logistic Regression: The following object is masked from 'package:Rcpp':
Info: Logistic Regression (4): Logistic Regression: registerPlugin
Info: Logistic Regression (4): Logistic Regression: 25 Œ‚ÌŒx‚ª‚ ‚è‚Ü‚µ‚½ (Œx‚ðŒ©‚é‚É‚Í warnings() ‚ðŽg‚Á‚ĉº‚³‚¢)
Info: Logistic Regression (4): Tool #214: Tool #2: 1 records were True and 71 were False
Info: Logistic Regression (4): Tool #214: Tool #4: 1 records were True and 71 were False
Info: Logistic Regression (4): Tool #214: Tool #9: 1 records were True and 71 were False
Info: Logistic Regression (4): Tool #214: Tool #13: 1 records were True and 71 were False
Info: Logistic Regression (4): Tool #214: Tool #16: 30 records were True and 42 were False
Info: Logistic Regression (4): Tool #214: Tool #23: 1 records were True and 71 were False
Info: Logistic Regression (4): Tool #214: Tool #66: 1 records were joined with 0 un-joined left records and 0 un-joined right records
Info: Logistic Regression (4): Tool #214: Tool #27: 3 records were True and 69 were False
Info: Logistic Regression (4): Tool #214: Tool #34: 1 records were True and 71 were False
Info: Logistic Regression (4): Tool #214: Tool #81: 1 records were True and 71 were False
Info: Logistic Regression (4): Tool #214: Tool #86: 1 records were output
Info: Logistic Regression (4): Tool #215: Tool #3: 1 records were True and 71 were False
Info: Logistic Regression (4): Tool #215: Tool #6: 29 records were True and 43 were False
Info: Logistic Regression (4): Tool #215: Tool #12: 1 records were output
File_Output: Browse (7): C:\Users\AppData\Local\Temp\Engine_7812_af48fa24a9c14382bc97a56b2cd6b15a_\Engine_7772_8c948ad530714107a08ce62c9233a21d_.yxdb|1 records
Info: Logistic Regression (4): Tool #127: R version 3.4.4 (2018-03-15) - x86_64
Info: Logistic Regression (4): Tool #127: rgeos version: 0.3-26, (SVN revision 560)
Info: Logistic Regression (4): Tool #127: GEOS runtime version: 3.6.1-CAPI-1.10.1 r0
Info: Logistic Regression (4): Tool #127: Linking to sp version: 1.2-7
Info: Logistic Regression (4): Tool #127: Polygon checking: TRUE
Info: Logistic Regression (4): Tool #127: Attaching package: 'AlteryxPredictive'
Info: Logistic Regression (4): Tool #127: The following object is masked from 'package:AlteryxRDataX':
Info: Logistic Regression (4): Tool #127: XMSG
Info: Logistic Regression (4): Tool #127: Attaching package: 'inline'
Info: Logistic Regression (4): Tool #127: The following object is masked from 'package:Rcpp':
Info: Logistic Regression (4): Tool #127: registerPlugin
Info: Logistic Regression (4): Tool #127: ŒxƒƒbƒZ[ƒW:
Info: Logistic Regression (4): Tool #127: readLines(x, warn = F) ‚Å:
Info: Logistic Regression (4): Tool #127: “ü—̓RƒlƒNƒVƒ‡ƒ“ 'C:/Program Files/Alteryx/R-3.4.4/library/flightdeck/htmlwidgets/lib/bootbox/bootbox.min.js' ‚É•s³‚È“ü—Í‚ª‚ ‚è‚Ü‚µ‚½
Info: Logistic Regression (4): Tool #128: 13 target records generated 13 output records
Info: Logistic Regression (4): Tool #129: 0 records were True and 13 were False
Info: Logistic Regression (4): Tool #132: 0 records were True and 0 were False
File_Output: Browse (8): C:\Users\makot\AppData\Local\Temp\Engine_7812_af48fa24a9c14382bc97a56b2cd6b15a_\Engine_7772_6ec553f3b1e44c68bdcfe7e20487eae3_.yxdb|13 records
File_Output: Browse (9): C:\Users\makot\AppData\Local\Temp\Engine_7812_af48fa24a9c14382bc97a56b2cd6b15a_\Engine_7772_17a9ea5f41d64aa5be64ebf2db977b6e_.yxdb|1 records
Info: Create Samples (3): Tool #46: 85442 records were True and 0 were False
Info: Score (5): Score: R version 3.4.4 (2018-03-15) - x86_64
Info: Score (5): Score: rgeos version: 0.3-26, (SVN revision 560)
Info: Score (5): Score: GEOS runtime version: 3.6.1-CAPI-1.10.1 r0
Info: Score (5): Score: Linking to sp version: 1.2-7
Info: Score (5): Score: Polygon checking: TRUE
Info: Score (5): Score: Attaching package: 'AlteryxPredictive'
Info: Score (5): Score: The following object is masked from 'package:AlteryxRDataX':
Info: Score (5): Score: XMSG
Info: Score (5): Score: Read 1 item
Info: Score (5): Score: Attaching package: 'inline'
Info: Score (5): Score: The following object is masked from 'package:Rcpp':
Info: Score (5): Score: registerPlugin
Warning: Score (5): The invalid name has been replaced by X.
Warning: Score (5): The provided field name was changed to X.
Info: Score (5): 85442 records were scored.
File_Output: Browse (6): C:\Users\AppData\Local\Temp\Engine_7812_af48fa24a9c14382bc97a56b2cd6b15a_\Engine_7772_9ad3cd63d14445dea169f9c6c9eedfe0_.yxdb|85442 records
Error: Score (5): Score: The R.exe exit code (4294967295) indicated an error.
End: Designer x64: Finished running Error.yxmd in 21:54 minutes with 1 error and 2 warnings

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @OTO 

 

Evidence indicates that this a R tool Fake error. 

 

Check it out in this topic.

 

Cheers,

Highlighted
Meteoroid
Hi @Thableaus
Thank you for your reply. I already looked at the fake error article, but the problem is that this fake error only causes an error, so I do not know why this process is not complete.
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@OTO 

 

Something people suggested in that topic was to add a "gc()" at the end of the R code in the Logistic Regression Macro.

 

Unfortunately I think this is something that Alteryx folks didn't figure out a way to handle more efficiently.

 

Cheers,

Highlighted
Meteoroid

@Thableaus

 

I do not know how to do it because I have no programming experience.
Open the Logistic regression tool in OpenMacro and click the R tool, the code for R is described on the left.
Should I add GC () at the bottom?

Please advise.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@OTO 

 

Yes, according to the topic, the last line of R code should be composed of this gc() call.


Cheers,

Highlighted
Meteoroid

Hi @Thableaus

Sorry for the late reply.
I worked as attached, but the following error message appeared and I could not edit it.

Access to the path
'C:\Users\username.SRC\AppData\Local\Alteryx\bin\HtmlPlugins\Logistic_Regression\Supporting_Macro\Logistic_Regression.yxmc'is denied.

 

I did "run as administrator"...

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hey @OTO  no problem!

 

Here's a clever way to open your macros in Designer

 

OpenMacro.png

 

Right click the logistic regression tool and this "Open Macro" option will show up to you.

 

Cheers,

Highlighted
Meteoroid

Hi @Thableaus 

 

As you say, after OpenMacro and then clicking the right R tool, I added gc () directly to the left configuration, but I was unable to save it.The same error occurs.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@OTO 

 

Is your alteryx version an admin version? Still running Alteryx as admin? Does your user have admin credentials?

 

Cheers,

Labels