Restore question

[wwwedward]

I may have to move back to 7.5.103f due to data issues in 7.6.200.5. IF I have saved the 7.5.103f macsql directory and sub directories.. Is this saved data any use? Can I copy this back into the macsql directory.. Tweak this or that and be back on 7.5.103f? If so, what might need tweaking?

sql 2000.. My var is also working on this issue..

Currently trying to find a data problem that is causing macexe errors... At least we think it is data and macola corp thinks it is data,, The reset allocation crashes at the same point each run? My live company has hard allocation, no bins or lots used.. My test company has soft allocation.. the data in test company is a little older but everything works without errors in that company>>> Macola will not let me change the allocation method with orders on file.. I cannot export the orders table because system crashes... What about just setting the imsetup file to soft via sql in live company??

 

[dgillz]

I have done probably 7 or 8 upgrades to 7.6.200.5 and never had a problem like this.

You canot change the allocation method to soft if there are open orders, unless you go under the hood with a tool such as MS SQL Enterprise Manager amd manually change it.

I seriously doubt that this is a data issue. There is no "data conversion" to go from 7.5.103d to 7.6.200.5. The main issue for 7.6.200x was moving from the Microfocus cobol compiled product to the Fujitsu compiled product.

Do you have a "good" version of 7.6.200.5, perhaps on a stand alone machine such as your VAR's laptop, available? If so I would copy the .mdf and .ldf files to a CD and see if your VAR experiences the same issues you are experiencing.

If none of that works, how about exporting the open orders with MS SQL Server rather than using Macola to do it? I would try that. There are 3 tables: OEORDHDR_SQL, OEORDLIN_SQL and OELINCMT_SQL.

Please keep the board posted, I am very interested in what you come up with. Good Luck.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

 

[wwwedward]

Thanks, I will see about a stand alone... Strange how the functions work in the test company such as allocation re-set.. This is a first for the var also after performing many upgrades... I will keep the board posted.

Thanks

 

[dgillz]

If you are able to do this in the demo data company, it does point to the data. I just don't understand it.

When you reset allocations, what error message are you getting?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

 

[wwwedward]

Problem found. Third party ecommerce product. The 7.6.200 did not like what was written to the oeheader.. We have an updated third party ecommerce product that writes oeheader and oedetail in a much more pleasing method for the new complier etc...

So data appeared to be the problem.... thanks for all the assitance from the smart people.. and my var

 

[dgillz]

What is the name of this product? Was it on Macola's list of approved solution partners?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports