looker-open-source / henry

A command line tool for Looker instance cleanup
MIT License
79 stars 27 forks source link

Henry throwing JSONDecodeError #94

Open orest-tokovenko-deel opened 1 week ago

orest-tokovenko-deel commented 1 week ago

I've configured the Looker.ini file with my credentials (same as my coworkers), but every time I run the command it throws the same error. Please see below.

using python 3.10 and henry 0.30

(.venv) ➜  henry pulse --timeout 120000                   
Test 1/6: Checking connections
Traceback (most recent call last):
  File "/Users/oresttokovenko/Documents/henry/.venv/lib/python3.10/site-packages/looker_sdk/rtl/serialize.py", line 66, in deserialize
    data = json.loads(data)
  File "/Users/oresttokovenko/.pyenv/versions/3.10.12/lib/python3.10/json/__init__.py", line 346, in loads
    return _default_decoder.decode(s)
  File "/Users/oresttokovenko/.pyenv/versions/3.10.12/lib/python3.10/json/decoder.py", line 337, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/Users/oresttokovenko/.pyenv/versions/3.10.12/lib/python3.10/json/decoder.py", line 355, in raw_decode
    raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/Users/oresttokovenko/Documents/henry/.venv/lib/python3.10/site-packages/looker_sdk/rtl/api_methods.py", line 90, in _return
    sdk_error = self.deserialize(data=value, structure=error.SDKError) # type: ignore
  File "/Users/oresttokovenko/Documents/henry/.venv/lib/python3.10/site-packages/looker_sdk/rtl/serialize.py", line 68, in deserialize
    raise DeserializeError(f"Bad json {ex}")
looker_sdk.rtl.serialize.DeserializeError: Bad json Expecting value: line 1 column 1 (char 0)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/Users/oresttokovenko/Documents/henry/.venv/bin/henry", line 8, in <module>
    sys.exit(main())
  File "/Users/oresttokovenko/Documents/henry/.venv/lib/python3.10/site-packages/henry/cli.py", line 16, in main
    pulse.Pulse.run(user_input)
  File "/Users/oresttokovenko/Documents/henry/.venv/lib/python3.10/site-packages/henry/commands/pulse.py", line 19, in run
    pulse.check_db_connections()
  File "/Users/oresttokovenko/.pyenv/versions/3.10.12/lib/python3.10/contextlib.py", line 79, in inner
    return func(*args, **kwds)
  File "/Users/oresttokovenko/Documents/henry/.venv/lib/python3.10/site-packages/henry/commands/pulse.py", line 43, in check_db_connections
    resp = self.sdk.test_connection(
  File "/Users/oresttokovenko/Documents/henry/.venv/lib/python3.10/site-packages/looker_sdk/sdk/api40/methods.py", line 3518, in test_connection
    self.put(
  File "/Users/oresttokovenko/Documents/henry/.venv/lib/python3.10/site-packages/looker_sdk/rtl/api_methods.py", line 222, in put
    return self._return(response, structure)
  File "/Users/oresttokovenko/Documents/henry/.venv/lib/python3.10/site-packages/looker_sdk/rtl/api_methods.py", line 92, in _return
    raise error.SDKError(value)
looker_sdk.error.SDKError: <!DOCTYPE html>
<html>
<head>
    <title>Looker Not Found (404)</title>
    <link href='https://fonts.googleapis.com/css?family=Open+Sans:400,600' rel='stylesheet' type='text/css'>

    <!-- @@@@@@@@@@@@@ FAVICONS @@@@@@@@@@@@@ -->

    <link rel="apple-touch-icon-precomposed" sizes="57x57" href="https://wwwstatic-b.lookercdn.com/favicon/apple-touch-icon-57x57.png" />
    <link rel="apple-touch-icon-precomposed" sizes="114x114" href="https://wwwstatic-c.lookercdn.com/favicon/apple-touch-icon-114x114.png" />
    <link rel="apple-touch-icon-precomposed" sizes="72x72" href="https://wwwstatic-d.lookercdn.com/favicon/apple-touch-icon-72x72.png" />
    <link rel="apple-touch-icon-precomposed" sizes="144x144" href="https://wwwstatic-a.lookercdn.com/favicon/apple-touch-icon-144x144.png" />
    <link rel="apple-touch-icon-precomposed" sizes="60x60" href="https://wwwstatic-b.lookercdn.com/favicon/apple-touch-icon-60x60.png" />
    <link rel="apple-touch-icon-precomposed" sizes="120x120" href="https://wwwstatic-c.lookercdn.com/favicon/apple-touch-icon-120x120.png" />
    <link rel="apple-touch-icon-precomposed" sizes="76x76" href="https://wwwstatic-d.lookercdn.com/favicon/apple-touch-icon-76x76.png" />
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="https://wwwstatic-a.lookercdn.com/favicon/apple-touch-icon-152x152.png" />
    <link rel="icon" type="image/png" href="https://wwwstatic-b.lookercdn.com/favicon/favicon-196x196.png" sizes="196x196" />
    <link rel="icon" type="image/png" href="https://wwwstatic-c.lookercdn.com/favicon/favicon-96x96.png" sizes="96x96" />
    <link rel="icon" type="image/png" href="https://wwwstatic-d.lookercdn.com/favicon/favicon-32x32.png" sizes="32x32" />
    <link rel="icon" type="image/png" href="https://wwwstatic-a.lookercdn.com/favicon/favicon-16x16.png" sizes="16x16" />
    <link rel="icon" type="image/png" href="https://wwwstatic-b.lookercdn.com/favicon/favicon-128.png" sizes="128x128" />
    <meta name="application-name" content="Looker"/>
    <meta name="msapplication-TileColor" content="#FFFFFF" />
    <meta name="msapplication-TileImage" content="https://wwwstatic-c.lookercdn.com/favicon/mstile-144x144.png" />
    <meta name="msapplication-square70x70logo" content="https://wwwstatic-d.lookercdn.com/favicon/mstile-70x70.png" />
    <meta name="msapplication-square150x150logo" content="https://wwwstatic-a.lookercdn.com/favicon/mstile-150x150.png" />
    <meta name="msapplication-wide310x150logo" content="https://wwwstatic-b.lookercdn.com/favicon/mstile-310x150.png" />
    <meta name="msapplication-square310x310logo" content="https://wwwstatic-c.lookercdn.com/favicon/mstile-310x310.png" />

    <style type="text/css">
        body {
            background-color: #2e343f;
            color: white;
            height: auto;
            font-family: Open Sans, Helvetica, Arial, sans-serif;
        }
        .message {
            width: 100%;
            max-width: 760px;
            margin: 0 auto;
            margin-top: 135px;
            text-align: center;
        }
        h2, h3 {
            font-weight: normal;
        }
        a {
            color: white;
        }
    </style>
</head>
<body>

    <div class="message">

        <img width="210" height="84" src="https://wwwstatic-a.lookercdn.com/logos/looker_all_white.svg" alt="Looker">

        <h1>Looker is unavailable.</h1>

        <h2>If you typed in a URL, double-check the spelling.</h2>
        <h2>This may also be due to a temporary condition such as an outage, <a href="https://docs.looker.com/relnotes/hosted-maintenance-hours">scheduled maintenance</a> or upgrade.</h2>
        <br>
        <h3>
          If this message persists or you have any concerns, <br> contact us from
          <a href="https://help.looker.com">help.looker.com</a> and we'll respond promptly.
        </h3>

    </div>

</body>
</html>