FRX Issue - Probably the DTS -- ANY insight?
"Chuck Mick" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
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 _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.