Systemcopy: problems with different schema users

[Former Member]

Hi,

I'm working on a systemcopy of an abap system with java addin. It is an Netweaver 7.01 SR1 installation.

The oracle version is 10.2.0.4.

The following problem occoured:

The source system had the ID P13. Therefore the schema users were SAPP13 and SAPP13DB.

The traget system has the ID P14. Therefore normally the schema users are SAP14 and SAPP14DB.

I read oss note 534765 I changed the dbs_ora_schema to the old ABAP schema, and the installtion of the abap went trough.

But now it stopps in the java part "Run Java migration tool kit".

The installtion wants to get information from the table SAPP14DB.j2ee_config which is not existent, but the table SAPP13DB.j2ee_config is existent.

I tried to change the scheme name in the keydb.xml and the inifile.xml in the installtion directory, and restaret the installation, but it still does not work.

Has anyone an idea how ti solve it?

Regards

Ulrike

[Former Member]

Hi,

when entering the information into Sapinst did you enter the new Schema. ? e.g SAPPI4

Mark

[Former Member]

Hi Mark,

yes, I did enter the new scheme. I tried to enter the old name, but it didn't accept those settings, so I tried with the new names SAPP14DB an d SAPP14.

Regards

Ulrike

[Former Member]

Hi,

Can you paste the output :

QL> select username from dba_users;

Mark

[Former Member]

Hi Mark,

SQL> select username from dba_users;

USERNAME

-

---

SAPP14DB

SAPP14

SAPP13DB

INSAM

SAPP13

OPS$ORAP14

OPS$SAPSERVICEP14

NAGIOS

OPS$P14ADM

SYS

SYSTEM

USERNAME

-

---

OUTLN

DBSNMP

DIP

ORACLE_OCM

TSMSYS

16 rows selected.

The users NAGIOS and INSAM are special Users (not SAP standard).

Regards

Ulrike

[Former Member]

Hi,

What happens if you do a select * from SAPPI4.BTCCTL;

Mark

[Former Member]

Hi Mark,

the table does not exist. It belongs to user SAPP13. But that should be ok according to the OSS note mentioned above. The problem is due to the tables that should belong to the java scheme SAPP14DB.

I was thinking about exporting all those tables and reimport it again the new user. But I hoped to find an easier solution.

Regards

Ulrike

[Former Member]

Hi,

Personally I do not think it's the Export dump........

What I believe is the Schema has got corupted in Sapinst when your entered it as part of the process for the install.

I recommend your trash the new install tidy everything up and run Sapinst again use the same export dump.

Should not take long, 10 minute job to tidy the sapdata etc filesystems up....

Mark

[ashish_mishra2]

Hi,

Can you please provide the error logs which you are facing in "Java Migration Phase" ?

Ashish

[Former Member]

Hi Ashish,

here is the log file runJmt.log:

com.sap.engine.frame.core.configuration.ConfigurationException: Error occurred d

uring DB access: cluster_data/dispatcher,

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceH

andler.readConfig(PersistenceHandler.java:108)

at com.sap.engine.core.configuration.impl.cache.CachedConfiguration.<ini

t>(CachedConfiguration.java:62)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.getCa

chedConfiguration(ConfigurationCache.java:848)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.getCa

chedConfiguration(ConfigurationCache.java:882)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.openC

onfiguration(ConfigurationCache.java:748)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.openC

onfiguration(ConfigurationHandlerImpl.java:734)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.openC

onfiguration(ConfigurationHandlerImpl.java:693)

at com.sap.sdt.serviceframework630.impl.ClusterDataImpl._getSourceIds0(C

lusterDataImpl.java:54)

at com.sap.sdt.serviceframework630.impl.ClusterDataImpl.getDispatcherIds

(ClusterDataImpl.java:91)

at com.sap.sdt.serviceframework630.impl.ClusterDataImpl.createIdMapping(

ClusterDataImpl.java:172)

at com.sap.sdt.jmt.migrationtool.MigrationToolImport.prepareSwitch(Migra

tionToolImport.java:1129)

