Focal Point
Has any one upgraded to 7.6.2 Data migrator?.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/9851055642

September 12, 2007, 04:02 PM
newtofocus
Has any one upgraded to 7.6.2 Data migrator?.
If yes, can you please share your experiences.

Thanks.


WF7.1.4 Prod/Test, MRE, self serve, DM
September 13, 2007, 05:46 AM
m
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...
September 13, 2007, 08:26 AM
m
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.
September 13, 2007, 09:33 AM
newtofocus
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
September 14, 2007, 06:07 AM
m
I have, thanks. Will update the post as soon as I've received feedback.
September 19, 2007, 05:22 AM
m
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.