Windows ActiveGate Extension: Failed to install the plugin into temporary location

[jc__]

Hello,

I am facing this error while building this activegate extension plugin.

Python Version: 3.8.0

OS: Windows 10

PowerShell (run as administrator) Output:

PS C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb> workon ag_extension
PS C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb> plugin_sdk build_plugin --no_upload
Arguments=Namespace(deployment_dir=None, no_cert_ver=False, no_upload=True, plugin_dir='C:\\Users\\junchao.thean\\OneDrive - ISATEC Sdn Bhd\\Desktop\\ag-extension-fa\\custom.remote.python.fadb', server=None, token=None, token_file=None, verbose=False)
Starting oneagent_build_plugin
Checking plugin metadata: C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\plugin.json
Validating plugin.json against schema
Plugin data: Plugin name=custom.remote.python.fadb, version=1.0
Cleaning up previous build information
running bdist_wheel
running build
running build_py
creating build
creating build\lib
copying C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.py -> build\lib
c:\users\junchao.thean\appdata\local\programs\python\python38\lib\site-packages\setuptools\_distutils\cmd.py:66: SetuptoolsDeprecationWarning: setup.py install is deprecated.
!!

        ********************************************************************************
        Please avoid running ``setup.py`` directly.
        Instead, use pypa/build, pypa/installer or other
        standards-based tools.

        See https://blog.ganssle.io/articles/2021/10/setup-py-deprecated.html for details.
        ********************************************************************************

!!
  self.initialize_options()
installing to build\bdist.win-amd64\wheel
running install
running install_lib
creating build\bdist.win-amd64
creating build\bdist.win-amd64\wheel
copying build\lib\fadb.py -> build\bdist.win-amd64\wheel\.
running install_egg_info
running egg_info
creating C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.egg-info
writing C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.egg-info\PKG-INFO
writing dependency_links to C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.egg-info\dependency_links.txt
writing requirements to C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.egg-info\requires.txt
writing top-level names to C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.egg-info\top_level.txt
writing manifest file 'C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.egg-info\SOURCES.txt'
reading manifest file 'C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.egg-info\SOURCES.txt'
writing manifest file 'C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.egg-info\SOURCES.txt'
Copying C:\Users\junchao.thean\OneDrive - ISATEC Sdn Bhd\Desktop\ag-extension-fa\custom.remote.python.fadb\fadb.egg-info to build\bdist.win-amd64\wheel\.\fadb-1.0-py3.8.egg-info
running install_scripts
creating build\bdist.win-amd64\wheel\fadb-1.0.dist-info\WHEEL
creating 'dist\fadb-1.0-py3-none-any.whl' and adding 'build\bdist.win-amd64\wheel' to it
adding 'fadb.py'
adding 'fadb-1.0.dist-info/METADATA'
adding 'fadb-1.0.dist-info/WHEEL'
adding 'fadb-1.0.dist-info/top_level.txt'
adding 'fadb-1.0.dist-info/RECORD'
removing build\bdist.win-amd64\wheel
Leaving directory C:\Users\JUNCHA~1.THE\AppData\Local\Temp\tmpyg5qvg7g
Created distribution of the plugin: [('bdist_wheel', '3.8', 'dist\\fadb-1.0-py3-none-any.whl')]
Installing plugin to temporary location
Processing c:\users\juncha~1.the\appdata\local\temp\tmpyg5qvg7g\dist\fadb-1.0-py3-none-any.whl
Collecting pymssql>=2.2.7 (from fadb==1.0)
  Using cached pymssql-2.2.8.tar.gz (171 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: pymssql
  Building wheel for pymssql (pyproject.toml) ... error
  error: subprocess-exited-with-error

  × Building wheel for pymssql (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [41 lines of output]
      setup.py: platform.system() => Windows
      setup.py: platform.architecture() => ('64bit', 'WindowsPE')
      setup.py: include_dirs => []
      setup.py: library_dirs => []
      running bdist_wheel
      running build
      running build_py
      creating build
      creating build\lib.win-amd64-cpython-38
      creating build\lib.win-amd64-cpython-38\pymssql
      copying src\pymssql\__init__.py -> build\lib.win-amd64-cpython-38\pymssql
      running build_ext
      Compiling src\pymssql\_mssql.pyx because it changed.
      [1/1] Cythonizing src\pymssql\_mssql.pyx
      building 'pymssql._mssql' extension
      creating build\temp.win-amd64-cpython-38
      creating build\temp.win-amd64-cpython-38\Release
      creating build\temp.win-amd64-cpython-38\Release\src
      creating build\temp.win-amd64-cpython-38\Release\src\pymssql
      "C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\VC\Tools\MSVC\14.36.32532\bin\HostX86\x64\cl.exe" /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Ic:\users\junchao.thean\appdata\local\programs\python\python38\include -Ic:\users\junchao.thean\appdata\local\programs\python\python38\Include "-IC:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\VC\Tools\MSVC\14.36.32532\include" "-IC:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\VC\Tools\MSVC\14.36.32532\ATLMFC\include" "-IC:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\VC\Auxiliary\VS\include" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\10\\include\10.0.22621.0\\um" "-IC:\Program Files (x86)\Windows Kits\10\\include\10.0.22621.0\\shared" "-IC:\Program Files (x86)\Windows Kits\10\\include\10.0.22621.0\\winrt" "-IC:\Program Files (x86)\Windows Kits\10\\include\10.0.22621.0\\cppwinrt" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.8\include\um" /Tcsrc\pymssql\_mssql.c /Fobuild\temp.win-amd64-cpython-38\Release\src\pymssql\_mssql.obj -DMSDBLIB
      _mssql.c
      src\pymssql\_mssql.c(1139): fatal error C1083: Cannot open include file: 'sqlfront.h': No such file or directory
      warning: src\pymssql\_mssql.pyx:27:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:28:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:29:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:30:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:31:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:32:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:35:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:36:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:38:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:82:0: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:230:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:264:4: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:333:4: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:831:8: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:919:8: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:1005:12: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:1379:16: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
      warning: src\pymssql\_mssql.pyx:1713:8: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
      error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio\\2022\\BuildTools\\VC\\Tools\\MSVC\\14.36.32532\\bin\\HostX86\\x64\\cl.exe' failed with exit code 2
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
  ERROR: Failed building wheel for pymssql
Failed to build pymssql
ERROR: Could not build wheels for pymssql, which is required to install pyproject.toml-based projects
Failed to install the plugin into temporary location

 Thanks in advance.

[natanael_mendes · Accepted solution]

 i had a similar error on macOS (M1 chip) when trying to install tap-mssql.  After I ran the following I was able to pip install pymsql (well, in my case it was pip install tap-mssql):

brew install freetds