Hi All,
We had successfully install the IBM Content Navigator Version 2.0.3 on Linux and
we are doing Configuring and deploying IBM Content Navigator components using Command Line Interface because we don't have GUI.
GenerateConfig files also done successfully , and after generating xml
we updated the config xml file with there value and executing the configuration files as below & getting error
'Connection error: null' and table or view does not exist.
./configmgr_cl execute -profile /opt/IBM/ECMClient/configure/profiles/GSDICN_Profile1 -debug
eclipse.buildId=unknown
java.fullversion=JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr13-20130114_134867 (JIT disabled, AOT disabled)
J9VM - 20130114_134867
GC - 20121212_AA
BootLoader constants: OS=linux, ARCH=x86, WS=gtk, NL=en_US
Framework arguments: execute -profile /opt/IBM/ECMClient/configure/profiles/GSDICN_Profile1
Command-line arguments: -os linux -ws gtk -arch x86 execute -profile /opt/IBM/ECMClient/configure/profiles/GSDICN_Profile1 -debug
!ENTRY com.ibm.ecm.configmgr.app.nexus 4 0 2016-08-25 04:35:55.142
!MESSAGE Connection error: null
!STACK 0
com.ibm.ecm.configmgr.engine.ConfigurationManagerException: Connection error: null
at com.ibm.ecm.configmgr.engine.jmx.JMXInvoker.invokeConnectMethodAndMethods(JMXInvoker.java:238)
at com.ibm.ecm.configmgr.engine.jmx.JMXInvoker.invokeConnectMethodAndMethod(JMXInvoker.java:142)
at com.ibm.ecm.configmgr.engine.jmx.WebSphereJMXInvoker.connect(WebSphereJMXInvoker.java:85)
at com.ibm.ecm.configmgr.app.nexus.applicationserver.WebsphereApplicationServer$TestActivity.testWork(WebsphereApplicationServer.java:393)
at com.ibm.ecm.configmgr.engine.profile.EnvironmentTestActivity.test(EnvironmentTestActivity.java:64)
at com.ibm.ecm.configmgr.engine.cli.ExecuteCommand.processCommand(ExecuteCommand.java:71)
at com.ibm.ecm.configmgr.engine.cli.CommandLineProcessor.execute(CommandLineProcessor.java:72)
at com.ibm.ecm.configmgr.engine.ConfigMgr.processCommandLineInterface(ConfigMgr.java:63)
at com.ibm.ecm.configmgr.app.nexus.rcp.Application.start(Application.java:77)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
Caused by: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:877)
at java.util.Properties.setProperty(Properties.java:681)
at com.ibm.websphere.management.AdminClientFactory.decodePasswordsAndExpandVariables(AdminClientFactory.java:1356)
at com.ibm.websphere.management.AdminClientFactory.loadPropertiesFromFile(AdminClientFactory.java:1229)
at com.ibm.websphere.management.AdminClientFactory.access$100(AdminClientFactory.java:127)
at com.ibm.websphere.management.AdminClientFactory$2.run(AdminClientFactory.java:392)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:63)
at com.ibm.websphere.management.AdminClientFactory.createAdminClientPrivileged(AdminClientFactory.java:390)
at com.ibm.websphere.management.AdminClientFactory.access$000(AdminClientFactory.java:127)
at com.ibm.websphere.management.AdminClientFactory$1.run(AdminClientFactory.java:210)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:63)
at com.ibm.websphere.management.AdminClientFactory.createAdminClient(AdminClientFactory.java:206)
at com.ibm.ecm.configmgr.utils.websphere.WebSphereJMXUtil.connect(WebSphereJMXUtil.java:135)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ecm.configmgr.engine.jmx.JMXInvoker.invokeConnectMethodAndMethods(JMXInvoker.java:191)
... 20 more
!ENTRY com.ibm.ecm.configmgr.engine 4 0 2016-08-25 04:36:24.392
!MESSAGE There was an error executing the Configure Your Database and Data Source task.
!STACK 0
com.ibm.ecm.configmgr.engine.ConfigurationManagerException: The task failed with the following messages:
error occurred during batching: ORA-00942: table or view does not exist
error occurred during batching: ORA-00942: table or view does not exist
Please assist .
Thanks in Advance
Regards
JD
I attempted to setup INC on Linux but could not complete due to time crunch, but moved on. I will be trying again later on. So has some experience. Hope this might help.
after running the generateConfig, I ran the sroepassword cmds, then ran the execute for individual tasks in certain order. Listed the cmds I used in the order I ran them.
generateConfig
./configmgr_cl generateConfig -appserver websphere -appserverVersion 8.5 -configure_CMOD yes -db oracle -icn_sso none -deploy cluster -profile /opt/IBM/ECMClient/configure/profiles
storepassword:
./configmgr_cl storePasswords �profile /opt/IBM/ECMClient/configure/profiles �task configureodwek -taskfile configureodwek.xml
./configmgr_cl storePasswords �profile /opt/IBM/ECMClient/configure/profiles�task configurejdbcecm -taskfile configurejdbcecm.xml
./configmgr_cl storePasswords �profile /opt/IBM/ECMClient/configure/profiles �task configurejdbcjarsecm -taskfile configurejdbcjarsecm.xml
./configmgr_cl storePasswords �profile /opt/IBM/ECMClient/configure/profiles �task configureloginmodules -taskfile configureloginmodules.xml
./configmgr_cl storePasswords �profile /opt/IBM/ECMClient/configure/profiles �task rebuildear -taskfile rebuildear.xml
./configmgr_cl storePasswords �profile /opt/IBM/ECMClient/configure/profiles �task deployapplication -taskfile deployapplication.xml
./configmgr_cl storePasswords �profile /opt/IBM/ECMClient/configure/profiles �task configureicntask -taskfile configureicntask.xml
./configmgr_cl storePasswords �profile /opt/IBM/ECMClient/configure/profiles �task configuretmtask -taskfile configuretmtask.xml
then execute tasks:
./configmgr_cl execute -task configureodwek -taskfile configureodwek.xml -profile /opt/IBM/ECMClient/configure/profiles
./configmgr_cl execute -task configurejdbcjarsecm -taskfile configurejdbcjarsecm.xml -profile /opt/IBM/ECMClient/configure/profiles
./configmgr_cl execute �task configurejdbcecm -taskfile configurejdbcecm.xml -profile /opt/IBM/ECMClient/configure/profiles
./configmgr_cl execute �task configureloginmodules -taskfile configureloginmodules.xml -profile /opt/IBM/ECMClient/configure/profiles
./configmgr_cl execute �profile /opt/IBM/ECMClient/configure/profiles �task configuretmtask -taskfile configuretmtask.xml
./configmgr_cl execute �profile /opt/IBM/ECMClient/configure/profiles�task configureicntask -taskfile configureicntask.xml
./configmgr_cl execute �profile /opt/IBM/ECMClient/configure/profiles�task rebuildear -taskfile rebuildear.xml
./configmgr_cl execute �profile /opt/IBM/ECMClient/configure/profiles �task deployapplication -taskfile deployapplication.xml
Thanks SV.
I tried to execute command for individual tasks but still getting the same error for task below .
./configmgr_cl execute �task configurejdbcecm -taskfile configurejdbcecm.xml -profile /opt/IBM/ECMClient/configure/profiles
error occurred during batching: ORA-00942: table or view does not exist
error occurred during batching: ORA-00942: table or view does not exist
Thanks
JD
Which database are you using for ICN?
Have you installed and configured the JDBC drivers for that database?
Did you configure the ICN configurejdbcecm.xml profile to run the DB script to create the tables? if not you need to manually run the updated script on the ICN database server.
Have you tested database connectivity from WAS?