This discussion is archived
2 Replies Latest reply: Sep 17, 2012 8:42 AM by Amar_Singh RSS

CSSCAN RESULT

517214 Newbie
Currently Being Moderated
Hi Guys,
I have just finished running a csscan for a schema.
The results are listed below from scan.err file.
What exactly do i need to do to fix these set of column size exceeded and lossy errors please?
Parameter                      Value
------------------------------ ------------------------------------------------
CSSCAN Version                 v2.1
Instance Name                  FCHDT
Database Version               10.2.0.5.0
Scan type                      User tables
User name                      FCHDBA
Scan CHAR data?                YES
Database character set         WE8DEC
FROMCHAR                       WE8DEC
TOCHAR                         AL32UTF8
Scan NCHAR data?               NO
Array fetch buffer size        1024000
Number of processes            1
Capture convertible data?      NO
------------------------------ ------------------------------------------------

[Data Dictionary individual exceptions]


[Application data individual exceptions]

User  : FCHDBA
Table : DTEC_ARCHIVE
Column: CALL_REASON_ADDITIONAL
Type  : VARCHAR2(100)
Number of Exceptions         : 12
Max Post Conversion Data Size: 103

ROWID              Exception Type      Size      Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAAW7aAAEAAPb2uAAL exceed column size   103 ETISINFORMATIONS- OCH UNDERHÃ
L
AAAW7aAAEAAPb6aAAi exceed column size   103 ETISINFORMATIONS- OCH UNDERHÃ
L
AAAW7aAAEAAPbwaAAY exceed column size   103 ETISINFORMATIONS- OCH UNDERHÃ
L
AAAW7aAAEAAPcMhAAS lossy conversion         5120120001-B299 1.4 L DIESEL S
AAAW7aAAEAAPcQJAAl lossy conversion         5120120001-B299 1.4 L DIESEL S
AAAW7aAAEAAPcQlAAf lossy conversion         5120120001-B299 1.4 L DIESEL S
AAAW7aAAEAAPcTlAAL lossy conversion         05120120001-B299 1.4 L DIESEL
AAAW7aAAEAAPcYUAAB lossy conversion         5120120001-B299 1.4 L DIESEL S
AAAW7aAAEAAPcbnAAb lossy conversion         05120120001-B299 1.4 L DIESEL
AAAW7aAAEAAPccFAAk lossy conversion         5120120001-B299 1.4 L DIESEL S
AAAW7aAAEAAPckDAAH lossy conversion         5120120001-B299 1.4 L DIESEL S
AAAW7aAAEAAPcniAAU lossy conversion         05120120001-B299 1.4 L DIESEL
------------------ ------------------ ----- ------------------------------


User  : FCHDBA
Table : SERVICE_REQUEST_EMAIL_LOG
Column: EMAIL_CONTENT
Type  : CLOB
Number of Exceptions         : 5369
Max Post Conversion Data Size: 29896
Thank you

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points