So that last log was trying to set it up on an empty db, here is the log
attempting to upgrade the actual db that I am really trying to get to
work...
2016-01-21 17:25:24,659 DEBUG [geonetwork.databasemigration] - DB Migration
/ Running 'class org.apache.commons.dbcp.BasicDataSource' after
initialization of 'javax.sql.DataSource'.
2016-01-21 17:25:24,675 INFO [geonetwork.databasemigration] - -
Migration ...
2016-01-21 17:25:25,705 INFO [geonetwork.databasemigration] - Webapp
version:3.0.3-0 subversion:SNAPSHOT
2016-01-21 17:25:25,705 INFO [geonetwork.databasemigration] -
Database version:2.10.1 subversion:0
2016-01-21 17:25:25,720 DEBUG [geonetwork.databasemigration] -
Migrating from 2.10.1 to 3.0.3 (dbtype:sqlserver)...
2016-01-21 17:25:25,720 INFO [geonetwork.databasemigration] -
Loading SQL migration step configuration from <?xml version="1.0"
encoding="UTF-8"?>
...
2016-01-21 17:25:25,720 INFO [geonetwork.databasemigration] - -
running tasks for 2.11.0...
2016-01-21 17:25:25,720 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v2110
prefix:1-migrate-db- ...
2016-01-21 17:25:25,736 WARN [geonetwork.database] - SQL failure for:
CREATE TABLE HarvesterSettings ( id int not null,
parentId int, name varchar(64) not null, value
varchar(max), primary key(id), foreign key(parentId) references
HarvesterSettings(id) ), error is:There is already an object named
'HarvesterSettings' in the database.
2016-01-21 17:25:25,736 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: There is already an object named
'HarvesterSettings' in the database.
2016-01-21 17:25:25,767 INFO [geonetwork.databasemigration] - -
Java migration class:v2110.MoveHarvesterSettings
2016-01-21 17:25:25,767 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v2110
prefix:2-migrate- ...
2016-01-21 17:25:25,783 WARN [geonetwork.database] - SQL failure for:
ALTER TABLE operations DROP COLUMN reserved, error is:ALTER TABLE DROP
COLUMN failed because column 'reserved' does not exist in table
'Operations'.
2016-01-21 17:25:25,783 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: ALTER TABLE DROP COLUMN failed
because column 'reserved' does not exist in table 'Operations'.
2016-01-21 17:25:25,798 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v2110
prefix:3-create-tmp-tables- ...
2016-01-21 17:25:25,814 WARN [geonetwork.database] - SQL failure for:
CREATE TABLE USERGROUPS_TMP ( USERID int NOT NULL, GROUPID int NOT
NULL, PROFILE int NOT NULL ), error is:There is already an object named
'USERGROUPS_TMP' in the database.
2016-01-21 17:25:25,814 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: There is already an object named
'USERGROUPS_TMP' in the database.
2016-01-21 17:25:25,829 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v2110
prefix:4-copy-to-tmp- ...
2016-01-21 17:25:25,845 WARN [geonetwork.database] - SQL failure for:
INSERT INTO USERS_TMP SELECT id, username, password, surname, name, 0,
organisation, kind, security, authtype FROM USERS where
profile='Administrator', error is:Violation of PRIMARY KEY constraint
'PK__USERS_TM__3213E83F6CF07955'. Cannot insert duplicate key in object
'dbo.USERS_TMP'. The duplicate key value is (1).
2016-01-21 17:25:25,845 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: Violation of PRIMARY KEY
constraint 'PK__USERS_TM__3213E83F6CF07955'. Cannot insert duplicate key in
object 'dbo.USERS_TMP'. The duplicate key value is (1).
2016-01-21 17:25:25,861 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v2110
prefix:5-recreate-old-tables- ...
2016-01-21 17:25:25,907 WARN [geonetwork.database] - SQL failure for:
CREATE TABLE USERGROUPS ( userId int not null,
groupId int not null, profile int not null,
primary key(userId,groupId,profile), foreign key(userId) references
Users(id), foreign key(groupId) references Groups(id) ), error
is:There are no primary or candidate keys in the referenced table 'Users'
that match the referencing column list in the foreign key
'FK__USERGROUP__userI__6BE40491'.
2016-01-21 17:25:25,907 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: There are no primary or candidate
keys in the referenced table 'Users' that match the referencing column list
in the foreign key 'FK__USERGROUP__userI__6BE40491'.
2016-01-21 17:25:25,923 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v2110
prefix:6-copy-from-tmp- ...
2016-01-21 17:25:25,923 INFO [geonetwork.databasemigration] - -
running tasks for 3.0.0...
2016-01-21 17:25:25,923 INFO [geonetwork.databasemigration] - -
Java migration class:SetSequenceValueToMaxOfMetadataAndStats
2016-01-21 17:25:25,939 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v300
prefix:migrate- ...
2016-01-21 17:25:25,954 WARN [geonetwork.database] - SQL failure for:
INSERT INTO Settings (name, value, datatype, position, internal) VALUES
('region/getmap/background', 'osm', 0, 9590, 'n'), error is:Cannot insert
the value NULL into column 'id', table 'geonet.dbo.Settings'; column does
not allow nulls. INSERT fails.
2016-01-21 17:25:25,954 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: Cannot insert the value NULL into
column 'id', table 'geonet.dbo.Settings'; column does not allow nulls.
INSERT fails.
2016-01-21 17:25:25,970 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v300
prefix:migrate-cswservice- ...
2016-01-21 17:25:25,970 WARN [geonetwork.database] - SQL failure for:
ALTER TABLE ServiceParameters ADD COLUMN occur varchar(1) default '+',
error is:Incorrect syntax near the keyword 'COLUMN'.
2016-01-21 17:25:25,970 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: Incorrect syntax near the keyword
'COLUMN'.
2016-01-21 17:25:25,985 INFO [geonetwork.databasemigration] - -
running tasks for 3.0.1...
2016-01-21 17:25:25,985 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v301
prefix:migrate- ...
2016-01-21 17:25:25,985 WARN [geonetwork.database] - SQL failure for:
INSERT INTO Settings (name, value, datatype, position, internal) VALUES
('map/is3DModeAllowed', 'false', 2, 9593, 'n'), error is:Cannot insert the
value NULL into column 'id', table 'geonet.dbo.Settings'; column does not
allow nulls. INSERT fails.
2016-01-21 17:25:26,001 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: Cannot insert the value NULL into
column 'id', table 'geonet.dbo.Settings'; column does not allow nulls.
INSERT fails.
2016-01-21 17:25:26,001 INFO [geonetwork.databasemigration] - -
running tasks for 3.0.2...
2016-01-21 17:25:26,001 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v302
prefix:migrate- ...
2016-01-21 17:25:26,017 WARN [geonetwork.database] - SQL failure for:
INSERT INTO Settings (name, value, datatype, position, internal) VALUES
('metadata/workflow/draftWhenInGroup', '', 0, 100002, 'n'), error is:Cannot
insert the value NULL into column 'id', table 'geonet.dbo.Settings'; column
does not allow nulls. INSERT fails.
2016-01-21 17:25:26,017 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: Cannot insert the value NULL into
column 'id', table 'geonet.dbo.Settings'; column does not allow nulls.
INSERT fails.
2016-01-21 17:25:26,032 WARN [geonetwork.databasemigration] - Error
occurs during migration. Check the log file for more details.
2016-01-21 17:25:29,231 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: create table HarvesterData (harvesterUuid
varchar(255) not null, key varchar(255) not null, value varchar(255) not
null, primary key (harvesterUuid, key))
2016-01-21 17:25:29,231 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Incorrect syntax near the keyword 'key'.
2016-01-21 17:25:29,231 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table CategoriesDes add constraint
FK_69p88c8991letuoq16jddi307 foreign key (idDes) references Categories
2016-01-21 17:25:29,231 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_69p88c8991letuoq16jddi307' has implicit reference to object
'Categories' which does not have a primary key defined on it.
2016-01-21 17:25:29,231 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table Groups add constraint
FK_balio8qkvhnitbdw241e4ryb8 foreign key (defaultCategory_id) references
Categories
2016-01-21 17:25:29,231 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_balio8qkvhnitbdw241e4ryb8' has implicit reference to object
'Categories' which does not have a primary key defined on it.
2016-01-21 17:25:29,231 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table GroupsDes add constraint
FK_4p4fkvpk92euh0l1hrphqmhgp foreign key (idDes) references Groups
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_4p4fkvpk92euh0l1hrphqmhgp' has implicit reference to object
'Groups' which does not have a primary key defined on it.
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table IsoLanguagesDes add constraint
FK_emeavjsu8j7v000m8iyu0skgo foreign key (idDes) references IsoLanguages
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_emeavjsu8j7v000m8iyu0skgo' has implicit reference to object
'IsoLanguages' which does not have a primary key defined on it.
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table MetadataCateg add constraint
FK_eq06r8xcyiiibgyl6q3r1ojk4 foreign key (categoryId) references Categories
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_eq06r8xcyiiibgyl6q3r1ojk4' has implicit reference to object
'Categories' which does not have a primary key defined on it.
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table MetadataCateg add constraint
FK_691tu1a51wae9905g6gtyjopt foreign key (metadataId) references Metadata
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_691tu1a51wae9905g6gtyjopt' has implicit reference to object
'Metadata' which does not have a primary key defined on it.
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table MetadataNotifications add constraint
FK_jbkvo3w3g4twk2bo1b8jn0sw8 foreign key (notifierId) references
MetadataNotifiers
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_jbkvo3w3g4twk2bo1b8jn0sw8' has implicit reference to object
'MetadataNotifiers' which does not have a primary key defined on it.
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table MetadataStatus add constraint
FK_b6th8n92l16998imlr7oqytaf foreign key (statusId) references StatusValues
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_b6th8n92l16998imlr7oqytaf' has implicit reference to object
'StatusValues' which does not have a primary key defined on it.
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table OperationsDes add constraint
FK_si4h3s9vk085jarb8xbfw1uv foreign key (idDes) references Operations
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_si4h3s9vk085jarb8xbfw1uv' has implicit reference to object
'Operations' which does not have a primary key defined on it.
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table Params add constraint
FK_6d52bqoq3c2eitpdq5r7y872g foreign key (requestid) references Requests
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_6d52bqoq3c2eitpdq5r7y872g' has implicit reference to object
'Requests' which does not have a primary key defined on it.
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table ServiceParameters add constraint
FK_t32t4xtdqmjhl8xmjpe95e474 foreign key (service) references Services
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_t32t4xtdqmjhl8xmjpe95e474' has implicit reference to object
'Services' which does not have a primary key defined on it.
2016-01-21 17:25:29,247 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table SourcesDes add constraint
FK_c3jxktm4qwai73lddsm5fiecb foreign key (idDes) references Sources
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_c3jxktm4qwai73lddsm5fiecb' has implicit reference to object
'Sources' which does not have a primary key defined on it.
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table StatusValuesDes add constraint
FK_2vkxyjsd2d3tdwn38p5yjhb71 foreign key (idDes) references StatusValues
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_2vkxyjsd2d3tdwn38p5yjhb71' has implicit reference to object
'StatusValues' which does not have a primary key defined on it.
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table UserAddress add constraint
FK_f8ecen6kghqbp0tkqc4cdr6q1 foreign key (userid) references Users
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_f8ecen6kghqbp0tkqc4cdr6q1' has implicit reference to object
'Users' which does not have a primary key defined on it.
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table UserGroups add constraint
FK_py108k658ig7v8luqf88sgrtu foreign key (groupId) references Groups
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_py108k658ig7v8luqf88sgrtu' has implicit reference to object
'Groups' which does not have a primary key defined on it.
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table UserGroups add constraint
FK_1x9ybprsvnlrawsk1a7nwgpq6 foreign key (userId) references Users
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_1x9ybprsvnlrawsk1a7nwgpq6' has implicit reference to object
'Users' which does not have a primary key defined on it.
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table email add constraint
FK_tlb3l7e2xg65r3nkoahbqlmii foreign key (User_id) references Users
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_tlb3l7e2xg65r3nkoahbqlmii' has implicit reference to object
'Users' which does not have a primary key defined on it.
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table group_category add constraint
FK_j8nj5ssnar3byh882nuf38tqw foreign key (CATEGORY_ID) references Categories
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_j8nj5ssnar3byh882nuf38tqw' has implicit reference to object
'Categories' which does not have a primary key defined on it.
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table group_category add constraint
FK_r1y7atocbww201qaj87h9j62e foreign key (GROUP_ID) references Groups
2016-01-21 17:25:29,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_r1y7atocbww201qaj87h9j62e' has implicit reference to object
'Groups' which does not have a primary key defined on it.
2016-01-21 17:25:33,147 DEBUG [geonetwork.databasemigration] - DB Migration
/ Running 'class org.springframework.orm.jpa.JpaTransactionManager' after
initialization of 'org.springframework.orm.jpa.JpaTransactionManager'.
2016-01-21 17:25:33,162 INFO [geonetwork.databasemigration] - -
Migration ...
2016-01-21 17:25:33,162 INFO [geonetwork.databasemigration] - Webapp
version:3.0.3-0 subversion:SNAPSHOT
2016-01-21 17:25:33,162 INFO [geonetwork.databasemigration] -
Database version:2.10.1 subversion:0
2016-01-21 17:25:33,162 DEBUG [geonetwork.databasemigration] -
Migrating from 2.10.1 to 3.0.3 (dbtype:sqlserver)...
2016-01-21 17:25:33,162 INFO [geonetwork.databasemigration] -
Loading SQL migration step configuration from <?xml version="1.0"
encoding="UTF-8"?>
...
2016-01-21 17:25:33,178 INFO [geonetwork.databasemigration] - -
running tasks for 3.0.3...
2016-01-21 17:25:33,178 INFO [geonetwork.databasemigration] - -
SQL migration
file:C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\classes\setup\sql\migrate\v303
prefix:migrate- ...
2016-01-21 17:25:33,178 WARN [geonetwork.database] - SQL failure for:
INSERT INTO MetadataIdentifierTemplate (id, name, template, isprovided)
VALUES (0, 'Custom URN', '', 'y'), error is:Violation of PRIMARY KEY
constraint 'PK__Metadata__3213E83F382A8C46'. Cannot insert duplicate key in
object 'dbo.MetadataIdentifierTemplate'. The duplicate key value is (0).
2016-01-21 17:25:33,178 INFO [geonetwork.databasemigration] -
Errors occurs during SQL migration file: Violation of PRIMARY KEY
constraint 'PK__Metadata__3213E83F382A8C46'. Cannot insert duplicate key in
object 'dbo.MetadataIdentifierTemplate'. The duplicate key value is (0).
2016-01-21 17:25:33,194 WARN [geonetwork.databasemigration] - Error
occurs during migration. Check the log file for more details.
2016-01-21 17:25:39,808 WARN [geonetwork.data.directory] - - Data
directory properties is not set. Use geonetwork.dir or geonetwork.dir
properties.
2016-01-21 17:25:39,808 WARN [geonetwork.data.directory] - - Data
directory provided could not be used. Using default location:
C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\data
2016-01-21 17:25:39,980 ERROR [geonetwork.settings] - Requested setting
with name: system/z3950/enable not found. Add it to the settings table.
2016-01-21 17:25:39,980 ERROR [geonetwork.settings] - Requested setting
with name: system/z3950/port not found. Add it to the settings table.
2016-01-21 17:25:40,494 WARN [geonetwork.schemamanager] - Cannot resolve
http://www.w3.org/2001/03/xml.xsd: will append last component to current
path (not sure it will help though!)
2016-01-21 17:25:40,791 WARN [geonetwork.schemamanager] - WARNING:
gco:Record is a global element without a type - assuming a string
2016-01-21 17:25:41,087 WARN [geonetwork.schemamanager] - WARNING:
gco:Record is a global element without a type - assuming a string
2016-01-21 17:25:41,087 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:VerticalDatum
2016-01-21 17:25:41,087 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:CoordinateSystemAxis
2016-01-21 17:25:41,087 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:VerticalCS
2016-01-21 17:25:41,103 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:CoordinateSystemAxis
2016-01-21 17:25:43,568 ERROR [geonetwork.settings] - Requested setting
with name: system/requestedLanguage/ignorechars not found. Add it to the
settings table.
2016-01-21 17:25:43,630 ERROR [geonetwork.settings] - Requested setting
with name: system/requestedLanguage/ignorechars not found. Add it to the
settings table.
/***********************There were thousands of this same error, i cut them
to save space...**************************************/
2016-01-21 17:25:46,173 ERROR [geonetwork.settings] - Requested setting
with name: system/requestedLanguage/ignorechars not found. Add it to the
settings table.
2016-01-21 17:25:46,485 ERROR [geonetwork.settings] - Requested setting
with name: system/indexoptimizer/enable not found. Add it to the settings
table.
2016-01-21 17:25:46,485 ERROR [geonetwork.settings] - Requested setting
with name: system/server/host not found. Add it to the settings table.
2016-01-21 17:25:46,485 ERROR [geonetwork.settings] - Requested setting
with name: system/server/securePort not found. Add it to the settings
table.
2016-01-21 17:25:46,485 ERROR [geonetwork.settings] - Requested setting
with name: system/server/port not found. Add it to the settings table.
2016-01-21 17:25:46,485 ERROR [geonetwork.settings] - Requested setting
with name: system/site/svnUuid not found. Add it to the settings table.
2016-01-21 17:25:46,485 ERROR [jeeves.engine] - Raised exception while
starting the application. Fix the error and restart.
2016-01-21 17:25:46,485 ERROR [jeeves.engine] - Handler :
org.fao.geonet.Geonetwork
2016-01-21 17:25:46,485 ERROR [jeeves.engine] - Exception :
java.util.NoSuchElementException: There is no existing setting element with
the key: system/site/svnUuid
2016-01-21 17:25:46,500 ERROR [jeeves.engine] - Message : There is no
existing setting element with the key: system/site/svnUuid
2016-01-21 17:25:46,500 ERROR [jeeves.engine] - Stack :
java.util.NoSuchElementException: There is no existing setting element with
the key: system/site/svnUuid
at
org.fao.geonet.kernel.setting.SettingManager.setValue(SettingManager.java:280)
at org.fao.geonet.kernel.SvnManager.init(SvnManager.java:126)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:345)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:454)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:175)
at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:82)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at
org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4978)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5270)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1795)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
2016-01-21 17:25:46,500 ERROR [jeeves.engine] - {Message=There is no
existing setting element with the key: system/site/svnUuid, Error=Raised
exception while starting the application. Fix the error and restart.,
Handler=org.fao.geonet.Geonetwork,
Exception=java.util.NoSuchElementException: There is no existing setting
element with the key: system/site/svnUuid,
Stack=java.util.NoSuchElementException: There is no existing setting
element with the key: system/site/svnUuid
at
org.fao.geonet.kernel.setting.SettingManager.setValue(SettingManager.java:280)
at org.fao.geonet.kernel.SvnManager.init(SvnManager.java:126)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:345)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:454)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:175)
at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:82)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at
org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4978)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5270)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1795)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
}
On Thu, Jan 21, 2016 at 11:05 AM, BillyZ Design <billyz313@anonymised.com> wrote:
Thanx Luke. Since it wasn't logging i decided to video the screen when it
ran so i could read the outputs. I found that it wasn't logging due to
permissions. I corrected the permissions and now i have the log. I still
am not sure what the issue is, but I have more info that you might be able
to help me with. Here is the log.
2016-01-21 17:00:25,355 DEBUG [geonetwork.databasemigration] - DB
Migration / Running 'class org.apache.commons.dbcp.BasicDataSource' after
initialization of 'javax.sql.DataSource'.
2016-01-21 17:00:25,362 INFO [geonetwork.databasemigration] - -
Migration ...
2016-01-21 17:00:26,328 INFO [geonetwork.databasemigration] - Error
getting database version: Invalid column name 'id'.. Probably due to an old
version. Trying with new Settings structure.
2016-01-21 17:00:26,328 INFO [geonetwork.databasemigration] -
Webapp version:3.0.3-0 subversion:SNAPSHOT
2016-01-21 17:00:26,328 INFO [geonetwork.databasemigration] -
Database version:null subversion:null
2016-01-21 17:00:26,328 WARN [geonetwork.databasemigration] -
Database does not contain any version information. Check that the database
is a GeoNetwork database with data. The database is probably empty, no
migration required.
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: create table HarvesterData (harvesterUuid
varchar(255) not null, key varchar(255) not null, value varchar(255) not
null, primary key (harvesterUuid, key))
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Incorrect syntax near the keyword 'key'.
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table Services add id int not null
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Cannot find the object "Services" because it does not exist or you do not
have permissions.
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table Services add class varchar(1024) not
null
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Cannot find the object "Services" because it does not exist or you do not
have permissions.
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table Services add description varchar(1024)
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Cannot find the object "Services" because it does not exist or you do not
have permissions.
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table Services add explicitQuery varchar(255)
2016-01-21 17:00:29,494 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Cannot find the object "Services" because it does not exist or you do not
have permissions.
2016-01-21 17:00:29,509 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
HHH000388: Unsuccessful: alter table ServiceParameters add constraint
FK_t32t4xtdqmjhl8xmjpe95e474 foreign key (service) references Services
2016-01-21 17:00:29,509 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] -
Foreign key 'FK_t32t4xtdqmjhl8xmjpe95e474' references invalid table
'Services'.
2016-01-21 17:00:33,937 DEBUG [geonetwork.databasemigration] - DB
Migration / Running 'class
org.springframework.orm.jpa.JpaTransactionManager' after initialization of
'org.springframework.orm.jpa.JpaTransactionManager'.
2016-01-21 17:00:33,942 INFO [geonetwork.databasemigration] - -
Migration ...
2016-01-21 17:00:33,948 INFO [geonetwork.databasemigration] - Error
getting database version: Invalid column name 'id'.. Probably due to an old
version. Trying with new Settings structure.
2016-01-21 17:00:33,949 INFO [geonetwork.databasemigration] -
Webapp version:3.0.3-0 subversion:SNAPSHOT
2016-01-21 17:00:33,950 INFO [geonetwork.databasemigration] -
Database version:null subversion:null
2016-01-21 17:00:33,950 WARN [geonetwork.databasemigration] -
Database does not contain any version information. Check that the database
is a GeoNetwork database with data. The database is probably empty, no
migration required.
2016-01-21 17:00:39,923 WARN [jeeves.engine] - Jeeves DBMS service
configuration lookup failed (database may not be available yet). Message
is: could not extract ResultSet; SQL [n/a]; nested exception is
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
2016-01-21 17:00:39,986 WARN [geonetwork.data.directory] - - Data
directory properties is not set. Use geonetwork.dir or geonetwork.dir
properties.
2016-01-21 17:00:40,001 WARN [geonetwork.data.directory] - - Data
directory provided could not be used. Using default location:
C:\Tomcat\apache-tomcat-8.0.29\webapps\geonetwork\WEB-INF\data
2016-01-21 17:00:40,064 WARN [geonetwork.database] - Executing SQL from:
WEB-INF\classes\setup\sql\data data-db-
2016-01-21 17:00:40,672 WARN [geonetwork.database] - SQL failure for:
INSERT INTO Users (id, username, password, name, surname, profile, kind,
organisation, security, authtype, enabled) VALUES
(1,'admin','46e44386069f7cf0d4f2a420b9a2383a612f316e2024b0fe84052b0b96c479a23e8a0be8b90fb8c2','admin','admin',0,'','','','',
true), error is:org.hibernate.exception.SQLGrammarException: could not
execute statement
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1771)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:87)
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:116)
at org.fao.geonet.lib.DbLib.access$000(DbLib.java:50)
at org.fao.geonet.lib.DbLib$1.doInTransaction(DbLib.java:70)
at
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at org.fao.geonet.lib.DbLib.insertData(DbLib.java:65)
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:522)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:195)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:454)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:175)
at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:82)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at
org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4978)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5270)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1795)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at
org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
at
org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
at
org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:371)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:78)
... 27 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column
name 'true'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 32 more
2016-01-21 17:00:40,689 ERROR [jeeves] - Error occurred within a
transaction
java.lang.RuntimeException: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:122)
at org.fao.geonet.lib.DbLib.access$000(DbLib.java:50)
at org.fao.geonet.lib.DbLib$1.doInTransaction(DbLib.java:70)
at
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at org.fao.geonet.lib.DbLib.insertData(DbLib.java:65)
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:522)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:195)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:454)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:175)
at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:82)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at
org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4978)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5270)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1795)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1771)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:87)
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:116)
... 26 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at
org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
at
org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
at
org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:371)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:78)
... 27 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column
name 'true'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 32 more
2016-01-21 17:00:40,767 ERROR [geonetwork.database] - Error occurred while
trying to execute SQL
java.lang.RuntimeException: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:122)
at org.fao.geonet.lib.DbLib.access$000(DbLib.java:50)
at org.fao.geonet.lib.DbLib$1.doInTransaction(DbLib.java:70)
at
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at org.fao.geonet.lib.DbLib.insertData(DbLib.java:65)
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:522)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:195)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:454)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:175)
at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:82)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at
org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4978)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5270)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1795)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1771)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:87)
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:116)
... 26 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at
org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
at
org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
at
org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:371)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:78)
... 27 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column
name 'true'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 32 more
2016-01-21 17:00:40,782 ERROR [jeeves.engine] - Raised exception while
starting the application. Fix the error and restart.
2016-01-21 17:00:40,782 ERROR [jeeves.engine] - Handler :
org.fao.geonet.Geonetwork
2016-01-21 17:00:40,782 ERROR [jeeves.engine] - Exception :
java.lang.RuntimeException: java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
2016-01-21 17:00:40,782 ERROR [jeeves.engine] - Message :
java.lang.RuntimeException: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
2016-01-21 17:00:40,782 ERROR [jeeves.engine] - Stack :
java.lang.RuntimeException: java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:532)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:195)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:454)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:175)
at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:82)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at
org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4978)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5270)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1795)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:122)
at org.fao.geonet.lib.DbLib.access$000(DbLib.java:50)
at org.fao.geonet.lib.DbLib$1.doInTransaction(DbLib.java:70)
at
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at org.fao.geonet.lib.DbLib.insertData(DbLib.java:65)
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:522)
... 21 more
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1771)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:87)
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:116)
... 26 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at
org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
at
org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
at
org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:371)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:78)
... 27 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column
name 'true'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 32 more
2016-01-21 17:00:40,814 ERROR [jeeves.engine] -
{Message=java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement,
Error=Raised exception while starting the application. Fix the error and
restart., Handler=org.fao.geonet.Geonetwork,
Exception=java.lang.RuntimeException: java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement,
Stack=java.lang.RuntimeException: java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:532)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:195)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:454)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:175)
at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:82)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at
org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4978)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5270)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1795)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException:
javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:122)
at org.fao.geonet.lib.DbLib.access$000(DbLib.java:50)
at org.fao.geonet.lib.DbLib$1.doInTransaction(DbLib.java:70)
at
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at org.fao.geonet.lib.DbLib.insertData(DbLib.java:65)
at org.fao.geonet.Geonetwork.importDatabaseData(Geonetwork.java:522)
... 21 more
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute statement
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1771)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:87)
at org.fao.geonet.lib.DbLib.runSQL(DbLib.java:116)
... 26 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at
org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
at
org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
at
org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:371)
at
org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:78)
... 27 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column
name 'true'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 32 more
}
On Wed, Jan 20, 2016 at 9:22 PM, Luke <coolhandluka@anonymised.com> wrote:
Probably best to find your logs and determine what the full error is in
that case.
I have setup a handful of GN 3.0.2 instances with SQL Server but only
using Jetty.
On Thu, Jan 21, 2016 at 12:59 PM, BillyZ Design <billyz313@anonymised.com>
wrote:
Yes, I point to the correct server. It actually makes the tables on the
first run.
On Jan 20, 2016 7:10 PM, "Luke" <coolhandluka@anonymised.com> wrote:
I find that you have to edit the sqlserver.xml as the server name is
hardcoded and not bound to the property from jdbc.properties
The jdbcURL bean modification I make is as follows:
<bean id="jdbcURL" class="java.lang.String">
<!-- <constructor-arg
value="jdbc:sqlserver://SERVER;database=${jdbc.database};integratedSecurity=false;"/>-->
<constructor-arg
value="jdbc:sqlserver://${jdbc.host};database=${jdbc.database};integratedSecurity=false;"/>
</bean>
On Thu, Jan 21, 2016 at 12:02 PM, BillyZ Design <billyz313@anonymised.com>
wrote:
I have changed WEB-INF/config-node/srv.xml to sql server, changed the
connection properties in WEB-INF/config-db/jdbc.properties.
I have added the jdbc driver. When I point it at an empty db it
connects properly and creates tables.
I am using tomcat.
On Wed, Jan 20, 2016 at 6:41 PM, Luke <coolhandluka@anonymised.com> wrote:
Hi Billy
What steps have you undertaken to configure GN to connect to MSSQL?
Are you using Jetty version or tomcat?
If you are using Jetty the logs are found in
\installdir\jetty\logs\geonetwork.log
--
*Luke Bassett*
* <lukembassett@anonymised.com>*Melbourne Australia
--
*Luke Bassett*
* <lukembassett@anonymised.com>*Melbourne Australia
--
*Luke Bassett*
* <lukembassett@anonymised.com>*Melbourne Australia