Share
Report
88I imported both GL Account segment 1 and segment 4 with descriptions successfully to the GL40200 table. I immediately ran checklinks on all tables in the Financial Series. We thought everything went well until we restored (an unrelated database) which requires us to recreate the MMR Data Mart.
I didn't create any of the segments as they were created when the GL Account was imported or created. A sample script to update the segment 4 description is as follows:
GL40200 SET DSCRIPTN 'Jane Doe' WHERE SGMTNUMB = '4' AND SGMNTID = '1828'
The error occurred when I enabled the integration, we get the error "Index was out of range. Must be non-negative and less than the size of the collection"
I followed the the the resolution below and every segment description was kicked out of the GL40200 table. The good news is I successfully recreated the MMR data mart. The bad news is we are missing all segment descriptions that were imported. It doesn't kick out any segment descriptions that are entered manually. What am I missing?
Thank you in advance for your help.
Peggy Aitken
Categories:
All responses (
Answers (
