Jira (PUP-11686) Windows Alteryx package resource causing fact failure

5 views
Skip to first unread message

Gavin Didrichsen (Jira)

unread,
Dec 5, 2022, 11:19:01 AM12/5/22
to puppe...@googlegroups.com
Gavin Didrichsen created an issue
 
Puppet / Bug PUP-11686
Windows Alteryx package resource causing fact failure
Issue Type: Bug Bug
Assignee: Unassigned
Created: 2022/12/05 8:18 AM
Labels: jira_escalated
Priority: Normal Normal
Reporter: Gavin Didrichsen

Puppet Version:
Puppet Server Version:
OS Name/Version:

facter on windows servers returns non-UTF characters

{{msi_info:}}{{{{ }}}}

{{{{ "Alteryx 2020.2 x64 Server (Remove only)\0e\0\0\0\x11":}}}}

{{{{ version: 2020.2.3.27789}}}}

{{{{ vendor: Alteryx
installdate: ''}}}}

{{...}}
{}

The short-term workaround is to disable package inventory collection on these nodes or remove this package. Please open a Jira ticket for this issue.

Desired Behavior:

  • Windows fact gathering should work stripping out troublesome non-UTF characters

Actual Behavior:

  • Windows facts are failing to insert into puppetdb with errors:

 

```

2022-11-21T01:47:08.618Z ERROR [p.p.command] [842,189,640] [replace facts] Exceeded max attempts (5) for hkwvadapp436.zone1.scbdev.net [Ljava.lang.Throwable;@7f2a2006

2022-11-21T01:49:07.293Z ERROR [p.p.command] [842,262,475] [replace facts] Retrying after attempt 4 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:21:21.094Z ERROR [p.p.command] [842,370,208] [replace facts] Retrying after attempt 3 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:29:53.884Z ERROR [p.p.command] [842,457,322] [replace facts] Retrying after attempt 2 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:39:03.480Z ERROR [p.p.command] [842,546,330] [replace facts] Retrying after attempt 1 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:39:35.186Z ERROR [p.p.command] [842,395,470] [replace facts] Retrying after attempt 3 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:49:09.155Z ERROR [p.p.command] [842,262,475] [replace facts] Exceeded max attempts (5) for hkwvadapp436.zone1.scbdev.net [Ljava.lang.Throwable;@7f2a2006

2022-11-21T03:02:30.741Z ERROR [p.p.command] [842,652,330] [replace facts] Retrying after attempt 0 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

```

**What do we know: 

  • Inspection of the facter output on one of the windows servers reveals some possible candidates.  ``puppet facts --render-as yaml``

 

```

msi_info:

    "Alteryx 2020.2 x64 Server (Remove only)\0e\0\0\0\x11":

      version: 2020.2.3.27789

      vendor: Alteryx

      installdate: ''

...

...

  diskdrives:

    '':

      Capacity: '575664128'

      FreeSpace: '118386688'

      FileSystem: "NTFS\r"

    "D:":

      Capacity: '107371032576'

      FreeSpace: '98313584640'

      FileSystem: "NTFS\r"

    "C:":

      Capacity: '106796412928'

      FreeSpace: '71102283776'

      FileSystem: NTFS

...

...

```

  • Inspection of the debug agent run reveals:

```

Debug: Facter: executing command: C:\Windows\system32\cmd.exe /c C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy remotesigned -Command "& { [Console]::OutputEncoding = [Text.UTF8Encoding]::UTF8; (get-itemproperty -path hklm:\software\microsoft\windows\currentversion\uninstall* -Exclude nbi* |  select displayname, displayversion, publisher, @{label='installdate'; expression={[datetime]::ParseExact($.installdate,'yyyyMMdd',$null).toshortdatestring()}}, uninstallstring) + (get-itemproperty -path HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall* -Exclude nbi* |  select displayname, displayversion, publisher, @{label='installdate'; expression={[datetime]::ParseExact($.installdate,'yyyyMMdd',$null).toshortdatestring()}}, uninstallstring) | sort -Property 'DisplayName' |  convertto-csv -delimiter ';' | select -Skip 2  }"

Debug: Facter: ;;;;"C:\ProgramData

{8AFA1BA5-4A02-4BE9-9109-E844AF87ECDF}

\RInstaller.exe"

 

;;;;"C:\ProgramData

{9D5434B2-ECD1-42D6-967D-5C7704D47541}

\AlteryxInstallx64.exe"

 

;;;;

 

;;;;

 

;;;;

 

;;;;"C:\ProgramData

{BB67A754-82EF-4165-A046-979A1240E1BB}

\AlteryxAISInstall.exe"

 

;;;;

 

;;;;

 

"Alteryx 2021.2 x64 Server (Remove only)

Debug: Facter: process exited with exit code 0.

Debug: Facter: fact "msi_info" has resolved to {

  Alteryx 2021.2 x64 Server (Remove only)e¡ =>

{     version => "2021.2.1.35394",     vendor => "Alteryx",     installdate => ""   }

,

 

```

Add Comment Add Comment
 
This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8)
Atlassian logo

Alvin Rodis (Jira)

