Issue while executing the JOB in BODS 4.2 SP6

[former_member247941]

HI Experts,

We are facing the issue while executing the JOBS in BODS 4.2

Environment of our server:

OS: Linux

DB Sybase

BODS version : 4.2 Sp6

Error Details:

1633

4160571200

RUN-058105

5/28/2016 10:00:50 AM

Error preparing to read <Query>: <Exception occurs when executing 'begin' method of the adapter operation with ID [1]. No files

1633

4160571200

RUN-058105

5/28/2016 10:00:50 AM

were found with names like C:\Users\XXX\Desktop/TCodesforIDOCS.xlsx. Make sure the Excel adapter is installed on

1633

4160571200

RUN-058105

5/28/2016 10:00:50 AM

the Job Server or make sure you mount the file directory in a shared folder to the Job Server on which the Excel adapter is

I have enabled the BOExcelAdapter and its running,Can you please help me in resolving the issue.

Thanks in advance

Thanks & regards

Teja

[former_member187605 · Accepted solution]

C:\Users\XXX\Desktop/ is definitely not the name of a Linux folder. The error text is clear, isn't it?

"

make sure you mount the file directory in a shared folder to the Job Server on which the Excel adapter is installed

"

[former_member247941 · Accepted solution]

HI Dirk,

Thank you for your reply

My Share folders are in Windows environment and my BODS server is in Linux,

1) You mean to mount the windows shared folder directly to Linux server ?

2) If so when the job executes which user will be running in the background to pick the file...

I am asking this because we required to create the same user  eg: SIDADM,DBSID or Developer users in share drive and give the access to Read,Write and execute to make the job successful.

PLease correct me if i am wrong

Thanks & Regards

Teja

[former_member187605 · Accepted solution]

Yes, the DS jobs on the Linux server must have access to the file. The owner of the DS installation is the user you'll have to grant access to.

[former_member198540 · Accepted solution]

In fact, you need mount the share folder in the Linux level, to made possible that the JoServer read the Excel file.

btw you need grant acces(permissions) to this share folder to DS user too.

[former_member247941 · Accepted solution]

HI Dirk,

Thanks issue of accessing the files is resolved as we have placed the files on the server driectly by mounting a share drive,

But still we are receiving the issue as below

989	3.79E+09	RUN-058107	6/1/2016 9:01	|Data flow J_Test|Reader Test_Excel1
989	3.79E+09	RUN-058107	6/1/2016 9:01	Error reading from <Test_Excel1>: <java.lang.StringIndexOutOfBoundsException: String index out of range: 0
989	3.79E+09	RUN-058107	6/1/2016 9:01	at java.lang.String.charAt(String.java:707)
989	3.79E+09	RUN-058107	6/1/2016 9:01	at com.acta.adapter.msexceladapter.MSExcelAdapterReadTable.ReadAllRowsNew(MSExcelAdapterReadTable.java:2242)
989	3.79E+09	RUN-058107	6/1/2016 9:01	at com.acta.adapter.msexceladapter.MSExcelAdapterReadTable.readNextNew(MSExcelAdapterReadTable.java:1420)
989	3.79E+09	RUN-058107	6/1/2016 9:01	at com.acta.adapter.msexceladapter.MSExcelAdapterReadTable.readNext(MSExcelAdapterReadTable.java:1311)
989	3.79E+09	RUN-058107	6/1/2016 9:01	at com.acta.adapter.sdk.StreamListener.handleBrokerMessage(StreamListener.java:178)
989	3.79E+09	RUN-058107	6/1/2016 9:01	at com.acta.brokerclient.BrokerClient.handleMessage(BrokerClient.java:406)
989	3.79E+09	RUN-058107	6/1/2016 9:01	at com.acta.brokerclient.BrokerClient.access$100(BrokerClient.java:53)
989	3.79E+09	RUN-058107	6/1/2016 9:01	at com.acta.brokerclient.BrokerClient$MessageHandler.run(BrokerClient.java:1559)
989	3.79E+09	RUN-058107	6/1/2016 9:01	at com.acta.brokerclient.ThreadPool$PoolThread.run(ThreadPool.java:100)
989	3.79E+09	RUN-058107	6/1/2016 9:01	>.
973	4.16E+09	RUN-058107	6/1/2016 9:01	|Data flow J_Test|Reader Test_Excel1
973	4.16E+09	RUN-058107	6/1/2016 9:01	Error reading from <Test_Excel1>: <java.lang.StringIndexOutOfBoundsException: String index out of range: 0
973	4.16E+09	RUN-058107	6/1/2016 9:01	at java.lang.String.charAt(String.java:707)
973	4.16E+09	RUN-058107	6/1/2016 9:01	at com.acta.adapter.msexceladapter.MSExcelAdapterReadTable.ReadAllRowsNew(MSExcelAdapterReadTable.java:2242)
973	4.16E+09	RUN-058107	6/1/2016 9:01	at com.acta.adapter.msexceladapter.MSExcelAdapterReadTable.readNextNew(MSExcelAdapterReadTable.java:1420)
973	4.16E+09	RUN-058107	6/1/2016 9:01	at com.acta.adapter.msexceladapter.MSExcelAdapterReadTable.readNext(MSExcelAdapterReadTable.java:1311)
973	4.16E+09	RUN-058107	6/1/2016 9:01	at com.acta.adapter.sdk.StreamListener.handleBrokerMessage(StreamListener.java:178)
973	4.16E+09	RUN-058107	6/1/2016 9:01	at com.acta.brokerclient.BrokerClient.handleMessage(BrokerClient.java:406)
973	4.16E+09	RUN-058107	6/1/2016 9:01	at com.acta.brokerclient.BrokerClient.access$100(BrokerClient.java:53)
973	4.16E+09	RUN-058107	6/1/2016 9:01	at com.acta.brokerclient.BrokerClient$MessageHandler.run(BrokerClient.java:1559)
973	4.16E+09	RUN-058107	6/1/2016 9:01	at com.acta.brokerclient.ThreadPool$PoolThread.run(ThreadPool.java:100)
973	4.16E+09	RUN-058107	6/1/2016 9:01	>.

