Task #1064: Case ID: HD00011535 - Approve Corus CMS user - KFH Support - Penril Support System

Task #1064

Case ID: HD00011535 - Approve Corus CMS user

Added by Sarinah Darsy about 13 years ago. Updated over 10 years ago.

Status:

Closed - End of life cycle

Start date:

July 27, 2011

Priority:

Normal

Due date:

Assignee:

Sarinah Darsy

% Done:

90%

Category:

Spent time:

Target version:

Description

APPROVING CMS USER FOR THIS PARTICULAR COMPANY GET ERROR MESSAGE "SERVICE CURRENTLY UNAVAILABLE". TRIED 3 TIMES BUT STILL THE SAME. ANOTHER TRIAL RESULTING "USERNAME ALREADY EXIST" EVEN THE EARLIER WAS FAILED. APPROVING OTHER COMPANY USER HAS NO PROBLEM. COMPANY ID: 19 - PRIMA CRYSTAL

The log file as attached, seems there are error on SQL satted as following:

2011/07/26 16:32:06:527 ERROR cst.hibernate.utils.HBCompanyUserUtils: Error code : 0000
2011/07/26 16:32:06:529 ERROR cst.hibernate.utils.HBCompanyUserUtils: Error details : Could not execute JDBC batch update
Exception class : org.hibernate.exception.SQLStateConverter, class method : handledNonSpecificException, line number : 126org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
my.com.cst.hibernate.utils.HBCompanyUserUtils.batchInsertsAndUpdate(HBCompanyUserUtils.java:1518)
my.com.cst.hibernate.utils.HBCompanyUserUtils.batchInsertsAndUpdate(HBCompanyUserUtils.java:1420)
my.com.cst.enterprise.services.cst106_maker_checker.CSTCheckerCompanyUserProfileApproveServices.approveCompanyUser(CSTCheckerCompanyUserProfileApproveServices.java:345)
my.com.cst.controller.actions.cst106_maker_checker.CSTCheckerCompanyUserProfileApproveAction.execute(CSTCheckerCompanyUserProfileApproveAction.java:75)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
my.com.cst.common.utils.IBActionServlet.doPost(IBActionServlet.java:81)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
my.com.cst.common.utils.SetSessionTimeout.doFilter(SetSessionTimeout.java:70)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
java.lang.Thread.run(Thread.java:595)

IBSystem_CST2.log_2011-07-26 (15 KB) Sarinah Darsy, July 27, 2011 12:02

IBSystem_CST2.log_2011-07-25 (3.44 KB) Sarinah Darsy, July 27, 2011 12:02

Corus_-_Approve_Primacrystal_-_26.07.11.docx (598 KB) Sarinah Darsy, July 27, 2011 15:07

History

#1 Updated by Sarinah Darsy about 13 years ago

File Corus_-_Approve_Primacrystal_-_26.07.11.docx added
Status changed from New - Begin Life Cycle to Development / Work In Progress

Added Print Screen for the issue.

#2 Updated by Sarinah Darsy about 13 years ago

% Done changed from 0 to 60

I test at development, creating one user on CORUS using the same data given by user.
When approving, it return me service unavailable same as KFH issue.

Checking on the logs, the error also return the same error which is point to 'Could not execute jDBC batch update':

Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "BIB"."BIB_USER"."U_FAV_DISPLAY_NAME" (actual: 35, maximum: 32)

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 47 more

The reason was because the column size in the database is only support for the data length of 32.

The data store into column 'U_FAV_DISPLAY_NAME' will be the inserted field of Name on Corus creation user.
At the data user input, the name is DATU MOHD KHUDDAR DATU ABDUL KADIR which length is 35 and the column only support for 32 length.

I will ask KFH Database system team, to check on the production column size of the table column.

#3 Updated by Sarinah Darsy about 13 years ago

Status changed from Development / Work In Progress to Pending Customer Feedback
% Done changed from 60 to 90

Already revert to user on the table column size problem.

After changes on table column size made, User need to re-register the user again even the user id was rejected otherwise the error user will get the error message of "Username already exist." since the user id is keep stored in the UPASS table.

Waiting for the user feedback.

#4 Updated by Norhaidah Md Dasuki over 10 years ago

Status changed from Pending Customer Feedback to Closed - End of life cycle

Issue closed.

Also available in: Atom PDF

B - Production Support » KFH Support

Issues