Unarchive issue

[vian_abduljalil]

hello,

we use SAPME version  6.0.4.41

when I try to unarchive a SFC this message appeares(file attached)

what is the reason?

thank you

Regards,

Vian

UNarchive.txt.zip

[vian_abduljalil]

hi,

I have activated the sql trace during the unarchive process, I got this error:

#2.0 #2016 02 09 09:12:00:862#+0100#Info#com.sap.me.trace#
##sap.com/me~ear#C0000AD30320D3990000000000001310#6383550000000004#sap.com/me~ear#com.sap.me.trace.VM#abduljalil_vi#108500#JTA Transaction : 6545259#0FD568D2CEFC11E5CA0A0000006167BE#c4d9e022cf0411e588ae0000006167be#c4d9e022cf0411e588ae0000006167be#0#Thread[HTTP Worker [@105404186],5,Dedicated_Application_Thread]#Plain##
SQLException while executing query sql: SELECT * FROM CUSTOM_FIELDS WHERE HANDLE = 'SFCDataBO:SFCBO:SEVA1,SE11240I7D,RMA_HISTORY_OCC,04/15/2014 09:45:45'#

#2.0 #2016 02 09 09:12:00:864#+0100#Error#com.sap.engine.services.ejb3.runtime#

I just wondered why it search for this handle in custom_fields table?

thank you

/Vian

[sergiy_katerinich]

Vian,

This is what I actually wrote about: if you unarchive an SFC without SFC Data, then it works fine, however it fails for the SFC which has SFC Data collected. The fix for this ssue seems to be released soon once SAP Note 2275920 has been published recently. So, please wait for the next patch and check if the fix is included there.

Regards,

Sergiy

[vian_abduljalil]

hi Sergiy,

do you know which patch will have the fix for this issue and when it will be released?

thank you

/Vian

[sergiy_katerinich]

The current patch 42 was released a week ago. Thus the next one can be anticipated approximately in 2-3 weeks.

[vian_abduljalil]

thank you Sergiy

[former_member182330]

You are missing a table or table column in DB:

Caused by: com.sap.me.frame.dao.DataAccessSystemException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'CUSTOM_FIELDS'.

  at com.sap.me.frame.dao.PersistentObjectCollection.initialize(PersistentObjectCollection.java:151)

  at com.sap.me.frame.dao.PersistentObjectCollection.iterator(PersistentObjectCollection.java:89)

  at com.sap.me.frame.dao.OneToManyList.getData(OneToManyList.java:56)

I would recommend to search sql scripts files for "CUSTOM_FIELDS" and run those scripts.

Regards,
Konstantin

[sergiy_katerinich]

Hi Vian,

First please check that you have the correct collation for WIP and ODS databases.

If so, then it might be an issue related to unarchiving SFCs which have SFC Data collected. For this, try to archive an SFC without SFC Data and then unarchive it. Then, archive and unarchive an SFC with SFC Data collected.

Regards,

Sergiy

[vian_abduljalil]

hello,

thank you for your response,

there is no different between the collation in WIP and ODS databases, and I tried archive and unarchive another SFC and it works.

in the log file refers to some invalid object name" custom_fields", and I don't know what it mean??

thank you

/Vian