197 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
System Info Report
Thu, Jan 19th 2017 9
Cumulative Hotfix 9001-ST-Proxy-FP-WLIN-A8ZJ5B for Sametime Proxy 9.0.0.1 [April 2016]
Wed, Apr 27th 2016 8
What do you think of when you hear IBM?
Tue, Apr 19th 2016 8
Your ACTION Required for Sametime 9 iOS Customers before May 5, 2016 - Updated security certificate for Push Notifications (iOS)
Mon, Apr 18th 2016 4
Sametime VMCU Capacity
Thu, Oct 8th 2015 4
Documentação em Português do IBM Sametime 9
Wed, Sep 30th 2015 4
Configuring LDAP for Domino on the Sametime Meeting Recording / Renderer Server on WAS 8.5.5.5
Tue, Sep 29th 2015 8
Top 10
System Info Report
Thu, Jan 19th 2017 9
Configuring LDAP for Domino on the Sametime Meeting Recording / Renderer Server on WAS 8.5.5.5
Tue, Sep 29th 2015 8
What do you think of when you hear IBM?
Tue, Apr 19th 2016 8
Cumulative Hotfix 9001-ST-Proxy-FP-WLIN-A8ZJ5B for Sametime Proxy 9.0.0.1 [April 2016]
Wed, Apr 27th 2016 8
CWWIM4551E Change handler was not defined for repository type 'DOMINO'
Wed, Aug 27th 2014 7
Recommendations for Network FIle System (NFS) Shared Area in Connections / Message Stores in Websphere
Wed, Jul 30th 2014 7
Ubuntu 14.04.1 LTS Post Install Tasks
Sat, Dec 6th 2014 6
IBM Connections 5.0 Cumulative Refresh 1 (CR1) Released!
Thu, Oct 16th 2014 5
Sametime VMCU Capacity
Thu, Oct 8th 2015 4
Documentação em Português do IBM Sametime 9
Wed, Sep 30th 2015 4


Sametime 9 Video Manager install fails - solidDB tables are not created at install
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

At a Sametime 9 Deployment, we ran into an issue where the database tables were not created at install, and received the following error in the IBM Installation Manager:

Exception thrown when trying to register installation with Sametime System Console 
Register the Sametime Media Server in Sametime System Console Server by running registerProduct.bat/sh utility 
Exception thrown when trying to add SIP Peer in Sametime Video Manager Server 
Exception thrown when trying to modify the default Conference Template in Sametime Video Manager Server 
Exception thrown when trying to create a new user in Sametime Video Manager Server. Use the default credentials. 

To check if the installer created the solidDB tables required, run the following commands:

