Author Topic: ICN Configuration Error on execute configuration files from the command line  (Read 4284 times)

Jaydeep Mehta

  • Guest
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 

SV

  • Guest
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

Jaydeep Mehta

  • Guest
 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

sisusteve

  • Guest
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?