Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.2.0
-
Fix Version/s: None
-
Component/s: Self Serve UI
-
Labels:None
-
Environment:
Build #9
Description
User can't upload new logo, Jboss log shows exceptions
[gsingh@optus-qa-smb1 jboss-5.1.0.GA]$ tail -f tsa_messaging_node_server.log
09:56:36,654 INFO [CustomImageUploadServlet] CustomImageUploadServlet.doPost()
09:56:36,659 INFO [CustomImageUploadServlet] BPID: CK Testing 005-0000000006
09:56:36,659 INFO [CustomImageUploadServlet] businessFunctionID: -1
09:56:36,659 INFO [CustomImageUploadServlet] serviceLocationID: -1
09:56:36,659 INFO [CustomImageUploadServlet] Custom image type:: jpg
09:56:36,659 INFO [CustomImageUploadServlet] Cusom image size [280893]
09:56:36,984 DEBUG [JdbcTemplate] Executing prepared SQL query
09:56:36,984 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
09:56:36,987 DEBUG [JdbcTemplate] Executing prepared SQL update
09:56:36,987 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into images(filename,businessTypeID,businessFunctionID,locationID,entityID,description,status,useCount) values (?,?,?,?,?,?,?,?)]
09:56:36,990 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:56:36,991 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
09:56:36,992 DEBUG [JdbcTemplate] Executing prepared SQL update
09:56:36,992 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into imageFileData(id,fileData) values (?,?)]
09:56:36,994 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:56:37,025 INFO [CustomImageUploadServlet] Custom Image Saved - ImageID::23
09:56:37,042 INFO [LoggingInInterceptor] Inbound Message
----------------------------
ID: 14
Address: /SMB-CS/CustomizationService
Encoding: UTF-8
Content-Type: text/xml; charset=utf-8
Headers:
{content-type=[text/xml; charset=utf-8], connection=[Keep-Alive], host=[svc-customizationservice.svc.thesearchagency.com:8443], Content-Length=[296], SOAPAction=[""], user-agent=[PHP-SOAP/5.3.3], Content-Type=[text/xml; charset=utf-8]}Payload: <?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://thesearchagency.com/smb/core"><SOAP-ENV:Body><ns1:readCustomized><BPID>CK Testing 005-0000000006</BPID></ns1:readCustomized></SOAP-ENV:Body></SOAP-ENV:Envelope>
--------------------------------------
09:56:37,043 DEBUG [JdbcTemplate] Executing prepared SQL query
09:56:37,043 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where customerBpId=?]
09:56:37,044 WARN [SQLErrorCodesFactory] Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@7b15c2fd
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:296)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:320)
at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:212)