[root@vmgrserver1 ~]# cd /opt/solidDB/soliddb-7.0/bin/
[root@vmgrserver1 bin]# ./solsql
IBM solidDB SQL Editor (teletype) - Version: 7.0.0.0 Build 2011-10-14
Copyright Oy International Business Machines Ab 1993, 2011.
Username: admin
Password:
Connected to default server.
Execute SQL statements terminated by a semicolon.
Exit by giving command: exit;
solsql> list tables;
RESULT
------
Catalog: PROXIAS
  Schema: ADMIN
    TABLES:
    -------
    CHANGE_MONITOR
    COMMOBJECT
    COMMOBJECT_H323IDENTITY_H323ID
    COMMOBJECT_H323IDENTITY_EMAILID
    COMMOBJECT_H323IDENTITY_MOBILEUIM
    COMMOBJECT_H323IDENTITY_URLID
    COMMOBJECT_H323IDENTITY_PARTYNUMBER
    COMMOBJECT_H323IDENTITY_DIALEDDIGITS
    COMMOBJECT_H323IDENTITY_TRANSPORTID
    COMMOBJECT_H323IDENTITY_CALLSIGNALADDRESS
    COMMOBJECT_H323IDENTITY_SECONDARYKEY
    COMMOBJECT_H323IDENTITY_RASADDRESS
    COMMOBJECT_H323IDENTITY_TERMINALTYPE
    COMMOBJECT_H323IDENTITY_FLATNAMESPACEUSERNAMES
    COMMOBJECT_H323IDENTITY_EMAILIDDERIVEFROMUSER
    COMMOBJECT_SIPIDENTITY_IDENTITYADDRESSESEXPIRE
    COMMOBJECT_SIPIDENTITY_IDENTITYSECONDARYKEY
    COMMOBJECT_SIPIDENTITY_IDENTITYTERITARYKEY
    COMMOBJECT_DEVICESITEUID
    HIBERNATECONFERENCEROOMIMPL
    HIBERNATECONFERENCEROOMTEMPLATEIMPL
    DIALRULE
    DEVICEAUTHENTICATION
    ENTERPRISEDIRECTORYCONFIG
    ENTERPRISEDIRECTORYREPORTSTATUS
    ENTERPRISEDOMAIN
    DOMAINSTATUSIMPL
    ENTERPRISEGROUPMAPPING
    ENTERPRISEGROUPMAPPING_ROLES
    EXTGATEKEEPER
    EXTMCUZONE
    EXTMCUZONEORDER
    EXTSBC
    EXTSIPPROXY
    EXTSIPPROXY_DOMAINLIST
    MEDIAPATHEXCLUSION
    NETWORK
    NETWORKUSAGESCOPE
    SUPERCLUSTERNODE
    SUPERCLUSTERNODE_ALTNAMES
    OUTBOUNDSIPAUTHENTICATION
    SCHEDULEDBANDWIDTHRESERVATION
    SCHEDULEDBANDWIDTHRESERVATION_THROTTLEPOINTBANDWIDTH
    SIMPLIFIEDGWDIALING
    SITE
    SITE_ISDNNUMBERASSIGNMENTCONFIG_ISDNNUMBERRANGES
    SITELINK
    TERRITORY
    TERRITORYOWNER
    PERSISTEDUSERINFO
    PERSISTEDUSERINFO_CONFERENCECODEERRORS
    PERSISTEDUSERINFO_INDIVIDUALROLES
    PERSISTEDUSERINFO_GROUPROLES
    VERTICALSERVICECODE
    VIRTUALENTRYQUEUE
    ACCOUNTCONFIG
    ALERTCONFIGURATION
    AVPROTECTIONCONFIG
    CALENDARCONFIG
    CALLSERVERCONFIGURATION
    CALLSERVERCONFIGURATION_SIPDOMAINLIST
    CMAINTEGRATIONCONFIGURATION
    CONSOLESESSIONCONFIG
    DEFAULTCONFERENCESETTINGSIMPL
    DNSPUBLISHINGCONFIGURATION
    DEVICEAUTHENTICATIONCONFIGURATION
    ENTERPRISEDIRECTORYSTATUS
    JUNIPERCONFIGURATION
    LOGINBANNERCONFIGURATION
    PASSWORDCONFIG
    REGISTRATIONPOLICYCONFIGURATION
    REPLICATIONSERVER
    REPLICATIONSERVER_NAMES
    SITETOPOLOGYSERVERCONFIGURATION
    VIRTUALENTRYQUEUEDEFAULT
    MRCCONFIGURATION
    GATEKEEPERBLACKLISTCONFIGURATION
    WHITELIST
    WHITELIST_WHITELISTIPS
    DMAFARMCONFIGURATION
    DAILY_STATISTICS
    CONFERENCEAUDIT
    CALLDEVICEALIASES
    CALLEVENT
    CALLPROPERTY
    CALLAUDIT
    NETWORKUSAGE
    CONFERENCEEVENT
    HOURLY_STATISTICS
    SUBSCRIPTIONBEGIN
    CALLMETADATA
    NETWORKUSAGE_SCOPE
    REGISTRATIONBEGIN
    CALLENDINFO
    MINUTELY_STATISTICS
    CONFERENCEPROPERTY
    REGISTRATIONSIGNALINGMESSAGE
    REGISTRATIONALIAS
    SUBSCRIPTIONEND
    CDRPROPERTY
    ALERTAUDIT
    SUBSCRIPTIONSIGNALINGMESSAGE
    REGISTRATIONEND
    EXPORTHISTORY

1 rows fetched.

solsql>


To create the required database schemas, need to run the following commands

loadSolidDBSchema.sh
createLBSchema.sh

When running this script the issue was that the customer installed Websphere in /local/IBM/Websphere/AppServer/ instead of /opt/IBM/WebSphere/AppServer and the creation script is looking for /opt/IBM/WebSphere/AppServer/java for the install path.

---------------------
http://dansilva.blogspot.com/2014/09/sametime-9-video-manager-install-fails.html
Sep 16, 2014
3 hits



Recent Blog Posts
9
System Info Report
Thu, Jan 19th 2017 8:23p   Dan Silva




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition