cancel
Showing results for 
Search instead for 
Did you mean: 

Error while executing the GenerateViews.cmd

former_member198401
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member198401
Active Contributor
0 Kudos

Any inputs or hints. Tried with JDK 1.5 and JD 1.6 as well

Regards

Arun Sasi

Former Member
0 Kudos

Hi Arun,

Please check the sapnote

1855991 - DBViews generation using clix command

Regards,

Prithviraj.

former_member198401
Active Contributor
0 Kudos

Thanks for the reply Prithviraj!!

We are about to upgrade to SP 10 next year but I was wondering whether we could update our existing views using the existing command file(GenerateViews.cmd)

Regards

Arun Sasi

Former Member
0 Kudos

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.

former_member198401
Active Contributor
0 Kudos

Hi Prithvi

I have somehow managed to run the command file but now its giving an error message

MDM DB Views Creator terminated abnormally. exit(-9999)

Any idea about this error

Regards

Arun Sasi

Former Member
0 Kudos

Hi Sasi,

Did you meet all the pre-requisites before running the command?

Also set IS_LOG parameter and share the complete log.

The error can be due to JDBC driver, oracle client mismatch, we may find details in logs the exact reason.

Regards,

Prithviraj.

former_member198401
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Arun,

This tells nothing.

Anyway check the sap note and try

1556213 - Generation of DB Views with Java utility

Regards,
Prithviraj.

former_member198401
Active Contributor
0 Kudos

Yeah Prithvi... I know this doesnt provide any useful info ...

I tried to put the ojdbc5.jar file under classpath but still it doesnt work....

Not sure whats the issue. Will keep trying

Regards

Arun Sasi

former_member198401
Active Contributor
0 Kudos

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

Answers (0)