Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Has any one upgraded to 7.6.2 Data migrator?.
Go
New
Search
Notify
Tools
Reply
  
Has any one upgraded to 7.6.2 Data migrator?.
 Login/Join
 
Platinum Member
posted
If yes, can you please share your experiences.

Thanks.


WF7.1.4 Prod/Test, MRE, self serve, DM
 
Posts: 176 | Location: Desplaines | Registered: August 05, 2004Reply With QuoteReport This Post
Member
posted Hide Post
Hi

We are attempting to upgrade from DM 7.6.1:

Issue: Double decimals are being lost:

In 7.6.1 we create a synonym which returns data as Actual D8, Usage D20.2.
Data in database = 179.97777777
Data in synonym = 179.98

We change the format for Usage to D20.8. and place the synonym in a flow.
Data in target (delimited file, csv) = 179.98000000
When you switch to edit on the synonym or flow, it displays Actual D8, Usage D20.8.

---------------------------------------------------------------------------------
Switching to DM 7.6.2 produces the following result:
We create a synonym which returns data as Actual D8, Usage D20.2.
Data in database = 179.97777777
Data in synonym = 179.98

We change the format for Usage to D20.8. and place the synonym in a flow.
Data in target (delimited file, csv) = 179 - without ANY decimals at all!

When you switch to edit on the synonym or flow, it displays Actual A20, Usage D20.8. - where did ALPHA come from?

I tried to edit the flow to be Actual D8, Usage D20.8 and it produces garbled text in the output document.
I then tried to force the source synonym to Decimal Packed 20.8 and it produces 179.97777777 - no ROUNDING!

So, would love to know if there is a setting for this somewhere...the conversion to Alpha seems wrong to me and losing decimals seems strange. Especially since this all worked seemlessly in the previous version...
 
Posts: 13 | Registered: August 08, 2007Reply With QuoteReport This Post
Member
posted Hide Post
I have also experienced the following issue on DM 7.6.2, which only seems to occur when your output target is set to physical location.

The path is "lost" if your data application directory setting is physical location and your value is anything besides the default c:\ibi...location.

So, say for example your data application directory is physical location and your value is c:\testing\output\reportname.csv.
Save this setting.
Add a stored procedure to your dataflow.
Save this.
Run...nothing happens...
Open the target properties: your data application directory has been reset to an application directory name eg baseapp and your value is empty.
Change it back to c:\testing\output\reportname.csv.
Save this.
Run...nothing happens...
Open and it has reset itself again.
Argh!
Change it back to c:\testing\output\reportname.csv and run it - select save while running - finally it keeps this value.

This happens every time I make any little change to the dataflow.
Please let me know if I'm using it incorrectly, but this did not seem to happen in 7.6.1.
 
Posts: 13 | Registered: August 08, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
m,

Did you open up a case with IBI?. if yes what is their take on this?.

Thanks


WF7.1.4 Prod/Test, MRE, self serve, DM
 
Posts: 176 | Location: Desplaines | Registered: August 05, 2004Reply With QuoteReport This Post
Member
posted Hide Post
I have, thanks. Will update the post as soon as I've received feedback.
 
Posts: 13 | Registered: August 08, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Feedback as promised:
This seems to be a known problem with Delimited Flat File targets. The person who attended to my case is sending this to programming for follow-up. A workaround would be to use a Formatted File" and a format of "COMT" instead for your target.

I tried using COMT and it worked, besides generating headers, which I don't want in the file.
 
Posts: 13 | Registered: August 08, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Has any one upgraded to 7.6.2 Data migrator?.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.