I have enabled the excel adapter too

Thanks in advance

Thanks & regards

Teja

[former_member187605 · Accepted solution]

StringIndexOutOfBoundsException seems to indicate something wrong with the file format. How have you copied the Excel file from Windows to the Linux shared drive?

[former_member247941 · Accepted solution]

Hi Dirk,

yes i have copied the file from windows to linux system.

File format - .xlsx

Thanks & Regards

Teja

[former_member187605 · Accepted solution]

With ftp? In bin mode?

[former_member247941 · Accepted solution]

Hi Dirk,

Used winscp  and moved the files to the server.

given the permissions as <SIDadm>:sapadmin 

permissions 775

Thanks & Regards

Teja

[former_member187605 · Accepted solution]

Winscp is fine. But which protocol? Ftp? And are you sure you copied the file in bin mode?

If you are not sure, copy it back to Windows and see whether you can still open it in Excel.

[former_member198401 · Accepted solution]

Teja,

Refer below link. Its seems to be an issue with the profile parameters

BO Excel Adpater for Unix not working | SCN

Regards

Arun Sasi

[former_member187605 · Accepted solution]

I tend to disagree . The adapter is started and running. It cannot process the file. That seems to be a different issue to me.

[former_member198401 · Accepted solution]

Not sure Dirk. It is very difficult to troubleshoot issues with Job server on Unix.

Anyways I have found a SAP Note

2267581 - Error "java.lang.StringIndexOutOfBoundsException: String index out of range:" when running...

Almost relevant to issue which is being faced by Teja.

Teja, Can you try saving the file as .XLS and check if it works.

Regards

Arun Sasi

[former_member247941 · Accepted solution]

HI Dirk,

i have moved the files using SFTP,

Please find the logs of Job server:

Job name: J_Test

(14.2) 05-27-16 14:37:13 (E) (1531:4160571200) RUN-058105: |Data flow J_Test Error preparing to read <Query>: <Adapter instance name not found: BOExcelAdapter>. (14.2) 05-27-16 14:37:19 (E) (1485:4160571200) RUN-058105: |Data flow J_Test Error preparing to read <Query>: <Adapter instance name not found: BOExcelAdapter>. 

Can you please help me in resolving the issue

Thanks & Regards

Teja

[former_member187605 · Accepted solution]

That is a totally different error message. The Excel adapter is not running (anymore)!

[former_member247941 · Accepted solution]

Hi Dirk/Sasi,

Sorry i have updated the old logs of excel adapter before starting in my previous post

I am using the ftp protocol and i am able to download the excel file from server to my desktop in same excel format.

Having the issue only in  .xlsx format where as below formats are working fine

.xls

.csv

.txt

can you please help me in resolving the issue of .xlsx

Thanks & regards

Teja

[former_member247941 · Accepted solution]

Hi Dirk/Sasi,

Sorry i have updated the old logs of excel adapter before starting in my previous post

I am using the ftp protocol and i am able to download the excel file from server to my desktop in same excel format.

Having the issue only in  .xlsx format where as below formats are working fine

.xls

.csv

.txt

can you please help me in resolving the issue of .xlsx

Thanks & regards

Teja