Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Issues with installation of Analytics 3.1.0 in Tomcat 8.5.43

More
05 Aug 2019 22:42 #1 by craigacgomez
Issues with installation of Analytics 3.1.0 in Tomcat 8.5.43 was created by craigacgomez
I recently tried to upgrade to Stambia Analytics 3.1.0. I use an Ubuntu 18.04 LTS server with Java 8 and Tomcat 8.5.43 behind Nginx with reverse proxy (Semarchy xDM is also deployed here). I use a PostgreSQL 10 database. I am not reusing the "STAMBIA_WEBAPP_HOME" from the 2.x install. I instead created a new "STAMBIA_WEBAPP_HOME" folder.

I followed the instructions in the install guide...
1. Make sure "STAMBIA_WEBAPP_HOME" environment variable is set
2. Correct permissions for the "STAMBIA_WEBAPP_HOME" directory
3. Stambia Analytics webapp war deployed as "di-analytics"
4. Setup up the sta_datasource_tomcat datasource resource in the Tomcat context.xml
5. Confirmed the analytics user is set up with "analyticsConnect" and "analyticsAdmin" roles
6. Confirmed presence required JDBC drivers

I am, however, unable to start up Stambia Analytics properly and use it. I have attached the tomcat catalina logs along with a copy of my context.xml for your reference.

These are the key sections of my log that seem relevant:
05-Aug-2019 20:01:20.165 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/opt/tomcat/webapps/di-analytics.war]
05-Aug-2019 20:01:21.084 INFO [localhost-startStop-1] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = sta_datasource Ignoring unknown property: value of "Analytics Data Source." for "description" property
05-Aug-2019 20:01:21.134 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
Analytics datasource initialization (001)
[EL Warning]: metadata: 2019-08-05 20:01:27.151--ServerSession(823838747)--Overriding the FIELD mapping attribute [field repository] with the FIELD mapping attribute [field repository] from class [com.stambia.app.execution.jpa.logs.Application]. To avoid this warning you should mark the attribute [field repository] as transient.
[EL Warning]: metadata: 2019-08-05 20:01:27.179--ServerSession(823838747)--Overriding the FIELD mapping attribute [field preferences] with the FIELD mapping attribute [field preferences] from class [com.stambia.app.execution.jpa.logs.Application]. To avoid this warning you should mark the attribute [field preferences] as transient.
[EL Info]: 2019-08-05 20:01:29.191--ServerSession(823838747)--EclipseLink, version: Eclipse Persistence Services - 2.6.4.v20160829-44060b6
[EL Severe]: ejb: 2019-08-05 20:01:29.208--ServerSession(823838747)--Exception [EclipseLink-7060] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.ValidationException
Exception Description: Cannot acquire data source [java:/jdbc/sta_datasource].
Internal Exception: javax.naming.NameNotFoundException: Name [jdbc/sta_datasource] is not bound in this Context. Unable to find [jdbc].
Analytics datasource initialization (002)
[EL Warning]: metadata: 2019-08-05 20:01:29.774--ServerSession(586045785)--Overriding the FIELD mapping attribute [field repository] with the FIELD mapping attribute [field repository] from class [com.stambia.app.execution.jpa.logs.Application]. To avoid this warning you should mark the attribute [field repository] as transient.
[EL Warning]: metadata: 2019-08-05 20:01:29.777--ServerSession(586045785)--Overriding the FIELD mapping attribute [field preferences] with the FIELD mapping attribute [field preferences] from class [com.stambia.app.execution.jpa.logs.Application]. To avoid this warning you should mark the attribute [field preferences] as transient.
[EL Info]: 2019-08-05 20:01:30.967--ServerSession(586045785)--EclipseLink, version: Eclipse Persistence Services - 2.6.4.v20160829-44060b6
[EL Info]: connection: 2019-08-05 20:01:31.187--ServerSession(586045785)--/bundleresource://15.fwk1888535024_sta_datasource_tomcat login successful

