License Error on migrating HSQL to MySQL db
13 January, 2011
Hello All
We have yellowfin test machine which actually using HSQL database, and has created a lot of reports in it. But management has decided to move to MySQL database now.
So I tried to migrate yellowfin database from HSQL to MySQL database,
after finishing upload all HSQL table records to the appropriate table in MySQL and make sure all the table's record count is the same between HSQL db and MySQL db, I also updated the web.xml like this
JDBCDriverClass
com.mysql.jdbc.Driver
JDBCUrl
jdbc:mysql://localhost/yellowfin?characterEncoding=utf8
JDBCUser
blablabla
JDBCPassword
blablabla
then
try to to startup the tomcat
but I got some error on catalina.out regarding the License :
=================== i4 JDBC Connection Pool ================================
|
| Description : Yellowfin Connection Pool
| JDBC Driver : com.mysql.jdbc.Driver
| Url : jdbc:mysql://localhost/yellowfin
| User : blablabla
| Min Count : 2
| Max Count : 5
| Timeout : null
| PS Cache Size: null
| Performing JDBC connections... OK
|
| The i4 JDBC Connection pool has been successfully started.
|
========================================================================
YF:2011-01-13 12:55:01: INFO (hofStartup:init) - === hofStartup Starting Up ===
============================== i4 Startup ==============================
|
| Current Code Version: 20100827
| Original Code Version: 20100827
| Schema Version: 20090617
| Boot Time: Thu Jan 13 12:55:01 EST 2011
| java.vm.name: OpenJDK Client VM
| java.vm.vendor: Sun Microsystems Inc.
| java.vm.version: 16.0-b13
| os.name: Linux
| os.arch: i386
| os.version: 2.6.32-308-ec2
| AppType: Reports
|
| Instantiating WeakKeyCache...
|
| Initialising RefCodeList...YF:2011-01-13 12:55:01: INFO (PropertyMessageResources:) - Initializing, config='com.hof.ApplicationResources', returnNull=true
OK
| Available languages: EN
| Default language: EN
|
|
| The i4 Utility classes listed above have been initialised.
|
========================================================================
YF:2011-01-13 12:55:02: INFO (JDBCEventCreation:createEvent) - EventId=16010,Time=1294883702279,SessionId=,EventTypeCode=SYSTEM,EventCode=STARTUP,IpSource=,UnitId=1,ReferenceId=99,Data=[StartupTime=Thu Jan 13 12:55:01 EST 2011,Build=20100827,Version=5.0]
============================== i4 Licence Check ==============================
|
YF:2011-01-13 12:55:02: INFO (LicenceControl:B) - Resetting Licence Contol
YF:2011-01-13 12:55:02:ERROR (License:A) - Error loading licence document: com.hof.util.LicenseNotFoundException: License Not Found
YF:2011-01-13 12:55:02:ERROR (LicenceControl:getInstance) - *** Error creating Licence: java.lang.RuntimeException: License Not Found
| Invalid or missing licence file: java.lang.Exception: License is invalid
|
========================================================================
..
..
..
yellowfin.log shows :
YF:2011-01-13 12:55:01: INFO (hofStartup:init) - === hofStartup Starting Up ===
YF:2011-01-13 12:55:01: INFO (PropertyMessageResources:) - Initializing, config='com.hof.ApplicationResources', returnNull=true
YF:2011-01-13 12:55:02: INFO (JDBCEventCreation:createEvent) - EventId=16010,Time=1294883702279,SessionId=,EventTypeCode=SYSTEM,EventCode=STARTUP,IpSource=,UnitId=1,ReferenceId=99,Data=[StartupTime=Thu Jan 13 12:55:01 EST 2011,Build=20100827,Version=5.0]
YF:2011-01-13 12:55:02: INFO (LicenceControl:B) - Resetting Licence Contol
YF:2011-01-13 12:55:02:ERROR (License:A) - Error loading licence document: com.hof.util.LicenseNotFoundException: License Not Found
YF:2011-01-13 12:55:02:ERROR (LicenceControl:getInstance) - *** Error creating Licence: java.lang.RuntimeException: License Not Found
YF:2011-01-13 12:57:00: INFO (TaskScheduler:A) - TaskScheduler polling TaskSchedule table
YF:2011-01-13 12:58:00: INFO (TaskScheduler:A) - TaskScheduler polling TaskSchedule table
^C
How to resolve the issues ? Have anybody deal with kind of migration ?
Thanks
Hi,
We have not done the migration from HSQL to MySQL before, though I had read it was possible to do.
In regards to the error message, it seems it is not able to read the licence data.
Can you please check the following 3 tables;
-DocumentData
-DocumentRevision
-DocumentItem
For anything that looks suspicious.
e.g. Duplicates, Null records.
Regards,
David
We have not done the migration from HSQL to MySQL before, though I had read it was possible to do.
In regards to the error message, it seems it is not able to read the licence data.
Can you please check the following 3 tables;
-DocumentData
-DocumentRevision
-DocumentItem
For anything that looks suspicious.
e.g. Duplicates, Null records.
Regards,
David
Hi
Nothing looks suspicious there
for these 3 tables record count are the same between hsql and mysql
and the content also checked seems OK.
mysql> select * from DocumentData limit 2;
+------------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| RevisionId | DataSeqNbr | DataChunk |
+------------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3001 | 1 | PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPCEtLSBZZWxsb3dmaW4gQ2Fj
aGVkRmlsdGVyIHhtbCAtLT4KPCEtLSBHZW5lcmF0ZWQgYXQgMDYtMDctMjAwOSAxMzoyMyBFU1Qg
KCsxMDAwKSAtLT4KPGNhY2hlZGZpbHRlcj4KICA8cmVwb3J0SWQ+Mjg2OTY8L3JlcG9ydElkPgog
IDxmaWx0ZXJJZD4yODczMDwvZmlsdGVySWQ+CiAgPGRhdGU+MTI0Njg1MDYzNzEwOTwvZGF0ZT4K
ICA8ZmlsdGVydmFsdWVzPlBHOWlhbVZqZEMxaGNuSmhlVDRLSUNBOGMzUnlhVzVuUGtGemFXRThM
M04wY21sdVp6NEtJQ0E4YzNSeWFXNW5Qa0YxYzNSeVlXeHAKWVR3dmMzUnlhVzVuUGdvZ0lEeHpk
SEpwYm1jK1JYVnliM0JsUEM5emRISnBibWMrQ2lBZ1BITjBjbWx1Wno1TVlYUnBiaUJCYldWeQph
V05oUEM5emRISnBibWMrQ2lBZ1BITjBjbWx1Wno1T2IzSjBhQ0JCYldWeWFXTmhQQzl6ZEhKcGJt
YytDaUFnUEhOMGNtbHVaejVUCmRXSWdVMkZvWVhKaGJpQkJabkpwWTJFOEwzTjBjbWx1Wno0S1BD
OXZZbXBsWTNRdFlYSnlZWGsrPC9maWx0ZXJ2YWx1ZXM+CjwvY2FjaGVkZmlsdGVyPgo= |
| 3003 | 1 | PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPCEtLSBZZWxsb3dmaW4gQ2Fj
aGVkRmlsdGVyIHhtbCAtLT4KPCEtLSBHZW5lcmF0ZWQgYXQgMDYtMDctMjAwOSAxMzoyNCBFU1Qg
KCsxMDAwKSAtLT4KPGNhY2hlZGZpbHRlcj4KICA8cmVwb3J0SWQ+Mjg2OTY8L3JlcG9ydElkPgog
IDxmaWx0ZXJJZD4yODczMTwvZmlsdGVySWQ+CiAgPGRhdGU+MTI0Njg1MDY0NTAzMTwvZGF0ZT4K
ICA8ZmlsdGVydmFsdWVzPlBHOWlhbVZqZEMxaGNuSmhlVDRLSUNBOGMzUnlhVzVuUGtaRlRVRk1S
VHd2YzNSeWFXNW5QZ29nSUR4emRISnBibWMrVFVGTVJUd3YKYzNSeWFXNW5QZ284TDI5aWFtVmpk
QzFoY25KaGVUND08L2ZpbHRlcnZhbHVlcz4KPC9jYWNoZWRmaWx0ZXI+Cg== |
+------------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> select * from DocumentRevision limit 2;
+------------+------------+--------------------+------------+---------------+-----------------+-----------------+---------------+-----------------+--------------------+----------------+----------------+----------------+-------------------+------------+------------+-------------+------------------+----------------------+--------------------+----------+-----------+--------------+
| DocumentId | RevisionId | RevisionStatusCode | FileName | FileExtention | FileSizeInBytes | ArchiveFileName | ArchiveFolder | ArchiveFullPath | ArchiveSizeInBytes | ArchiveFileCRC | IpLastModifier | ModifyTypeCode | ModifyGMTDateTime | ModifyDate | ModifyTime | PublishFlag | StorageCodexCode | StorageCodexFileSize | StorageCodexChunks | Comments | IndexFlag | MimeTypeCode |
+------------+------------+--------------------+------------+---------------+-----------------+-----------------+---------------+-----------------+--------------------+----------------+----------------+----------------+-------------------+------------+------------+-------------+------------------+----------------------+--------------------+----------+-----------+--------------+
| 3000 | 3001 | OPEN | filter.xml | xml | 563 | | | | 0 | | 5 | CREATE | 20090706032357 | 2009-07-05 | | 12237 | 0 | BASE64 | 761 | 1 | | 0 | text/xml
| 3002 | 3003 | OPEN | filter.xml | xml | 385 | | | | 0 | | 5 | CREATE | 20090706032405 | 2009-07-05 | | 12245 | 0 | BASE64 | 522 | 1 | | 0 | text/xml
+------------+------------+--------------------+------------+---------------+-----------------+-----------------+---------------+-----------------+--------------------+----------------+----------------+----------------+-------------------+------------+------------+-------------+------------------+----------------------+--------------------+----------+-----------+--------------+
2 rows in set (0.00 sec)
mysql> select * from DocumentItem limit 2;
+------------+------------------+--------------+------------+----------------------+--------------+---------------+-------+-----------------+-----------+-------------------+-----------+---------------------+--------------+--------------+-----------------+----------------+-------------------+------------+------------+---------------------+--------------+--------------+----------------------+----------+----------+----------+------------+-------------------+------------+------------+
| DocumentId | DocumentTypeCode | DocumentCode | StatusCode | ShortDescription | LocationCode | MediaTypeCode | IpOrg | SubjectTypeCode | SubjectId | SubjectAccessCode | IpCreator | CreationGMTDateTime | CreationDate | CreationTime | ReviewerGroupId | IpLastReviewer | ReviewGMTDateTime | ReviewDate | ReviewTime | LastReadGMTDateTime | LastReadDate | LastReadTime | Description | Comments | Abstract | Hitcount | IpLockedBy | LockedGMTDateTime | LockedDate | LockedTime |
+------------+------------------+--------------+------------+----------------------+--------------+---------------+-------+-----------------+-----------+-------------------+-----------+---------------------+--------------+--------------+-----------------+----------------+-------------------+------------+------------+---------------------+--------------+--------------+----------------------+----------+----------+----------+------------+-------------------+------------+------------+
| 3000 | REPORTFILTER | CACHEDFILTER | OPEN | Cached Filter Values | INTERNAL | FILTERXML | 1 | REPORTFILTER | 28730 | GLOBAL | 5 | 20090706032357 | 2009-07-05 | 12237 | 0 | 5 | 20090706032357 | 2009-07-05 | 12237 | 0 | NULL | 0 | Cached Filter Values | | | 0 | 0 | 0 | NULL | 0 |
| 3002 | REPORTFILTER | CACHEDFILTER | OPEN | Cached Filter Values | INTERNAL | FILTERXML | 1 | REPORTFILTER | 28731 | GLOBAL | 5 | 20090706032405 | 2009-07-05 | 12245 | 0 | 5 | 20090706032405 | 2009-07-05 | 12245 | 0 | NULL | 0 | Cached Filter Values | | | 0 | 0 | 0 | NULL | 0 |
+------------+------------------+--------------+------------+----------------------+--------------+---------------+-------+-----------------+-----------+-------------------+-----------+---------------------+--------------+--------------+-----------------+----------------+-------------------+------------+------------+---------------------+--------------+--------------+----------------------+----------+----------+----------+------------+-------------------+------------+------------+
2 rows in set (0.00 sec)
Any other possible setting problems ?
Nothing looks suspicious there
for these 3 tables record count are the same between hsql and mysql
and the content also checked seems OK.
mysql> select * from DocumentData limit 2;
+------------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| RevisionId | DataSeqNbr | DataChunk |
+------------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3001 | 1 | PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPCEtLSBZZWxsb3dmaW4gQ2Fj
aGVkRmlsdGVyIHhtbCAtLT4KPCEtLSBHZW5lcmF0ZWQgYXQgMDYtMDctMjAwOSAxMzoyMyBFU1Qg
KCsxMDAwKSAtLT4KPGNhY2hlZGZpbHRlcj4KICA8cmVwb3J0SWQ+Mjg2OTY8L3JlcG9ydElkPgog
IDxmaWx0ZXJJZD4yODczMDwvZmlsdGVySWQ+CiAgPGRhdGU+MTI0Njg1MDYzNzEwOTwvZGF0ZT4K
ICA8ZmlsdGVydmFsdWVzPlBHOWlhbVZqZEMxaGNuSmhlVDRLSUNBOGMzUnlhVzVuUGtGemFXRThM
M04wY21sdVp6NEtJQ0E4YzNSeWFXNW5Qa0YxYzNSeVlXeHAKWVR3dmMzUnlhVzVuUGdvZ0lEeHpk
SEpwYm1jK1JYVnliM0JsUEM5emRISnBibWMrQ2lBZ1BITjBjbWx1Wno1TVlYUnBiaUJCYldWeQph
V05oUEM5emRISnBibWMrQ2lBZ1BITjBjbWx1Wno1T2IzSjBhQ0JCYldWeWFXTmhQQzl6ZEhKcGJt
YytDaUFnUEhOMGNtbHVaejVUCmRXSWdVMkZvWVhKaGJpQkJabkpwWTJFOEwzTjBjbWx1Wno0S1BD
OXZZbXBsWTNRdFlYSnlZWGsrPC9maWx0ZXJ2YWx1ZXM+CjwvY2FjaGVkZmlsdGVyPgo= |
| 3003 | 1 | PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPCEtLSBZZWxsb3dmaW4gQ2Fj
aGVkRmlsdGVyIHhtbCAtLT4KPCEtLSBHZW5lcmF0ZWQgYXQgMDYtMDctMjAwOSAxMzoyNCBFU1Qg
KCsxMDAwKSAtLT4KPGNhY2hlZGZpbHRlcj4KICA8cmVwb3J0SWQ+Mjg2OTY8L3JlcG9ydElkPgog
IDxmaWx0ZXJJZD4yODczMTwvZmlsdGVySWQ+CiAgPGRhdGU+MTI0Njg1MDY0NTAzMTwvZGF0ZT4K
ICA8ZmlsdGVydmFsdWVzPlBHOWlhbVZqZEMxaGNuSmhlVDRLSUNBOGMzUnlhVzVuUGtaRlRVRk1S
VHd2YzNSeWFXNW5QZ29nSUR4emRISnBibWMrVFVGTVJUd3YKYzNSeWFXNW5QZ284TDI5aWFtVmpk
QzFoY25KaGVUND08L2ZpbHRlcnZhbHVlcz4KPC9jYWNoZWRmaWx0ZXI+Cg== |
+------------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> select * from DocumentRevision limit 2;
+------------+------------+--------------------+------------+---------------+-----------------+-----------------+---------------+-----------------+--------------------+----------------+----------------+----------------+-------------------+------------+------------+-------------+------------------+----------------------+--------------------+----------+-----------+--------------+
| DocumentId | RevisionId | RevisionStatusCode | FileName | FileExtention | FileSizeInBytes | ArchiveFileName | ArchiveFolder | ArchiveFullPath | ArchiveSizeInBytes | ArchiveFileCRC | IpLastModifier | ModifyTypeCode | ModifyGMTDateTime | ModifyDate | ModifyTime | PublishFlag | StorageCodexCode | StorageCodexFileSize | StorageCodexChunks | Comments | IndexFlag | MimeTypeCode |
+------------+------------+--------------------+------------+---------------+-----------------+-----------------+---------------+-----------------+--------------------+----------------+----------------+----------------+-------------------+------------+------------+-------------+------------------+----------------------+--------------------+----------+-----------+--------------+
| 3000 | 3001 | OPEN | filter.xml | xml | 563 | | | | 0 | | 5 | CREATE | 20090706032357 | 2009-07-05 | | 12237 | 0 | BASE64 | 761 | 1 | | 0 | text/xml
| 3002 | 3003 | OPEN | filter.xml | xml | 385 | | | | 0 | | 5 | CREATE | 20090706032405 | 2009-07-05 | | 12245 | 0 | BASE64 | 522 | 1 | | 0 | text/xml
+------------+------------+--------------------+------------+---------------+-----------------+-----------------+---------------+-----------------+--------------------+----------------+----------------+----------------+-------------------+------------+------------+-------------+------------------+----------------------+--------------------+----------+-----------+--------------+
2 rows in set (0.00 sec)
mysql> select * from DocumentItem limit 2;
+------------+------------------+--------------+------------+----------------------+--------------+---------------+-------+-----------------+-----------+-------------------+-----------+---------------------+--------------+--------------+-----------------+----------------+-------------------+------------+------------+---------------------+--------------+--------------+----------------------+----------+----------+----------+------------+-------------------+------------+------------+
| DocumentId | DocumentTypeCode | DocumentCode | StatusCode | ShortDescription | LocationCode | MediaTypeCode | IpOrg | SubjectTypeCode | SubjectId | SubjectAccessCode | IpCreator | CreationGMTDateTime | CreationDate | CreationTime | ReviewerGroupId | IpLastReviewer | ReviewGMTDateTime | ReviewDate | ReviewTime | LastReadGMTDateTime | LastReadDate | LastReadTime | Description | Comments | Abstract | Hitcount | IpLockedBy | LockedGMTDateTime | LockedDate | LockedTime |
+------------+------------------+--------------+------------+----------------------+--------------+---------------+-------+-----------------+-----------+-------------------+-----------+---------------------+--------------+--------------+-----------------+----------------+-------------------+------------+------------+---------------------+--------------+--------------+----------------------+----------+----------+----------+------------+-------------------+------------+------------+
| 3000 | REPORTFILTER | CACHEDFILTER | OPEN | Cached Filter Values | INTERNAL | FILTERXML | 1 | REPORTFILTER | 28730 | GLOBAL | 5 | 20090706032357 | 2009-07-05 | 12237 | 0 | 5 | 20090706032357 | 2009-07-05 | 12237 | 0 | NULL | 0 | Cached Filter Values | | | 0 | 0 | 0 | NULL | 0 |
| 3002 | REPORTFILTER | CACHEDFILTER | OPEN | Cached Filter Values | INTERNAL | FILTERXML | 1 | REPORTFILTER | 28731 | GLOBAL | 5 | 20090706032405 | 2009-07-05 | 12245 | 0 | 5 | 20090706032405 | 2009-07-05 | 12245 | 0 | NULL | 0 | Cached Filter Values | | | 0 | 0 | 0 | NULL | 0 |
+------------+------------------+--------------+------------+----------------------+--------------+---------------+-------+-----------------+-----------+-------------------+-----------+---------------------+--------------+--------------+-----------------+----------------+-------------------+------------+------------+---------------------+--------------+--------------+----------------------+----------+----------+----------+------------+-------------------+------------+------------+
2 rows in set (0.00 sec)
Any other possible setting problems ?
Even if the Licence Servlet is failing.. it doesn't mean that Yellowfin won't start.
You should be able to login and reload the licence via the interface.
If the tomcat service is not starting, then it will not be because of the Licence check at startup.
If the service is not starting there should be log lines at the end of catalina.out saying that the service has been stopped, otherwise you should be able to login as usual.
You should be able to login and reload the licence via the interface.
If the tomcat service is not starting, then it will not be because of the Licence check at startup.
If the service is not starting there should be log lines at the end of catalina.out saying that the service has been stopped, otherwise you should be able to login as usual.
Even still cannot login due to the characterEncoding error:
Jan 14, 2011 9:54:53 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8088
Jan 14, 2011 9:54:53 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 13595 ms
YF:2011-01-14 09:55:06: INFO (SysSessionListener:sessionCreated) - TRACE == CREATE SESSION: Session being created with sessionid : B1E48BA286F6966A662E9687A2E15
YF:2011-01-14 09:55:06: INFO (SysSessionListener:sessionCreated) - TRACE == CREATE SESSION: Session has creationTime 1294970106406
YF:2011-01-14 09:55:06: INFO (SysSessionListener:attributeAdded) - TRACE == Attribute Added: LogonForm
YF:2011-01-14 09:55:06: INFO (PropertyMessageResources:) - Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
YF:2011-01-14 09:55:06: INFO (PropertyMessageResources:) - Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
YF:2011-01-14 09:55:06: INFO (PropertyMessageResources:) - Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
YF:2011-01-14 09:55:06: INFO (PropertyMessageResources:) - Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
YF:2011-01-14 09:55:06: INFO (PropertyMessageResources:) - Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
YF:2011-01-14 09:55:40: INFO (SysSessionListener:attributeAdded) - TRACE == Attribute Added: org.apache.struts.action.LOCALE
YF:2011-01-14 09:55:40: INFO (LogonAction:execute) - Logon Action entered
YF:2011-01-14 09:55:40: INFO (LogonAction:performLogin) - Internal Entry Point for Logon
YF:2011-01-14 09:55:40: INFO (SysSessionListener:attributeAdded) - TRACE == Attribute Added: INDEX_PAGE
YF:2011-01-14 09:55:40: INFO (JDBCAuthentication:authenticate) - Entered JDBCAuthentication plugin
YF:2011-01-14 09:55:40:ERROR (JDBCAuthentication:authenticate) - An exception occurred in JDBCAuthentication adapter
java.io.UnsupportedEncodingException: UTF-8
at java.lang.StringCoding.encode(Unknown Source)
at java.lang.String.getBytes(Unknown Source)
at com.hof.util.Crypto.oneWayHash(Crypto.java:188)
at com.hof.util.Crypto.oneWayHash64(Crypto.java:229)
at com.hof.adapter.JDBCAuthentication.authenticate(JDBCAuthentication.java:283)
at com.hof.adapter.YFConfigAuthentication.authenticate(YFConfigAuthentication.java:77)
at com.hof.ip.process.LogonProcess.processYellowfinLogon(LogonProcess.java:1207)
at com.hof.ip.web.action.LogonAction.performLogin(LogonAction.java:638)
at com.hof.ip.web.action.LogonAction.execute(LogonAction.java:237)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
YF:2011-01-14 09:55:40: INFO (JDBCAuthentication:authenticate) - Exiting JDBCAuthentication Plugin
YF:2011-01-14 09:55:40:ERROR (LogonProcess:processYellowfinLogon) - Error raised in logon process: java.io.UnsupportedEncodingException: UTF-8
java.io.UnsupportedEncodingException: UTF-8
at java.lang.StringCoding.encode(Unknown Source)
at java.lang.String.getBytes(Unknown Source)
at com.hof.util.Crypto.oneWayHash(Crypto.java:188)
at com.hof.util.Crypto.oneWayHash64(Crypto.java:229)
at com.hof.adapter.JDBCAuthentication.authenticate(JDBCAuthentication.java:283)
at com.hof.adapter.YFConfigAuthentication.authenticate(YFConfigAuthentication.java:77)
at com.hof.ip.process.LogonProcess.processYellowfinLogon(LogonProcess.java:1207)
at com.hof.ip.web.action.LogonAction.performLogin(LogonAction.java:638)
at com.hof.ip.web.action.LogonAction.execute(LogonAction.java:237)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
YF:2011-01-14 09:55:40: WARN (AuthUtil:findIpOrg) - Unable to find an ipOrg for url http://localhost:8088/failure.jsp
YF:2011-01-14 09:55:40: INFO (PropertyMessageResources:) - Initializing, config='org.apache.struts.taglib.bean.LocalStrings', returnNull=true
YF:2011-01-14 09:55:41: INFO (PropertyMessageResources:) - Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
YF:2011-01-14 09:56:00: INFO (TaskScheduler:A) - TaskScheduler polling TaskSchedule table
YF:2011-01-14 09:57:00: INFO (TaskScheduler:A) - TaskScheduler polling TaskSchedule table
Hi,
Can you please email the entire catalina.out & yellowfin.log file to support@yellowfin.com
Thanks,
David
Can you please email the entire catalina.out & yellowfin.log file to support@yellowfin.com
Thanks,
David