When we try to import a file into Oracle Apps R12.2.4 using the import script which comes with the Jdeveloper 10.1.3.5.0, it is throwing an error message as below:
Cause:
The jar file which has the oracle.dms.console.DMSConsole is not getting set in the class path.
I tried to set this jar file in the class path using the CLASSPATH environment variable (in several ways), but didn't get it working. Finally I modified the import.bat file and it worked. So I will mention the steps here.
Fix:
Open the import.bat file which is available under C:\.....\jdevbin\oaext\bin\import.bat.
Modify the below line (line no: 121)
Save the file and try the import again.
Note:- If it didn't work, just try to restart the machine and try again.
Related blog: OAF: Import/Export Page/Personalization/Substitution using XMLImporter/JPXImporter in Oracle Application Framework
Feel free to point out if anything is missing/wrong in this blog.
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole
at oracle.jdbc.driver.DMSFactory.<clinit>(DMSFactory.java:51) at oracle.jdbc.driver.PhysicalConnection.createDMSSensors(PhysicalConnection.java:3821) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:632) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:230) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:207) at oracle.adf.mds.tools.util.ConnectUtils.getDBConnection(ConnectUtils.java:166) at oracle.jrad.tools.xml.importer.XMLImporter.importDocuments(XMLImporter.java:232) at oracle.jrad.tools.xml.importer.XMLImporter.main(XMLImporter.java:88)
Caused by: java.lang.ClassNotFoundException: oracle.dms.console.DMSConsole
at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) ... 11 more
Cause:
The jar file which has the oracle.dms.console.DMSConsole is not getting set in the class path.
I tried to set this jar file in the class path using the CLASSPATH environment variable (in several ways), but didn't get it working. Finally I modified the import.bat file and it worked. So I will mention the steps here.
Fix:
Open the import.bat file which is available under C:\.....\jdevbin\oaext\bin\import.bat.
Modify the below line (line no: 121)
to
set CLASSPATH=%JRAD_ROOT%\jdev\appslibrt\ebsuix.jar
set CLASSPATH=%JRAD_ROOT%\jdev\appslibrt\ebsuix.jar;%JRAD_ROOT%\lib\dms.jar
Save the file and try the import again.
Note:- If it didn't work, just try to restart the machine and try again.
Related blog: OAF: Import/Export Page/Personalization/Substitution using XMLImporter/JPXImporter in Oracle Application Framework
Feel free to point out if anything is missing/wrong in this blog.
Thanks a lot you are the best
ReplyDeleteThank you..
ReplyDeleteYou are super! Thank you!
ReplyDelete