Shows that it could connect to the datasource resource...
[EL Warning]: 2019-08-05 20:07:32.497--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_source" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_SOURCE ADD CONSTRAINT UK_STA_REP_SOURCE_01 UNIQUE (PROC_DB_ID, ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_SOURCE ADD CONSTRAINT UK_STA_REP_SOURCE_01 UNIQUE (PROC_DB_ID, ID)")
[EL Warning]: 2019-08-05 20:07:32.504--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_builder" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILDER ADD CONSTRAINT UK_STA_DEL_BUILDER_01 UNIQUE (PROJ_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILDER ADD CONSTRAINT UK_STA_DEL_BUILDER_01 UNIQUE (PROJ_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.507--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_profile_log" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_PROFILE_LOG ADD CONSTRAINT UK_STA_APP_PROFILE_LOG_01 UNIQUE (PROF_DB_ID, LOG_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_PROFILE_LOG ADD CONSTRAINT UK_STA_APP_PROFILE_LOG_01 UNIQUE (PROF_DB_ID, LOG_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.509--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_preference" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_PREFERENCE ADD CONSTRAINT UK_STA_APP_PREFERENCE_01 UNIQUE (APP_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_PREFERENCE ADD CONSTRAINT UK_STA_APP_PREFERENCE_01 UNIQUE (APP_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.513--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP ADD CONSTRAINT UK_STA_REP_01 UNIQUE (APP_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP ADD CONSTRAINT UK_STA_REP_01 UNIQUE (APP_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.515--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_source_attr" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_SOURCE_ATTR ADD CONSTRAINT UK_STA_REP_SOURCE_ATTR_01 UNIQUE (SRC_DB_ID, ATTR_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_SOURCE_ATTR ADD CONSTRAINT UK_STA_REP_SOURCE_ATTR_01 UNIQUE (SRC_DB_ID, ATTR_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.516--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_build" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILD ADD CONSTRAINT UK_STA_DEL_BUILD_01 UNIQUE (VER_DB_ID, ENV_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILD ADD CONSTRAINT UK_STA_DEL_BUILD_01 UNIQUE (VER_DB_ID, ENV_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.518--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_statistic" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_STATISTIC ADD CONSTRAINT UK_STA_APP_STATISTIC_01 UNIQUE (APP_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_STATISTIC ADD CONSTRAINT UK_STA_APP_STATISTIC_01 UNIQUE (APP_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.52--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_version_src" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_VERSION_SRC ADD CONSTRAINT UK_STA_DEL_VERSION_SRC_01 UNIQUE (VER_DB_ID, SRC_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_VERSION_SRC ADD CONSTRAINT UK_STA_DEL_VERSION_SRC_01 UNIQUE (VER_DB_ID, SRC_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.522--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_package_src" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_PACKAGE_SRC ADD CONSTRAINT UK_STA_REP_PACKAGE_SRC_01 UNIQUE (PCK_DB_ID, SRC_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_PACKAGE_SRC ADD CONSTRAINT UK_STA_REP_PACKAGE_SRC_01 UNIQUE (PCK_DB_ID, SRC_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.525--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_builder_env" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILDER_ENV ADD CONSTRAINT UK_STA_DEL_BUILDER_ENV_01 UNIQUE (BUILDER_DB_ID, ENV_DB_ID, VER_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILDER_ENV ADD CONSTRAINT UK_STA_DEL_BUILDER_ENV_01 UNIQUE (BUILDER_DB_ID, ENV_DB_ID, VER_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.531--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met_configuration_attr" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET_CONFIGURATION_ATTR ADD CONSTRAINT UK_STA_MET_CONFIGURATION_ATTR_01 UNIQUE (CONF_DB_ID, ATTR_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET_CONFIGURATION_ATTR ADD CONSTRAINT UK_STA_MET_CONFIGURATION_ATTR_01 UNIQUE (CONF_DB_ID, ATTR_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.533--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_process" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_PROCESS ADD CONSTRAINT UK_STA_REP_PROCESS_01 UNIQUE (REP_DB_ID, ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_PROCESS ADD CONSTRAINT UK_STA_REP_PROCESS_01 UNIQUE (REP_DB_ID, ID)")
[EL Warning]: 2019-08-05 20:07:32.535--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_log_db" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_LOG_DB ADD CONSTRAINT UK_STA_APP_RDBMS_01 UNIQUE (APP_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_LOG_DB ADD CONSTRAINT UK_STA_APP_RDBMS_01 UNIQUE (APP_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.536--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_project" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_PROJECT ADD CONSTRAINT UK_STA_DEL_PROJECT_01 UNIQUE (REP_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_PROJECT ADD CONSTRAINT UK_STA_DEL_PROJECT_01 UNIQUE (REP_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.538--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_version" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_VERSION ADD CONSTRAINT UK_STA_DEL_VERSION_01 UNIQUE (BUILDER_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_VERSION ADD CONSTRAINT UK_STA_DEL_VERSION_01 UNIQUE (BUILDER_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.54--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_build_src" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILD_SRC ADD CONSTRAINT UK_STA_DEL_BUILD_SRC_01 UNIQUE (BUILD_DB_ID, SRC_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILD_SRC ADD CONSTRAINT UK_STA_DEL_BUILD_SRC_01 UNIQUE (BUILD_DB_ID, SRC_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.542--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_build_attr" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILD_ATTR ADD CONSTRAINT UK_STA_DEL_BUILD_ATTR_01 UNIQUE (BUILD_DB_ID, CONF_DB_ID, ATTR_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILD_ATTR ADD CONSTRAINT UK_STA_DEL_BUILD_ATTR_01 UNIQUE (BUILD_DB_ID, CONF_DB_ID, ATTR_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.544--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_environment" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_ENVIRONMENT ADD CONSTRAINT UK_STA_DEL_ENVIRONMENT_01 UNIQUE (APP_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_ENVIRONMENT ADD CONSTRAINT UK_STA_DEL_ENVIRONMENT_01 UNIQUE (APP_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.546--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met_configuration" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET_CONFIGURATION ADD CONSTRAINT UK_STA_MET_CONFIGURATION_01 UNIQUE (APP_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET_CONFIGURATION ADD CONSTRAINT UK_STA_MET_CONFIGURATION_01 UNIQUE (APP_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.548--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_source_data" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_SOURCE_DATA ADD CONSTRAINT UK_STA_REP_SOURCE_DATA_01 UNIQUE (SRC_DB_ID, DATA_TYPE)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_SOURCE_DATA ADD CONSTRAINT UK_STA_REP_SOURCE_DATA_01 UNIQUE (SRC_DB_ID, DATA_TYPE)")
[EL Warning]: 2019-08-05 20:07:32.55--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_runtime" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_RUNTIME ADD CONSTRAINT UK_STA_APP_RUNTIME_01 UNIQUE (APP_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_RUNTIME ADD CONSTRAINT UK_STA_APP_RUNTIME_01 UNIQUE (APP_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.551--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_environment_rt" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_ENVIRONMENT_RT ADD CONSTRAINT UK_STA_DEL_ENVIRONMENT_RT_01 UNIQUE (ENV_DB_ID, RT_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_ENVIRONMENT_RT ADD CONSTRAINT UK_STA_DEL_ENVIRONMENT_RT_01 UNIQUE (ENV_DB_ID, RT_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.553--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met_attribute" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET_ATTRIBUTE ADD CONSTRAINT UK_STA_MET_ATTR_01 UNIQUE (PARENT_DB_ID, XML_NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET_ATTRIBUTE ADD CONSTRAINT UK_STA_MET_ATTR_01 UNIQUE (PARENT_DB_ID, XML_NAME)")
[EL Warning]: 2019-08-05 20:07:32.555--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_project_env" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_PROJECT_ENV ADD CONSTRAINT UK_STA_DEL_PROJECT_ENV_01 UNIQUE (PROJ_DB_ID, ENV_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_PROJECT_ENV ADD CONSTRAINT UK_STA_DEL_PROJECT_ENV_01 UNIQUE (PROJ_DB_ID, ENV_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.556--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET ADD CONSTRAINT UK_STA_MET_01 UNIQUE (APP_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET ADD CONSTRAINT UK_STA_MET_01 UNIQUE (APP_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.558--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_nav_resource" does not exist
Error Code: 0
Call: ALTER TABLE STA_NAV_RESOURCE ADD CONSTRAINT UK_STA_NAV_RESOURCE UNIQUE (NAME, PARENT_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_NAV_RESOURCE ADD CONSTRAINT UK_STA_NAV_RESOURCE UNIQUE (NAME, PARENT_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.559--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_profile" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_PROFILE ADD CONSTRAINT UK_STA_APP_PROFILE_01 UNIQUE (APP_DB_ID, NAME)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_PROFILE ADD CONSTRAINT UK_STA_APP_PROFILE_01 UNIQUE (APP_DB_ID, NAME)")
[EL Warning]: 2019-08-05 20:07:32.561--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met_node" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET_NODE ADD CONSTRAINT UK_STA_MET_NODE_01 UNIQUE (MET_DB_ID, ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET_NODE ADD CONSTRAINT UK_STA_MET_NODE_01 UNIQUE (MET_DB_ID, ID)")
[EL Warning]: 2019-08-05 20:07:32.569--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_package" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_PACKAGE ADD CONSTRAINT UK_STA_REP_PACKAGE_01 UNIQUE (REP_DB_ID, ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_PACKAGE ADD CONSTRAINT UK_STA_REP_PACKAGE_01 UNIQUE (REP_DB_ID, ID)")
[EL Warning]: 2019-08-05 20:07:32.571--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_environment_conf" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_ENVIRONMENT_CONF ADD CONSTRAINT UK_STA_DEL_ENVIRONMENT_CONF_01 UNIQUE (ENV_DB_ID, CONF_DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_ENVIRONMENT_CONF ADD CONSTRAINT UK_STA_DEL_ENVIRONMENT_CONF_01 UNIQUE (ENV_DB_ID, CONF_DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.573--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_source" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_SOURCE ADD CONSTRAINT FK_STA_REP_SOURCE_PROC_DB_ID FOREIGN KEY (PROC_DB_ID) REFERENCES STA_REP_PROCESS (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_SOURCE ADD CONSTRAINT FK_STA_REP_SOURCE_PROC_DB_ID FOREIGN KEY (PROC_DB_ID) REFERENCES STA_REP_PROCESS (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.575--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_builder" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILDER ADD CONSTRAINT FK_STA_DLV_BUILDER_PROJ_DB_ID FOREIGN KEY (PROJ_DB_ID) REFERENCES STA_DLV_PROJECT (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILDER ADD CONSTRAINT FK_STA_DLV_BUILDER_PROJ_DB_ID FOREIGN KEY (PROJ_DB_ID) REFERENCES STA_DLV_PROJECT (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.577--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_profile_log" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_PROFILE_LOG ADD CONSTRAINT FK_STA_APP_PROFILE_LOG_PROF_DB_ID FOREIGN KEY (PROF_DB_ID) REFERENCES STA_APP_PROFILE (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_PROFILE_LOG ADD CONSTRAINT FK_STA_APP_PROFILE_LOG_PROF_DB_ID FOREIGN KEY (PROF_DB_ID) REFERENCES STA_APP_PROFILE (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.579--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_preference" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_PREFERENCE ADD CONSTRAINT FK_STA_APP_PREFERENCE_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_PREFERENCE ADD CONSTRAINT FK_STA_APP_PREFERENCE_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.581--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP ADD CONSTRAINT FK_STA_REP_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP ADD CONSTRAINT FK_STA_REP_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.583--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_source_attr" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_SOURCE_ATTR ADD CONSTRAINT FK_STA_REP_SOURCE_ATTR_ATTR_DB_ID FOREIGN KEY (ATTR_DB_ID) REFERENCES STA_MET_ATTRIBUTE (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_SOURCE_ATTR ADD CONSTRAINT FK_STA_REP_SOURCE_ATTR_ATTR_DB_ID FOREIGN KEY (ATTR_DB_ID) REFERENCES STA_MET_ATTRIBUTE (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.584--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_build" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILD ADD CONSTRAINT FK_STA_DLV_BUILD_VER_DB_ID FOREIGN KEY (VER_DB_ID) REFERENCES STA_DLV_VERSION (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILD ADD CONSTRAINT FK_STA_DLV_BUILD_VER_DB_ID FOREIGN KEY (VER_DB_ID) REFERENCES STA_DLV_VERSION (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.586--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_statistic" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_STATISTIC ADD CONSTRAINT FK_STA_APP_STATISTIC_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_STATISTIC ADD CONSTRAINT FK_STA_APP_STATISTIC_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.587--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_version_src" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_VERSION_SRC ADD CONSTRAINT FK_STA_DLV_VERSION_SRC_VER_DB_ID FOREIGN KEY (VER_DB_ID) REFERENCES STA_DLV_VERSION (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_VERSION_SRC ADD CONSTRAINT FK_STA_DLV_VERSION_SRC_VER_DB_ID FOREIGN KEY (VER_DB_ID) REFERENCES STA_DLV_VERSION (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.589--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_package_src" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_PACKAGE_SRC ADD CONSTRAINT FK_STA_REP_PACKAGE_SRC_PCK_DB_ID FOREIGN KEY (PCK_DB_ID) REFERENCES STA_REP_PACKAGE (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_PACKAGE_SRC ADD CONSTRAINT FK_STA_REP_PACKAGE_SRC_PCK_DB_ID FOREIGN KEY (PCK_DB_ID) REFERENCES STA_REP_PACKAGE (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.59--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_builder_env" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILDER_ENV ADD CONSTRAINT FK_STA_DLV_BUILDER_ENV_VER_DB_ID FOREIGN KEY (VER_DB_ID) REFERENCES STA_DLV_VERSION (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILDER_ENV ADD CONSTRAINT FK_STA_DLV_BUILDER_ENV_VER_DB_ID FOREIGN KEY (VER_DB_ID) REFERENCES STA_DLV_VERSION (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.592--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met_configuration_attr" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET_CONFIGURATION_ATTR ADD CONSTRAINT FK_STA_MET_CONFIGURATION_ATTR_ATTR_DB_ID FOREIGN KEY (ATTR_DB_ID) REFERENCES STA_MET_ATTRIBUTE (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET_CONFIGURATION_ATTR ADD CONSTRAINT FK_STA_MET_CONFIGURATION_ATTR_ATTR_DB_ID FOREIGN KEY (ATTR_DB_ID) REFERENCES STA_MET_ATTRIBUTE (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.593--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_process" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_PROCESS ADD CONSTRAINT FK_STA_REP_PROCESS_REP_DB_ID FOREIGN KEY (REP_DB_ID) REFERENCES STA_REP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_PROCESS ADD CONSTRAINT FK_STA_REP_PROCESS_REP_DB_ID FOREIGN KEY (REP_DB_ID) REFERENCES STA_REP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.595--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_log_db" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_LOG_DB ADD CONSTRAINT FK_STA_APP_LOG_DB_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_LOG_DB ADD CONSTRAINT FK_STA_APP_LOG_DB_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.6--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_nav_folder" does not exist
Error Code: 0
Call: ALTER TABLE STA_NAV_FOLDER ADD CONSTRAINT FK_STA_NAV_FOLDER_NAVIGATOR_DB_ID FOREIGN KEY (NAVIGATOR_DB_ID) REFERENCES STA_NAV (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_NAV_FOLDER ADD CONSTRAINT FK_STA_NAV_FOLDER_NAVIGATOR_DB_ID FOREIGN KEY (NAVIGATOR_DB_ID) REFERENCES STA_NAV (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.607--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_project" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_PROJECT ADD CONSTRAINT FK_STA_DLV_PROJECT_REP_DB_ID FOREIGN KEY (REP_DB_ID) REFERENCES STA_REP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_PROJECT ADD CONSTRAINT FK_STA_DLV_PROJECT_REP_DB_ID FOREIGN KEY (REP_DB_ID) REFERENCES STA_REP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.609--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_version" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_VERSION ADD CONSTRAINT FK_STA_DLV_VERSION_BUILDER_DB_ID FOREIGN KEY (BUILDER_DB_ID) REFERENCES STA_DLV_BUILDER (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_VERSION ADD CONSTRAINT FK_STA_DLV_VERSION_BUILDER_DB_ID FOREIGN KEY (BUILDER_DB_ID) REFERENCES STA_DLV_BUILDER (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.61--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_build_src" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILD_SRC ADD CONSTRAINT FK_STA_DLV_BUILD_SRC_BUILD_DB_ID FOREIGN KEY (BUILD_DB_ID) REFERENCES STA_DLV_BUILD (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILD_SRC ADD CONSTRAINT FK_STA_DLV_BUILD_SRC_BUILD_DB_ID FOREIGN KEY (BUILD_DB_ID) REFERENCES STA_DLV_BUILD (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.612--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_build_attr" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_BUILD_ATTR ADD CONSTRAINT FK_STA_DLV_BUILD_ATTR_CONF_DB_ID FOREIGN KEY (CONF_DB_ID) REFERENCES STA_MET_CONFIGURATION (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_BUILD_ATTR ADD CONSTRAINT FK_STA_DLV_BUILD_ATTR_CONF_DB_ID FOREIGN KEY (CONF_DB_ID) REFERENCES STA_MET_CONFIGURATION (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.615--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_environment" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_ENVIRONMENT ADD CONSTRAINT FK_STA_DLV_ENVIRONMENT_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_ENVIRONMENT ADD CONSTRAINT FK_STA_DLV_ENVIRONMENT_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.616--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met_configuration" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET_CONFIGURATION ADD CONSTRAINT FK_STA_MET_CONFIGURATION_PARENT_DB_ID FOREIGN KEY (PARENT_DB_ID) REFERENCES STA_MET_CONFIGURATION (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET_CONFIGURATION ADD CONSTRAINT FK_STA_MET_CONFIGURATION_PARENT_DB_ID FOREIGN KEY (PARENT_DB_ID) REFERENCES STA_MET_CONFIGURATION (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.62--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP ADD CONSTRAINT FK_STA_APP_PROF_DB_ID FOREIGN KEY (PROF_DB_ID) REFERENCES STA_APP_PROFILE (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP ADD CONSTRAINT FK_STA_APP_PROF_DB_ID FOREIGN KEY (PROF_DB_ID) REFERENCES STA_APP_PROFILE (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.624--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_source_data" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_SOURCE_DATA ADD CONSTRAINT FK_STA_REP_SOURCE_DATA_SRC_DB_ID FOREIGN KEY (SRC_DB_ID) REFERENCES STA_REP_SOURCE (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_SOURCE_DATA ADD CONSTRAINT FK_STA_REP_SOURCE_DATA_SRC_DB_ID FOREIGN KEY (SRC_DB_ID) REFERENCES STA_REP_SOURCE (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.626--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_runtime" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_RUNTIME ADD CONSTRAINT FK_STA_APP_RUNTIME_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_RUNTIME ADD CONSTRAINT FK_STA_APP_RUNTIME_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.628--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_environment_rt" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_ENVIRONMENT_RT ADD CONSTRAINT FK_STA_DLV_ENVIRONMENT_RT_ENV_DB_ID FOREIGN KEY (ENV_DB_ID) REFERENCES STA_DLV_ENVIRONMENT (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_ENVIRONMENT_RT ADD CONSTRAINT FK_STA_DLV_ENVIRONMENT_RT_ENV_DB_ID FOREIGN KEY (ENV_DB_ID) REFERENCES STA_DLV_ENVIRONMENT (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.631--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met_attribute" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET_ATTRIBUTE ADD CONSTRAINT FK_STA_MET_ATTRIBUTE_PARENT_DB_ID FOREIGN KEY (PARENT_DB_ID) REFERENCES STA_MET_NODE (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET_ATTRIBUTE ADD CONSTRAINT FK_STA_MET_ATTRIBUTE_PARENT_DB_ID FOREIGN KEY (PARENT_DB_ID) REFERENCES STA_MET_NODE (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.633--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_project_env" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_PROJECT_ENV ADD CONSTRAINT FK_STA_DLV_PROJECT_ENV_PROJ_DB_ID FOREIGN KEY (PROJ_DB_ID) REFERENCES STA_DLV_PROJECT (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_PROJECT_ENV ADD CONSTRAINT FK_STA_DLV_PROJECT_ENV_PROJ_DB_ID FOREIGN KEY (PROJ_DB_ID) REFERENCES STA_DLV_PROJECT (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.634--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET ADD CONSTRAINT FK_STA_MET_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET ADD CONSTRAINT FK_STA_MET_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.636--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_nav_resource" does not exist
Error Code: 0
Call: ALTER TABLE STA_NAV_RESOURCE ADD CONSTRAINT FK_STA_NAV_RESOURCE_PARENT_DB_ID FOREIGN KEY (PARENT_DB_ID) REFERENCES STA_NAV_FOLDER (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_NAV_RESOURCE ADD CONSTRAINT FK_STA_NAV_RESOURCE_PARENT_DB_ID FOREIGN KEY (PARENT_DB_ID) REFERENCES STA_NAV_FOLDER (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.637--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_profile" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_PROFILE ADD CONSTRAINT FK_STA_APP_PROFILE_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_PROFILE ADD CONSTRAINT FK_STA_APP_PROFILE_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.639--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_met_node" does not exist
Error Code: 0
Call: ALTER TABLE STA_MET_NODE ADD CONSTRAINT FK_STA_MET_NODE_ROOT_DB_ID FOREIGN KEY (ROOT_DB_ID) REFERENCES STA_MET (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_MET_NODE ADD CONSTRAINT FK_STA_MET_NODE_ROOT_DB_ID FOREIGN KEY (ROOT_DB_ID) REFERENCES STA_MET (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.64--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_nav" does not exist
Error Code: 0
Call: ALTER TABLE STA_NAV ADD CONSTRAINT FK_STA_NAV_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_NAV ADD CONSTRAINT FK_STA_NAV_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.644--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_rep_package" does not exist
Error Code: 0
Call: ALTER TABLE STA_REP_PACKAGE ADD CONSTRAINT FK_STA_REP_PACKAGE_REP_DB_ID FOREIGN KEY (REP_DB_ID) REFERENCES STA_REP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_REP_PACKAGE ADD CONSTRAINT FK_STA_REP_PACKAGE_REP_DB_ID FOREIGN KEY (REP_DB_ID) REFERENCES STA_REP (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.646--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_dlv_environment_conf" does not exist
Error Code: 0
Call: ALTER TABLE STA_DLV_ENVIRONMENT_CONF ADD CONSTRAINT FK_STA_DLV_ENVIRONMENT_CONF_ENV_DB_ID FOREIGN KEY (ENV_DB_ID) REFERENCES STA_DLV_ENVIRONMENT (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_DLV_ENVIRONMENT_CONF ADD CONSTRAINT FK_STA_DLV_ENVIRONMENT_CONF_ENV_DB_ID FOREIGN KEY (ENV_DB_ID) REFERENCES STA_DLV_ENVIRONMENT (DB_ID)")
[EL Warning]: 2019-08-05 20:07:32.648--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app_log" does not exist
Error Code: 0
Call: ALTER TABLE STA_APP_LOG ADD CONSTRAINT FK_STA_APP_LOG_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)
Query: DataModifyQuery(sql="ALTER TABLE STA_APP_LOG ADD CONSTRAINT FK_STA_APP_LOG_APP_DB_ID FOREIGN KEY (APP_DB_ID) REFERENCES STA_APP (DB_ID)")
[EL Info]: query: 2019-08-05 20:07:42.668--ServerSession(586045785)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_sequence" does not exist
  Position: 15
Error Code: 0
Call: SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'
Query: DataReadQuery(sql="SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'").
[EL Info]: query: 2019-08-05 20:07:42.67--ServerSession(586045785)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_sequence" does not exist
  Position: 15
Error Code: 0
Call: SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'
Query: DataReadQuery(sql="SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'").
[EL Info]: query: 2019-08-05 20:07:47.674--ServerSession(586045785)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_sequence" does not exist
  Position: 15
Error Code: 0
Call: SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'
Query: DataReadQuery(sql="SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'").
[EL Warning]: 2019-08-05 20:07:52.677--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_sequence" does not exist
  Position: 15
Error Code: 0
Call: SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'
Query: DataReadQuery(sql="SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'")
[EL Info]: query: 2019-08-05 20:08:02.702--ServerSession(586045785)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_sequence" does not exist
  Position: 15
Error Code: 0
Call: SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'
Query: DataReadQuery(sql="SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'").
[EL Info]: query: 2019-08-05 20:08:02.704--ServerSession(586045785)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_sequence" does not exist
  Position: 15
Error Code: 0
Call: SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'
Query: DataReadQuery(sql="SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'").
[EL Info]: query: 2019-08-05 20:08:07.707--ServerSession(586045785)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_sequence" does not exist
  Position: 15
Error Code: 0
Call: SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'
Query: DataReadQuery(sql="SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'").
[EL Warning]: 2019-08-05 20:08:12.717--ServerSession(586045785)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_sequence" does not exist
  Position: 15
Error Code: 0
Call: SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'
Query: DataReadQuery(sql="SELECT * FROM sta_sequence WHERE SEQ_NAME = 'SEQ_GEN'")
[EL Info]: query: 2019-08-05 20:08:13.624--UnitOfWork(494045310)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app" does not exist
  Position: 134
Error Code: 0
Call: SELECT DB_ID AS a1, CRT_DT AS a2, CRT_USR AS a3, DB_VERSION AS a4, UPD_DT AS a5, UPD_USR AS a6, VERSION AS a7, PROF_DB_ID AS a8 FROM STA_APP LIMIT ? OFFSET ?
	bind => [2 parameters bound]
Query: ReadAllQuery(referenceClass=Application sql="SELECT DB_ID AS a1, CRT_DT AS a2, CRT_USR AS a3, DB_VERSION AS a4, UPD_DT AS a5, UPD_USR AS a6, VERSION AS a7, PROF_DB_ID AS a8 FROM STA_APP LIMIT ? OFFSET ?").
[EL Info]: query: 2019-08-05 20:08:13.626--UnitOfWork(494045310)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app" does not exist
  Position: 134
Error Code: 0
Call: SELECT DB_ID AS a1, CRT_DT AS a2, CRT_USR AS a3, DB_VERSION AS a4, UPD_DT AS a5, UPD_USR AS a6, VERSION AS a7, PROF_DB_ID AS a8 FROM STA_APP LIMIT ? OFFSET ?
	bind => [2 parameters bound]
Query: ReadAllQuery(referenceClass=Application sql="SELECT DB_ID AS a1, CRT_DT AS a2, CRT_USR AS a3, DB_VERSION AS a4, UPD_DT AS a5, UPD_USR AS a6, VERSION AS a7, PROF_DB_ID AS a8 FROM STA_APP LIMIT ? OFFSET ?").
[EL Info]: query: 2019-08-05 20:08:18.63--UnitOfWork(494045310)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app" does not exist
  Position: 134
Error Code: 0
Call: SELECT DB_ID AS a1, CRT_DT AS a2, CRT_USR AS a3, DB_VERSION AS a4, UPD_DT AS a5, UPD_USR AS a6, VERSION AS a7, PROF_DB_ID AS a8 FROM STA_APP LIMIT ? OFFSET ?
	bind => [2 parameters bound]
Query: ReadAllQuery(referenceClass=Application sql="SELECT DB_ID AS a1, CRT_DT AS a2, CRT_USR AS a3, DB_VERSION AS a4, UPD_DT AS a5, UPD_USR AS a6, VERSION AS a7, PROF_DB_ID AS a8 FROM STA_APP LIMIT ? OFFSET ?").
[EL Warning]: 2019-08-05 20:08:23.633--UnitOfWork(494045310)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "sta_app" does not exist
  Position: 134
Error Code: 0
Call: SELECT DB_ID AS a1, CRT_DT AS a2, CRT_USR AS a3, DB_VERSION AS a4, UPD_DT AS a5, UPD_USR AS a6, VERSION AS a7, PROF_DB_ID AS a8 FROM STA_APP LIMIT ? OFFSET ?
	bind => [2 parameters bound]
Query: ReadAllQuery(referenceClass=Application sql="SELECT DB_ID AS a1, CRT_DT AS a2, CRT_USR AS a3, DB_VERSION AS a4, UPD_DT AS a5, UPD_USR AS a6, VERSION AS a7, PROF_DB_ID AS a8 FROM STA_APP LIMIT ? OFFSET ?")
Analytics datasource could not be initialized

It did not create the relevant STA tables, but tried to "ALTER" tables that weren't present. And at the end of it all, it could not initialise the Analytics datasource.

I can confirm that no tables were created in the database.

When I try to access the webapp in a browser "<URL>/di-analytics/stambia", I immediate get the error "Exception Description: Cannot acquire data source [java:/jdbc/sta_datasource]" (attached)

This message has attachments files.
Please log in or register to see it.

More
06 Aug 2019 10:06 - 06 Aug 2019 11:08 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Issues with installation of Analytics 3.1.0 in Tomcat 8.5.43
Hi,
This error can happen on Tomcat servers when the JDBC datasource is not correctly named.
As the documentation specifies, the datasource must be named sta_datasource_tomcat when working with a Tomcat server.
=> Can you make sure that this name has been used for declaring the datasource in context.xml ?
=> Also make sure that the required JDBC driver is installed in Tomcat's lib directory, and then restart Tomcat.
=> Also change the parameter defaultAutoCommit="false" to "true", the error may be caused by the "false" value.
Last edit: 06 Aug 2019 11:08 by Thomas BLETON.
More
13 Aug 2019 19:20 #3 by craigacgomez
Replied by craigacgomez on topic Issues with installation of Analytics 3.1.0 in Tomcat 8.5.43
Thank you for the quick response. Looks like the only change I had to do was change the defaultAutoCommit values to true in the datasource definition in the Tomcat context xml.