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]
Did you follow the instructions in the Teradata Viewpoint 14.0 Configuration Guide to ensure all the right permissions and enabling steps were completed?
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
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?
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.
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.
You can ignore that warning above. Are you still getting the "ERROR: relation "config.systems" does not exist" error during install?