1 Reply Latest reply: Oct 3, 2013 2:42 PM by DavidGreenfield RSS

    JUNK CHARACTERS IN REJECTED_RECORD COLUMN IN CUBE_REJECTED_RECORDS TABLE

    user703537

      After maintaining the cube, for the rejected rows, we are seeing the error message "A column value is not a valid member of its target dimension." but the rejected record column shows junk characters. We want to be able to read this column so that we know the row which is causing the error. Could you please help in resolving this issue? Thanks.

       

      From rejected_record column in cube_rejected_records table -

       

      (CLOB) ㄰〹㐰〶㄰ㄹ㈠㌱㈰〸㌲㠠䕕删㐷㘴㘠㄰〰㐠ⴱㄠ倠㄰〸㘠㜴㔱⸶ㄠㄴ㤱㠮ㄳ‷㐵ㄮ㘱‷㐵ㄮ㘱‱㐹ㄸ⸱㌠㜴㔱⸶ㄠㄴ㤱㠮ㄳ‷㤮㐸‰‰‷㐵ㄮ㘱‱㐹ㄸ⸱㌠㜴㔱⸶ㄠㄴ㤱㠮ㄳ‷㤮㐸‷㐵ㄮ㘱‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‰‷㤮㐸‰‱㐹ㄸ⸱㌠〠ㄴ㤱㠮ㄳ‷㐵ㄮ㘱‰‰‷㐵ㄮ㘱‰‰