SAP ME 6.1.2 upgrade issue

[former_member206397]

Hi All,

We are upgrading ME from 6.0 to 6.1.2 and getting the below error when we are trying to access ME from browser.

Accessing URL: http://<Host>:<Port>/manufacturing/index.jsp

Error: An internal error occurred; contact technical support

The details of error is like below:

Caused by: com.sap.engine.services.jndi.persistent.exceptions720.NameNotFoundException: Object not found in lookup of wipPool.
        at com.sap.engine.services.jndi.implserver.ServerContextImpl.lookup(ServerContextImpl.java:631)
        at com.sap.engine.services.jndi.implclient.ClientContext.lookup(ClientContext.java:363)
        at com.sap.engine.services.jndi.implclient.OffsetClientContext.lookup(OffsetClientContext.java:224)
        at com.sap.engine.services.jndi.implclient.OffsetClientContext.lookup(OffsetClientContext.java:243)
        at javax.naming.InitialContext.lookup(InitialContext.java:392)
        at javax.naming.InitialContext.lookup(InitialContext.java:392)
        at com.sap.me.frame.AbstractDataSource.init(AbstractDataSource.java:60)
        ... 57 more

#

#2.#2013 08 26 19:42:01:189#0-400#Error#com.sap.me.integration.actions.workflow.SimpleMessageDispatcher#
##sap.com/me~ear#C000097C2FEE01250000000000005DA1#12666250000011579#sap.com/xapps~xmii~ear#com.sap.me.integration.actions.workflow.SimpleMessageDispatcher.ME#RUNAS_urwuyc#0##19152B540E9611E3ADFE000000C1458A#19152b540e9611e3adfe000000c1458a#00000000000000000000000000000000#0#Thread[Managed_Application_Thread_65,5,Managed_Application_Thread]#Plain##
[SimpleMessageDispatcher] Error handling message: java.sql.SQLSyntaxErrorException: ORA-00904: "IS_SYNC_PROC": invalid identifier

Can anybody provide any suggestion on the issue?

[Note: All wizards related to upgrade were successfull]

Thanks in Advance

Chandan

[alexander_teslyuk · Accepted solution]

Hello Chandan,

The column IS_SYNC_PROC had to be added in 6.0 only to enable parallel processing in SAPMEINT. It had to be added to the table APMEINT_MESSAGE_QUEUE. It should be available starting 6.1.

So, did you upgrade SAPMEINT? What is the exact version? Did you run SAPMEINT wizards?

Regards, Alex.

[former_member206397 · Accepted solution]

Hi Alexander,

Thank you so much for your help. We have upgraded the MEINT and ME also 6.1.2.2. I have manually added the IS_SYNC_PROC in SAPMEINT_MESSAGE_QUEUE table and the issue is solved.

Thanks again.

Chandan

[ravi_kumar123 · Accepted solution]

Hi Chandan,

We have same issue with one of our ME system.

Right now we have SAPMEINT 6.1.2.1 ,SAPMECORE 6.1.2.3 on our ME system.

Can you please guide me how to add IS_SYNC_PROC in SAPMEINT_MESSAGE_QUEUE table ?

Regards,

-Ravi Kumar.D

[former_member206397 · Accepted solution]

Hi Ravi,

I have used SQL developer to access the table structure of SAPMEINT_MESSAGE_QUEUE and manually added a column called IS_SYNC_PROC and after that I have restarted the me~ear application from nwa (Login in nwa ->Operations->Start & Stop->Java Applications (now filter me~ear)). Then it was working. For more details step please check the  

SAP Note 1855705 - Parallel Processing in SAPMEINT

I think it will help you to solve the issue.

Thanks

Chandan

[ravi_kumar123 · Accepted solution]

Hi Chandan,

I have connected to my ME system using Oracle SQL developer tool.

When I list the table..  SQL>Select * from tab SAPMEINT_MESSAGE_QUEUE

It gives me records.. but,

When I ran the SQL query... 

SQL> ALTER TABLE SAPMEINT_MESSAGE_QUEUE ADD  IS_SYNC_PROC numeric(38, 0)

This gives me an error:

Error starting at line 1 in command:

ALTER TABLE SAPMEINT_MESSAGE_QUEUE ADD  IS_SYNC_PROC numeric(38, 0)

Error report:

SQL Error: ORA-00942: table or view does not exist

00942. 00000 -  "table or view does not exist"

*Cause:   

*Action:

The Snote: 1855705 says..

Execute the following database scripts on the SAPMEINT schema:

Is this mean I need to change to SAPMEINT schema.. ?

Please suggest me.. 

Regards,

-Ravi Kumar.D

[former_member182330 · Accepted solution]

And where did you think SAPMEINT_* table would be located? Obviously in SAPMEINT schema. It would be located in WIP only if everything was put in 1 schema during installation/initial config, meaning WIP=SAPMEINT.

[ravi_kumar123 · Accepted solution]

Konstantin,

Ok, what you said was correct. but, i dont see any owner of this table.

When ran the query

SQL>select owner from all_tables where table_name='SAPMEINT_MESSAGE_QUEUE'

It returns me no values..

-And when try to see the schema owners.. I see 10 Owners..  but, not WIP=SAPMEINT..

SQL>SELECT username from all_users ORDER BY username

1.APPQOSSYS

2.DBSNMP

3.DIP

4.OPS$SITASERV40\ME6ADM

5.OPS$SITASERV40\SAPSERVICEME6

6.ORACLE_OCM

7.OUTLN

8.SAPSR3DB

9.SYS

10.SYSTEM

-when I try to alter the table..

SQL>ALTER TABLE SAPMEINT_MESSAGE_QUEUE ADD  IS_SYNC_PROC numeric(38, 0)

Error report:

SQL Error: ORA-00942: table or view does not exist

00942. 00000 -  "table or view does not exist"

*Cause:   

*Action:

Can  you suggest me how to proceed further. ?

[ravi_kumar123 · Accepted solution]

Hello Konstantin,

-Ignore the previous post.

Ok, what you said might be correct. but, i don't see the table in my database.

SQL:> SELECT * from SAPMEINT_MESSAGE_QUEUE

ORA-00942: table or view does not exist

00942. 00000 -  "table or view does not exist"

*Cause:   

*Action:

Error at Line: 1 Column: 14

Any clue.. ?

[former_member182330 · Accepted solution]

Hi,

This means you do/did something wrong. If integration was setup correctly previously - you should have the table among other SAPMEINT_* tables. If you don't know where those tables are located - then I doubt we would be able to help here as answers will be useful for someone who understands how ME operates or at least of which parts it consists of. If you lack this understanding, I would suggest to go back to ME upgrade/installation guide and follow the steps described there one by one.

Br,

Konstnatin

[former_member201054]

Hi Chandan,

Please share the upgrade document with me.I need it urgently

thanks in advance

[former_member206397]

Hi Daniel,

Here is the SAP ME 6.1 Upgrade Master Guide

http://service.sap.com/instguides -> SAP Business Suite Applications-> SAP Manufacturing -> SAP Manufacturing Execution 6.1.

Thanks

Chandan

.