Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PostgreSQL has been copied form H2 database was a failure. #755

Closed
MatsumotoHiroko opened this issue Jun 13, 2017 · 6 comments
Closed

PostgreSQL has been copied form H2 database was a failure. #755

MatsumotoHiroko opened this issue Jun 13, 2017 · 6 comments

Comments

@MatsumotoHiroko
Copy link

MatsumotoHiroko commented Jun 13, 2017 •
edited
Loading

I want to use PostgreSQL database which status to be copied successfully from H2 database
But my challenge was a complete failure.

I tried blow tasks.

I push the link about システム設定 > データベースの接続先変更.
I fill the parameters of PostgreSQL.
I push the 保存 button.
It happens warning.
Tomcat restart.

Then, I sign in the knowledge.
I push the link about システム設定 > データベースの接続先変更.
Head of the page view a message which is "Information 現在、カスタム設定が有効になっています".
I push the 組み込みDBで保存していたデータをカスタム設定のDBにコピー button.
The catalina.out was written many messages.(*1 This message is below.)
Then, I can see the complete message.
I push any link.
It happens Server Error.(*2 This message is below.)

Why is the reason?

my environment

CentOS Linux release 7.3.1611 (Core) 
PostgreSQL 9.6.3

*1

INFO  2017-06-13 10:12:06,874 [LoggingFilter(100)] GET	http://xxxxxxxxxx:8080/knowledge/admin.database/data_transfer	200	192.168.12.22	161[ms]
INFO  2017-06-13 10:12:06,958 [LoggingFilter(100)] GET	http://xxxxxxxxxx:8080/knowledge/open.account/icon/1	200	192.168.12.22	6[ms]
INFO  2017-06-13 10:12:07,249 [LoggingFilter(100)] GET	http://xxxxxxxxxx:8080/knowledge/data_transfer	101	192.168.12.22	36[ms]
INFO  2017-06-13 10:12:07,307 [DataTransferEndpoint(50)] websocket open: 0 : 1
INFO  2017-06-13 10:12:07,343 [DataTransferEndpoint(59)] /usr/local/tomcat/webapps/knowledge/
INFO  2017-06-13 10:12:08,323 [DataTransferEndpoint(68)] log4j:ERROR setFile(null,true) call failed.
INFO  2017-06-13 10:12:08,325 [DataTransferEndpoint(68)] java.io.FileNotFoundException: /app.log (許可がありません)
INFO  2017-06-13 10:12:08,326 [DataTransferEndpoint(68)] 	at java.io.FileOutputStream.open0(Native Method)
INFO  2017-06-13 10:12:08,326 [DataTransferEndpoint(68)] 	at java.io.FileOutputStream.open(FileOutputStream.java:270)
INFO  2017-06-13 10:12:08,326 [DataTransferEndpoint(68)] 	at java.io.FileOutputStream.<init>(FileOutputStream.java:213)
INFO  2017-06-13 10:12:08,327 [DataTransferEndpoint(68)] 	at java.io.FileOutputStream.<init>(FileOutputStream.java:133)
INFO  2017-06-13 10:12:08,327 [DataTransferEndpoint(68)] 	at org.apache.log4j.FileAppender.setFile(FileAppender.java:294)
INFO  2017-06-13 10:12:08,327 [DataTransferEndpoint(68)] 	at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:165)
INFO  2017-06-13 10:12:08,327 [DataTransferEndpoint(68)] 	at org.apache.log4j.DailyRollingFileAppender.activateOptions(DailyRollingFileAppender.java:223)
INFO  2017-06-13 10:12:08,328 [DataTransferEndpoint(68)] 	at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:307)
INFO  2017-06-13 10:12:08,328 [DataTransferEndpoint(68)] 	at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:295)
INFO  2017-06-13 10:12:08,328 [DataTransferEndpoint(68)] 	at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:176)
INFO  2017-06-13 10:12:08,329 [DataTransferEndpoint(68)] 	at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:191)
INFO  2017-06-13 10:12:08,329 [DataTransferEndpoint(68)] 	at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:523)
INFO  2017-06-13 10:12:08,329 [DataTransferEndpoint(68)] 	at org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:492)
INFO  2017-06-13 10:12:08,329 [DataTransferEndpoint(68)] 	at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1006)
INFO  2017-06-13 10:12:08,330 [DataTransferEndpoint(68)] 	at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:872)
INFO  2017-06-13 10:12:08,331 [DataTransferEndpoint(68)] 	at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:778)
INFO  2017-06-13 10:12:08,331 [DataTransferEndpoint(68)] 	at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526)
INFO  2017-06-13 10:12:08,331 [DataTransferEndpoint(68)] 	at org.apache.log4j.LogManager.<clinit>(LogManager.java:127)
INFO  2017-06-13 10:12:08,331 [DataTransferEndpoint(68)] 	at org.apache.log4j.Logger.getLogger(Logger.java:104)
INFO  2017-06-13 10:12:08,332 [DataTransferEndpoint(68)] 	at org.support.project.common.log.impl.log4j.Log4jLogInitializerImpl.createLog(Log4jLogInitializerImpl.java:11)
INFO  2017-06-13 10:12:08,332 [DataTransferEndpoint(68)] 	at org.support.project.common.log.LogFactory.getLog(LogFactory.java:44)
INFO  2017-06-13 10:12:08,332 [DataTransferEndpoint(68)] 	at org.support.project.knowledge.bat.AbstractBat.<clinit>(AbstractBat.java:16)
INFO  2017-06-13 10:12:08,332 [DataTransferEndpoint(68)] log4j:ERROR Either File or DatePattern options are not set for appender [APP_FILEOUT].
INFO  2017-06-13 10:12:08,333 [DataTransferEndpoint(68)] log4j:ERROR Either File or DatePattern options are not set for appender [APP_FILEOUT].
INFO  2017-06-13 10:12:08,375 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:08,366 [AbstractBat(32)] DataTransferBat is start.
INFO  2017-06-13 10:12:09,008 [DataTransferEndpoint(68)] Env [KNOWLEDGE_HOME] was not found.
INFO  2017-06-13 10:12:09,231 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:09,226 [DBConnenctionLogic(45)] Custom connection setting is exists.
INFO  2017-06-13 10:12:11,683 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:11,673 [DataTransferLogic(71)] migrate from db
INFO  2017-06-13 10:12:11,710 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:11,700 [DataTransferLogic(77)] migrate to db
INFO  2017-06-13 10:12:11,711 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:11,701 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:11,887 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:11,886 [Intercepter(213)] error. [object]class org.support.project.web.dao.SystemsDao_$$_jvst30a_0[proceed]_d17executeQuerySingle[param0]SELECT * FROM SYSTEMS WHERE SYSTEM_NAME = ?  AND DELETE_FLAG = 0[param1]class org.support.project.web.entity.SystemsEntity[param2][Ljava.lang.Object;@4034c28c
INFO  2017-06-13 10:12:11,888 [DataTransferEndpoint(68)] [throwable.getMessage()] ERROR: リレーション"systems"は存在しません
INFO  2017-06-13 10:12:11,888 [DataTransferEndpoint(68)]   ポジション: 15 [cause] ERROR: リレーション"systems"は存在しません
INFO  2017-06-13 10:12:11,889 [DataTransferEndpoint(68)]   ポジション: 15
INFO  2017-06-13 10:12:11,889 [DataTransferEndpoint(68)] ----- SQL Infomation -----
INFO  2017-06-13 10:12:11,889 [DataTransferEndpoint(68)] [sql]SELECT * FROM SYSTEMS WHERE SYSTEM_NAME = ?  AND DELETE_FLAG = 0
INFO  2017-06-13 10:12:11,889 [DataTransferEndpoint(68)] [params]
INFO  2017-06-13 10:12:11,890 [DataTransferEndpoint(68)] 	[params][0]knowledge
INFO  2017-06-13 10:12:11,890 [DataTransferEndpoint(68)] [execute]SELECT * FROM SYSTEMS WHERE SYSTEM_NAME = knowledge  AND DELETE_FLAG = 0
INFO  2017-06-13 10:12:11,890 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:11,891 [DataTransferEndpoint(68)] ERROR 2017-06-13 10:12:11,887 [Transaction(58)] Error(Rollback) : org.support.project.web.dao.SystemsDao_$$_jvst30a_0#_d46selectOnKey
INFO  2017-06-13 10:12:11,903 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:11,902 [Intercepter(213)] error. [object]class org.support.project.web.dao.SystemsDao_$$_jvst30a_0[proceed]_d46selectOnKey[param0]knowledge
INFO  2017-06-13 10:12:11,903 [DataTransferEndpoint(68)] [throwable.getMessage()] ERROR: リレーション"systems"は存在しません
INFO  2017-06-13 10:12:11,903 [DataTransferEndpoint(68)]   ポジション: 15 [cause] ERROR: リレーション"systems"は存在しません
INFO  2017-06-13 10:12:11,904 [DataTransferEndpoint(68)]   ポジション: 15
INFO  2017-06-13 10:12:11,904 [DataTransferEndpoint(68)] ----- SQL Infomation -----
INFO  2017-06-13 10:12:11,904 [DataTransferEndpoint(68)] [sql]SELECT * FROM SYSTEMS WHERE SYSTEM_NAME = ?  AND DELETE_FLAG = 0
INFO  2017-06-13 10:12:11,904 [DataTransferEndpoint(68)] [params]
INFO  2017-06-13 10:12:11,905 [DataTransferEndpoint(68)] 	[params][0]knowledge
INFO  2017-06-13 10:12:11,905 [DataTransferEndpoint(68)] [execute]SELECT * FROM SYSTEMS WHERE SYSTEM_NAME = knowledge  AND DELETE_FLAG = 0
INFO  2017-06-13 10:12:11,905 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:11,988 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:11,984 [InitializeDao(43)] Database initialize start.
INFO  2017-06-13 10:12:12,398 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:12,388 [InitializeDao(49)] /org/support/project/web/database/ddl.sql is loaded.
INFO  2017-06-13 10:12:13,137 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:13,136 [InitializeDao(49)] /org/support/project/knowledge/database/ddl.sql is loaded.
INFO  2017-06-13 10:12:13,154 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:13,154 [InitializeDao(49)] /org/support/project/knowledge/database/init_datas.sql is loaded.
INFO  2017-06-13 10:12:13,155 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:13,154 [InitializeDao(51)] Database initialize finish.
INFO  2017-06-13 10:12:13,950 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:13,950 [InitDB(142)] Migrate to 1.8.5
INFO  2017-06-13 10:12:13,974 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:13,967 [DataTransferLogic(88)] clear init data from to db.
INFO  2017-06-13 10:12:14,500 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,493 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.DatabaseControlDao
INFO  2017-06-13 10:12:14,501 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,496 [ConnectionManager(212)] change default connection. [form] custom  [to] connection
INFO  2017-06-13 10:12:14,501 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,496 [DataTransferLogic(168)] skip: org.support.project.knowledge.dao.gen.DatabaseControlDao
INFO  2017-06-13 10:12:14,501 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,496 [DataTransferLogic(169)] org.support.project.knowledge.dao.gen.DatabaseControlDao.physicalCountAll()
INFO  2017-06-13 10:12:14,502 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,496 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenAccountImagesDao
INFO  2017-06-13 10:12:14,528 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,524 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenCommentsDao
INFO  2017-06-13 10:12:14,544 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,543 [DataTransferLogic(152)]    -> insert data to custom
INFO  2017-06-13 10:12:14,545 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,543 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:14,561 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,556 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenDraftItemValuesDao
INFO  2017-06-13 10:12:14,562 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,561 [ConnectionManager(212)] change default connection. [form] custom  [to] connection
INFO  2017-06-13 10:12:14,574 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,570 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenDraftKnowledgesDao
INFO  2017-06-13 10:12:14,601 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,597 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenEventsDao
INFO  2017-06-13 10:12:14,620 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,616 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenItemChoicesDao
INFO  2017-06-13 10:12:14,673 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,672 [DataTransferLogic(152)]    -> insert data to custom
INFO  2017-06-13 10:12:14,673 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,672 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:14,709 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,704 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenKnowledgeEditGroupsDao
INFO  2017-06-13 10:12:14,710 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,709 [ConnectionManager(212)] change default connection. [form] custom  [to] connection
INFO  2017-06-13 10:12:14,720 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,716 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenKnowledgeEditUsersDao
INFO  2017-06-13 10:12:14,725 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,721 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenKnowledgeFilesDao
INFO  2017-06-13 10:12:14,752 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,751 [DataTransferLogic(152)]    -> insert data to custom
INFO  2017-06-13 10:12:14,753 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,751 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:14,795 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,790 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenKnowledgeGroupsDao
INFO  2017-06-13 10:12:14,796 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,795 [ConnectionManager(212)] change default connection. [form] custom  [to] connection
INFO  2017-06-13 10:12:14,800 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,797 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenKnowledgeHistoriesDao
INFO  2017-06-13 10:12:14,836 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,835 [DataTransferLogic(152)]    -> insert data to custom
INFO  2017-06-13 10:12:14,837 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,836 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:14,864 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,859 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenKnowledgeItemValuesDao
INFO  2017-06-13 10:12:14,865 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,864 [ConnectionManager(212)] change default connection. [form] custom  [to] connection
INFO  2017-06-13 10:12:14,882 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,881 [DataTransferLogic(152)]    -> insert data to custom
INFO  2017-06-13 10:12:14,882 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,881 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:14,926 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,922 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenKnowledgesDao
INFO  2017-06-13 10:12:14,926 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,926 [ConnectionManager(212)] change default connection. [form] custom  [to] connection
INFO  2017-06-13 10:12:14,934 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,933 [DataTransferLogic(152)]    -> insert data to custom
INFO  2017-06-13 10:12:14,935 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,934 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:14,961 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,957 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenKnowledgeTagsDao
INFO  2017-06-13 10:12:14,962 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,961 [ConnectionManager(212)] change default connection. [form] custom  [to] connection
INFO  2017-06-13 10:12:14,978 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:14,975 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenKnowledgeUsersDao
INFO  2017-06-13 10:12:15,005 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,004 [DataTransferLogic(152)]    -> insert data to custom
INFO  2017-06-13 10:12:15,005 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,004 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:15,016 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,013 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenLikesDao
INFO  2017-06-13 10:12:15,016 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,016 [ConnectionManager(212)] change default connection. [form] custom  [to] connection
INFO  2017-06-13 10:12:15,034 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,033 [DataTransferLogic(152)]    -> insert data to custom
INFO  2017-06-13 10:12:15,034 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,033 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:15,063 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,059 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenMailHookConditionsDao
INFO  2017-06-13 10:12:15,064 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,063 [ConnectionManager(212)] change default connection. [form] custom  [to] connection
INFO  2017-06-13 10:12:15,068 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,065 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenMailHooksDao
INFO  2017-06-13 10:12:15,086 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,084 [DataTransferLogic(124)] Data transfer : org.support.project.knowledge.dao.gen.GenMailLocaleTemplatesDao
INFO  2017-06-13 10:12:15,191 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,190 [DataTransferLogic(152)]    -> insert data to custom
INFO  2017-06-13 10:12:15,191 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,190 [ConnectionManager(212)] change default connection. [form] connection  [to] custom
INFO  2017-06-13 10:12:15,197 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,193 [Intercepter(213)] error. [object]class org.support.project.knowledge.dao.gen.GenMailLocaleTemplatesDao_$$_jvst30a_20[proceed]_d17executeUpdate[param0]INSERT INTO MAIL_LOCALE_TEMPLATES ( KEY , TEMPLATE_ID , TITLE , CONTENT , INSERT_USER , INSERT_DATETIME , UPDATE_USER , UPDATE_DATETIME , DELETE_FLAG ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? )[param1][Ljava.lang.Object;@59662a0b
INFO  2017-06-13 10:12:15,197 [DataTransferEndpoint(68)] [throwable.getMessage()] ERROR: 重複キーが一意性制約"mail_locale_templates_pkc"に違反しています
INFO  2017-06-13 10:12:15,197 [DataTransferEndpoint(68)]   詳細: キー (template_id, key)=(notify_event, ja) はすでに存在します [cause] ERROR: 重複キーが一意性制約"mail_locale_templates_pkc"に違反しています
INFO  2017-06-13 10:12:15,197 [DataTransferEndpoint(68)]   詳細: キー (template_id, key)=(notify_event, ja) はすでに存在します
INFO  2017-06-13 10:12:15,198 [DataTransferEndpoint(68)] ----- SQL Infomation -----
INFO  2017-06-13 10:12:15,198 [DataTransferEndpoint(68)] [sql]INSERT INTO MAIL_LOCALE_TEMPLATES ( KEY , TEMPLATE_ID , TITLE , CONTENT , INSERT_USER , INSERT_DATETIME , UPDATE_USER , UPDATE_DATETIME , DELETE_FLAG ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? )
INFO  2017-06-13 10:12:15,198 [DataTransferEndpoint(68)] [params]
INFO  2017-06-13 10:12:15,198 [DataTransferEndpoint(68)] 	[params][0]ja
INFO  2017-06-13 10:12:15,198 [DataTransferEndpoint(68)] 	[params][1]notify_event
INFO  2017-06-13 10:12:15,199 [DataTransferEndpoint(68)] 	[params][2][Knowledge] 開催通知 {Date} {Start} #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,199 [DataTransferEndpoint(68)] 	[params][3]
INFO  2017-06-13 10:12:15,199 [DataTransferEndpoint(68)] {UserName} 様
INFO  2017-06-13 10:12:15,199 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,199 [DataTransferEndpoint(68)] あなたの {Status} の以下のイベントが {Timing} 開催されます。
INFO  2017-06-13 10:12:15,200 [DataTransferEndpoint(68)] イベントの詳細は以下のURLをご確認ください。
INFO  2017-06-13 10:12:15,200 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,200 [DataTransferEndpoint(68)] {URL}
INFO  2017-06-13 10:12:15,200 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,200 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,201 [DataTransferEndpoint(68)] #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,201 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,201 [DataTransferEndpoint(68)] 開催日時: {Date} {Start} - {End}
INFO  2017-06-13 10:12:15,201 [DataTransferEndpoint(68)] 開催場所: {Place}
INFO  2017-06-13 10:12:15,202 [DataTransferEndpoint(68)] ステータス: {Status}
INFO  2017-06-13 10:12:15,202 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,202 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,202 [DataTransferEndpoint(68)] ※本メールはシステムより自動で送信されています。
INFO  2017-06-13 10:12:15,202 [DataTransferEndpoint(68)]  このメールに対する返信は出来ませんので御了承ください。
INFO  2017-06-13 10:12:15,203 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,203 [DataTransferEndpoint(68)] 	[params][4]0
INFO  2017-06-13 10:12:15,203 [DataTransferEndpoint(68)] 	[params][5]2017-05-12 05:40:34.314
INFO  2017-06-13 10:12:15,203 [DataTransferEndpoint(68)] 	[params][6]0
INFO  2017-06-13 10:12:15,203 [DataTransferEndpoint(68)] 	[params][7]2017-05-12 05:40:34.314
INFO  2017-06-13 10:12:15,204 [DataTransferEndpoint(68)] 	[params][8]0
INFO  2017-06-13 10:12:15,204 [DataTransferEndpoint(68)] [execute]INSERT INTO MAIL_LOCALE_TEMPLATES ( KEY , TEMPLATE_ID , TITLE , CONTENT , INSERT_USER , INSERT_DATETIME , UPDATE_USER , UPDATE_DATETIME , DELETE_FLAG ) VALUES ( ja , notify_event , [Knowledge] 開催通知 {Date} {Start} #{KnowledgeId}: {KnowledgeTitle} , 
INFO  2017-06-13 10:12:15,204 [DataTransferEndpoint(68)] {UserName} 様
INFO  2017-06-13 10:12:15,204 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,205 [DataTransferEndpoint(68)] あなたの {Status} の以下のイベントが {Timing} 開催されます。
INFO  2017-06-13 10:12:15,205 [DataTransferEndpoint(68)] イベントの詳細は以下のURLをご確認ください。
INFO  2017-06-13 10:12:15,205 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,205 [DataTransferEndpoint(68)] {URL}
INFO  2017-06-13 10:12:15,205 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,206 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,206 [DataTransferEndpoint(68)] #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,206 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,206 [DataTransferEndpoint(68)] 開催日時: {Date} {Start} - {End}
INFO  2017-06-13 10:12:15,206 [DataTransferEndpoint(68)] 開催場所: {Place}
INFO  2017-06-13 10:12:15,207 [DataTransferEndpoint(68)] ステータス: {Status}
INFO  2017-06-13 10:12:15,207 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,207 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,207 [DataTransferEndpoint(68)] ※本メールはシステムより自動で送信されています。
INFO  2017-06-13 10:12:15,224 [DataTransferEndpoint(68)]  このメールに対する返信は出来ませんので御了承ください。
INFO  2017-06-13 10:12:15,224 [DataTransferEndpoint(68)]  , 0 , 2017-05-12 05:40:34.314 , 0 , 2017-05-12 05:40:34.314 , 0 )
INFO  2017-06-13 10:12:15,224 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,224 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,194 [Intercepter(213)] error. [object]class org.support.project.knowledge.dao.gen.GenMailLocaleTemplatesDao_$$_jvst30a_20[proceed]_d40rawPhysicalInsert[param0]key = ja
INFO  2017-06-13 10:12:15,224 [DataTransferEndpoint(68)] templateId = notify_event
INFO  2017-06-13 10:12:15,225 [DataTransferEndpoint(68)] title = [Knowledge] 開催通知 {Date} {Start} #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,225 [DataTransferEndpoint(68)] content = 
INFO  2017-06-13 10:12:15,225 [DataTransferEndpoint(68)] {UserName} 様
INFO  2017-06-13 10:12:15,225 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,226 [DataTransferEndpoint(68)] あなたの {Status} の以下のイベントが {Timing} 開催されます。
INFO  2017-06-13 10:12:15,226 [DataTransferEndpoint(68)] イベントの詳細は以下のURLをご確認ください。
INFO  2017-06-13 10:12:15,226 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,226 [DataTransferEndpoint(68)] {URL}
INFO  2017-06-13 10:12:15,226 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,227 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,227 [DataTransferEndpoint(68)] #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,227 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,227 [DataTransferEndpoint(68)] 開催日時: {Date} {Start} - {End}
INFO  2017-06-13 10:12:15,227 [DataTransferEndpoint(68)] 開催場所: {Place}
INFO  2017-06-13 10:12:15,228 [DataTransferEndpoint(68)] ステータス: {Status}
INFO  2017-06-13 10:12:15,228 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,228 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,228 [DataTransferEndpoint(68)] ※本メールはシステムより自動で送信されています。
INFO  2017-06-13 10:12:15,228 [DataTransferEndpoint(68)]  このメールに対する返信は出来ませんので御了承ください。
INFO  2017-06-13 10:12:15,229 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,229 [DataTransferEndpoint(68)] insertUser = 0
INFO  2017-06-13 10:12:15,229 [DataTransferEndpoint(68)] insertDatetime = 2017-05-12 05:40:34.314
INFO  2017-06-13 10:12:15,229 [DataTransferEndpoint(68)] updateUser = 0
INFO  2017-06-13 10:12:15,229 [DataTransferEndpoint(68)] updateDatetime = 2017-05-12 05:40:34.314
INFO  2017-06-13 10:12:15,230 [DataTransferEndpoint(68)] deleteFlag = 0
INFO  2017-06-13 10:12:15,230 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,230 [DataTransferEndpoint(68)] [throwable.getMessage()] ERROR: 重複キーが一意性制約"mail_locale_templates_pkc"に違反しています
INFO  2017-06-13 10:12:15,230 [DataTransferEndpoint(68)]   詳細: キー (template_id, key)=(notify_event, ja) はすでに存在します [cause] ERROR: 重複キーが一意性制約"mail_locale_templates_pkc"に違反しています
INFO  2017-06-13 10:12:15,231 [DataTransferEndpoint(68)]   詳細: キー (template_id, key)=(notify_event, ja) はすでに存在します
INFO  2017-06-13 10:12:15,231 [DataTransferEndpoint(68)] ----- SQL Infomation -----
INFO  2017-06-13 10:12:15,231 [DataTransferEndpoint(68)] [sql]INSERT INTO MAIL_LOCALE_TEMPLATES ( KEY , TEMPLATE_ID , TITLE , CONTENT , INSERT_USER , INSERT_DATETIME , UPDATE_USER , UPDATE_DATETIME , DELETE_FLAG ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? )
INFO  2017-06-13 10:12:15,231 [DataTransferEndpoint(68)] [params]
INFO  2017-06-13 10:12:15,232 [DataTransferEndpoint(68)] 	[params][0]ja
INFO  2017-06-13 10:12:15,232 [DataTransferEndpoint(68)] 	[params][1]notify_event
INFO  2017-06-13 10:12:15,232 [DataTransferEndpoint(68)] 	[params][2][Knowledge] 開催通知 {Date} {Start} #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,232 [DataTransferEndpoint(68)] 	[params][3]
INFO  2017-06-13 10:12:15,232 [DataTransferEndpoint(68)] {UserName} 様
INFO  2017-06-13 10:12:15,233 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,233 [DataTransferEndpoint(68)] あなたの {Status} の以下のイベントが {Timing} 開催されます。
INFO  2017-06-13 10:12:15,233 [DataTransferEndpoint(68)] イベントの詳細は以下のURLをご確認ください。
INFO  2017-06-13 10:12:15,233 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,233 [DataTransferEndpoint(68)] {URL}
INFO  2017-06-13 10:12:15,234 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,234 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,234 [DataTransferEndpoint(68)] #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,234 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,249 [DataTransferEndpoint(68)] 開催日時: {Date} {Start} - {End}
INFO  2017-06-13 10:12:15,249 [DataTransferEndpoint(68)] 開催場所: {Place}
INFO  2017-06-13 10:12:15,249 [DataTransferEndpoint(68)] ステータス: {Status}
INFO  2017-06-13 10:12:15,250 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,250 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,250 [DataTransferEndpoint(68)] ※本メールはシステムより自動で送信されています。
INFO  2017-06-13 10:12:15,250 [DataTransferEndpoint(68)]  このメールに対する返信は出来ませんので御了承ください。
INFO  2017-06-13 10:12:15,250 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,251 [DataTransferEndpoint(68)] 	[params][4]0
INFO  2017-06-13 10:12:15,251 [DataTransferEndpoint(68)] 	[params][5]2017-05-12 05:40:34.314
INFO  2017-06-13 10:12:15,251 [DataTransferEndpoint(68)] 	[params][6]0
INFO  2017-06-13 10:12:15,251 [DataTransferEndpoint(68)] 	[params][7]2017-05-12 05:40:34.314
INFO  2017-06-13 10:12:15,251 [DataTransferEndpoint(68)] 	[params][8]0
INFO  2017-06-13 10:12:15,252 [DataTransferEndpoint(68)] [execute]INSERT INTO MAIL_LOCALE_TEMPLATES ( KEY , TEMPLATE_ID , TITLE , CONTENT , INSERT_USER , INSERT_DATETIME , UPDATE_USER , UPDATE_DATETIME , DELETE_FLAG ) VALUES ( ja , notify_event , [Knowledge] 開催通知 {Date} {Start} #{KnowledgeId}: {KnowledgeTitle} , 
INFO  2017-06-13 10:12:15,252 [DataTransferEndpoint(68)] {UserName} 様
INFO  2017-06-13 10:12:15,252 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,252 [DataTransferEndpoint(68)] あなたの {Status} の以下のイベントが {Timing} 開催されます。
INFO  2017-06-13 10:12:15,252 [DataTransferEndpoint(68)] イベントの詳細は以下のURLをご確認ください。
INFO  2017-06-13 10:12:15,253 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,253 [DataTransferEndpoint(68)] {URL}
INFO  2017-06-13 10:12:15,253 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,253 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,254 [DataTransferEndpoint(68)] #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,254 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,254 [DataTransferEndpoint(68)] 開催日時: {Date} {Start} - {End}
INFO  2017-06-13 10:12:15,254 [DataTransferEndpoint(68)] 開催場所: {Place}
INFO  2017-06-13 10:12:15,254 [DataTransferEndpoint(68)] ステータス: {Status}
INFO  2017-06-13 10:12:15,255 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,255 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,255 [DataTransferEndpoint(68)] ※本メールはシステムより自動で送信されています。
INFO  2017-06-13 10:12:15,255 [DataTransferEndpoint(68)]  このメールに対する返信は出来ませんので御了承ください。
INFO  2017-06-13 10:12:15,255 [DataTransferEndpoint(68)]  , 0 , 2017-05-12 05:40:34.314 , 0 , 2017-05-12 05:40:34.314 , 0 )
INFO  2017-06-13 10:12:15,256 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,256 [DataTransferEndpoint(68)] ERROR 2017-06-13 10:12:15,195 [DataTransferBat(87)] ERROR
INFO  2017-06-13 10:12:15,256 [DataTransferEndpoint(68)] java.lang.reflect.InvocationTargetException
INFO  2017-06-13 10:12:15,256 [DataTransferEndpoint(68)] 	at org.support.project.knowledge.logic.DataTransferLogic.transferData(DataTransferLogic.java:162)
INFO  2017-06-13 10:12:15,256 [DataTransferEndpoint(68)] 	at org.support.project.knowledge.bat.DataTransferBat.start(DataTransferBat.java:84)
INFO  2017-06-13 10:12:15,257 [DataTransferEndpoint(68)] 	at org.support.project.knowledge.bat.DataTransferBat.main(DataTransferBat.java:27)
INFO  2017-06-13 10:12:15,257 [DataTransferEndpoint(68)] Caused by: org.support.project.ormapping.exception.ORMappingException: ERROR: 重複キーが一意性制約"mail_locale_templates_pkc"に違反しています
INFO  2017-06-13 10:12:15,257 [DataTransferEndpoint(68)]   詳細: キー (template_id, key)=(notify_event, ja) はすでに存在します [cause] ERROR: 重複キーが一意性制約"mail_locale_templates_pkc"に違反しています
INFO  2017-06-13 10:12:15,257 [DataTransferEndpoint(68)]   詳細: キー (template_id, key)=(notify_event, ja) はすでに存在します
INFO  2017-06-13 10:12:15,257 [DataTransferEndpoint(68)] ----- SQL Infomation -----
INFO  2017-06-13 10:12:15,258 [DataTransferEndpoint(68)] [sql]INSERT INTO MAIL_LOCALE_TEMPLATES ( KEY , TEMPLATE_ID , TITLE , CONTENT , INSERT_USER , INSERT_DATETIME , UPDATE_USER , UPDATE_DATETIME , DELETE_FLAG ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? )
INFO  2017-06-13 10:12:15,258 [DataTransferEndpoint(68)] [params]
INFO  2017-06-13 10:12:15,258 [DataTransferEndpoint(68)] 	[params][0]ja
INFO  2017-06-13 10:12:15,258 [DataTransferEndpoint(68)] 	[params][1]notify_event
INFO  2017-06-13 10:12:15,259 [DataTransferEndpoint(68)] 	[params][2][Knowledge] 開催通知 {Date} {Start} #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,259 [DataTransferEndpoint(68)] 	[params][3]
INFO  2017-06-13 10:12:15,259 [DataTransferEndpoint(68)] {UserName} 様
INFO  2017-06-13 10:12:15,259 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,273 [DataTransferEndpoint(68)] あなたの {Status} の以下のイベントが {Timing} 開催されます。
INFO  2017-06-13 10:12:15,273 [DataTransferEndpoint(68)] イベントの詳細は以下のURLをご確認ください。
INFO  2017-06-13 10:12:15,274 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,274 [DataTransferEndpoint(68)] {URL}
INFO  2017-06-13 10:12:15,274 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,274 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,274 [DataTransferEndpoint(68)] #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,275 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,275 [DataTransferEndpoint(68)] 開催日時: {Date} {Start} - {End}
INFO  2017-06-13 10:12:15,275 [DataTransferEndpoint(68)] 開催場所: {Place}
INFO  2017-06-13 10:12:15,275 [DataTransferEndpoint(68)] ステータス: {Status}
INFO  2017-06-13 10:12:15,276 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,276 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,276 [DataTransferEndpoint(68)] ※本メールはシステムより自動で送信されています。
INFO  2017-06-13 10:12:15,276 [DataTransferEndpoint(68)]  このメールに対する返信は出来ませんので御了承ください。
INFO  2017-06-13 10:12:15,276 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,277 [DataTransferEndpoint(68)] 	[params][4]0
INFO  2017-06-13 10:12:15,277 [DataTransferEndpoint(68)] 	[params][5]2017-05-12 05:40:34.314
INFO  2017-06-13 10:12:15,277 [DataTransferEndpoint(68)] 	[params][6]0
INFO  2017-06-13 10:12:15,277 [DataTransferEndpoint(68)] 	[params][7]2017-05-12 05:40:34.314
INFO  2017-06-13 10:12:15,277 [DataTransferEndpoint(68)] 	[params][8]0
INFO  2017-06-13 10:12:15,278 [DataTransferEndpoint(68)] [execute]INSERT INTO MAIL_LOCALE_TEMPLATES ( KEY , TEMPLATE_ID , TITLE , CONTENT , INSERT_USER , INSERT_DATETIME , UPDATE_USER , UPDATE_DATETIME , DELETE_FLAG ) VALUES ( ja , notify_event , [Knowledge] 開催通知 {Date} {Start} #{KnowledgeId}: {KnowledgeTitle} , 
INFO  2017-06-13 10:12:15,278 [DataTransferEndpoint(68)] {UserName} 様
INFO  2017-06-13 10:12:15,278 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,278 [DataTransferEndpoint(68)] あなたの {Status} の以下のイベントが {Timing} 開催されます。
INFO  2017-06-13 10:12:15,278 [DataTransferEndpoint(68)] イベントの詳細は以下のURLをご確認ください。
INFO  2017-06-13 10:12:15,279 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,279 [DataTransferEndpoint(68)] {URL}
INFO  2017-06-13 10:12:15,279 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,279 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,279 [DataTransferEndpoint(68)] #{KnowledgeId}: {KnowledgeTitle}
INFO  2017-06-13 10:12:15,280 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,280 [DataTransferEndpoint(68)] 開催日時: {Date} {Start} - {End}
INFO  2017-06-13 10:12:15,280 [DataTransferEndpoint(68)] 開催場所: {Place}
INFO  2017-06-13 10:12:15,280 [DataTransferEndpoint(68)] ステータス: {Status}
INFO  2017-06-13 10:12:15,280 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,281 [DataTransferEndpoint(68)] ------------------------------------------
INFO  2017-06-13 10:12:15,281 [DataTransferEndpoint(68)] ※本メールはシステムより自動で送信されています。
INFO  2017-06-13 10:12:15,281 [DataTransferEndpoint(68)]  このメールに対する返信は出来ませんので御了承ください。
INFO  2017-06-13 10:12:15,281 [DataTransferEndpoint(68)]  , 0 , 2017-05-12 05:40:34.314 , 0 , 2017-05-12 05:40:34.314 , 0 )
INFO  2017-06-13 10:12:15,281 [DataTransferEndpoint(68)] 
INFO  2017-06-13 10:12:15,282 [DataTransferEndpoint(68)] 	at org.support.project.ormapping.dao.AbstractDao.executeUpdate(AbstractDao.java:481)
INFO  2017-06-13 10:12:15,282 [DataTransferEndpoint(68)] 	at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:48)
INFO  2017-06-13 10:12:15,282 [DataTransferEndpoint(68)] 	at org.support.project.knowledge.dao.gen.GenMailLocaleTemplatesDao.rawPhysicalInsert(GenMailLocaleTemplatesDao.java:150)
INFO  2017-06-13 10:12:15,282 [DataTransferEndpoint(68)] 	at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:48)
INFO  2017-06-13 10:12:15,282 [DataTransferEndpoint(68)] 	... 3 more
INFO  2017-06-13 10:12:15,283 [DataTransferEndpoint(68)] Caused by: org.postgresql.util.PSQLException: ERROR: 重複キーが一意性制約"mail_locale_templates_pkc"に違反しています
INFO  2017-06-13 10:12:15,283 [DataTransferEndpoint(68)]   詳細: キー (template_id, key)=(notify_event, ja) はすでに存在します
INFO  2017-06-13 10:12:15,283 [DataTransferEndpoint(68)] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
INFO  2017-06-13 10:12:15,283 [DataTransferEndpoint(68)] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
INFO  2017-06-13 10:12:15,295 [DataTransferEndpoint(68)] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
INFO  2017-06-13 10:12:15,296 [DataTransferEndpoint(68)] 	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562)
INFO  2017-06-13 10:12:15,296 [DataTransferEndpoint(68)] 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
INFO  2017-06-13 10:12:15,296 [DataTransferEndpoint(68)] 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
INFO  2017-06-13 10:12:15,296 [DataTransferEndpoint(68)] 	at org.support.project.ormapping.dao.AbstractDao.executeUpdate(AbstractDao.java:470)
INFO  2017-06-13 10:12:15,296 [DataTransferEndpoint(68)] 	... 6 more
INFO  2017-06-13 10:12:15,932 [DataTransferEndpoint(68)] INFO  2017-06-13 10:12:15,931 [DataTransferBat(54)] Database stop.

