This tutorial steps through the process to install the Teradata Viewpoint Development Portal, a cut-down version of Viewpoint, on your local desktop machine. These instructions are specifically for Windows, though the PDK has been validated to work on Mac OS X, Linux, and Solaris.

Step 1: Install Prerequisite Software

Java 1.5 SDK

Download and install "Java 2 Platform, Standard Edition 5.0". You'll want the JDK 5.0 without the NetBeans IDE or the Java EE. After installing the Java SDK, add a JAVA_HOME environment variable that points to the installation location of the JDK. Don't forget to add the Java JDK bin directory to the Windows PATH environment variable, as described in the Java installation instructions.

Ant 1.7.x

Download and install Ant. After installation, add Ant's bin directory to your Windows PATH environment variable.

PostgreSQL 8.1.x to 8.3.x

Download PostgreSQL and run the installer.

  1. On the "Service configuration" screen, either choose a secure password or accept the offer to allow the system to replace your weak password with a secure auto-generated one. If you use a weak password, the install will fail later with the inability to create the user.

    • Use the default superuser name of postgres and enter a password. Be sure to remember the password for this superuser!
    • If you want to connect to the database from another system, check the box "Accept connections on all addresses, not just localhost".
    • If there are separate Encoding fields for Server and Client they should both be SQL_ASCII.
    • If you change the PostgreSQL port number, you will need to remember the new port as well.
  2. Uncheck "Launch Stack Builder at exit" on the last install screen.

Step 2: Setting Up the PostgreSQL Database


  1. Under the folder PostgreSQL is installed in, edit data\postgresql.conf:
    • Under QUERY TUNING, set constraint_exclusion = on and remove the "#" from the beginning of the line.
  2. Open a command prompt and navigate to the directory PostgreSQL is installed in, then enter these commands:
    cd bin
    createlang --username=postgres --password=<SERVICE_ACCOUNT_PASSWORD> plpgSQL template1
    Enter the PostgreSQL superuser password when prompted. If you receive a warning that the language plpgSQL already exists, you can ignore it and proceed.
  3. Run "pgAdmin III" from the Start menu under PostgreSQL.
  4. Double-click "PostgreSQL Database Server 8.1 (localhost)" to connect, and enter the superuser password. Replace "8.1" with the version that is installed.
  5. Right-click on Login Roles, and select New Login Role...
  6. Create a role named viewpoint that can create database objects.


    Be sure to remember this password! This is the password that will be used for setting up the Teradata Viewpoint Portal in the following steps.
  7. Repeat Steps 5 and 6 to create another role name cam.  Be sure to remember the password also.
  8. Create a database named lportal with owner viewpoint 
  9. Repeat Step 8 to create databases named dcsdb, td_portal, and td_portlets (all with owner viewpoint).
  10. Repeat Step 8 to create a database named cam, with owner cam.
  11. Create a schema under dcsdb called tasm with owner viewpoint.  You can do this by expanding the tree for dcsdb created in Step 9.  Right click on Schemas and select New Schema.  Enter tasm as the Name and select viewpoint as the Owner.  Click OK to save.
  12. Repeat Step 11 and create another schema under dcsdb called tasmwd.

Step 3: Unzip the Teradata Viewpoint PDK

  1. Download the Teradata Viewpoint PDK.
  2. Unzip the file, creating a folder called tdpdk-xx.xx.xx.xx, where the xx's indicate the version number. The rest of this tutorial assumes that this folder is located at C:\tdpdk-xx.xx.xx.xx, but it can be located elsewhere if desired.

Step 4: Configuring the Teradata Viewpoint Portal 

While configuring the Teradata Viewpoint Portal, you might need to modify JDBC URLs for the PostgreSQL database. If the PostgreSQL database is running on your local machine with the default port(5432), you do not need to make any changes to these URLs.

If the database is running on a separate system, you need to replace "localhost" with the name of the database system. If you are using a custom PostgreSQL port number, replace "5432" with the custom port number.

Important: Do not make any other changes to these URLs.

Edit C:\tdpdk-xx.xx.xx.xx\viewpoint-portal\conf\server.xml

