FRX Issue - Probably the DTS -- ANY insight?

Hello.



We are not 'big' FRX users...and generally our folks are not fans of the
package...but I digress in that we have the product and do use it.
Yes...I know Infor discontinued its relationship with Microsoft FRX /
dynamics. However, I'm hoping for some guidance or insight.



We are running a full load...and the load manager is showing a couple
errors. Once the load is complete...the FRX database / reports do not
contain all the information.



If I run the DTS using SQL enterprise manager, the final result appears
to be 2 errors. One errors is that a delta load didn't run...which is
obviously fine since we ran a full load. The second error is more
cryptic and appears more targeted.



The second error is on the frl_trx_detail. I see 16 (or so) errors.
The last error shows a problem with column 21 called attrib12. It
appears to be a data issue with the function to cast date.



I have opened the SQL database...and attrib12 appears to be one of the
date fields on the detail. I am uncertain how to locate the specific
offending record since the error just gives the row number. The row
number is around 1,650,000... I have queried the database...and we have
some 'odd' future dates in the field due to data entry issues. However,
the records do have valid periods...so I'm not sure this information is
even relevant.



I have tried multiple full loads.



I have deleted the various g32 files on the server...



Ideally...I need to resolve the issue and obtain our standard FRX
reports... I have several thoughts...if you can assist...

- We are missing a step...and once we perform that
step...the DTS will work fine...



- I do not think we use the 'offending' column...if that is
the issue...in any of our reports...we generally don't drill down below
the unit / nature / period combinations... Can I create a new DTS that
doesn't include that column?



- If the aforementioned is possible....could I just exclude
the whole detail table and only work with the unit / nature / period
balances...wow would that ever speed things up...



Any assistance or guidance is appreciated....





Chuck Mick

Diversified Machine, Inc.

(m) 517.643.3548

(o) 248.277.4315