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.

Summary

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.

  1. New modular look for delivery setting.
  2. Timeout options for Alert action such as BTEQ scripts, Run a Program and SQL Queries.
  3. New display name option when sending an e-mail.
  4. If needed, SMTP configuration can now be cleared or disabled.
  5. Big Numbers support for Alert Viewer portlet.

Features Details:

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.

 Figure 1

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.

Figure 2

For easy identification of e-mails a new display name option has been added (See Figure 3).

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).

Figure 4

Finally, please refer the associated Alert Configuration Guide for full details of the upgrade process and User Guide for all new feature details.

Hope these new additions and improvements in Alerting mechanisms are helpful to you. We always look forward to your thoughts and comments.

Discussion
sridharsj 3 comments Joined 03/13
11 Mar 2015

Will I be able to get mobile alerts, please guide me with neccessary docs etc. Thanks in Advance

Shrity 52 comments Joined 05/12
12 Mar 2015

Can you clarify what do you mean by mobile Alerts. As of today you can send an e-mail, SNMP trap and run programs.

sridharsj 3 comments Joined 03/13
12 Mar 2015

For e.g. if any node failures, it needs to notify the DBAs by mobile messaging SMS etc

monoranjan 5 comments Joined 09/13
24 Mar 2015

Hi Shrity
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.
 

Thanks,
Monoranjan

Shrity 52 comments Joined 05/12
24 Mar 2015

Hi Monoranjan,
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.
Thanks
Shrity 

monoranjan 5 comments Joined 09/13
24 Mar 2015

Hi Shrity,
Thanks for the update.
The macro will generate ALTER Table stament for Fallback tables to No-Fallback.

Thanks,
Monoranjan

monoranjan 5 comments Joined 09/13
26 Mar 2015

Hi Shrity,
 
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.

Thanks,
Monoranjan

Shrity 52 comments Joined 05/12
26 Mar 2015

Hi Manoranjan,
 
Not sure if I can say anything without looking at your system. Check your login credentials, if not you can open GSC ticket.
 
Thanks
Shrity 

geethareddy 129 comments Joined 10/11
1 month ago

Hi Manoranjan,
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.

Thanks,
Geeta

geethareddy 129 comments Joined 10/11
1 month ago

Hi Shrity,
 
Thanks for the informative article.
I just wanted to know if the limitation with the email id field (while creating the user id from UserManager), it only takes 48 characters in 14.10.xx.xx versions. is this lifted in 15.10?
 
 

Thanks,
Geeta

Shrity 52 comments Joined 05/12
1 month ago

Hi Geetha,
Yes, the limitation no longer exists.
Thanks
Shrity

geethareddy 129 comments Joined 10/11
1 month ago

Good to know that. Thank you.

Thanks,
Geeta

You must sign in to leave a comment.