Topic
  • 6 replies
  • Latest Post - ‏2013-03-09T18:08:03Z by SystemAdmin
SystemAdmin
SystemAdmin
648 Posts

Pinned topic Schema version mismatch error creating test company

‏2012-06-25T06:34:17Z |
I have setup MDM Collaboration Server 10.0 on an AIX server and I am in the verification phase.

When I run the create_cmp script I get an error. As shown below:

-bash-3.2$ ./bin/db/create_cmp.sh --code=test
====================================================
database user name: pim
database user passwd: *****
Client login command: CONNECT TO pimdb USER pim USING *****
JDBC driver type: 4
JDBC URL: jdbc:db2://dev-mdm01.foodstuffs-wgtn.co.nz:60000/pimdb
====================================================

company code: test
company name: test
company locale: en_US
!! do you want to continue ? (y/n)y
Analyzing ....
=======================================
ERROR: Database schema version mismatch
=======================================
To avoid possible data corruption the application will not be started
You must update your Schema schema proceeding

Does anybody know what could cause this? I am completely stumped.

Justin
Updated on 2013-03-09T18:08:03Z at 2013-03-09T18:08:03Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    648 Posts

    Re: Schema version mismatch error creating test company

    ‏2012-06-25T06:59:36Z  
    Hi,

    Did you complete the step *Creating the schema*?

    http://publib.boulder.ibm.com/infocenter/mdm/v10r0m0/topic/com.ibm.pim.ins.doc/pim_tsk_create_schema.html
  • SystemAdmin
    SystemAdmin
    648 Posts

    Re: Schema version mismatch error creating test company

    ‏2012-06-25T22:03:07Z  
    Hi,

    Did you complete the step *Creating the schema*?

    http://publib.boulder.ibm.com/infocenter/mdm/v10r0m0/topic/com.ibm.pim.ins.doc/pim_tsk_create_schema.html
    Yes. I ran it in verbose mode and it didn't return any errors. I debugged the creat company script somewhat it just checks for a successful return and gives the same error message no matter what re the schema. Running the java command that it runs I get the following stack trace

    Exception in thread "main" java.lang.ExceptionInInitializerError
    at java.lang.J9VMInternals.initialize(J9VMInternals.java:222)
    at com.ibm.ccd.common.context.ThreadResource.getResourceForCurrentThread(Unknown Source)
    at com.ibm.ccd.synchronize.DBSchemaVersion.isSynchronized(Unknown Source)
    at com.ibm.ccd.synchronize.DBSchemaVersion.main(Unknown Source)
    Caused by: Generic Error
    at com.ibm.ccd.common.context.AustinContext.initCacheManager(Unknown Source)
    at com.ibm.ccd.common.context.AustinContext.<clinit>(Unknown Source)
    at java.lang.J9VMInternals.initializeImpl(Native Method)
    at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
    ... 3 more
    Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:45)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:515)
    ... 7 more
    Caused by: net.sf.ehcache.CacheException: Not a multicast address
    at net.sf.ehcache.distribution.MulticastRMICacheManagerPeerProvider.init(MulticastRMICacheManagerPeerProvider.java:99)
    at net.sf.ehcache.CacheManager.init(CacheManager.java:327)
    at net.sf.ehcache.CacheManager.<init>(CacheManager.java:208)
    at com.ibm.ccd.cache.ehcache.EhcacheMdmCacheManager.<init>(Unknown Source)
    ... 11 more

    I'm checking the multicast setting from

    ...
    cache
    1. multicast ip addr for MDMPIM cache. Must be unique on the LAN
    multicast_addr=11.5.5.1
    ...

    How do I verify that my RMI port is correct? ... that I suppose is the only other thing that could be wrong.

    BTW at this point I haven't started the application in Websphere ... should I?
  • SystemAdmin
    SystemAdmin
    648 Posts

    Re: Schema version mismatch error creating test company

    ‏2012-06-26T01:54:46Z  
    Yes. I ran it in verbose mode and it didn't return any errors. I debugged the creat company script somewhat it just checks for a successful return and gives the same error message no matter what re the schema. Running the java command that it runs I get the following stack trace

    Exception in thread "main" java.lang.ExceptionInInitializerError
    at java.lang.J9VMInternals.initialize(J9VMInternals.java:222)
    at com.ibm.ccd.common.context.ThreadResource.getResourceForCurrentThread(Unknown Source)
    at com.ibm.ccd.synchronize.DBSchemaVersion.isSynchronized(Unknown Source)
    at com.ibm.ccd.synchronize.DBSchemaVersion.main(Unknown Source)
    Caused by: Generic Error
    at com.ibm.ccd.common.context.AustinContext.initCacheManager(Unknown Source)
    at com.ibm.ccd.common.context.AustinContext.<clinit>(Unknown Source)
    at java.lang.J9VMInternals.initializeImpl(Native Method)
    at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
    ... 3 more
    Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:45)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:515)
    ... 7 more
    Caused by: net.sf.ehcache.CacheException: Not a multicast address
    at net.sf.ehcache.distribution.MulticastRMICacheManagerPeerProvider.init(MulticastRMICacheManagerPeerProvider.java:99)
    at net.sf.ehcache.CacheManager.init(CacheManager.java:327)
    at net.sf.ehcache.CacheManager.<init>(CacheManager.java:208)
    at com.ibm.ccd.cache.ehcache.EhcacheMdmCacheManager.<init>(Unknown Source)
    ... 11 more

    I'm checking the multicast setting from

    ...
    cache
    1. multicast ip addr for MDMPIM cache. Must be unique on the LAN
    multicast_addr=11.5.5.1
    ...

    How do I verify that my RMI port is correct? ... that I suppose is the only other thing that could be wrong.

    BTW at this point I haven't started the application in Websphere ... should I?
    I configured and tested the multicast issue and the script runs wihout an error. It seems to be hanging right now though. Some futher troubleshooting is probably required.

    Justin
  • KaranBal
    KaranBal
    108 Posts

    Re: Schema version mismatch error creating test company

    ‏2012-06-27T16:56:56Z  
    I configured and tested the multicast issue and the script runs wihout an error. It seems to be hanging right now though. Some futher troubleshooting is probably required.

    Justin
    The error indicates that the database schema user is not compatible with the version of MDMCS that you are trying to install. My guess is that you installed a new version of MDMCS and tried to connect it to an older database without migrating the database itself.
    Please verify that you have migrated the database schema to the required version. You can also use the $TOP/bin/db/verify_tables_indexes.sh to check the state of your table space.
  • SystemAdmin
    SystemAdmin
    648 Posts

    Re: Schema version mismatch error creating test company

    ‏2012-07-03T08:05:48Z  
    I configured and tested the multicast issue and the script runs wihout an error. It seems to be hanging right now though. Some futher troubleshooting is probably required.

    Justin
    Setting a valid multicast address fixed the problem
  • SystemAdmin
    SystemAdmin
    648 Posts

    Re: Schema version mismatch error creating test company

    ‏2013-03-09T18:08:03Z  
    Setting a valid multicast address fixed the problem
    Hi Justin,

    Where did you set the multicast address? In the env_settings_ini file? If so does that mean you have to configure the installation once again?

    Thx.