3 Replies Latest reply on Mar 11, 2017 8:06 AM by Matt Coles

    I have configured Vizalerts.yaml file, But when I tried to execute python Vizalerts.py script getting error " Could not process source viz data from Book1/Sheet1 for the following reason:  Invalid regular expression found. Could not evaluate expression '"

    Asif Shaik

      c:\VizAlerts>python C:\VizAlerts\vizalerts.py

      MainThread - 2017-02-22 11:55:14 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2017-02-22.log

      MainThread - 2017-02-22 11:55:14 - [INFO] - main - VizAlerts v2.0.1 is starting

      MainThread - 2017-02-22 11:55:14 - [DEBUG] - trusted_ticket_test - testing trusted ticket: 172.20.24.234, admin, None, None

      MainThread - 2017-02-22 11:55:14 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: 172.20.24.234, Site: , Username: admin, Url: http://172.20.24.234/trusted, Postdat

      a: username=admin.

      MainThread - 2017-02-22 11:55:14 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

      MainThread - 2017-02-22 11:55:14 - [DEBUG] - get_trusted_ticket - Got ticket: p3gHycVj5HGqJIQdjmYoIfn-

      MainThread - 2017-02-22 11:55:14 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: p3gHycVj5HGqJIQdjmYoIfn-

      MainThread - 2017-02-22 11:55:14 - [DEBUG] - get_alerts - Pulling source viz data down

      MainThread - 2017-02-22 11:55:14 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: 172.20.24.234, Site: test, Username: admin, Url: http://172.20.24.234/trusted, Pos

      tdata: username=admin&target_site=test.

      MainThread - 2017-02-22 11:55:14 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

      MainThread - 2017-02-22 11:55:15 - [DEBUG] - get_trusted_ticket - Got ticket: HfU3UH4gm2-BLZOzQe7KvlHH

      MainThread - 2017-02-22 11:55:15 - [DEBUG] - export_view - Getting vizdata from: http://172.20.24.234/trusted/HfU3UH4gm2-BLZOzQe7KvlHH/t/test/views/Book1/Sheet1?&:format=csv&:refresh=y

      MainThread - 2017-02-22 11:55:15 - [DEBUG] - export_view - NOT Validating cert for this request

      MainThread - 2017-02-22 11:55:15 - [DEBUG] - _new_conn - Starting new HTTP connection (1): 172.20.24.234

      MainThread - 2017-02-22 11:55:15 - [DEBUG] - _make_request - http://172.20.24.234:80 "GET /trusted/HfU3UH4gm2-BLZOzQe7KvlHH/t/test/views/Book1/Sheet1?&:format=csv&:refresh=y HTTP/1.1" 302 0

      MainThread - 2017-02-22 11:55:15 - [DEBUG] - _make_request - http://172.20.24.234:80 "GET /t/test/views/Book1/Sheet1?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 112

      MainThread - 2017-02-22 11:55:15 - [INFO] - export_view - Attempting to write to: .\temp\20170222115515295000_MainThread_Book1-Sheet1.csv

      MainThread - 2017-02-22 11:55:15 - [INFO] - send_email - sending email: smtp.gmail.com,asif.tableau@gmail.com,dilasif12@gmail.com,None,None,ALERT: VizAlerts failed to execute properly,None

      MainThread - 2017-02-22 11:55:15 - [DEBUG] - send_email - email body: Could not process source viz data from Book1/Sheet1 for the following reason:<br/><br/>Invalid regular expression found. Could not

      evaluate expression '' in the field allowed_from_address. Raw error:<br/><br/>allowed_from_address

      MainThread - 2017-02-22 11:55:18 - [ERROR] - <module> - An unhandled exception occurred: Traceback (most recent call last):

        File "C:\VizAlerts\vizalerts.py", line 463, in <module>

          main()

        File "C:\VizAlerts\vizalerts.py", line 130, in main

          alerts = get_alerts()

        File "C:\VizAlerts\vizalerts.py", line 240, in get_alerts

          e.message))

        File "C:\VizAlerts\vizalerts.py", line 448, in quit_script

          sys.exit(1)

      SystemExit: 1

      Traceback (most recent call last):

        File "C:\VizAlerts\vizalerts.py", line 463, in <module>

          main()

        File "C:\VizAlerts\vizalerts.py", line 130, in main

          alerts = get_alerts()

        File "C:\VizAlerts\vizalerts.py", line 240, in get_alerts

          e.message))

        File "C:\VizAlerts\vizalerts.py", line 448, in quit_script

          sys.exit(1)

      SystemExit: 1