Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Visitor
aflefaive
Posts: 3
Registered: 10-07-2009
0

VI Data Truncated

Some of my flat file data from VI jobs ends up being truncated with missing rows and always with missing ending text qualifiers.  If I run the job through MAS GUI, I have no problem and the flat file looks okay.  When I run the job via command line, the data gets to about 98% of the rows it should have and then it just leaves off right in the middle of a row.  This doesn't occur with all just, only some of the jobs called from command line.

Super Contributor
DFeller
Posts: 2,820
Registered: 10-28-2008
0

Re: VI Data Truncated

What version and service update are you having the issue on?

 

Dawn

Visitor
aflefaive
Posts: 3
Registered: 10-07-2009
0

Re: VI Data Truncated

I am on MAS200 V 4.30.0.17

Switcher
BigLouie
Posts: 2,533
Registered: 10-28-2008
0

Re: VI Data Truncated

Please note that it is faster and easier to pull data from MAS using Access or Excel than using VI.

Big Louie No MBA but BMOC
--------------------------------------------------------------------------
I went to the bookstore and asked the saleswoman, 'Where’s the self-help section?' She said if she told me, it would defeat the purpose.
Visitor
aflefaive
Posts: 3
Registered: 10-07-2009
0

Re: VI Data Truncated

I am not concerned with speed since this will occur overnight and unattended.  I am just baffled why when called from command line the flat file is truncated  but not when the job is started through the MAS console.