I will most likely give the rebuild a whirl this weekend. I was thinking it would be done through pervasive, but from your posts it sounds like this can be done just as well through Macola.
How should i go about identifying mismatch information?
I'm assuming I'll need printed records to...
To view the sales history, we choose:
1. order entry
2. view
3. order history
4. by customer
When I check oehdrhst and oehdrhst_sql, both show data that is missing in the report. The trx_posted_fg field in these rows have a Y.
Thanks again for your patience and advice.
Jamie
example:
In Macola, when viewing sales history for company A, the data stops in November 2004. There is not data shown for 2005 at all.
I opened the OEHDHST_SQL table in PCC and did see an entry for Company A from this year.
Does this not prove the info is there, but just not being read by...
Hi Guys,
Thanks again for your help.
I have looked in the OEHDRHST and found records that match what we are missing.
I guess doing a rebuild of the database is the next step.
I'm still not sure if this will actually fix the problem as there seems to be no common date or event that I can say...
When checking customer purchase history, some customers are mising all 2003 and 2004 data. Other are just missing a month or two of purchase hisory.
I do think it is unlikely that this information was deleted.
I was thinking maybe this data was somehow locked or corrupted, and hoping there...
Hello all,
I'm running macola progression on pervasive sql. When we run history repots, there is data missing from random customers on random dates.
Is there a way to tell if this information is still there and fix it, or should I restore from backup ? ?
note: One user had her hard drive...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.