*2

ERROR 2017-06-13 10:15:46,285 [ControlManagerFilter(206)] ERROR SEND
ERROR 2017-06-13 10:15:46,306 [LoggingFilter(64)] Any exception is thrown. [javax.servlet.ServletException]
javax.servlet.ServletException: javax.servlet.ServletException: org.support.project.common.exception.SystemException: 
	at org.support.project.web.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:300)
	at org.support.project.knowledge.listener.CloseAbleAuthenticationFilter.doFilter(CloseAbleAuthenticationFilter.java:98)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.support.project.web.filter.LoggingFilter.doFilter(LoggingFilter.java:62)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.support.project.web.filter.SeqFilter.doFilter(SeqFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.support.project.web.filter.EncodingFilter.doFilter(EncodingFilter.java:36)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: javax.servlet.ServletException: org.support.project.common.exception.SystemException: 
	at org.support.project.web.filter.ControlManagerFilter.doFilter(ControlManagerFilter.java:216)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.support.project.web.filter.MultipartFilter.doFilter(MultipartFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.support.project.web.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:184)
	... 28 more
Caused by: org.support.project.common.exception.SystemException: 
	at org.support.project.common.util.ObjectUtils.invoke(ObjectUtils.java:136)
	at org.support.project.web.common.InvokeTarget.invoke(InvokeTarget.java:106)
	at org.support.project.web.filter.ControlManagerFilter.doInvoke(ControlManagerFilter.java:345)
	at org.support.project.web.filter.ControlFilter.invoke(ControlFilter.java:31)
	at org.support.project.web.filter.ControlManagerFilter.doFilter(ControlManagerFilter.java:184)
	... 34 more
Caused by: java.lang.reflect.InvocationTargetException
	at org.support.project.common.util.ObjectUtils.invoke(ObjectUtils.java:132)
	... 38 more
Caused by: org.support.project.web.exception.AuthenticateException: 
	at org.support.project.web.logic.impl.AbstractAuthenticationLogic.setSession(AbstractAuthenticationLogic.java:156)
	at org.support.project.web.control.Control.updateLoginInfo(Control.java:500)
	at org.support.project.knowledge.control.open.KnowledgeControl.list(KnowledgeControl.java:313)
	... 39 more
Caused by: java.lang.NullPointerException
	at org.support.project.web.bean.LoginedUser.getLoginUser(LoginedUser.java:87)
	at org.support.project.web.logic.impl.AbstractAuthenticationLogic.setUserInfo(AbstractAuthenticationLogic.java:233)
	at org.support.project.web.logic.impl.AbstractAuthenticationLogic.setSession(AbstractAuthenticationLogic.java:154)
	... 41 more
INFO  2017-06-13 10:15:46,310 [LoggingFilter(100)] GET	http://192.168.11.202:8080/knowledge/open.knowledge/list	500	192.168.12.22	62[ms]
ERROR 2017-06-13 10:15:46,567 [LoggingFilter(64)] Any exception is thrown. [javax.servlet.ServletException]
javax.servlet.ServletException: java.lang.NullPointerException
	at org.support.project.web.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:300)
	at org.support.project.knowledge.listener.CloseAbleAuthenticationFilter.doFilter(CloseAbleAuthenticationFilter.java:98)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.support.project.web.filter.LoggingFilter.doFilter(LoggingFilter.java:62)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.support.project.web.filter.SeqFilter.doFilter(SeqFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.support.project.web.filter.EncodingFilter.doFilter(EncodingFilter.java:36)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException
	at org.support.project.web.bean.LoginedUser.getLoginUser(LoginedUser.java:87)
	at org.support.project.web.logic.impl.AbstractAuthenticationLogic.isLogined(AbstractAuthenticationLogic.java:113)
	at org.support.project.web.filter.AuthenticationFilter.isLogin(AuthenticationFilter.java:309)
	at org.support.project.web.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:175)
	... 28 more
