Data Sources, Troublshooting import sets

[sLuintel]

My import set shows that it is complete and has created the data source but not loaded the data. when I tryt o manually load it i get an error.

What does this error message mean?

IOException on file /glide/nodes/mhp001_16007/bin/../tmp/ids313285452ba6e50052ad4c7605da15fd.tmp, Invalid header signature; read 724303750490253372, expected -2226271756974174256

[sLuintel]

Hi Jason, we actually had some external help from servicenow with this. I can see from your blog that it is exactly the same thing that we are trying to do. Like I mentioned above, yes it does read a .xls file when I save a file and send it or when somebody else saves the file in.xls and sends it, it performs its function brilliantly. However when the file comes in staright from oracle it fails to read it. Browsing the net for answers I keep coming across 'POI not reading it as excel' and need a way to figure out if there is a way to do that automatically instead of having to get that extract from oracle and save it as a .xls again and send it.

[jason_petty]

Since you are getting this from Oracle, is there a reason why you couldn't use JDBC connection to get that data instead of an Excel attachment?

[Ashok Katam]

Hi Jason

may I know how to resolve similar issue???

When I am sending email with excel attachment, Data Source is being created and excel file is attached in it. I am able to see excel file as it is sent in email

But data is not loading into import set table and so transform map is also not running

When I do loading data manually, it works pretty fine

Appreciate your help

Thanks

Kumar

[sLuintel]

ok, so again looking at this for the umpteenth time, service now is actually saving that file from oracle as web page for some reason. Where can I go, or what can I change to figure out why it is doing that? inbound sets are set correctly, rest messages are correct, datasources set coreectly. Is there anything else that needs to be checked... is it something that when it comes from one system to another it cause this issue?

[sLuintel]

The issue has been figured that this is to with the export coming in from oracle.