unread,
Dec 5, 2022, 11:20:01 AM12/5/22
to puppe...@googlegroups.com
Alvin Rodis updated an issue
Change By: Alvin Rodis
Zendesk Ticket Count: 1
Zendesk Ticket IDs: 50334

Josh Cooper (Jira)

unread,
Dec 5, 2022, 12:00:05 PM12/5/22
to puppe...@googlegroups.com
Josh Cooper updated an issue
Change By: Josh Cooper
*Puppet Version:*
*Puppet Server Version:*
*OS Name/Version:*


facter on windows servers returns non-UTF characters


{ {{{ noformat}
msi_info: }}}}{{{{ }}}}

{{{{
   "Alteryx 2020.2 x64 Server (Remove only)\0e\0\0\0\x11" :}}}}

{{{{
      version: 2020.2.3.27789 }}}}

{{{{
      vendor: Alteryx
      installdate: ''
}}}}

{ {{{... noformat } }}}
{{{{}}}}

The short-term workaround is to disable package inventory collection on these nodes or remove this package. Please open a Jira ticket for this issue.

*Desired Behavior:*
* Windows fact gathering should work stripping out troublesome non-UTF characters

*Actual Behavior:*
* Windows facts are failing to insert into puppetdb with errors:

  {noformat}

```

2022-11-21T01:47:08.618Z ERROR [p.p.command] [842,189,640] [replace facts] Exceeded max attempts (5) for hkwvadapp436.zone1.scbdev.net [Ljava.lang.Throwable;@7f2a2006

2022-11-21T01:49:07.293Z ERROR [p.p.command] [842,262,475] [replace facts] Retrying after attempt 4 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:21:21.094Z ERROR [p.p.command] [842,370,208] [replace facts] Retrying after attempt 3 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:29:53.884Z ERROR [p.p.command] [842,457,322] [replace facts] Retrying after attempt 2 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:39:03.480Z ERROR [p.p.command] [842,546,330] [replace facts] Retrying after attempt 1 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:39:35.186Z ERROR [p.p.command] [842,395,470] [replace facts] Retrying after attempt 3 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006

2022-11-21T02:49:09.155Z ERROR [p.p.command] [842,262,475] [replace facts] Exceeded max attempts (5) for hkwvadapp436.zone1.scbdev.net [Ljava.lang.Throwable;@7f2a2006

2022-11-21T03:02:30.741Z ERROR [p.p.command] [842,652,330] [replace facts] Retrying after attempt 0 for hkwvadapp436.zone1.scbdev.net, due to: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 [Ljava.lang.Throwable;@7f2a2006
{noformat}
```

***What do we know**:* 
* Inspection of the facter output on one of the windows servers reveals some possible candidates.  ``puppet facts --render-as yaml``

 

``` {code:yaml}

msi_info:

    "Alteryx 2020.2 x64 Server (Remove only)\0e\0\0\0\x11":

      version: 2020.2.3.27789

      vendor: Alteryx

      installdate: ''

...

...

  diskdrives:

    '':

      Capacity: '575664128'

      FreeSpace: '118386688'

      FileSystem: "NTFS\r"

    "D:":

      Capacity: '107371032576'

      FreeSpace: '98313584640'

      FileSystem: "NTFS\r"

    "C:":

      Capacity: '106796412928'

      FreeSpace: '71102283776'

      FileSystem: NTFS
{code}
...

...

```
* Inspection of the debug agent run reveals:

``` {noformat}

Debug: Facter: executing command: C:\Windows\system32\cmd.exe /c C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy remotesigned -Command "& { [Console]::OutputEncoding = [Text.UTF8Encoding]::UTF8; (get-itemproperty -path hklm:\software\microsoft\windows\currentversion\uninstall\* -Exclude nbi* |  select displayname, displayversion, publisher, @\{label='installdate'; expression={[datetime]::ParseExact($_.installdate,'yyyyMMdd',$null).toshortdatestring()}}, uninstallstring) + (get-itemproperty -path HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\* -Exclude nbi* |  select displayname, displayversion, publisher, @\{label='installdate'; expression={[datetime]::ParseExact($_.installdate,'yyyyMMdd',$null).toshortdatestring()}}, uninstallstring) | sort -Property 'DisplayName' |  convertto-csv -delimiter ';' | select -Skip 2  }"

Debug: Facter: ;;;;"C:\ProgramData\\{8AFA1BA5-4A02-4BE9-9109-E844AF87ECDF}\RInstaller.exe"

 

;;;;"C:\ProgramData\\{9D5434B2-ECD1-42D6-967D-5C7704D47541}\AlteryxInstallx64.exe"

 

;;;;

 

;;;;

 

;;;;

 

;;;;"C:\ProgramData\\{BB67A754-82EF-4165-A046-979A1240E1BB}\AlteryxAISInstall.exe"

 

;;;;

 

;;;;

 

"Alteryx 2021.2 x64 Server (Remove only)

Debug: Facter: process exited with exit code 0.

Debug: Facter: fact "msi_info" has resolved to {

  Alteryx 2021.2 x64 Server (Remove only)e¡ => {

    version => "2021.2.1.35394",

    vendor => "Alteryx",

    installdate => ""

  },

 

```
{noformat}
Reply all
Reply to author
Forward
0 new messages