Hi All,

Everyone is our company is getting a message pop up in Order Entry when they start the program, and periodically thereafter, that says "The order statistics will now be updated due to postings in ACCPAC Order Entry".

I've posted questions before on this, but it seems we are at another dead end.

We've made sure opportunistic locking is turned off on all machines, and have also run integrity checks. The last check came up clean, but we continue to get this message.

Any more idead would be greatly appreciated, and thanks for all your time with this issue thus far!

Cam

If you rename the OEASP directory on the server, I bet the problem goes away.

David

Hi David,

The directory you listed doesn't seem to exist on our system. is there another one to try, or can you think of something else?

Thanks!

Make sure it is renamed on every workstation too. Perhaps someone has a local copy of ACCPAC Plus.

OEASP is the install directory for Accpac Orderentry. It is probably in the root of network drive x:\OEASP or maybe in x:\asp\OEASP. And as Andrew mentions, someone may have a local copy of Orderentry on a workstation.

David

If you are importing OE orders, or posting them from an EDI program, Adagio may see them as having been entered in Plus OE and will run the update routine.

Good point Kate!

Thanks

Yep. That's what's happening here. We import EDI orders via Edisoft's Merchant software. That software doesn't interface natively with Adagio, but uses the ACCPAC interface instead. As a result, EDI orders get 'entered' into ACCPAC OE. When we subsequently launch Adagio OE, it displays the message Acrylon mentions.
In our case, we understand why this is happening - so it's not a problem for us. We have been told Edisoft is working on an Adagio version of its software, which should make those messages go away.

Hi Everyone,

We are not posting with EDI yet, but will be very soon. So when that message comes up again, I'll know why!

As for renaming the install directory, it appears on my local drive under C:\SOFTRAK\OEWIN\WKSETUP, and on the server under P:\SOFTRAK\OEWIN\WKSETUP. Do I just rename the 'WKSETUP' folder?

Will it cause problems if I change the network folder name and not all the local ones too? There are a few people who use OE, so changing all the local ones at the same time might be a problem.

Thanks a bunch!

Cam

Acrylon,

As mentioned in this thread the renaming of a folder was renaming the Accpac OEASP folder to prevent anyone from using Accpac. Renaming the folder does NOT relate to Adagio folders.

David

So if I find some culprits with the Accpac OEASP install directory and rename it, what kind of problems with this create?

Thanks!

They won't be able to start ACCPAC Plus Order Entry.

One last question (for this round!):

The install directory for Accpac isn't on the server, so if I actually find it on someone's local drive and change it, would it even solve the problem?

Thanks a bunch all

Well, it would prevent that user from launching ACCPAC Plus.

Still no dice!

One interesting thing that might shed some light on this situation:

I have a copy of the database on my local drive that I've been using to do some testing (we are about to start EDI). Obviously no one else can access this database, yet I still get the same message popping up. This makes me think it doesn't have anything to do with the multiuser environment, since I'm the only one who uses this set of data.

I know this message comes up when file counts dont add up - couldn't we just go into one of the database and manually delete some older ones so they do add up?

Does this help at all?

Thanks!

Is there some process you can do that makes the message occur consistently?

It usually seems to be random. If I leave OE alone for a while, you can guarantee the message will be there. Sometimes I'll look through 20 invoices before the message appears again.

There are two times when it will always happen though: after you log in, and when you press the "Orders" button.

The message says that 'the order statistics will now be updated...', is it possible they are just not being updates?

Thanks

OK - the message occurs when the count is being corrected, and the counts are checked when the "Orders" form is launched and when the application is first opened. This means you'll only see the message at that time, but something else is messing up the count.

Is there some regular process that you do that always generates the message the next time the "Orders" form is launched?

Hello Acrylon,

Could you right mouse click on the file OEWOPT.xxx (where "xxx" is your data extension), select properties, and report how many bytes are in the file (next to the label "Size:" on the first screen).

It should report 256 bytes.

Hi Andrew,

The file size is 256KB.

I can't think of some 'regular process' that we do for the message to come up. I'm assuming that this other process would somehow have to change this order count one way or another?

What are the things that make this order count change? It says the problem is due to 'postings in Accpac OE', but I'm sure there's been no postings in Accpac for quite some time.

Thanks,

Cam

Hello Cam,

256 KB or 256 Bytes? It should be Bytes.

Since you're there, could you also confirm it's not marked "Read Only"?

Sorry Andrew, it was Bytes. Also, the box next to "Read Only" is not checkmarked.

Under the advanced tab, there is a check next to 'file is ready for archiving'.

OK - all those settings and numbers are correct.

So - perhaps when you work with this data, you can keep a mental note of the things you are doing prior to seeing that message.

It's possible there's some function in Adagio OrderEntry that is not correctly updating the counts, but it's infrequently accessed. Once we know what it is, we can go looking.

OK?

Great, thanks Andrew. I'll keep my eye open.

Are there only a few things that effect the count, or are there a lot? I'm just not sure what to keep my eye out for, as this happens at random while the program is open (and when we open the program and open the orders tab).

Is it possible that everyone would get this message when one person opens the program and orders tab? Could that generate what seems as the 'random' pop ups?