<!-- DCS datasource -->
<Resource name="jdbc/dcs"
  auth="Container"
  driverClass="org.postgresql.Driver"

  jdbcUrl="jdbc:postgresql://localhost:5432/dcsdb"
  user="viewpoint"
  password="TDv1i2e3w4"

  maxPoolSize="100"
  minPoolSize="1"
  acquireIncrement="1"
  maxIdleTime="120"
  factory="org.apache.naming.factory.BeanFactory"
  type="com.mchange.v2.c3p0.ComboPooledDataSource"/>
<!-- TD Portlets datasource -->
<Resource name="jdbc/td_portlets"
  auth="Container"
  driverClass="org.postgresql.Driver"

  jdbcUrl="jdbc:postgresql://localhost:5432/td_portlets"
  user="viewpoint"
  password="TDv1i2e3w4"

  maxPoolSize="100"
  minPoolSize="1"
  acquireIncrement="1"
  maxIdleTime="120"
  factory="org.apache.naming.factory.BeanFactory"
  type="com.mchange.v2.c3p0.ComboPooledDataSource"/>
<!-- TD Portal datasource -->
<Resource name="jdbc/td_portal"
  auth="Container"
  driverClass="org.postgresql.Driver"

  jdbcUrl="jdbc:postgresql://localhost:5432/td_portal"
  user="viewpoint"
  password="TDv1i2e3w4"

  maxPoolSize="100"
  minPoolSize="1"
  acquireIncrement="1"
  maxIdleTime="120"
  factory="org.apache.naming.factory.BeanFactory"
  type="com.mchange.v2.c3p0.ComboPooledDataSource" />
<!-- cam datasource -->
<Resource name="jdbc/cam"
	auth="Container"
	driverClass="org.postgresql.Driver"
	jdbcUrl="jdbc:postgresql://%{activeDatabaseHost}:5432/cam"
	user="cam"
	password="TDc1a2m3"
	maxPoolSize="100"
	minPoolSize="1"
	acquireIncrement="1"
	maxIdleTime="120"
	factory="org.apache.naming.factory.BeanFactory"
	type="com.teradata.viewpoint.cluster.datasource.c3p0.C3p0PromotionAwareDataSource"/>
  1. You need to provide the portal with the database address and port number, and the PostgreSQL username and password you set up earlier.
    <!-- Datasource used by the Liferay portal itself -->
    <Resource name="jdbc/LiferayPool"
      auth="Container"
      driverClass="org.postgresql.Driver"
    
      jdbcUrl="jdbc:postgresql://localhost:5432/lportal"
      user="viewpoint"
      password="TDv1i2e3w4"
    
      maxPoolSize="100"
      minPoolSize="1"
      acquireIncrement="1"
      maxIdleTime="120"
      factory="org.apache.naming.factory.BeanFactory"
      type="com.mchange.v2.c3p0.ComboPooledDataSource"/>
    
  2. Next, configure the datasource for the Data Collection Service. If you want to connect to an existing DCS database, enter the DCS database login details here. Otherwise, make the same changes as above.
  3. You also need to modify the TD Portlets datasource. As before, provide the PostgreSQL system name and port, along with the username and password.
  4. Repeat Step 3 for the TD Portal datasource.
  5. You also need to modify the cam datasource. Make sure the PostgreSQL system name and port, along with the username and password is correct.

Edit the file C:\tdpdk-xx.xx.xx.xx\viewpoint-portal\setup\config\viewpoint.properties

