Issue during Migrating ME database (INT) from Oracle to HANA on 15.1 SP05

j4inp4nk4j — Mon, 30 Jul 2018 20:09:06 GMT

Hi,

I have upgraded ME from 6.1 on oracle to 15.1SP05 on HANA

I am following s-note : 2275116 - Migrating your SAP ME 15.1 databases to SAP HANA,

ran below CTC in order

1. SAP ME Database Setup for Installation
2. SAP ME Configuration for Installation (it creates the global site *)
3. SAPMEINT Standard Interfaces (for one plant/site for integration with ERP system)
4. SAP ME Database Migration to SAP HANA Database

In HANA database I have 3 schema's

1. Netweaver
2. SAPMEWIP
3. SAPMEINT

When I am running CTC wizard "SAP ME Database Migration to SAP HANA Database" , its giving error during migration of INT database 14 SAPMEINT tables , saying it coulnd find MEINT tables in SAPMEWIP schema , I am not sure why , it should be loading data into SAPMEINT schema where these table structure were created ,

ERROR_MESSAGE SAP DBTech JDBC: [259]: invalid table name: Could not find table/view SAPMEINT_WORKFLOW_CONFIG in schema SAPMEWIP: line 1 col 13 (at pos 12) OpenSQLExceptionCategories: [NON_TRANSIENT, DB_OBJECT_UNKNOWN]

Please advice

Thanks

Pankaj

Re: Issue during Migrating ME database (INT) from Oracle to HANA on 15.1 SP05

carlos_gao — Tue, 07 Aug 2018 22:59:08 GMT

ME on HANA: WIP tables, MEINT tables and ODS tables should locate in one schema. Kindly check.

Kindly refer to installation guide:

SAP ME WIP, ODS, and INT databases use a single database schema.

Question Re: Issue during Migrating ME database (INT) from Oracle to HANA on 15.1 SP05 in Product Lifecycle Management Q&A

Issue during Migrating ME database (INT) from Oracle to HANA on 15.1 SP05

Re: Issue during Migrating ME database (INT) from Oracle to HANA on 15.1 SP05