SQL error in fields occurred during a patch update - transport

[former_member199632]

Hi,

When performing a patch update (K-60016INISOIL.SAR,KH60016.SAR,KNA7016.SAR,KNA7017.SAR) it trows this error and transport stops with RC=8

Pls guide me how to solve this!

Table BSEG is in physical pool/cluster: RFBLG

Fields names differ (old - PRODPER and new - KSTAR)

An SQL error occurred during a test access to the table

An inconsistency between the nametab and database may exist

Result   BSEG:    Action: CNV      Mode flag: E    Return code: 8

But when check the BSEG from se11, it shows these 2 fields

(old - PRODPER and new - KSTAR)

Screenshot attached.1.jpg/2.jpg

Whats the reason KSTAR and PRODPER fields appears in 2 different colors.

regards,

zerandib

[former_member227283]

Dear Zerandib,

2 Different color is not a problem KSTAR is a actual field present in the table and field PRODPER has been came from Append Structure, basically you should not get such error as both field has different data type.

I would suggest to raise an OSS with SAP for this, as error looks very weird.

Regards,

Anil

[former_member182657]

Hi Zerandib,

Please consider SAP Note  24864 - No conversion of the table BSEG

Regards,

[former_member199632]

Thx, i will look on to that

Still its this error!!!

DB-TABLBSEG

          Request: Convert Table BSEG (DDIC/02.01.16/14:24)

          Process: erptrn_2

          Test activation of Table BSEG successful

            Fields names differ (old - PRODPER and new - KSTAR)

          An SQL error occurred during a test access to the table

          Cause: Database lock or inconsistency: Dictionary database

          Compare module DD_DECIDE ended with error(s)

          Request for BSEG could not be executed

[former_member182657]

Hi,

You should follow SAP KBA  1900549 - Add-on Installation fails due to inactive nametab

Hope this will help you.

Regards,

[former_member199632]

Hi Rana,

Thx for the info...

According to the sap note  1248769 , when trying to reconstruct the table it is in disable/inactive status

Any idea?

SE14 -> BSEG table ...EDIT

Table -> Reconstruct (inactive)

Its status is showing as 'upgrade'

rgds

zerandib

[Former Member]

Hi,

You need to preform the set of actions in Client 000 with DDIC user.

Regards,

Prithviraj.

[former_member199632]

Yes Prithviraj exactly, it is done that way

Is it possible to check this bseg is locked by some program or like that?

[Former Member]

Hi

Check if any tp process is running. Check DB01 to see any lock on the table

If possible, give a system restart and then repeat the import.

Regards,

Prithviraj.

[Sriram2009]

Hi Zerandib.

Could you check the table consistency on Transaction code SE11.

Regards

SS

[former_member199632]

Hi SS,

I have chekd it.

It says, 'No inconsistencies found'

rgds,

zerandib