You need to uncomment (remove the # at the beginning of) several lines in viewpoint.properties. viewpoint.db.host and viewpoint.db.port only need to be uncommented if the database is not on your local system or if you're using a custom port for the database. viewpoint.db.username and viewpoint.db.password should be uncommented and modified to contain your PostgreSQL username and password.

viewpoint.db.host=localhost
viewpoint.db.port=5432

#lportal.db.name=lportal
#tdportal.db.name=td_portal
#tdportlets.db.name=td_portlets
#dcs.db.name=dcsdb

viewpoint.db.username=viewpoint
viewpoint.db.password=TDv1i2e3w4

Step 5: Running the Viewpoint setup script

C:
cd \tdpdk-xx.xx.xx.xx\viewpoint-portal\setup\bin
setup.bat
  1. Create an environment variable CATALINA_HOME that points to the path for the Teradata Viewpoint Portal (C:\tdpdk-xx.xx.xx.xx\viewpoint-portal).
  2. Open a command prompt and execute the following commands:

Step 6: Start Viewpoint

C:
cd \tdpdk-xx.xx.xx.xx\viewpoint-portal\bin
startup.bat
  1. To start Viewpoint, open a command prompt and execute the following commands:
  2. Allow the Viewpoint to start up fully (log output completes) before continuing on to the next step.

Step 7: Login to Viewpoint

  1. Start a web browser and connect to the portal using a URL as follows:
    • If you're accessing the portal from the system it's installed on with the default settings, the portal URL is http://localhost:8080.
    • If the Teradata Viewpoint Portal server is not running on your local machine, or if you've modified the port number, the URL is always in the form http://machinename:portnumber (replace machinename with the machine name and portnumber with the port number).
  2. Log in to the portal using username "admin" with the default password "teradata"(without the quotation marks).
  3. It is recommended that you change this password after logging in by clicking on Profile in the top right of the screen.

Troubleshooting

  • If your Viewpoint Portal does not start up, please go back through each of the steps to ensure you haven't missed anything.
  • Make sure you have the correct versions of Java, Ant, and Postgres installed.
  • Check the viewpoint.log or the output from the command window to see if there are any errors.  Search the Teradata Developer Exchange Viewpoint forums for any resolutions to the problems.
  • If you have any additional questions or comments, please post them on the Teradata Developer Exchange Viewpoint forums.

 

Discussion
Douglas 2 comments Joined 06/10
13 Jul 2010

I was unable to find the PDK for 13.03 on the link above. The only ones listed were 13.01 and 13.02, if 13.03's PDK is unavailable can you give me an expected release date on it.

dfu 14 comments Joined 09/09
13 Jul 2010

The 13.03 PDK will be released this week.

Douglas 2 comments Joined 06/10
14 Jul 2010

I have just installed the new version 13.03 but the skewed sessions portlet does not work. The tomcat error log says this

Caused by: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/teradata/dcs/data/model/postgresql/SystemStatistics-PostgreSQL.xml.
--- The error occurred while applying a result map.
--- Check the SystemStatistics.SystemStatisticsResultMap.
--- Check the result mapping for the 'upAmpCount' property.
--- Cause: org.postgresql.util.PSQLException: The column name upAmpCount was not found in this ResultSet.
Caused by: org.postgresql.util.PSQLException: The column name upAmpCount was not found in this ResultSet.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:107)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
at com.teradata.dcs.data.dao.ibatis.AbstractDataDAOiBatis$CustomSQLExceptionTranslator.translate(AbstractDataDAOiBatis.java:271)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:196)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:241)
at com.teradata.dcs.data.dao.ibatis.SystemStatisticsDAOiBatis.getCurrentSystemStatistics(SystemStatisticsDAOiBatis.java:84)
at com.teradata.portlets.skewedsessions.service.impl.SkewedSessionsManagerImpl.getCurrentSkewedSessions(SkewedSessionsManagerImpl.java:90)
at com.teradata.portlets.skewedsessions.controllers.SkewedSessionsViewController.summary(SkewedSessionsViewController.java:76)
... 93 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/teradata/dcs/data/model/postgresql/SystemStatistics-PostgreSQL.xml.
--- The error occurred while applying a result map.
--- Check the SystemStatistics.SystemStatisticsResultMap.
--- Check the result mapping for the 'upAmpCount' property.
--- Cause: org.postgresql.util.PSQLException: The column name upAmpCount was not found in this ResultSet.
Caused by: org.postgresql.util.PSQLException: The column name upAmpCount was not found in this ResultSet.

ERROR 14 Jul 2010 11:23:47,429 [http-8080-Processor24] [com.liferay.portal.log.CommonsLogImpl.error(52)] org.postgresql.util.PSQLException: The column name upAmpCount was not found in this ResultSet.

could you point me in the right direction as to what this might mean all the tables and columns are fine in the dcsdb. Also the skewed sessions portlet works on the 13.02 installation that i have.

dfu 14 comments Joined 09/09
15 Jul 2010

The upAmpcount column was added in the 13.03 version. Make sure your Skewed Sessions Portlet was built for 13.03.

