You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi guys. I've been using CCP 6 with Internetware Connect (to import and export Sage accounts details) for the last couple of years with limited success.
I realize that this isn't necessarily an issue with CCP but I'm struggling to identify what is causing the problems. I've tried to get help from Howard at Greenbarn but I'm getting a stonewall, 'it's an issue with your webserver', no suggestion as to what the issue might be, not very helpful. So, I'm going to have to delve a bit deeper and am looking for a few hints from the guys who know CCP 6 hundreds of times better than I do.
Connect creates XML files which it downloads and uploads from and to CCP (i.e. our webserver), these then update the cart or Sage depending on upload or download. Now my problems:
1. The download works just fine until there are more than 14 new orders to download in one connection, the download still completes but doesn't write back to the cart to change the order status to prevent downloading again, if I dont keep an eye on this I can end up with hundreds of repeatedly downloaded orders over a weekend. Most annoying and time consuming to repair. It will work fine with 14 orders but 15 or more is too much for it. I can't believe this isn't a setting within the script, it's not an erratic problem so it's not dependant on server load or bandwidth etc.
2. The upload of invoices to the cart (all invoices from within Sage) to allow the cart to be auto updated with despatch details etc works fine when its working but for some reason it will simply fail at random and repeating the task does not help. It will work faultlessly for up to 3 months at a time, running once per day, and then will fail partway through, without warning and nothing I can do will allow it to complete successfully. I've tried rebooting all computers involved, stopping as many services as I can on the webserver, running at different times of day etc, all to no avail. It generally starts working again without any explaination after about a week or so. The XML file created and uploaded appears to be around 40MB.
I even changed from SQLite to MySQL in the vain hope that it was due to SQLite not being fully supported, the problems are exactly the same for both databases.
If anyone can help or is in a position to investigate further or examine the scripts I would be most grateful and happy to pay for a resolution. I guess it needs someone with an overview of CCP 6, Microsoft webservers (2003 Web edition) and Connect although I suspect the issue is not due to Connect, it's a very simple application.
I'd also be very interested to hear from anyone else who's using a similar setup, whether they have any similar problems.
Best regards,
Rob Hemsley
Offline
First and probably biggest suggestion would be to move off of the MS web server Rob especially a version so old. For your first issue it sounds remarkably like a size limit/restriction that you are running into. How large are the files involved?
Offline
Hi Dave, Thanks for your suggestion. Unfortunately I'm reasonably comfortable with MS products and out of my depth with Linux, it's not really an option for me at this time :-\.
I've done a bit of testing this morning, the download of 14 orders is 38KB, therefore I would assume that 15 orders would be approx 40KB. More interesting is the subsequent upload of 'order downloaded' notifications to CCP, to change the order status to 'downloaded to Sage' this totals 93894 bytes for 14 orders (according to the log file) and would therefore be very close to 100KB for 15 orders.
As mentioned, the upload of orders to update the cart status is currently approx 40MB, this is split into chunks by Connect and takes about half an hour to complete the whole process. The issue is due to some type of timeout but I can find no reason for it.
I agree that a server size limit may be causing the restriction but where or what that limit is is a bit of a mystery...I've been through every obvious IIS setting I can find
Best regards,
Rob
Offline
Look beyond IIS. It could be a database or PHP setting though the numbers you mention, other than the 40 meg, are all low enough to not really be suspect.
Offline
I've made a few changes to the Metabase.xml file, which appears to control and limit a lot of the sizes and settings of the active server parts. Just waiting for the problem to arise again now to see it's sorted, or at least improved.
I think it's unlikely to be the database as I had exactly the same issues with SQLite as I do with MySQL, I doubt they'd have the same defaults, I have had a good look at the MySQL setup previously and made a few adjustments to no avail :-\
Thanks again Dave.
Rob
Offline