INFO  2017-06-13 10:15:46,568 [LoggingFilter(100)] GET	http://192.168.11.202:8080/knowledge/open.account/icon/-2147483648	200	192.168.12.22	2[ms]
@koda-masaru
Copy link
Contributor

I confirmed the log, I think that an error occurred when copying master data from H2 Database to PostgreSQL.
It is probably a bug in data copy processing. I will try to analyze and fix it.

@MatsumotoHiroko
Copy link
Author

MatsumotoHiroko commented Jun 13, 2017 •
edited
Loading

koda-masaru-san

Thank you for checking my failure.
I really appreciate your help.

So, I have found this issue.
#550
I also will try tomorrow.

@Monota
Copy link
Contributor

Monota commented Jun 13, 2017

最新版 1.9.X をご利用でしょうか？
1.8.X であれば #714 で近いログを見たように記憶しています。ログを見た感じだと 5/12 にレコードを Insert しているようなので気になりました。

@MatsumotoHiroko
Copy link
Author

Monota様、ただいま調べたところ、1.8.1がインストールされている状態でした。
ご指摘いただきまことにありがとうございます。
最新版にアップグレードしてもう一度調査いたします。

@MatsumotoHiroko
Copy link
Author

最新版にしたところ、無事にデータベースの切り替えが成功しました。
本当にありがとうございます。
このような件でissueをあげてお手を煩わせてしまい大変失礼しました。

I tried to make version up.
After that, my failure doesn't happen.
Thank you for their helping, koda-masaru-san and Monota-san.
I really appreciate it.

@koda-masaru
Copy link
Contributor

Monotaさん
ご指摘ありがとうございました。
データ移行の不具合対応をしたことをすっかり忘れてたので、とっても助かりました 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@MatsumotoHiroko @Monota @koda-masaru