ct185020 3 comments Joined 05/09
26 Oct 2010

Hi,

I installed this package successfully on my desktop. Now I am trying to install this package on Linux-64bit but facing following error.
Is this package compatible with Linux-64-bit?? Has anyone came across such errors during installation??
***********************************************************************
Caused by: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/teradata/viewpoint/security/model/postgresql/portlet-sqlmap-config.xml.
--- The error occurred while applying a parameter map.
--- Check the unregisterAllPortlets-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: org.postgresql.util.PSQLException: ERROR: relation "portlet_registry" does not exist
Caused by: org.postgresql.util.PSQLException: ERROR: relation "portlet_registry" does not exist

***********************************************************************

Regards,
Chhaya.

ct185020 3 comments Joined 05/09
26 Oct 2010

Never Mind. I got my mistake. It is working with SUSE Linux 10 64bit very well.

Thanks,
Chhaya.

mnylin 2 comments Joined 12/09
11 Feb 2011

I followed the instructions indicated above to install the PDK on an installation of openSuse 11.3 32bit. Everything went smoothly down to the point where I ran setup.sh. I received the following stack trace output from setup.sh:

Exception in thread "main" java.lang.reflect.InvocationTargetException
at java.lang.reflect.Method.invoke(libgcj.so.11)
at com.teradata.commons.bootstrap.Bootstrap.main(Bootstrap.java:166)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tdPortalSqlMapClient' defined in class path resource [com/teradata/viewpoint/setup/applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: gnu.xml.dom.ls.DomLSException: element content (typeAlias*|cacheModel*124resultMap*124parameterMap*124sql*124statement*124insert*124update*124delete*124select*124procedure*)+ does not match expression ((typeAlias )*|(cacheModel )*|(resultMap )*|(parameterMap )*|(sql )*|(statement )*|(insert )*|(update )*|(delete )*|(select )*|(procedure )*)+: "select select select select select insert delete update statement "
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1032)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348)
at org.springframework.context.support.ClassPathXmlApplicationContext.(ClassPathXmlApplicationContext.java:92)
at org.springframework.context.support.ClassPathXmlApplicationContext.(ClassPathXmlApplicationContext.java:77)
at org.springframework.context.support.ClassPathXmlApplicationContext.(ClassPathXmlApplicationContext.java:68)
at com.teradata.viewpoint.setup.ViewpointSetup.execute(ViewpointSetup.java:133)
at com.teradata.viewpoint.setup.ViewpointSetup.main(ViewpointSetup.java:157)
at java.lang.reflect.Method.invoke(libgcj.so.11)
...1 more
Caused by: java.lang.RuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: gnu.xml.dom.ls.DomLSException: element content (typeAlias*|cacheModel*124resultMap*124parameterMap*124sql*124statement*124insert*124update*124delete*124select*124procedure*)+ does not match expression ((typeAlias )*|(cacheModel )*|(resultMap )*|(parameterMap )*|(sql )*|(statement )*|(insert )*|(update )*|(delete )*|(select )*|(procedure )*)+: "select select select select select insert delete update statement "
at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:84)
at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:62)
at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:255)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029)
...14 more
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: gnu.xml.dom.ls.DomLSException: element content (typeAlias*|cacheModel*124resultMap*124parameterMap*124sql*124statement*124insert*124update*124delete*124select*124procedure*)+ does not match expression ((typeAlias )*|(cacheModel )*|(resultMap )*|(parameterMap )*|(sql )*|(statement )*|(insert )*|(update )*|(delete )*|(select )*|(procedure )*)+: "select select select select select insert delete update statement "
at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:52)
at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:81)
...18 more
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: gnu.xml.dom.ls.DomLSException: element content (typeAlias*|cacheModel*124resultMap*124parameterMap*124sql*124statement*124insert*124update*124delete*124select*124procedure*)+ does not match expression ((typeAlias )*|(cacheModel )*|(resultMap )*|(parameterMap )*|(sql )*|(statement )*|(insert )*|(update )*|(delete )*|(select )*|(procedure )*)+: "select select select select select insert delete update statement "
at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:113)
at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:74)
at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:92)
at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)
at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:50)
...19 more
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: gnu.xml.dom.ls.DomLSException: element content (typeAlias*|cacheModel*124resultMap*124parameterMap*124sql*124statement*124insert*124update*124delete*124select*124procedure*)+ does not match expression ((typeAlias )*|(cacheModel )*|(resultMap )*|(parameterMap )*|(sql )*|(statement )*|(insert )*|(update )*|(delete )*|(select )*|(procedure )*)+: "select select select select select insert delete update statement "
at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:52)
at com.ibatis.sqlmap.engine.builder.xml.SqlMapParser.parse(SqlMapParser.java:50)
at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:364)
at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:111)
...23 more
Caused by: gnu.xml.dom.ls.DomLSException: element content (typeAlias*|cacheModel*124resultMap*124parameterMap*124sql*124statement*124insert*124update*124delete*124select*124procedure*)+ does not match expression ((typeAlias )*|(cacheModel )*|(resultMap )*|(parameterMap )*|(sql )*|(statement )*|(insert )*|(update )*|(delete )*|(select )*|(procedure )*)+: "select select select select select insert delete update statement "
at gnu.xml.dom.ls.DomLSParser.doParse(libgcj.so.11)
at gnu.xml.dom.ls.DomLSParser.parse(libgcj.so.11)
at gnu.xml.dom.DomDocumentBuilder.parse(libgcj.so.11)
at com.ibatis.common.xml.NodeletParser.createDocument(NodeletParser.java:147)
at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:49)
...26 more
Caused by: org.xml.sax.SAXParseException: element content (typeAlias*|cacheModel*124resultMap*124parameterMap*124sql*124statement*124insert*124update*124delete*124select*124procedure*)+ does not match expression ((typeAlias )*|(cacheModel )*|(resultMap )*|(parameterMap )*|(sql )*|(statement )*|(insert )*|(update )*|(delete )*|(select )*|(procedure )*)+: "select select select select select insert delete update statement "
at gnu.xml.stream.SAXParser.parse(libgcj.so.11)
at gnu.xml.dom.ls.DomLSParser.doParse(libgcj.so.11)
...30 more
Caused by: javax.xml.stream.XMLStreamException: element content (typeAlias*|cacheModel*124resultMap*124parameterMap*124sql*124statement*124insert*124update*124delete*124select*124procedure*)+ does not match expression ((typeAlias )*|(cacheModel )*|(resultMap )*|(parameterMap )*|(sql )*|(statement )*|(insert )*|(update )*|(delete )*|(select )*|(procedure )*)+: "select select select select select insert delete update statement "
at gnu.xml.stream.XMLParser.error(libgcj.so.11)
at gnu.xml.stream.XMLParser.validateElementContent(libgcj.so.11)
at gnu.xml.stream.XMLParser.validateEndElement(libgcj.so.11)
at gnu.xml.stream.XMLParser.endElementValidationHook(libgcj.so.11)
at gnu.xml.stream.XMLParser.readEndElement(libgcj.so.11)
at gnu.xml.stream.XMLParser.next(libgcj.so.11)
at gnu.xml.stream.SAXParser.parse(libgcj.so.11)
...31 more

