10 Replies Latest reply on Sep 20, 2016 10:33 AM by Matt Coles

    Schedule has been set but I'm still having to start the Python script manually...?

    Lisa Burlingame

      Okay, you all were so helpful last week that I'm back for more!

       

      We've now installed VizAlerts to our production server and my IT resource has assured me that the one minute scheduled task has been set and he even sent me these screenshots to prove it. But, alas, I'm still needing to manual kick the Python command to get anything to process through. And it does process...things are working, but what are we missing with the scheduling?

      sch task1.png

      sch task2.png

      sch task3.png

      sch task4.png

       

      sch task5.png

       

      Add Arguments (optional):         G:\Program Files\VizAlerts-1.1.0\VizAlerts-1.1.0\vizalerts.py

      Start in (optional): G:\Program Files\VizAlerts-1.1.0\VizAlerts-1.1.0

       

      Everything else is set to default and the history shows a successful run every minute…

       

      Appreciate any direction you can give us. We're almost there!

        • 1. Re: Schedule has been set but I'm still having to start the Python script manually...?
          Jonathan Drummey

          What's happening in the VizAlerts logs?

           

          Sent from my iPhone

          • 2. Re: Schedule has been set but I'm still having to start the Python script manually...?
            Lisa Burlingame

            Does this help? All of these instances are me hitting vizalerts.py on the command line. And yes, I was patient and waited for it to do it by itself!

             

             

            2016-08-23 12:01:24 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2016-08-23.log

            2016-08-23 12:01:24 - [DEBUG] - trusted_ticket_test - testing trusted ticket: hr-tableau-01.company.org, svc_tableau, None

            2016-08-23 12:01:24 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: , Username: svc_tableau, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=svc_tableau.

            2016-08-23 12:01:24 - [DEBUG] - get_trusted_ticket - Got ticket: QgH2Qhj_ukRw6cj3MB0KAvj_

            2016-08-23 12:01:24 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: QgH2Qhj_ukRw6cj3MB0KAvj_

            2016-08-23 12:01:24 - [DEBUG] - get_views - PostgreSQL repository returned 1 rows

            2016-08-23 12:01:24 - [DEBUG] - get_views - Checking rule with from: 0, to: 3600, timeout: 30

            2016-08-23 12:01:24 - [DEBUG] - get_views - Checking rule with from: 3600, to: 7200, timeout: 60

            2016-08-23 12:01:24 - [DEBUG] - get_views - Checking rule with from: 7200, to: 14400, timeout: 120

            2016-08-23 12:01:24 - [DEBUG] - get_views - Rule applies!

            2016-08-23 12:01:24 - [DEBUG] - get_views - using timeout 120s, data retrieval tries 2, due to it being 7284.394 seconds since last run.

            2016-08-23 12:01:24 - [INFO] - main - Processing a total of 1 views

            2016-08-23 12:01:24 - [DEBUG] - process_views - Processing subscription_id 48, view_id 1437, site_name HR, customized view id None, view_name triggers for active emp and aff data

            2016-08-23 12:01:24 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: lburling,company.org,company,org

            2016-08-23 12:01:24 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: lburling,company

            2016-08-23 12:01:24 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: HR, Username: lburling, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=lburling&target_site=HR.

            2016-08-23 12:01:24 - [DEBUG] - get_trusted_ticket - Got ticket: ZXjbCfNQIIHhcEgNBAuxl0VH

            2016-08-23 12:01:24 - [DEBUG] - export_view - Getting vizdata from: https://hr-tableau-01.company.org/trusted/ZXjbCfNQIIHhcEgNBAuxl0VH/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata?&:format=csv&:refresh=y

            2016-08-23 12:01:24 - [INFO] - _new_conn - Starting new HTTPS connection (1): hr-tableau-01.company.org

            2016-08-23 12:01:24 - [DEBUG] - _make_request - "GET /trusted/ZXjbCfNQIIHhcEgNBAuxl0VH/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata?&:format=csv&:refresh=y HTTP/1.1" 302 0

            2016-08-23 12:01:27 - [DEBUG] - _make_request - "GET /t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 269

            2016-08-23 12:01:27 - [INFO] - export_view - Attempting to write to: .\temp\20160823120127440000_sccaautomatedreporting-triggersforactiveempandaffdata.csv

            2016-08-23 12:01:27 - [DEBUG] - process_csv - Opening file .\temp\20160823120127440000_sccaautomatedreporting-triggersforactiveempandaffdata.csv for reading

            2016-08-23 12:01:27 - [DEBUG] - process_csv - Iterating through rows

            2016-08-23 12:01:27 - [DEBUG] - process_csv - Rowcount at: 1

            2016-08-23 12:01:27 - [DEBUG] - process_csv - Done loading data

            2016-08-23 12:01:27 - [DEBUG] - process_csv - Advanced alert detected

            2016-08-23 12:01:27 - [DEBUG] - process_csv - Processing as an advanced alert

            2016-08-23 12:01:27 - [DEBUG] - process_csv - Validating email addresses

            2016-08-23 12:01:27 - [DEBUG] - addresses_are_invalid - Validating email field value: lburling@company.org

            2016-08-23 12:01:27 - [DEBUG] - addresses_are_invalid - Validating presumed email address: lburling@company.org

            2016-08-23 12:01:27 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: lburling,company.org,company,org

            2016-08-23 12:01:27 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: lburling,company

            2016-08-23 12:01:27 - [DEBUG] - addresses_are_invalid - Validating email field value: hris@company.org

            2016-08-23 12:01:27 - [DEBUG] - addresses_are_invalid - Validating presumed email address: hris@company.org

            2016-08-23 12:01:27 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: hris,company.org,company,org

            2016-08-23 12:01:27 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: hris,company

            2016-08-23 12:01:27 - [DEBUG] - get_unique_vizdata - Start of get_unique_vizdata

            2016-08-23 12:01:27 - [DEBUG] - get_unique_vizdata - Removing duplicates

            2016-08-23 12:01:27 - [DEBUG] - get_unique_vizdata - Sorting unique rows

            2016-08-23 12:01:27 - [DEBUG] - get_unique_vizdata - Done sorting, returning the list

            2016-08-23 12:01:27 - [DEBUG] - find_viz_refs - Identifying content references

            2016-08-23 12:01:27 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: HR, Username: lburling, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=lburling&target_site=HR.

            2016-08-23 12:01:27 - [DEBUG] - get_trusted_ticket - Got ticket: c3R61aDn2FqRUVXbqHdOiR2K

            2016-08-23 12:01:27 - [DEBUG] - export_view - Getting vizdata from: https://hr-tableau-01.company.org/trusted/c3R61aDn2FqRUVXbqHdOiR2K/t/HR/views/sccaautomatedreporting/activeempandaffdata?&:format=csv&:refresh=y

            2016-08-23 12:01:27 - [INFO] - _new_conn - Starting new HTTPS connection (1): hr-tableau-01.company.org

            2016-08-23 12:01:27 - [DEBUG] - _make_request - "GET /trusted/c3R61aDn2FqRUVXbqHdOiR2K/t/HR/views/sccaautomatedreporting/activeempandaffdata?&:format=csv&:refresh=y HTTP/1.1" 302 0

            2016-08-23 12:01:33 - [DEBUG] - _make_request - "GET /t/HR/views/sccaautomatedreporting/activeempandaffdata?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 609855

            2016-08-23 12:01:33 - [INFO] - export_view - Attempting to write to: .\temp\20160823120133628000_sccaautomatedreporting-activeempandaffdata.csv

            2016-08-23 12:01:33 - [DEBUG] - find_viz_refs - Returning content references

            2016-08-23 12:01:33 - [DEBUG] - process_csv - Starting iteration 0, consolidate_email_ctr is 0

            2016-08-23 12:01:33 - [DEBUG] - process_csv - Starting email action

            2016-08-23 12:01:33 - [INFO] - process_csv - Sending email to lburling@company.org, CC None, BCC None, Subject CCA employees and non employees

            2016-08-23 12:01:33 - [DEBUG] - append_body_and_inlineattachments - Replacing body text with exact content references for inline attachments and hyperlinks

            2016-08-23 12:01:33 - [DEBUG] - append_attachments - Adding appended attachments to list

            2016-08-23 12:01:33 - [INFO] - send_email - sending email: mx.company.org,hris@company.org,lburling@company.org,None,None,CCA employees and non employees,[]

            2016-08-23 12:01:33 - [DEBUG] - send_email - email body: Attached is a CSV file of the data requested.<br><br><font size="2"><i>This VizAlerts email generated on behalf of lburling@company.org, from view <a href="http://hr-tableau-01.company.org/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata">triggers for active emp and aff data</a></i></font>

            2016-08-23 12:16:34 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2016-08-23.log

            2016-08-23 12:16:34 - [DEBUG] - trusted_ticket_test - testing trusted ticket: hr-tableau-01.company.org, svc_tableau, None

            2016-08-23 12:16:34 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: , Username: svc_tableau, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=svc_tableau.

            2016-08-23 12:16:34 - [DEBUG] - get_trusted_ticket - Got ticket: zSOJIitw097KLOkj_qyNLUTc

            2016-08-23 12:16:34 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: zSOJIitw097KLOkj_qyNLUTc

            2016-08-23 12:16:35 - [DEBUG] - get_views - PostgreSQL repository returned 1 rows

            2016-08-23 12:16:35 - [DEBUG] - get_views - Checking rule with from: 0, to: 3600, timeout: 30

            2016-08-23 12:16:35 - [DEBUG] - get_views - Rule applies!

            2016-08-23 12:16:35 - [DEBUG] - get_views - using timeout 30s, data retrieval tries 1, due to it being 911.026 seconds since last run.

            2016-08-23 12:16:35 - [INFO] - main - Processing a total of 1 views

            2016-08-23 12:16:35 - [DEBUG] - process_views - Processing subscription_id 48, view_id 1437, site_name HR, customized view id None, view_name triggers for active emp and aff data

            2016-08-23 12:16:35 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: lburling,company.org,company,org

            2016-08-23 12:16:35 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: lburling,company

            2016-08-23 12:16:35 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: HR, Username: lburling, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=lburling&target_site=HR.

            2016-08-23 12:16:35 - [DEBUG] - get_trusted_ticket - Got ticket: sK_SiV1MSR6MmygbF0Y_uYXT

            2016-08-23 12:16:35 - [DEBUG] - export_view - Getting vizdata from: https://hr-tableau-01.company.org/trusted/sK_SiV1MSR6MmygbF0Y_uYXT/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata?&:format=csv&:refresh=y

            2016-08-23 12:16:35 - [INFO] - _new_conn - Starting new HTTPS connection (1): hr-tableau-01.company.org

            2016-08-23 12:16:35 - [DEBUG] - _make_request - "GET /trusted/sK_SiV1MSR6MmygbF0Y_uYXT/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata?&:format=csv&:refresh=y HTTP/1.1" 302 0

            2016-08-23 12:16:36 - [DEBUG] - _make_request - "GET /t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 269

            2016-08-23 12:16:36 - [INFO] - export_view - Attempting to write to: .\temp\20160823121636495000_sccaautomatedreporting-triggersforactiveempandaffdata.csv

            2016-08-23 12:16:36 - [DEBUG] - process_csv - Opening file .\temp\20160823121636495000_sccaautomatedreporting-triggersforactiveempandaffdata.csv for reading

            2016-08-23 12:16:36 - [DEBUG] - process_csv - Iterating through rows

            2016-08-23 12:16:36 - [DEBUG] - process_csv - Rowcount at: 1

            2016-08-23 12:16:36 - [DEBUG] - process_csv - Done loading data

            2016-08-23 12:16:36 - [DEBUG] - process_csv - Advanced alert detected

            2016-08-23 12:16:36 - [DEBUG] - process_csv - Processing as an advanced alert

            2016-08-23 12:16:36 - [DEBUG] - process_csv - Validating email addresses

            2016-08-23 12:16:36 - [DEBUG] - addresses_are_invalid - Validating email field value: lburling@company.org

            2016-08-23 12:16:36 - [DEBUG] - addresses_are_invalid - Validating presumed email address: lburling@company.org

            2016-08-23 12:16:36 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: lburling,company.org,company,org

            2016-08-23 12:16:36 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: lburling,company

            2016-08-23 12:16:36 - [DEBUG] - addresses_are_invalid - Validating email field value: hris@company.org

            2016-08-23 12:16:36 - [DEBUG] - addresses_are_invalid - Validating presumed email address: hris@company.org

            2016-08-23 12:16:36 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: hris,company.org,company,org

            2016-08-23 12:16:36 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: hris,company

            2016-08-23 12:16:36 - [DEBUG] - get_unique_vizdata - Start of get_unique_vizdata

            2016-08-23 12:16:36 - [DEBUG] - get_unique_vizdata - Removing duplicates

            2016-08-23 12:16:36 - [DEBUG] - get_unique_vizdata - Sorting unique rows

            2016-08-23 12:16:36 - [DEBUG] - get_unique_vizdata - Done sorting, returning the list

            2016-08-23 12:16:36 - [DEBUG] - find_viz_refs - Identifying content references

            2016-08-23 12:16:36 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: HR, Username: lburling, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=lburling&target_site=HR.

            2016-08-23 12:16:36 - [DEBUG] - get_trusted_ticket - Got ticket: oov3oieAABb80Zjq5ZslVvoz

            2016-08-23 12:16:36 - [DEBUG] - export_view - Getting vizdata from: https://hr-tableau-01.company.org/trusted/oov3oieAABb80Zjq5ZslVvoz/t/HR/views/sccaautomatedreporting/activeempandaffdata?&:format=csv&:refresh=y

            2016-08-23 12:16:36 - [INFO] - _new_conn - Starting new HTTPS connection (1): hr-tableau-01.company.org

            2016-08-23 12:16:36 - [DEBUG] - _make_request - "GET /trusted/oov3oieAABb80Zjq5ZslVvoz/t/HR/views/sccaautomatedreporting/activeempandaffdata?&:format=csv&:refresh=y HTTP/1.1" 302 0

            2016-08-23 12:16:42 - [DEBUG] - _make_request - "GET /t/HR/views/sccaautomatedreporting/activeempandaffdata?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 673512

            2016-08-23 12:16:42 - [INFO] - export_view - Attempting to write to: .\temp\20160823121642526000_sccaautomatedreporting-activeempandaffdata.csv

            2016-08-23 12:16:42 - [DEBUG] - find_viz_refs - Returning content references

            2016-08-23 12:16:42 - [DEBUG] - process_csv - Starting iteration 0, consolidate_email_ctr is 0

            2016-08-23 12:16:42 - [DEBUG] - process_csv - Starting email action

            2016-08-23 12:16:42 - [INFO] - process_csv - Sending email to lburling@company.org, CC None, BCC None, Subject CCA employees and non employees

            2016-08-23 12:16:42 - [DEBUG] - append_body_and_inlineattachments - Replacing body text with exact content references for inline attachments and hyperlinks

            2016-08-23 12:16:42 - [DEBUG] - append_attachments - Adding appended attachments to list

            2016-08-23 12:16:42 - [INFO] - send_email - sending email: mx.company.org,hris@company.org,lburling@company.org,None,None,CCA employees and non employees,[]

            2016-08-23 12:16:42 - [DEBUG] - send_email - email body: Attached is a CSV file of the data requested.<br><br><font size="2"><i>This VizAlerts email generated on behalf of lburling@company.org, from view <a href="http://hr-tableau-01.company.org/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata">triggers for active emp and aff data</a></i></font>

            2016-08-23 15:09:15 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2016-08-23.log

            2016-08-23 15:09:15 - [DEBUG] - trusted_ticket_test - testing trusted ticket: hr-tableau-01.company.org, svc_tableau, None

            2016-08-23 15:09:15 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: , Username: svc_tableau, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=svc_tableau.

            2016-08-23 15:09:15 - [DEBUG] - get_trusted_ticket - Got ticket: hk-0dBDtnm99M5Xjn8pEi-LJ

            2016-08-23 15:09:15 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: hk-0dBDtnm99M5Xjn8pEi-LJ

            2016-08-23 15:09:15 - [DEBUG] - get_views - PostgreSQL repository returned 1 rows

            2016-08-23 15:09:15 - [DEBUG] - get_views - Checking rule with from: 0, to: 3600, timeout: 30

            2016-08-23 15:09:15 - [DEBUG] - get_views - Checking rule with from: 3600, to: 7200, timeout: 60

            2016-08-23 15:09:15 - [DEBUG] - get_views - Checking rule with from: 7200, to: 14400, timeout: 120

            2016-08-23 15:09:15 - [DEBUG] - get_views - Rule applies!

            2016-08-23 15:09:15 - [DEBUG] - get_views - using timeout 120s, data retrieval tries 2, due to it being 10360.774 seconds since last run.

            2016-08-23 15:09:15 - [INFO] - main - Processing a total of 1 views

            2016-08-23 15:09:15 - [DEBUG] - process_views - Processing subscription_id 48, view_id 1437, site_name HR, customized view id None, view_name triggers for active emp and aff data

            2016-08-23 15:09:15 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: lburling,company.org,company,org

            2016-08-23 15:09:15 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: lburling,company

            2016-08-23 15:09:15 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: HR, Username: lburling, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=lburling&target_site=HR.

            2016-08-23 15:09:15 - [DEBUG] - get_trusted_ticket - Got ticket: pXGiYMTO0jAjTSVycluMzgqL

            2016-08-23 15:09:15 - [DEBUG] - export_view - Getting vizdata from: https://hr-tableau-01.company.org/trusted/pXGiYMTO0jAjTSVycluMzgqL/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata?&:format=csv&:refresh=y

            2016-08-23 15:09:15 - [INFO] - _new_conn - Starting new HTTPS connection (1): hr-tableau-01.company.org

            2016-08-23 15:09:15 - [DEBUG] - _make_request - "GET /trusted/pXGiYMTO0jAjTSVycluMzgqL/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata?&:format=csv&:refresh=y HTTP/1.1" 302 0

            2016-08-23 15:09:18 - [DEBUG] - _make_request - "GET /t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 426

            2016-08-23 15:09:18 - [INFO] - export_view - Attempting to write to: .\temp\20160823150918774000_sccaautomatedreporting-triggersforactiveempandaffdata.csv

            2016-08-23 15:09:18 - [DEBUG] - process_csv - Opening file .\temp\20160823150918774000_sccaautomatedreporting-triggersforactiveempandaffdata.csv for reading

            2016-08-23 15:09:18 - [DEBUG] - process_csv - Iterating through rows

            2016-08-23 15:09:18 - [DEBUG] - process_csv - Rowcount at: 1

            2016-08-23 15:09:18 - [DEBUG] - process_csv - Rowcount at: 2

            2016-08-23 15:09:18 - [DEBUG] - process_csv - Done loading data

            2016-08-23 15:09:18 - [DEBUG] - process_csv - Advanced alert detected

            2016-08-23 15:09:18 - [DEBUG] - process_csv - Processing as an advanced alert

            2016-08-23 15:09:18 - [DEBUG] - process_csv - Validating email addresses

            2016-08-23 15:09:18 - [DEBUG] - addresses_are_invalid - Validating email field value: lburling@company.org

            2016-08-23 15:09:18 - [DEBUG] - addresses_are_invalid - Validating presumed email address: lburling@company.org

            2016-08-23 15:09:18 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: lburling,company.org,company,org

            2016-08-23 15:09:18 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: lburling,company

            2016-08-23 15:09:18 - [DEBUG] - addresses_are_invalid - Validating email field value: hris@company.org

            2016-08-23 15:09:18 - [DEBUG] - addresses_are_invalid - Validating presumed email address: hris@company.org

            2016-08-23 15:09:18 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: hris,company.org,company,org

            2016-08-23 15:09:18 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: hris,company

            2016-08-23 15:09:18 - [DEBUG] - addresses_are_invalid - Validating email field value: lburling@company.org

            2016-08-23 15:09:18 - [DEBUG] - addresses_are_invalid - Validating presumed email address: lburling@company.org

            2016-08-23 15:09:18 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: lburling,company.org,company,org

            2016-08-23 15:09:18 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: lburling,company

            2016-08-23 15:09:18 - [DEBUG] - addresses_are_invalid - Validating email field value: hris@company.org

            2016-08-23 15:09:18 - [DEBUG] - addresses_are_invalid - Validating presumed email address: hris@company.org

            2016-08-23 15:09:18 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: hris,company.org,company,org

            2016-08-23 15:09:18 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: hris,company

            2016-08-23 15:09:18 - [DEBUG] - get_unique_vizdata - Start of get_unique_vizdata

            2016-08-23 15:09:18 - [DEBUG] - get_unique_vizdata - Removing duplicates

            2016-08-23 15:09:18 - [DEBUG] - get_unique_vizdata - Sorting unique rows

            2016-08-23 15:09:18 - [DEBUG] - get_unique_vizdata - Done sorting, returning the list

            2016-08-23 15:09:18 - [DEBUG] - find_viz_refs - Identifying content references

            2016-08-23 15:09:18 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: HR, Username: lburling, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=lburling&target_site=HR.

            2016-08-23 15:09:18 - [DEBUG] - get_trusted_ticket - Got ticket: PSaJ8rIENKYNvpHvz7L_tmv0

            2016-08-23 15:09:18 - [DEBUG] - export_view - Getting vizdata from: https://hr-tableau-01.company.org/trusted/PSaJ8rIENKYNvpHvz7L_tmv0/t/HR/views/sccaautomatedreporting/activeempandaffdata?&:format=csv&:refresh=y

            2016-08-23 15:09:18 - [INFO] - _new_conn - Starting new HTTPS connection (1): hr-tableau-01.company.org

            2016-08-23 15:09:18 - [DEBUG] - _make_request - "GET /trusted/PSaJ8rIENKYNvpHvz7L_tmv0/t/HR/views/sccaautomatedreporting/activeempandaffdata?&:format=csv&:refresh=y HTTP/1.1" 302 0

            2016-08-23 15:09:25 - [DEBUG] - _make_request - "GET /t/HR/views/sccaautomatedreporting/activeempandaffdata?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 673502

            2016-08-23 15:09:25 - [INFO] - export_view - Attempting to write to: .\temp\20160823150925508000_sccaautomatedreporting-activeempandaffdata.csv

            2016-08-23 15:09:25 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: HR, Username: lburling, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=lburling&target_site=HR.

            2016-08-23 15:09:25 - [DEBUG] - get_trusted_ticket - Got ticket: 13D284lbauGV8K5thhcrc1KX

            2016-08-23 15:09:25 - [DEBUG] - export_view - Getting vizdata from: https://hr-tableau-01.company.org/trusted/13D284lbauGV8K5thhcrc1KX/t/HR/views/sccaautomatedreporting/hiresandrehires?&:format=csv&:refresh=y

            2016-08-23 15:09:25 - [INFO] - _new_conn - Starting new HTTPS connection (1): hr-tableau-01.company.org

            2016-08-23 15:09:25 - [DEBUG] - _make_request - "GET /trusted/13D284lbauGV8K5thhcrc1KX/t/HR/views/sccaautomatedreporting/hiresandrehires?&:format=csv&:refresh=y HTTP/1.1" 302 0

            2016-08-23 15:09:29 - [DEBUG] - _make_request - "GET /t/HR/views/sccaautomatedreporting/hiresandrehires?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 5126

            2016-08-23 15:09:29 - [INFO] - export_view - Attempting to write to: .\temp\20160823150929055000_sccaautomatedreporting-hiresandrehires.csv

            2016-08-23 15:09:29 - [DEBUG] - find_viz_refs - Returning content references

            2016-08-23 15:09:29 - [DEBUG] - process_csv - Starting iteration 0, consolidate_email_ctr is 0

            2016-08-23 15:09:29 - [DEBUG] - process_csv - Starting email action

            2016-08-23 15:09:29 - [INFO] - process_csv - Sending email to lburling@company.org, CC None, BCC None, Subject CCA employees and non employees

            2016-08-23 15:09:29 - [DEBUG] - append_body_and_inlineattachments - Replacing body text with exact content references for inline attachments and hyperlinks

            2016-08-23 15:09:29 - [DEBUG] - append_attachments - Adding appended attachments to list

            2016-08-23 15:09:29 - [INFO] - send_email - sending email: mx.company.org,hris@company.org,lburling@company.org,None,None,CCA employees and non employees,[]

            2016-08-23 15:09:29 - [DEBUG] - send_email - email body: Attached is a CSV file of the data requested.<br><br><font size="2"><i>This VizAlerts email generated on behalf of lburling@company.org, from view <a href="http://hr-tableau-01.company.org/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata">triggers for active emp and aff data</a></i></font>

            2016-08-23 15:09:29 - [DEBUG] - process_csv - Starting iteration 1, consolidate_email_ctr is 0

            2016-08-23 15:09:29 - [DEBUG] - process_csv - Starting email action

            2016-08-23 15:09:29 - [INFO] - process_csv - Sending email to lburling@company.org, CC None, BCC None, Subject New Hires/Rehires

            2016-08-23 15:09:29 - [DEBUG] - append_body_and_inlineattachments - Replacing body text with exact content references for inline attachments and hyperlinks

            2016-08-23 15:09:29 - [DEBUG] - append_attachments - Adding appended attachments to list

            2016-08-23 15:09:29 - [INFO] - send_email - sending email: mx.company.org,hris@company.org,lburling@company.org,None,None,New Hires/Rehires,[]

            2016-08-23 15:09:29 - [DEBUG] - send_email - email body: Attached is a CSV file of the data requested.<br><br><font size="2"><i>This VizAlerts email generated on behalf of lburling@company.org, from view <a href="http://hr-tableau-01.company.org/t/HR/views/sccaautomatedreporting/triggersforactiveempandaffdata">triggers for active emp and aff data</a></i></font>

            2016-08-23 15:47:26 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2016-08-23.log

            2016-08-23 15:47:26 - [DEBUG] - trusted_ticket_test - testing trusted ticket: hr-tableau-01.company.org, svc_tableau, None

            2016-08-23 15:47:26 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: , Username: svc_tableau, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=svc_tableau.

            2016-08-23 15:47:26 - [DEBUG] - get_trusted_ticket - Got ticket: M_Pwpq_DtgIKQl7JXm_1fOPR

            2016-08-23 15:47:26 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: M_Pwpq_DtgIKQl7JXm_1fOPR

            2016-08-23 15:47:26 - [DEBUG] - get_views - PostgreSQL repository returned 4 rows

            2016-08-23 15:47:26 - [INFO] - main - Processing a total of 0 views

            2016-08-23 15:49:43 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2016-08-23.log

            2016-08-23 15:49:43 - [DEBUG] - trusted_ticket_test - testing trusted ticket: hr-tableau-01.company.org, svc_tableau, None

            2016-08-23 15:49:43 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: hr-tableau-01.company.org, Site: , Username: svc_tableau, Url: https://hr-tableau-01.company.org/trusted, Postdata: username=svc_tableau.

            2016-08-23 15:49:43 - [DEBUG] - get_trusted_ticket - Got ticket: zavZuHjb7CkvLqpzin_VqFpi

            2016-08-23 15:49:43 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: zavZuHjb7CkvLqpzin_VqFpi

            2016-08-23 15:49:44 - [DEBUG] - get_views - PostgreSQL repository returned 4 rows

            2016-08-23 15:49:44 - [INFO] - main - Processing a total of 0 views

            • 3. Re: Schedule has been set but I'm still having to start the Python script manually...?
              Matt Coles

              Hey Lisa, thanks to you and your IT contact on the screenshots, they're very helpful. They show that the scheduled task is set up correctly. The logs you shared tell me that things are working just fine when you execute the script manually. And you said that the history of the Scheduled Task indicates things are working okay there, as well.

               

              So...all of that is confusing to me. What's the problem?! In the first post you said "I'm still needing to manual kick the Python command to get anything to process through." Could you clarify exactly what you are seeing that indicates that nothing is "processing through"? Does that mean that when the scheduled task itself runs, you see a successful result in Scheduled Tasks in the history tab, but you don't see any new logged lines in the VizAlerts logs themselves?

              • 4. Re: Schedule has been set but I'm still having to start the Python script manually...?
                Jonathan Drummey

                The logs should have an entry every single minute (based on the schedule)

                so VizAlerts isn't running. I'm not sure why, I suggest that your sys admin

                checks the event log in the Task Scheduler. For example there might be a

                permissions error.

                 

                Jonathan

                 

                 

                On Thu, Aug 25, 2016 at 12:20 PM, Lisa Burlingame <

                • 5. Re: Schedule has been set but I'm still having to start the Python script manually...?
                  Lisa Burlingame

                  Ok, so my sys admin is out of the office till Tuesday, but I did manage to get to the Task Scheduler log and it looks like it is running every minute.

                   

                   

                  And Matt, what I meant is I only get the emails when I manually go to the command line and run the python script. I guess I'm confused about how the task scheduler and the Tableau schedule tie together. The test emails I'm trying to receive are scheduled to run every 15 minutes...but unless I run the python manually, they don't generate.  Is there another piece I'm missing - is it because the data hasn't changed in the attached csv or pdf files that a new email is not being generated? Are there two criteria that need to be met - the schedule and the presence of new data - to send a new email? That doesn't seem logical as I have some views I'd like to have generate (and land in inboxes daily) but the data may not change - there will be data, it just may be the same data and VizAlerts isn't that smart, is it? I guess while I'm testing I would expect to see an email every 15 minutes...not so?

                   

                  Really appreciate your help with this!

                   

                  Lisa

                  • 6. Re: Schedule has been set but I'm still having to start the Python script manually...?
                    Matt Coles

                    Got it, thanks! So 0x2, despite Task Scheduler assuring you it "ran successfully", is actually an error code. Why on earth Task Scheduler can't translate that for you into English, in 2016, I have no idea. However, that code means "file not found".

                     

                    Windows System Error Codes (exit codes)

                     

                    So first off, check the paths again that the Task is running--make sure they're correct and that you can run the same thing in the command line. If that works, then it's certainly a permissions problem--your svc_tableau account will need the correct permissions to write and delete to the VizAlerts folder and all files and folders within it. It's one of those two things.

                    • 7. Re: Schedule has been set but I'm still having to start the Python script manually...?
                      Jonathan Drummey

                      Thanks for jumping in on this, Matt! I’d run into this same problem at one point but couldn’t remember what fixed it, I think both of your ideas are spot-on.

                       

                      Jonathan

                      • 8. Re: Schedule has been set but I'm still having to start the Python script manually...?
                        Lisa Burlingame

                        Matt & Jonathan - thanks for the info...I love when error messages say 'ran successfully'!

                         

                        My IT resource will be back on Tuesday (8/30) so I plan to follow up and we'll let you know if we can resolve this. Stay tuned...

                         

                        Lisa

                        • 9. Re: Schedule has been set but I'm still having to start the Python script manually...?
                          Lisa Burlingame

                          Well, I finally circled back around with my IT resource and he confirmed that we had a path off and things are now working as designed. Thanks for all the help!