Adagio OrderEntry does a consistency check on the numbers stored when the program opens, and when the order tab opens. It will re-count the orders/invoices and credit notes when it detects its counts don't match those on file. Once they are re-synched, OrderEntry keep the figures updated. In theory, only ACCPAC Plus could change the count of the documents without updating the figures. However, it is possible that there is a section of code in Adagio that is either a) not updating the counts correctly, or b) is updating the file which contains the counts with some other information and writing back out of date document counts. (My guess is thatwe'll probably find it's circumstance b).)

The other information stored with the counts are various user and company profile options (such as what costs to display, and whether "printing" an order to the screen resets the "order printed" status, and various default specification forms to use.) Unfortunately, these options are scattered through various data entry screen (company profile, file options and edit groups) so there isn't a single place to look.

B) sounds like a likely culprit. I don't think we do enough invoicing / order entry to account for the number of times that this message comes up a day.

If it is possible that the re-syncing is using bad data, then would the order statistics that are being updated never really be fixed? Is it possible to somehow just go into this data and fix/change it?

Thanks

I'm asssuming that your data passes the data integrity check (File | Data Integrity Check ). If it doesn't, then all bets are off.

It usually comes through clean. So can we just add / subtract / fix something with the syncing data?

If the integrity check is clean, there is nothing for you to fix. The 'order statistics' in this message is simply the count of transactions that Andrew mentioned a couple of posts before. There is a record count in the data, and a second count for the order grid (so that it knows how many orders or invoices or credit notes to display). As Andrew posted, if these counts are ever different when starting OrderEntry or opening the Enter Orders function, the message will display.

I believe it is our intention to remove this message from appearing, now that Accpac Plus OE is more in the rear-view mirror, but likely there are still particular processes that are updating one count but not the other. If anything other than Adagio OE adds order records directly to the data, this is an example of such a process. Or a 'circumstance B' as above.

I like this 'removing the message' idea. Could this hurt anything? Is it easy to do, or would it be part of an update or something liket that?

Thanks!

It would have to be a program update. And we can't promise anything for right now, as there are cases when this message is displaying correctly.

On some machines, re-synching the count can take a measurable amount of time. Users don't like it when their machine "goes away" and does something without letting them know what it's doing. Displaying a message is preferable when the computer is busy. We could remove the reference to ACCPAC Plus, but at the moment that is the only known and repeatable way to generate the issue.

Oh yes - what version of OrderEntry are you running?

I'm running 8.1A (070826).

Is it possible for us to just send off our data over a weekend or something like that to get it re-synched?

Thanks!

The re-synching of which Andrew speaks is what happens when you see: "The order statistics will now be updated due to postings in ACCPAC Order Entry".

His point is that removing the message is OK if the process is fast (say 5 seconds), but would cause confusion in cases where it takes longer.

Hello Acrylon,

What company name would that module be registered under?

Thanks

Hey Andrew,

Western Profiles Ltd. is our company. That is also who it is registered to. Let me know if you need anything else.

I know we have some updates to install, but were waiting before we do some item number changes.

Thanks,

Cam

So what is being suggested is that we remove the message, but the 'synching' still happens?

It only takes a second or two after you press OK on the message for everything to be good to go.

How can I go about doing this?

Thanks!

The message displays while the synchronization process runs. You cannot remove it, and the synchronization must occur for Adagio OrderEntry to display your orders and invoice grids properly. We need to find out what procedure you are following to throw these counts out of synch.

Sorry.

So can we still 'remove the reference to ACCPAC Plus..."?

Sorry, no.

If the process only takes a second or two and if there is no evidence of data problems, I suggest accepting the inconvenience and moving ahead.

I know you would like the mystery resolved so my answer won't be a popular one. But there are many things about Word and Excel that I have learned to live with. And as long as those things don't impede my work, I try to focus on the ways that I can use the tools better. Adagio is like that - the OE module has lots of features that can improve your daily processes. And if you are on the Upgrades plan, install OE 8.1B and see the new features.

On the other hand, if you really want to solve the mystery, ask your local Adagio reseller to help diagnose the circumstances.

OK then, that is what we will do.

Thanks for all your help with this issue - its been quite a ride!

Have a great day!

Cam

One last question:

When I run checksys on my system, I get a warning:

========== Multi-User Common Directory Status ==========

The following Multi-User Common directories ("EZTASKS") were found:
[Note: the common names are listed on the left; the crucial unique names are in parentheses]
p:\asp (\\winnipeg\data\accpac\asp)
p:\softrak\program files (\\winnipeg\data\accpac\softrak\program files)
WARNING: Generally only 1 such directory should exist, but (2) unique names were found!!
This may cause multi-user data corruption problems if programs use different
directories while concurrently accessing common data!!
Please check with your system administrator to ensure proper configuration.

Could this cause the message?

Thanks!!

Hi, Acrylon,

Only one EZTasks directory should be used. It appears that your site either used to use ACCPAC Plus or perhaps still uses it sometimes along with Adagio.

ACCPAC Plus also uses EZTasks and other common files.

If you are still using ACCPAC Plus, the EZTasks path, located in the ADSProf.xxx file in your data directory (where 'xxx' is your 3-character data extension) should probably point to the first path (eg. p:\asp). If you have migrated to only using Adagio, you would probably use the second path. The key is that only one should be in use for both programs or you could run into problems as the ChkSys Warning indicates.