Am I missing something? I'm running java 1.5.0, ant 1.7.1, and PostgreSQL 8.3. All of my configuration files should be set up correctly and I've set the JAVA_HOME and CATALINA_HOME environment variables. I've even re-copied the PDK from the zip file and re-edited the configuration files.

Thanks.

dfu 14 comments Joined 09/09
11 Feb 2011

Make sure you are running either the Sun or IBM version of Java 1.5. Looks like it's trying to use the GNU XML parser which is not supported.

25 Feb 2011

Can you please help...Got stuck at STEP 5 ( while running setup.bat)

C:\tdpdk\tdpdk-13.03.00.05\viewpoint-portal\setup\bin>cd ..

C:\tdpdk\tdpdk-13.03.00.05\viewpoint-portal\setup>C:\"Program Files"\Java\jdk1.5
.0_22\bin\java -Dbootstrap.class=com.teradata.viewpoint.setup.ViewpointSetup -Db
ootstrap.classpath=lib -jar lib/tdcommons-bootstrap.jar
Setting up Viewpoint databases.
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.teradata.commons.bootstrap.Bootstrap.main(Bootstrap.java:166)
Caused by: org.springframework.transaction.CannotCreateTransactionException: Cou
ld not open JDBC Connection for transaction; nested exception is org.postgresql.
util.PSQLException: FATAL: password authentication failed for user "viewpoint"
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBe
gin(DataSourceTransactionManager.java:219)
at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:315)
at com.teradata.viewpoint.setup.DatabaseSetup.begin(DatabaseSetup.java:9
9)
at com.teradata.viewpoint.setup.ViewpointSetup.setup(ViewpointSetup.java
:88)
at com.teradata.viewpoint.setup.ViewpointSetup.execute(ViewpointSetup.ja
va:139)
at com.teradata.viewpoint.setup.ViewpointSetup.main(ViewpointSetup.java:
157)
... 5 more
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication fai
led for user "viewpoint"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(Connect
ionFactoryImpl.java:275)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne
ctionFactoryImpl.java:94)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor
y.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Conn
ection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Conn
ection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:382)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec
tionFromDriverManager(DriverManagerDataSource.java:291)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec
tionFromDriverManager(DriverManagerDataSource.java:277)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec
tionFromDriverManager(DriverManagerDataSource.java:259)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec
tion(DriverManagerDataSource.java:240)
at com.teradata.viewpoint.cluster.datasource.PromotionAwareDataSource.ge
tConnection(PromotionAwareDataSource.java:186)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBe
gin(DataSourceTransactionManager.java:182)
... 10 more

