All Forums Viewpoint
28 Dec 2011
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

gryback 271 posts Joined 12/08
28 Dec 2011

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

29 Dec 2011

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) 

stever 149 posts Joined 08/09
05 Jan 2012

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?

Yvonne 7 posts Joined 07/09
16 Mar 2012

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 22 posts Joined 09/09
16 Mar 2012

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.

Yvonne 7 posts Joined 07/09
19 Mar 2012

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 22 posts Joined 09/09
19 Mar 2012

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.

Yvonne 7 posts Joined 07/09
20 Mar 2012

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 22 posts Joined 09/09
20 Mar 2012

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

Yvonne 7 posts Joined 07/09
21 Mar 2012

Yes, error still occurs:

ERROR 21 Mrz 2012 09:21:27,588 [main] [com.teradata.viewpoint.security.globalentity.sync.GlobalEntitySynchronizer.synchronize(96)] Exception synchroni
zing security framework with DCS!!
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.Nest
edSQLException:
--- 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
Caused by: org.postgresql.util.PSQLException: ERROR: relation "config.systems" does not exist
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
Caused by: org.postgresql.util.PSQLException: ERROR: relation "config.systems" does not exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:614)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:588)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)

dfu 22 posts Joined 09/09
22 Mar 2012

Can you verify for me that the Systems table in the Config schema under dcsdb does not exist?  If it doesn't, can you verify if you ran "both" of the following scripts in Step 5?

 

Step 5: Running the Viewpoint setup script

---------------------------------------------------------

Create an environment variable CATALINA_HOME that points to the path for the Teradata Viewpoint Portal (C:\tdpdk-xx.xx.xx.xx\viewpoint-portal).

 

1. Open a command prompt and execute the following commands:

 

C:cd \tdpdk-xx.xx.xx.xx\viewpoint-portal\setup\bin

setup.bat

 

2. If you do not have an existing DCS database to connect to, you will need to run the following script:

 

C:cd \tdpdk-xx.xx.xx.xx\viewpoint-portal\setup\bin

setup-dcs.bat

 

You must sign in to leave a comment.