BOExcelAdapter is not getting Started

dataservices administration
1

Hi all,

At my clinet place we are usign Data Services 12.1.0.0 version, on UNIX
we have some excel files to process using data Services.

I am trying to configure SNMP on jobserver and BOExcelAdapter on Management console,

on the management console under Adapter Instances, BOExcelAdapter is not getting started.

when I try to start it, it says starting and will shutdown in few seconds.

when I try to run the job (excel file as source)from designer the job hang’s on.

please let me know if I am missing anything while configuring.

MY Configuration Process:

on Job server I Enabled SNMP with 4001 port.

on management console I have Add the MSExcelAdapter from Adapter Instance.

Is there anything that I need to check/configure to make Excel adapter work.

Attached is the screen shot of Adapter Instances page on Management Console
Adapter Instance.gif

newdiuser (BOB member since 2008-12-05)

2

Hi,

First you have to config the Adapter from Job server using that .sh scripts.
Once you have configured that adapter, then in Web-admin console you will see entry for the same.

Anyway, attached is the word document, that describes the steps, that I did in my last project.

Hope that helps!
Setting up Excel adapter connector on LINUX job server.doc (230.0 KB)

data_guy :us: (BOB member since 2006-08-19)

3

check the adapter trace and error file ? you can view the trace and error file from the management console or from the machine where Job server managing the Adapter is running from ($LINK_DIR/adapters/log directory

check the job Server log file (server_evenetlog_.txt) it will have the command for starting the Adapter, check if the Java path is correct that is used to start the adapter

make sure you are using correct version of Java

for 12.1 you will need JDK 1.5

manoj_d (BOB member since 2009-01-02)

4

Hi guys,

Thank you for you responce,

I did the same thing as you mentioned in your document.

But when I click Start Adapter (management console)after configuring, this is not getting started.

Attached are the entries from server_eventlog_.log file

I have checked that the .jar files are in correct directory, and they are.

I am not much familiar with java or UNIX, please let me know how to validate, that java is working when the adapter is started.
Server_eventlog.gif

newdiuser (BOB member since 2008-12-05)

5

to check java env, check for following
cd to $LINK_DIR/bin
source the DS env file (. ./al_env.sh)
run the following commands
echo $JAVA_HOME
which java
java -version

the other thing that you can try is copy the command line that you see in the log file and run from the command line, does it prints any errors on the stdout

what do you see in BOExcelAdapter error log file ?
to isolate if its env setup problem or Excel Adapter problem, configure a WebService Adapter, and start that, is that running successfully ?

manoj_d (BOB member since 2009-01-02)

6

Hi

I have copied the values from log which are used to start the adapter

Starting Adapter with command line :
java -classpath “/opt/BusinessObjects_12.1.0/dataservices/lib/acta_adapter_sdk.jar:/opt/BusinessObjects_12.1.0/dataservices/lib/acta_broker_client.jar:/opt/BusinessObjects_12.1.0/dataservices/ext/lib/xerces.jar:/opt/BusinessObjects_12.1.0/dataservices/lib/acta_tool.jar:/opt/BusinessObjects_12.1.0/dataservices/lib/log4j-1.2.3.jar:/opt/BusinessObjects_12.1.0/dataservices/ext/lib/poi-2.5.1-final-20040804.jar:/opt/BusinessObjects_12.1.0/dataservices/lib/msexceladapter.jar:” -Xms64m -Xmx256m com.acta.adapter.sdk.AdapterMain -a com.acta.adapter.msexceladapter.MSExcelAdapter -i BOExcelAdapter -h falcon12 -p 4001 -ccom.acta.adapter.ServiceProvider.BOExcelAdapter -cs default -mcs default -51 -js JobServer_1 -r/opt/BusinessObjects_12.1.0/dataservices
AdapterSDK version: 12.0.0.0

it gives me the following message:

com.acta.adapter.sdk.AdapterMain
-a <adapter class (fully qualified name)>
Parameters to set from Job Server:
-i
-h
-p
-r <root directory (%LINK_DIR%)>
-sh
-sp
-v
Optional command line paramters:
-d
-x
java.lang.IllegalArgumentException: Adapter startup arguments not provided.
at com.acta.adapter.sdk.AdapterRunnerImpl.(AdapterRunnerImpl.java:175)
at com.acta.adapter.sdk.AdapterMain.main(AdapterMain.java:35)
Exception in thread “main” java.lang.NullPointerException
at com.acta.adapter.sdk.AdapterMain.main(AdapterMain.java:152)

Please help me out, what this message means, and what I am missing in configuration

Thanks

newdiuser (BOB member since 2008-12-05)

7

this error is coming because you didn’t give a space after -r option
-r/opt/BusinessObjects_12.1.0/dataservices it should be
-r /opt/BusinessObjects_12.1.0/dataservices

I asked you to run the command from prompt to make sure the process starts, since you are getting this error the process is able to start

can you attach the following log files from $LINK_DIR/adapters/log directory

BOExcelAdapter_trace.txt
BOExcelAdapter_error.txt - if exists

What is the OS ? Linux or solaris or HP or AIX

manoj_d (BOB member since 2009-01-02)

8

No files are generated in $LINK_DIR/adapters/log directory

operating system: solaris

after giving space after -r option (if running from command promt)
-r /opt/BusinessObjects_12.1.0/dataservices

the adapter is getting started,

but when I click start from management console its not getting started. and its also not generating any log files in LINK_DIR/adapters/log directory.

newdiuser (BOB member since 2008-12-05)

9

kill the process that you started from command line
from the managment console, enable trace for BOExcelAdapter from Adapter configuration and start the Adapter again, check if this generates any trace file

manoj_d (BOB member since 2009-01-02)