This article describes what's new in the Teradata Alerts 14.10 release (also known internally as CAM). This release was made available on May 30th 2013.
The Teradata Alerts 14.10 release restructures the alert delivery type in the Viewpoint "Admin" -> "Alert Setup" portlet to make it more modular and introduces a new timeout setting feature for various delivery types. The remainder of this article provides feature details for all the highlights of the Teradata Alerts 14.10 release.
The Delivery settings layout in the Alert Setup portlet has been restructured. The BTEQ/SQL Login configuration has moved to the new Authentication area and renamed Teradata Login (See Fig 1). A new Notification Service area can be used to easily identify user defined scripts and programs running on notification server.
Users now have an option to terminate or get notified if a program or script runs more than an anticipated amount of time. In Alert Setup portlet, the user can select the Notify option when setting up the delivery types for SQL Queries or when setting up Notification service such as BTEQ Scripts or Programs and get notified for a long running/hung scripts or programs. Users can also choose to terminate a hung program or a script immediately or after certain period of time using Terminate option (See Figure 2). In the delivery type setting Notify and Terminate options are available for SQL Queries delivery type. See below.
For easy identification of e-mails a new display name option has been added (See Figure 3).
Delivery Types can now be enabled or disabled. For Example, an administrator can now disable an already configured SNMP delivery type. For easy identification of disabled Delivery Types, while setting up the Action Sets, the Delivery Types are displayed in red and if scripts are disabled they are indicated as disabled (See Figure 4).
Hope these new additions and improvements in Alerting mechanisms are helpful to you. We always look forward to your thoughts and comments.
Can you clarify what do you mean by mobile Alerts. As of today you can send an e-mail, SNMP trap and run programs.
I am trying to execute a Macro in the SQL tab (Delivery Settings>SQL Queries>SQL ).
The macro is selecting some table information and generating ALTER TABLE statements, can you guide me how can i get ALTER SQL statements through mail.
can you please tell us how can we check Teradata Notification Service is installed and Running on the server.
While creating action set add multiple action (Alert preset -> Action set -> Action) select e-mail as well as SQL. However, not sure what is the purpose of ALTER TABLE statement. you can always write Alter statement in the message box with Alert properties.
Teradata Notification Service will have to be installed on Windows/Linux server other than Viewpoint server.
I am getting below error while trying to create new login setup, but earlier i was able to create the login setup with the same user.
Teradata logon test caught exception: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException:
could you please guide me on the error.
Not sure if I can say anything without looking at your system. Check your login credentials, if not you can open GSC ticket.
I saw the issue when the system was is busy. But apart from the credentails are wrong fo the ID that you are using, it is also possible to see this error if there are any potential network issues due to which the Viewpoint server could not able to connect OR if the Database is too busy to accept the new connections. I suggest to submit an incident to GSC.