10 Replies Latest reply on Apr 4, 2017 7:13 AM by Matt Coles Branched from an earlier discussion. Branched to a new discussion.

    VizAlerts failing

    Prashanth Badugu

      Hi Sudhakar .

       

      can across the tableau community ..understood from your posts that you have configured Vizalerts ..

       

      we are facing issues with configuring vizalerts ..

       

      would be great if you can help us through get pass through this ..

       

      below is the error msg  when i running the python script..

       

       

      E:\>VizAlerts\vizalerts.py

      MainThread - 2017-03-23 04:38:02 - [INFO] - LoggerQuickSetup - Logging initializ

      ed, writing to .\logs\vizalerts.log_2017-03-23.log

      MainThread - 2017-03-23 04:38:02 - [INFO] - main - VizAlerts v2.0.1 is starting

      An exception was raised loading the config file .\config\vizalerts.yaml: (<type

      'exceptions.IOError'>, IOError(2, 'No such file or directory'), <traceback objec

      t at 0x02C53BC0>) Stacktrace: <traceback object at 0x02C53BC0>

      MainThread - 2017-03-23 04:38:02 - [ERROR] - validate_conf - An exception was ra

      ised loading the config file .\config\vizalerts.yaml: (<type 'exceptions.IOError

      '>, IOError(2, 'No such file or directory'), <traceback object at 0x02C53BC0>) S

      tacktrace: <traceback object at 0x02C53BC0>

      MainThread - 2017-03-23 04:38:02 - [ERROR] - <module> - An unhandled exception o

      ccurred: Traceback (most recent call last):

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

          main()

        File "E:\VizAlerts\vizalerts.py", line 84, in main

          config.validate_conf(configfile)

        File "E:\VizAlerts\vizalert\config.py", line 70, in validate_conf

          sys.exit(1)

      SystemExit: 1

      Traceback (most recent call last):

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

          main()

        File "E:\VizAlerts\vizalerts.py", line 84, in main

          config.validate_conf(configfile)

        File "E:\VizAlerts\vizalert\config.py", line 70, in validate_conf

          sys.exit(1)

      SystemExit: 1

       

      i am from Bangalore .. would be great to hear from you at the earliest..

       

      you can reach me at 8978000946

        • 1. Re: VizAlerts failing
          Jonathan Drummey

          Hi Prashanth,

           

          It appears that the error message is that the VizAlerts can't find the .config\vizalerts.yaml file. When you edited the vizalerts.yaml file as described in the installation guide did you change the filename or extension at all?

           

          Also, a couple of forums notes:

           

          1) Please don't make multiple posts with the same question, that can result of overlap and confusion.

          2) Most everyone who answers questions on the forums is a volunteer so we are answering questions when we can. The forums are not a tech support line with guaranteed response times.

          3) #2 especially applies to VizAlerts which is a community-developed piece of software. If you are in need of specific support beyond what you can get here on the forums you could potentially arrange with my company (DataBlick) or with Tableau professional services (I'm naming two organizations that I know have done paid support for VizAlerts).

           

          Jonathan

          • 2. Re: VizAlerts failing
            Toby Erkson

            Also, questions asked here are expected to be answered here, not off-site privately through email or phone.  This allows others who may have the same issue to follow along and possibly fix it.  It allows input from other people, too, so asking others to contact you outside of the forums really doesn't help, so I would recommend removing your phone number...plus by posting it you allow spammers another way to contact you and that's never fun

             

            Because VizAlerts is not supported there isn't the option to contact Tableau Support.  Reading the documentation and asking questions here is your best free method of getting help.

            • 3. Re: VizAlerts failing
              Toby Erkson

              Prashanth Badugu wrote:

               

              ...below is the error msg  when i running the python script..

               

              E:\>VizAlerts\vizalerts.py

              MainThread - 2017-03-23 04:38:02 - [INFO] - LoggerQuickSetup - Logging initializ

              ed, writing to .\logs\vizalerts.log_2017-03-23.log

              MainThread - 2017-03-23 04:38:02 - [INFO] - main - VizAlerts v2.0.1 is starting

              An exception was raised loading the config file .\config\vizalerts.yaml: (<type

              'exceptions.IOError'>, IOError(2, 'No such file or directory'), <traceback objec

              t at 0x02C53BC0>) Stacktrace: <traceback object at 0x02C53BC0>

              MainThread - 2017-03-23 04:38:02 - [ERROR] - validate_conf - An exception was ra

              ised loading the config file .\config\vizalerts.yaml: (<type 'exceptions.IOError

              '>, IOError(2, 'No such file or directory'), <traceback object at 0x02C53BC0>) S

              tacktrace: <traceback object at 0x02C53BC0>...

              I'm guessing from the error message that the configuration file cannot be found.  Does your VizAlerts 2.0 file structure look like this?

              • 4. Re: VizAlerts failing
                Prashanth Badugu

                Hi Toby Erkson

                 

                thanks for you time and reply .. i see on our folder structure looks like this

                 

                • 5. Re: VizAlerts failing
                  Jonathan Drummey

                  Hi Prashanth,

                   

                  Thanks for the screenshot. I can tell from the screenshot that you've got file extensions turned off, can you use the View menu and make sure that you've got file extensions displayed (as in the screenshot below) and verify that vizalerts.yaml actually has just that as a file name and not something tacked on the end?

                   

                  Screen Shot 2017-03-23 at 12.13.40 PM.png

                   

                  Jonathan

                  • 6. Re: VizAlerts failing
                    Prashanth Badugu

                    Hi Jonathan

                     

                    thanks for you response ..

                     

                    i did check on the  folder and had updated the folder options as mentioned above ..

                     

                     

                     

                     

                     

                     

                     

                     

                    below is the YAML file ..

                     

                    # Local paths settings

                    log.dir: ".\\logs\\"                            # folder write dump log files to. Will be created if it does not exist.

                    log.dir.file_retention_seconds: 432000          # retain log files for default of 5 days

                    log.level: DEBUG                                # level of log verbosity

                    schedule.state.dir: ".\\ops\\"                  # file written to keep the last run state for schedules

                    temp.dir: ".\\temp\\"                           # folder to write temporary files to (csv, png for viz exports). Will be created if it does not exist.

                    temp.dir.file_retention_seconds: 86400          # retain temp files for default of 24 hours, mostly for debugging

                     

                     

                    # Email settings

                    smtp.serv: temailhost.tycoelectronics.net       # name of the smtp mail server (change for production use; default is only set to "localhost" for ease of testing with PaperCut: https://papercut.codeplex.com/)

                    smtp.port: 25                                   # port to user for SMTP server (default is 25)

                    smtp.address.from: Tabserver-Dev-VizAlerts_DoNotReply@xx.com   # default sender for all alerts mail

                    smtp.address.to: bitableauplatformsupport@txxx.com     # email address of admin to send failures to

                     

                     

                    smtp.subject: 'ALERT: VizAlerts failed to execute properly'  # subject line in exception emails sent to admin

                    smtp.ssl: false                                 # use encryption when connecting to SMTP server

                    smtp.user: null                                 # username for account used to connect to SMTP server (null for no authentication)

                    smtp.password: null                             # password for account used to connect to SMTP server (null for no authentication)

                                                                    # This can either be a plaintext password enclosed in single quotes, e.g. 'myp@ssw0rd'

                                                                    # OR it can be a valid path to a .txt file containing the password, e.g. 'c:\users\mcoles\password.txt'

                    # Tableau Server settings

                    server: insights-dev.connect.xx.com             # the Tableau Server instance your alerts will reside on. Recommend using the fully-qualified name, e.g. 'myserver.mydomain.com'

                    server.version: 10                              # the major version of Tableau Server that this is running against (just ensures correct URLs in email footers)

                    server.user: xxx1S0156                           # this is ANY user licensed in Tableau Server--it does not need to be an Admin. It must have access to download summary data from vizalerts.source.viz

                    server.user.domain: xxxxxxxx             # the domain for the server.user account.

                                                                    # Leave as null (no quotes) if Tableau Server uses local authentication

                                                                    # Set to the domain if using AD authentication, e.g. 'mycompany.com'

                    vizalerts.source.viz: 'VizAlertsConfig/ScheduledTriggerViews'     # Viz to pull list of alerts from. Must be of the form 'WorkbookURL/ViewUrl'

                    vizalerts.source.site: 'VizAlerts'              # Site that the vizalerts.source.viz exists within. Leave as 'Default' if using the default site.

                     

                     

                    # Security settings

                    server.ssl: true                                # use HTTPS for Server connections (recommended, but left off by default for testing)

                    server.certcheck: true                          # if using HTTPS, validate the certificate (recommended, but left off by default for testing)

                                                                       # If you turn this on you MUST specify a certificate bundle in server.certfile

                    server.certfile: E:\\Tableau\\Tableau Server\\SSL\\insights-dev_ssl.pem      # Full path to the set of trusted CA certificates to verify your SSL certificate on Tableau Server in .pem format

                                                                        # example: 'c:\\certificates\\cacert.pem'

                    trusted.useclientip: false                      # use clientip for trusted tickets verification

                                                                        # This is optional. Please see http://onlinehelp.tableausoftware.com/current/server/en-us/trusted_auth_optional.htm

                    trusted.clientip: null                          # IP address of THIS host. Only needed if trusted.useclientip is set to true. Otherwise, just leave it null.

                     

                     

                    # SMS Settings

                    smsaction.enable: false                         # use these settings to enable SMS messages. If false, we won't even check them, and all SMS attempts will fail

                    smsaction.provider: twilio                      # the only allowed provider currently is twilio

                    smsaction.account_id: ''                        # account ID, for Twilio this is the account SID from http://twilio.com/user/account

                    smsaction.auth_token: ''                        # auth token, for Twilio http://twilio.com/user/account

                                                                        # This can either be a plaintext password enclosed in quotes, e.g. 'eyJ0eXAiOiJKV1QiLCJhbGciO...'

                                                                        # OR it can be a valid path to a .txt file containing the auth token, e.g. 'c:\users\mcoles\authtoken.txt'

                     

                     

                    # Processing settings

                    threads: 2                                      # Number of threads VizAlerts will use to process alerts

                                                                         # Higher = More alerts process at once, increased server load

                                                                         # Lower = Fewer alerts processed at once, decreased server load

                                                                         # Content references within a single alert are processed serially

                     

                     

                    data.coldelimiter: ','                          # Character used to separate field values in CSV files exported from Tableau Server

                                                                         # Some regions use semicolons for this, in which case switch it to ';'

                    • 7. Re: VizAlerts failing
                      Matt Coles

                      Thanks for sharing our community etiquette, Jonathan and Toby!

                       

                      Prashanth Badugu, you will need to run VizAlerts in the context of the directory your .py script is in:

                       

                       

                      E:\>cd E:\VizAlerts

                      E:\VizAlerts> python .\vizalerts.py

                       

                      The reason it is failing is because it is looking for the config file in .\config\vizalerts.yaml, one level under the path you are running it from, not the path that vizalerts.py lives in. So just change where you run it from and it should fix it.

                      • 8. Re: VizAlerts failing
                        Toby Erkson

                        Prashanth Badugu, did you get this to work?  If so, was it Matt's answer or was it by some other method?

                        • 9. Re: VizAlerts failing
                          Prashanth Badugu

                          Hi

                           

                          The issues isn't fixed yet .. we are getting an error with -1

                           

                          the error msg  :Error
                          msg: MainThread - 2017-04-04 00:47:22 - [ERROR] - get_trusted_ticket -
                          UserWarning generating trusted ticket: Error generating trusted ticket

                           

                          not sure why

                           

                          Postdata: username=oelectronics%5Cxx1S0156&amp;target_site=VizAlerts.

                           

                          We should be able to pass only the xx1S0156  but in our case we are
                          passing 5Cxx1S0156

                           

                          am I missing something in the config ??

                           

                           

                          • 10. Re: VizAlerts failing
                            Matt Coles

                            That actually does mean that the previous issue was fixed, but now you have a new issue. The solution can be found here.