201310041230000054failed to save eoo recordx

tenuousdrunkshipInternet and Web Development

Nov 12, 2013 (3 years and 9 months ago)

172 views


Failed to Save” OBBEOO Problem

1.

When user wants to save the OBBEOO record, the message “Fail to save data” is
prompted. According to the log, the problem is due to the column “activity_desc”

Please advise us the solution before implementation




13134787

2013
-
10
-
04 11:25:56,676[DEBUG][java.sql.Connection]:{conn
-
207937} Preparing
Statement: insert into ACTIVITY_LOG_OBB
(ACT_LOG_ID,ACTIVITY_DESC,CREATED_BY,CREATED_DATE,ACTIVITY_CODE,APPL_ID,SCHEME_C
ODE) va
lues ( ACT_LOG_ID_SEQ.NextVal,?,?,sysdate,?,?,? )

13134787 2013
-
10
-
04 11:25:56,676[DEBUG][java.sql.PreparedStatement]:{pstm
-
207940}
Executing Statement: insert into ACTIVITY_LOG_OBB
(ACT_LOG_ID,ACTIVITY_DESC,CREATED_
BY,CREATED_DATE,ACTIVITY_CODE,APPL_ID,SCHEME_C
ODE) values ( ACT_LOG_ID_SEQ.NextVal,?,?,sysdate,?,?,? )

13134787 2013
-
10
-
04 11:25:56,676[DEBUG][java.sql.PreparedStatement]:{pstm
-
207940}
Parameters: [AMEND APPLICATION DETAIL (SPECIAL),[masted dat
a], DP
-
APP
-
07020, 513134787
2013
-
10
-
04 11:25:56,676[DEBUG][java.sql.PreparedStatement]:{pstm
-
207940} Types:
[java.lang.String, java.lang.String, java.lang.String, java.lang.Long, java.lang.String]

13134797 2013
-
10
-
04
11:25:56,686[ERROR][com.hkhs.soa.obb.ap
plication.service.impl.ApplicationObbServiceImpl]:sa
veObbApplication(obbApplication)

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized
SQLException for SQL []; SQL state [72000]; error code [12899];

---

The error occ
urred in com/hkhs/soa/obb/application/dao/ibatis/sql/ActivityLogObbSQL.xml.

---

The error occurred while applying a parameter map.

---

Check the ActivityLogObb.addParam.

---

Check the statement (update failed).

---

Cause: java.sql.SQLException: ORA
-
12899:
value too large for column
"HS_EOS"."ACTIVITY_LOG_OBB"."ACTIVITY_DESC" (actual: 515, maximum: 500)

; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

---

The error occurred in com/hkhs/soa/obb/application/dao/ibatis/sql/ActivityLogO
bbSQL.xml.

---

The error occurred while applying a parameter map.

---

Check the ActivityLogObb.addParam.

---

Check the statement (update failed).

---

Cause: java.sql.SQLException: ORA
-
12899: value too large for column
"HS_EOS"."ACTIVITY_LOG_OBB"."ACTIVITY_
DESC" (actual: 515, maximum: 500)