ora-1455 error occurred during System copy

[former_member227150]

Hello All,

We are doing system copy of SAP R3 4.7 and during System Export getting below error while accessing table S161:

DbSl Trace: Error 1455 in stmt_fetch()

DbSl Trace: ORA-1455 occurred when executing SQL statement (parse error offset=304)

(EXP) ERROR: DbSlExeRead failed

  rc = 99, table "S161"

  (SQL error 1455)

  error message returned by DbSl:

ORA-01455: converting column overflows integer datatype

(DB) INFO: disconnected from DB

Can anyone help in resolving this error?

Thanks,

Gaurav

[Reagan]

What is the version of Oracle Instant Client you are using ?

Regards

RB

[former_member188883]

Hi Gaurav,

Could you refer following SAP note

Note 591600 - Error due to inappropriate column values

Alternatively please share the Oracle version installed along with patch set details.

There are known bugs in oracle 9i and 10g which may lead to above ORA errors. Ref. Metalink note 351233.1

Hope this helps.

Regards,

Deepak Kori

[former_member227150]

Hello Sunny / Deepak,

I have updated the Kernel but it doesn't worked.

I have also checked SAP Note - 591600 and used analyze command to check the table for any errors. but there were no errors reported.

We are on Oracle 9.2.0.4.0 .

Thanks,

Gaurav

[former_member188883]

Hi Gaurav,

According to Metalink note 351233.1, this is an export bug in 9.2.0.4.0 fixed in 10.2.0 and linked to audit trail configuration.

If you disable auditing with "noaudit session" before running full export, export should complete successfully.

Hope this helps.

Regards,

Deepak Kori

[former_member227150]

Hello Deepak,

Auditing is already disabled in oracle.

Parameter AUDIT_TRAIL is set to NONE.

Thanks,

Gaurav

[Sriram2009]

Hi Gaurav

1. Could you check the table S161 consistency or not? Go to t code se11 chose utilites - database object- check

2. DBSL patch level? if it is low pls upgrade and than retry

Regards

Sriram

[former_member227150]

Hello Sriram,

Table S161 is consistent. Currently, my kernel is 640 patch level 196 (NUC)and DBSL is 640 patch level 175 (NUC).

To which level I should update 640 latest (this I have already tried) or 700/720.

Thanks

Gaurav

[Sriram2009]

Hi Gaurav

Which OS ? patch level 196 is old one, new kernel version on 640 patch level 414 apply that than retry

Regards

Ram

[Former Member]

You have to update your kernel to latest available.

Regards,

Nick Loy

[former_member227150]

Hello Sriram / Nick,

Kernel 414 was not working with my system, so I applied 404 but then also it's not working.

Same error.

Thanks,

Gaurav

[Sriram2009]

Hi Gaurav

Check this SAP Note  1609745?

Regards

Sriram

[Former Member]

Paste the error that you are receiving after Kernel update (414).

Regards,

Nick Loy

[sunny_pahuja2]

Hello,

Have you tried to update your kernel to latest level?

Thanks,

Sunny