DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Bassam_Hesham
Participant



Joined: 26 Feb 2018
Posts: 3

Points: 21

Post Posted: Tue Jul 23, 2019 4:02 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello,
I have an issue that happened right after restaritng the datastage engine server as excel sheets that are attached in mail arrive corrupted while they are normally opened when downloaded directly from server 'this happened on one project while the other is working normally'
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43011
Location: Denver, CO
Points: 221947

Post Posted: Tue Jul 23, 2019 4:38 pm Reply with quote    Back to top    

"Corrupted" how, exactly? And are we talking .xls or .xlsx files or a .csv that automatically opens in Excel?

_________________
-craig

The muffin man is seated at the table in the laboratory of the Utility Muffin Research Kitchen reaching for an oversized chrome spoon
Rate this response:  
Not yet rated
Bassam_Hesham
Participant



Joined: 26 Feb 2018
Posts: 3

Points: 21

Post Posted: Tue Jul 23, 2019 4:54 pm Reply with quote    Back to top    

Corrupted as it doesn't open and excel keeps saying it is a corrupted file (xls and xlsx), csv works normally.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54535
Location: Sydney, Australia
Points: 295717

Post Posted: Fri Jul 26, 2019 6:52 pm Reply with quote    Back to top    

Try to ascertain what's different between the two projects. Can you also let us know which stage type you are using to read the Excel worksheets?

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43011
Location: Denver, CO
Points: 221947

Post Posted: Sat Jul 27, 2019 8:40 am Reply with quote    Back to top    

Well, that's another question actually. Is DataStage creating the spreadsheets or simply emailing them? And yes, the difference between the two projects (or the jobs in them) is probably key here. Can you clarify that for us, please? The two projects are running identical jobs where one works and one doesn't or do they contain similar jobs?

_________________
-craig

The muffin man is seated at the table in the laboratory of the Utility Muffin Research Kitchen reaching for an oversized chrome spoon
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours