I did check for this problem in forum, but no luck.
I am literally stuck in these, so any pointers will be very helpful.
I did successfully import EXCEL file from WINDOW server in my past project, but now I am working on LINUX platform, and when I run my job, I get this error:
2/8/2008 4:40:39 PM Job Server <> defined for adapter datastore <ORDER_SMRY1> is not found in the repository. Please select a valid Job Server in
2/8/2008 4:40:39 PM the Datastore Editor dialog.
Is there any important steps thats need to be done, while working on Linux machine to import Excel as a source.
Due to some limitation, I cant save those Excel file in CSV format, as I am using data generated from a BO report, which we saves in EXCEL format.
Since we want to automate the process, the format has to be EXCEL, unless we can save BO report in CSV format
This doesn’t help your specific problem, but another alternative, if you can’t get the Excel to work:
If your BO reporting environment is XIR2 SP2 or later, you could use Query as a Web Service in BO reporting. Then in DI, create a web service datastore which points at the BO query.
So we figured out the Excel Adapter on Linux job server, Everything works great expect this, which I think may be a bug in DI.
So we schedule one of the report, which is saved in some folder at DI job server, which is a linux box. The report is saved in Excel, which has 5 tabs, the report is schedule daily, which should be loaded in some table via DI.
Now here the thing with DI.
Every day when we have new file, with same name, same tab we have to redeclare the format all over, in order to load it, thats not the issue with csv format in DI.
What might be the thing, that its not loading the EXCEL file.
Both of our BO/DI server is on same machine on Linux platform.
Sorry Data_guy, I did not get the gist of the error you are receiving. Can you post a screen shot of the error you get on day 2 when you try to import the excel file using the definition from day 1?
We have scheduled one report, which have 5 tabs, runs on week days and saved in MS EXCEL format in some location.
Both of our DI and BO job server are on same machine running on Red Hat Linux.
The file is saved as Report.xls.
Now we declared the file definition for this excel file just like we do for CSV file. We are interested only with one worksheet say test.
2/26/08 6:19:36 PM Could not find worksheet test in file /inputfiles/Report.xls
2/26/08 6:19:36 PM Could not find worksheet test in file /inputfiles/Report.xls
2/26/08 6:19:36 PM Exception occurs when executing ‘begin’ method of the adapter operation with ID [3].
So for day 1 this will work, as I defined the format of the file. But tomorrow day 2, when I get same file with new data, it shoots the above error.
Again if I re declare the format on Day 2 it will work. Its not the case with CSV file, you just declare the format once and it works.
I am presuming that you have made sure that the spreadsheet report.xls actually contains a worksheet named “test” on the second day. If that is the case, it sounds like you have a bug, either in DI or in the excel adapter you are using. I would file a case with support immediately.
(BOB member since 2006-08-19)