at com.sap.sdt.jmt.migrationtool.MigrationToolImport.startTool(MigrationToolImport.java:403)

at com.sap.sdt.jmt.migrationtool.MigrationToolImport.main(MigrationToolImport.java:1561)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:61)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)

at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:85

4)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3

370)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415

)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeQuery(BasicPreparedStatement.java:97

)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java

:281)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java

:248)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBAccessDefault.getConfiguration

(DBAccessDefault.java:578)

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.readConfig(Pe

rsistenceHandler.java:102)

... 18 more

com.sap.engine.frame.core.configuration.ConfigurationException: Error occurred during DB access: clu

ster_data/dispatcher,

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.readConfig(Pe

rsistenceHandler.java:108)

at com.sap.engine.core.configuration.impl.cache.CachedConfiguration.<init>(CachedConfigurati

on.java:62)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.getCachedConfiguration(Co

nfigurationCache.java:848)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.getCachedConfiguration(Co

nfigurationCache.java:882)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.openConfiguration(Configu

rationCache.java:748)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.openConfiguration(Configu

rationHandlerImpl.java:734)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.openConfiguration(Configu

rationHandlerImpl.java:693)

at com.sap.sdt.serviceframework630.impl.ClusterDataImpl._getSourceIds0(ClusterDataImpl.java:

54)

at com.sap.sdt.serviceframework630.impl.ClusterDataImpl.getDispatcherIds(ClusterDataImpl.jav

a:91)

at com.sap.sdt.serviceframework630.impl.ClusterDataImpl.createIdMapping(ClusterDataImpl.java

:172)

at com.sap.sdt.jmt.migrationtool.MigrationToolImport.prepareSwitch(MigrationToolImport.java:

1129)

at com.sap.sdt.jmt.migrationtool.MigrationToolImport.startTool(MigrationToolImport.java:403)

at com.sap.sdt.jmt.migrationtool.MigrationToolImport.main(MigrationToolImport.java:1561)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:61)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)

at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:85

4)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3

370)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415

)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeQuery(BasicPreparedStatement.java:97

)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java

:281)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java

:248)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBAccessDefault.getConfiguration

(DBAccessDefault.java:578)

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.readConfig(Pe

rsistenceHandler.java:102)

... 18 more

Error executing Migration Tool Import

java.lang.IllegalArgumentException

at com.sap.sdt.serviceframework630.impl.ClusterDataImpl.createBoxNumberMapping(ClusterDataIm

pl.java:137)

at com.sap.sdt.serviceframework630.impl.ClusterDataImpl.createIdMapping(ClusterDataImpl.java

:172)

at com.sap.sdt.jmt.migrationtool.MigrationToolImport.prepareSwitch(MigrationToolImport.java:

1129)

at com.sap.sdt.jmt.migrationtool.MigrationToolImport.startTool(MigrationToolImport.java:403)

at com.sap.sdt.jmt.migrationtool.MigrationToolImport.main(MigrationToolImport.java:1561)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:61)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Additiononal information are int the log file /tmp/sapinst_instdir/NW701/LM/COPY/ORA/SYSTEM/CENTRAL/AS/jmt/

system.log

#1.5^H#C00086F783A30000000000150C720C72000482F1A7986410#1269874317354#/System/Database/sql/jdbc/direct##com.sap.sql.jdbc.direct.DirectPreparedStatement#######Thread[main,5,main]##0#0#Error#1#com.sap.sql.jdbc.direct.DirectPreparedStatement#Java#com.sap.sql_0003#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="";

SQL statement is "".#5#942#42000#ORA-00942: table or view does not exist

#fmgp14:P14:SAPP14DB#SELECT "CPATH","CID","PARENTCID","CACHEMODE","CTYPE" FROM "J2EE_CONFIG" WHERE "PATHHASH" = ?#

#1.5^H#C00086F783A30000000000160C720C72000482F1A79867F8#1269874317355#/System/Server##com.sap.engine.core.configuration#######Thread[main,5,main]##0#0#Error#1#com.sap.engine.core.configuration#Plain###ORA-00942: table or view does not exist

Regards

Ulrike