on 12-23-2015 12:12 PM
Hi Experts,
Our SAP MDM version: 7.1 SP9
Oracle Database version: Oracle 11G R2
I am trying to execute GenerateViews.cmd on my windows 7 machine. I receive the below error while executing the command. Does any body have a clue.
C:\Users\user\Desktop>"C:\Program Files (x86)\Java\jdk1.6.0_26\jre\bin\java" -cp C:\Program Files (x86)\Java\jdk1.6.0_26\jre\bin;C:\MDMAPI\mdm-admin.jar;C:\MDMAPI\mdm-common.jar;C:\MDMAPI\mdm-core.jar;C:\MDMAPI\mdm-data.jar;C:\MDMAPI\mdm-extension.jar;C:\MDMAPI\mdm-protocol.jar;C:\MDMAPI\mdm-publishing.jar;C:\app\sapmgntinst\product\11.2.0\client_2\jdbc\lib\ojdbc5.jar;C:\app\sapmgntinst\product
\11.2.0\client_2\jlib\orai18n.jar;C:\DBVIEW\lib\MdmDbViews.jar;C:\DBVIEW\lib\MDMDatabaseHelper.jar;C:\DBVIEW\lib\MCUcommonApi.jar;C:\DBVIEW\lib\MCUcommonUtils.jar -Xmx300m -Xms300m -XX:PermSize=128m -
XX:MaxPermSize=256m -XX:NewSize=128m -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -Djava.ext.dirs=C:\MDMAPI;"C:\Program Files (x86)\Java\jdk1.6.0_26\jre\lib\ext com.sap.mdm.utilities.dbviews.Main -ms "MDM_Server_Name" -mp "" -mr "MDM_DEV" -mun "Admin" -mup "sapmdm" -regions "English [US]" -dbd "DM1" -dbt "O" -dbu "suppDM1" -dbp "xxxxx" "-LOG" "-override" "" -displayDelimiter "
; " -hierarchyDelimiter "\\"
Picked up _JAVA_OPTIONS: -Xmx512M
Exception in thread "main" java.lang.NoClassDefFoundError: Files
Caused by: java.lang.ClassNotFoundException: Files
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:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
Could not find the main class: Files. Program will exit.
Regards
Arun Sasi
Any inputs or hints. Tried with JDK 1.5 and JD 1.6 as well
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
As per the sapnote 1599633 - MDM DB Views creation support via OSS from MDM 7.1 SP10 only
It says...
For issues occurring in releases prior to MDM 7.1 SP10, contact a SAP consultant in your area and request assistance with the issue you are facing.
Though you can try below steps if that helps...
Pre-requisites:
MDM Java API version which corresponds to the MDM Server version
Java Runtime Environment, JRE 1.5.x and above
Type 2 JDBC Drivers according to the MDM database server type
For Oracle – Oracle client
1. Install the Java Runtime Environment.
2. Install the relevant JDBC Driver.
3. Unzip the DB Views execution package.Recommended Folder location: C:\Program Files\SAP MDM 5.5\DB Views
4. Install MDM Java API and make sure that the MDM Server and the MDM Java API are of the same version
Execution:
Edit the GenerateViews.cmd Configuration Options File
Parameters Description
MDMDbV_HOME Folder location of the unzipped DB Views execution package
Database home Folder location of the database client directory (ORA_HOME)
MDM JAVA API(API_DIR) Folder location of the MDM Java API
MDM Server The server on which the MDM repository is mounted
MDM Repository The repository for which you would like to generate and maintain views
MDM ServerPassword Optional – User password for performing any server-level functions
MDM User Name Optional – Name of user who is connecting to the MDM repository
and performing any repository-level functions
MDM UserPassword Optional – User password for connecting to the MDM repository and performing any repository-level functions
MDM region The regions for which the views are created
To specify 2 or more regions use ‘ : ‘ as a delimiter
To specify all regions, remove variable and instances
Database type Type of database
MDM DBMS name The database server on which the MDM repository is stored
Database UserName Optional – The user connecting to the database server
Database Password Optional – The database user’s password
Display FieldDelimiter The delimiter for concatenation of the table’s display fields Hierarchy Full Path Delimiter The delimiter for the full path of the hierarchy
IS_LOG Optional - To produce a log file, set to "-LOG"
Optional – To override existing views, set to “-override"
IS_OVERRIDE This option is preferable due to schema changes that may disable views.
IS_DELETE_ALL Optional – To delete All DB views mode, set to "-D"
Regards,
Prithviraj.
Hi Prithvi
Logging is enabled but there is no error related to JDBC or Oracle.
Below is the log file entry
# --------------------------------------------
# LOG FILE : MDM_Db_Views_SHC_MASTER_PR_151230_014215.log
# START TIME : Wed Dec 30 01:42:15 CST 2015
# --------------------------------------------
Initialize:
Connecting to repository 'SHC_MASTER_PR' on server 'fqdn'...OK. (91 ms)
Connecting to database...
Regards
Arun Sasi
Hi Arun,
This tells nothing.
Anyway check the sap note and try
1556213 - Generation of DB Views with Java utility
Regards,
Prithviraj.
Hi Prithvi,
I was able to connect to the MDM repository and was able to generate some tables and views but most of the important views and tables are missing. The command file only looks for jar files related to JDK 1.5 and Oracle JDBC(ojdbc5.jar) jar files.
The command file executed fine but it finished quickly rather than taking long time to finish
Regards
Arun Sasi
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.