dfu 14 comments Joined 09/09
28 Feb 2011

Looks like your "viewpoint" database user password is incorrect: "FATAL: password authentication failed for user "viewpoint""

Laughner 3 comments Joined 11/11
25 Feb 2012

I have same issue with an incorrect viewpoint user password installing Viewpoint 14.00.00.00. What should the database password be for viewpoint?

Thanks

ramubindu 10 comments Joined 06/08
26 Feb 2012

Hi

i have installed teradata demo version 13.00 in my persal PC. it is working fine and i am to install Viewpoint PDK 14.00 in pernal PC i want to work on viewpoint 14.00 in pernal PC so can i able to install Viewpoint PDK 14.00 in pernal PC

could you please help me what software are required if i want to install in persal PC

Laughner 3 comments Joined 11/11
27 Feb 2012

I installed 14.00.00.00 but thought it would be the full version for experimentation. But it appears to only be base version without many portlets.

Thanks

ramubindu 10 comments Joined 06/08
27 Feb 2012

Hi Laughner,

did you install your persanal PC? if you say yes could you please provide the Guideline to me so that i will install in my persanal PC

ramubindu 10 comments Joined 06/08
28 Feb 2012

I have installed Viewpoint my persanal Windows XP PC.
Java - JDK 1.6.0_11
Ant - 1.8.0
Postgres - 8.3 - installed on the local machine on default port.

i am not bale to run viewpoing could you please help me how to run viewpoint

ramubindu 10 comments Joined 06/08
28 Feb 2012

while I'm running java 1.5.0, ant 1.8.0, and PostgreSQL 8.3 . i got message like missing All of configuration files where i need to set those the JAVA_HOME and CATALINA_HOME environment variables.

Laughner 3 comments Joined 11/11
29 Feb 2012

JAVA_HOME must point to your Java JDK directory where you installed Java. CATALINA_HOME should point to the directory path where you installed Viewpoint PDK and specificallcally the viewpoint-portal folder. Mine points to this path. C:\tdpdk-14.00.00.00\tdpdk-14.00.00.00\viewpoint-portal

If running Windows 7, right-click Computer, Properties, Adavanced System Settings, Environment Variables, New and add as a system variable. Note any command line windows will need to be closed and restarted after entering new variables.
\

Thanks

dfu 14 comments Joined 09/09
29 Feb 2012

Make sure you are using Java 1.5, Ant 1.7.x, and Postgres 8.1 or 8.3. If you are using Java 1.6 and Ant 1.8 you will run into problems.

ScottWoodrow22 1 comment Joined 04/13
30 May 2013

I installed 1.6 first on accident, and now have uninstalled and replaced with 1.5.11. Now my tomcat window blinks and closes. Any advice?

You must sign in to leave a comment.