Error while defining new 'Teradata Accounts' in Viewpoint

Viewpoint

Error while defining new 'Teradata Accounts' in Viewpoint

Gurus,

I happen to install Teradata viewpoint 14.00 ( went smothly), but when i tried to a new system for monitor   ( Admin --> Teradata Systems    or Profile--> Teradata Account)

page gets struct and nothing happens  , and below is the error details that i see (tomcat window)... I understand that we need to define Teradata Server details at some place, but not able to figure out where ?

Any help would be great,

 [SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in com/teradata/dcs/config/model/postgresql/System-PostgreSQL.xml.

--- The error occurred while applying a parameter map.

--- Check the GetSystemsByType-InlineParameterMap.

--- Check the statement (query failed).

--- Cause: org.postgresql.util.PSQLException: ERROR: relation "config.systems" does not exist]

Regards

Balu

11 REPLIES
Teradata Employee

Re: Error while defining new 'Teradata Accounts' in Viewpoint

Did you follow the instructions in the Teradata Viewpoint 14.0 Configuration Guide to ensure all the right permissions and enabling steps were completed?

Re: Error while defining new 'Teradata Accounts' in Viewpoint

Yep, double checked on permission, but still the same error.   Not sure if   '"config.systems'  is file and should exit as i don;t see it.

 Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:

-- The error occurred in com/teradata/dcs/config/model/postgresql/System-PostgreSQL.xml.

-- The error occurred while applying a parameter map.

-- Check the GetSystemsByType-InlineParameterMap.

-- Check the statement (query failed).

-- Cause: org.postgresql.util.PSQLException: ERROR: relation "config.systems" does not exist

       at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) 

Teradata Employee

Re: Error while defining new 'Teradata Accounts' in Viewpoint

Is this a fresh install of 14.00?  Or was it an upgrade?  Were there any errors reported during the installation of the dcs RPM?

Enthusiast

Re: Error while defining new 'Teradata Accounts' in Viewpoint

Get same error on Windows XP system during startup.bat:

ERROR 16 Mrz 2012 15:57:20,906 [main] [com.teradata.viewpoint.security.globalent
ity.sync.GlobalEntitySynchronizer.synchronize(96)] Exception synchronizing secur
ity framework with DCS!!
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL
grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLExcep
tion:
--- The error occurred in com/teradata/dcs/config/model/postgresql/System-Postgr
eSQL.xml.
--- The error occurred while applying a parameter map.
--- Check the GetSystemsByType-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: org.postgresql.util.PSQLException: ERROR: relation "config.systems" d
oes not exist
Caused by: org.postgresql.util.PSQLException: ERROR: relation "config.systems" d
oes not exist
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/teradata/dcs/config/model/postgresql/System-Postgr
eSQL.xml.
--- The error occurred while applying a parameter map.
--- Check the GetSystemsByType-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: org.postgresql.util.PSQLException: ERROR: relation "config.systems" d
oes not exist
Caused by: org.postgresql.util.PSQLException: ERROR: relation "config.systems" d
oes not exist

It's a fresh installation of pdk 14.00!

I could not finde any ddl hint of config.systems in create-postgresql-teradata.T.sql!
Where should the ddl stored?

@balu: have you solved this issue? How?
dfu
Teradata Employee

Re: Error while defining new 'Teradata Accounts' in Viewpoint

Looks like the "systems" table in the "config" schema is missing.

Step 13 of the 14.00 PDK install guide says:  "Repeat Step 11 and create another schema under dcsdb called config."  Can you verify if you performed that step before running the install?  Thanks.

Enthusiast

Re: Error while defining new 'Teradata Accounts' in Viewpoint

I did a new installation of all components!

I still get the error: Cause: org.postgresql.util.PSQLException: ERROR: relation "config.systems" does not exist

Here my ddls:

-- Database: lportal

-- DROP DATABASE lportal;

CREATE DATABASE lportal
WITH OWNER = viewpoint
ENCODING = 'SQL_ASCII';

-- Database: dcsdb

-- DROP DATABASE dcsdb;

CREATE DATABASE dcsdb
WITH OWNER = viewpoint
ENCODING = 'SQL_ASCII';

-- Database: td_portal

-- DROP DATABASE td_portal;

CREATE DATABASE td_portal
WITH OWNER = viewpoint
ENCODING = 'SQL_ASCII';

-- Database: td_portlets

-- DROP DATABASE td_portlets;

CREATE DATABASE td_portlets
WITH OWNER = viewpoint
ENCODING = 'SQL_ASCII';

-- Database: cam

-- DROP DATABASE cam;

CREATE DATABASE cam
WITH OWNER = cam
ENCODING = 'SQL_ASCII';

-- Schema: "tasm"

-- DROP SCHEMA tasm;

CREATE SCHEMA tasm
AUTHORIZATION viewpoint;

-- Schema: "tasmwd"

-- DROP SCHEMA tasmwd;

CREATE SCHEMA tasmwd
AUTHORIZATION viewpoint;

-- Schema: "config"

-- DROP SCHEMA config;

CREATE SCHEMA config
AUTHORIZATION viewpoint;

-- Schema: "config"

-- DROP SCHEMA config;

CREATE SCHEMA config
AUTHORIZATION cam;

From my point of view all neccessary steps were done in the correct order!
I'm using postgresql-8.3.18-1 is this postgress version recoommended?
dfu
Teradata Employee

Re: Error while defining new 'Teradata Accounts' in Viewpoint

Can you confirm for me that you have the Config Schema created under "dcsdb" database?  

There are 2 Config schemas that need to be created, one under the "dcsdb" database with owner "viewpoint", the other is under the "Cam" database with owner "cam".

Postgres 8.3.18 should be fine.

Enthusiast

Re: Error while defining new 'Teradata Accounts' in Viewpoint

Yes, 2 config schemas!
one under "dcsdb" -> owner "viewpoint"
one under "cam" -> owner "cam"

Found the following warning:

WARN 20 Mrz 2012 09:52:22,983 [main] [com.teradata.viewpoint.security.config.JaxbXmlConfigParser.parse(174)] Schema validation failed for V
iewpoint configuration file. cvc-complex-type.2.4.a: Invalid content was found starting with element 'supported-locale'. One of '{"http://schemas.teradata.com/viewpoint/v2010":resource-bundle, "http://schemas.teradata.com/viewpoint/v2010":domain}' is expected.

dfu
Teradata Employee

Re: Error while defining new 'Teradata Accounts' in Viewpoint

You can ignore that warning above.  Are you still getting the "ERROR: relation "config.systems" does not exist" error during install?