unable to read multiple files in BODS

[former_member186160]

hi all,

i am unable to read multiple files [with same format of fields] using wild card characters in file name.

scenario:

i have 2 files: test1.xlsx & test2.xlsx

in the excel file format, for the file name column, i have given test*.xlsx.

and done the direct mapping to target column.

but when i run the job i am getting below error.

at com.acta.adapter.msexceladapter.MSExcelAdapterReadTable.ReadAllRows(MSExcelAdapterReadTable.java:1242)

at com.acta.adapter.msexceladapter.MSExcelAdapterReadTable.readNext(MSExcelAdapterReadTable.java:1285)

at com.acta.adapter.sdk.StreamListener.handleBrokerMessage(StreamListener.java:151)

at com.acta.brokerclient.BrokerClient.handleMessage(BrokerClient.java:448)

at com.acta.brokerclient.BrokerClient.access$100(BrokerClient.java:53)

at com.acta.brokerclient.BrokerClient$MessageHandler.run(BrokerClient.java:1600)

at com.acta.brokerclient.ThreadPool$PoolThread.run(ThreadPool.java:100)

please let me know if there is any solution to this.

regards,

Swetha

[former_member187000 · Accepted solution]

Hi Swetha,

can provide DS version and OS details.?

[former_member186160 · Accepted solution]

hi,

below is the DS version details.

OS details:

SUSE Linux Enterprise Server 11 (x86_64)

VERSION = 11

PATCHLEVEL = 2

please suggest.

Message was edited by: Swetha N

[former_member187000 · Accepted solution]

Hi,

to process excel files in Linux, we require MSexcel adaters should be configured.

follow below steps:

1. Stop the job server and enable adapter communication for a job server and start the job server

2, create a MSExcelAdapter adater instance with BOExcelAdapter as adapterinstance name in management console

check the below link:

http://help.sap.com/businessobject/product_guides/sboDS41/en/sbo411_ds_designer_en.pdf#page=143&zoom...

[former_member186160 · Accepted solution]

hi, excel adapter is already configured. i am able to work well with a single excel file.

even giving   '*.xlsx '  works fine if only there is one file which is matching that criteria.

but when more than one file is matching that criteria, i am facing the issue.

[former_member189153 · Accepted solution]

hi,

can you please explain more about your requiment.

[former_member186160 · Accepted solution]

hi,

my requirement:

i have multiple excel files to be read, all of the files have same format of fields.

one new file will be available daily.

the names are same except that it comes with the timestamp.

example of file names:

Finance_report_12122014.xlsx

Finance_report_12132014.xlsx

..

..

..

so i am trying to use excel file format, with the file name field with value 'Finance_report_*.xlsx'

but while executing it, i get the excel adapter error as mentioned in my first reply in this thread.

so i changed the settings for Range = A10:C10 , the job is executing successfully, but no data is getting loaded to target table.

i have browsed so many webpages and in SCN, but every where its mentioned that its possible to read multiple files using wild card names for file names like *.xlsx.

but i am facing these issues. please suggest.

[former_member187000 · Accepted solution]

Hi,

i just copied a xlsx file with 3 different names (Test_Data.xlsx, Test_1.xlsx, Test_2.xlsx) and tried with below options and it worked for me.

Note: I tried on the same OS and DS 4.1 SP2(14.1.2.378)versions. In Linux File names are case sensitive.

[former_member187605 · Accepted solution]

If you don't need all fields and don't know the number of row upfront, define a custom range. Make sure you specify at least 2 rows in "Custom range" and do not forget to check "Extend range":

[former_member186160 · Accepted solution]

i have the same setting in my job, but not sure why my job is not working.

[former_member186160 · Accepted solution]

yes , i have tried giving these settings too.

job is executing successfully but not loading any records.

[former_member187605 · Accepted solution]

Is there any info in the trace, monitor or error files?

if not, activate error handling:

[former_member186160 · Accepted solution]

hi, i tried the above error handling settings. but the error file is not at all getting created.

pls suggest if any idea on this.

[former_member187605 · Accepted solution]

To summarise:

• You're able to process one file, even using *.xlsx wildcard notation.
• When more than one file present, no output at all is generated.
• Error handling does not produce any output at all (Have you tried it with one file, too? Of course, when input is 100% correct, no error output will be generated)
• It's not a generic bug, because not reproducible on another system

Are these assumptions correct?

if so, I cannot give you a final definitive solution, but here's a couple of additional suggestions:

• Contact SAP support
• (They will say) upgrade to a more / the most recent DS version
• Develop a workaround:
  • Concatenate your files at OS-level before processing in DS, or
  • Build a loop in DS to process each file individually

[former_member186160 · Accepted solution]

we are waiting for upgrading our DS version.

hopefull for this issue to be resolved after that.

[former_member186160]

hi all,

the issue was due to the designer being in old version.

we need to atleast upgrade to 4.2 version.