on 06-19-2018 9:36 PM
Hi Experts,
Am migrating the SAP NW java 7.4 from MS sql to oracle, during my import process, its throwing the error like as below.
E R R O R ******* (DbOraColumn dev 09.04.2013 13:00:00) 12:08:47 2018-06-18 ora-Error: checkTypeAttributes failed: type attributes of column FIELD6 are invalid 12:08:47 2018-06-18 dbs-Warning: Table MDO202 was not successfully checked 12:08:47 2018-06-18 dbs-Info: <<< End of phase: Analysis 12:08:47 2018-06-18 dbs-Info: <<< End of phase: Execution of statements 12:08:47 2018-06-18 dbs-Info: Analysis and adjustment of tables finished with errors at com.sap.inst.jmigmon.engine.dispatcher.JLoadTask.execute(JLoadTask.java:175) at com.sap.inst.jmigmon.engine.dispatcher.JLoadTask.run(JLoadTask.java:125) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:763) Caused by: com.sap.inst.common.exception.TaskExecutionException: com.sap.dictionary.database.dbs.JddRuntimeException: Table MDO202 could not be created in database. Version: dev 09.04.2013 13:00:00
when i checked the source database, the table exists and the filed6 also there with nvarcahr(2000). i tried to check all logs and now with this error it got stopped the import process.
if anyone come across the same error while import of java in oracle from sql DB. please provide your inputs.
thanks
Venkata
hi All,
Finally my issue got resolved, by changing the source DB data type and re exported and import went fine with out any issue. where the target DB is not able to handle to nvarchar data type value 3000. FYI, here the source is Sql and target is oracel 12c.
thanks for all your inputs and support!!.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes, i have already gone thorugh the thread and followed the stesp. but no luck. i came to know that the target cannt take nvachar(2000) during import. it seems it has some limitation and SAP suggested to shrink the data type in source and reimport it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.