Kryptronic Software Support Forum

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.

#1 10-09-2008 09:55:56

stage
Member
Registered: 12-12-2005
Posts: 170

ATS Batch Process Orders won't complete

We are getting more orders now than ever before (a good thing :-), but now when we open the Batch Process Orders window, there is no Submit etc. button at the bottom.  It ends with the last order, but there's no way to Submit changes.

Same in both MSIE and Firefox.

Any ideas for a fix?

Nathan Kahn

Offline

 

#2 10-09-2008 11:34:37

rachaelseven
Member
From: Massachusetts, USA
Registered: 01-23-2006
Posts: 3169
Website

Re: ATS Batch Process Orders won't complete

Try a 'View Source' on the page and look to see if there are any errors there.  Or at least see what is the last thing put out so we can try to infer what happened.


Rachael Katz
- Custom Focusing Screens for DSLR Cameras

Offline

 

#3 10-09-2008 14:41:51

stage
Member
Registered: 12-12-2005
Posts: 170

Re: ATS Batch Process Orders won't complete

I did it 3 times and it simply stopped at 3 different places.  No error message.

I'm wondering if my host has a timeout set, so I'm going to ask them next.

Here is an example of the last few lines from 1 of the above:

<tr bgcolor='#FFFFFF'><td valign='top'><input type='hidden' name='tracking_id95' value='ORD2008100218'>
<input type='hidden' name='tracking_oldstatus95' value='NS'>
<input type='radio' value='P' name='tracking_sta

Thanks,
Nathan

Offline

 

#4 10-09-2008 16:03:28

rachaelseven
Member
From: Massachusetts, USA
Registered: 01-23-2006
Posts: 3169
Website

Re: ATS Batch Process Orders won't complete

That definitely sounds like a timeout problem... talk to the host.  Fwiw, I routinely run my ATS batch with 25-30 orders on it without a problem now; although on one host, I did have problems with the updates timing out when the list got longer than 10 orders or so.


Rachael Katz
- Custom Focusing Screens for DSLR Cameras

Offline

 

#5 10-09-2008 17:52:38

stage
Member
Registered: 12-12-2005
Posts: 170

Re: ATS Batch Process Orders won't complete

My host says:

We monitored the script during its execution. The script was not using a MySQL database for this data.
It was reading its data from the following file:
/www/www/data/tables/trackitem.csv
For some reason, after reaching the end of the file, the scripts starts reading it all over again. You should contact the developers of this application, or consult its documentation to see what may cause this problem.


I checked and the trackitem table is indeed set to CSV.  (Must be the default install from ATS?  I know I haven't changed it.)

Anyway, I clicked on Change but after a few seconds it says:

500 Server Error
The web server encountered an error or misconfiguration and was unable to complete your request.


I'm guessing that there are now so many orders that I need to be in SQL mode?  But how do I change to it?

P.S.  There are 100 or so unshipped orders at the moment.

Thanks,
Nathan

Offline

 

#6 10-10-2008 07:49:03

rachaelseven
Member
From: Massachusetts, USA
Registered: 01-23-2006
Posts: 3169
Website

Re: ATS Batch Process Orders won't complete

Following on your other post, it seems you've tracked the problem back to a defective trackitem.csv.  The way the ATS script is written, trackitem.csv will be read more than once, so that in and of itself does not necessarily represent a problem.  Let's get your table working right and then see where we need to go from there.


Rachael Katz
- Custom Focusing Screens for DSLR Cameras

Offline

 

#7 10-10-2008 12:49:00

stage
Member
Registered: 12-12-2005
Posts: 170

Re: ATS Batch Process Orders won't complete

This is the error message my host provided to me, as a result of trying to change trackitem.csv to database mode.


[Fri Oct 10 13:06:56 2008] cp-admin.cgi: DBD::mysql::db do failed: Duplicate entry '1' for key 1 at /home/stage/www/www/cgi-bin/ccp5/library/common/database.pl line 646.
DBD::mysql::db do failed: Duplicate entry '1' for key 1 at /home/stage/www/www/cgi-bin/ccp5/library/common/database.pl line 646.

INSERT INTO trackitem VALUES ('1','ORD200803251','W1132','John Beatles Wig','2','','39.9','0','0','0.92','0','S','UPS Ground','Lauren','Rose','','135 W. Lorain St.','OCMR 2729','Oberlin','Ohio','United States','44074','R','','UPSWEBAPI','1Z3922860347907754','4/1/2008','W1132','','Y','C','','14043772210@myfax.com','1')


The first column of the CSV file, trackitem_id, is the line number of the order.  It certainly is not unique.  Is it supposed to be?  There is a numeral 1 in this field for every single order number - order number being in column 2 trackitem_tracknum.


How do I fix this please?

Thanks,
Nathan

P.S.  I put up the first 5 lines of my trackitem.csv at:
http://www.stagesupply.com/trackitem-a.csv

Offline

 

#8 10-10-2008 17:27:20

stage
Member
Registered: 12-12-2005
Posts: 170

Re: ATS Batch Process Orders won't complete

For whatever reason, the trackitem_id began incrementing properly this morning.  (I think it was after I deleted the corrupt entry.)  Prior to that, it restarted at 1 for every new order.

So how do I fix this?  What number does this trackitem_id correlate to?  Can I simply overwrite that column with the numbers 1-whatever?

Offline

 

#9 10-10-2008 18:20:51

rachaelseven
Member
From: Massachusetts, USA
Registered: 01-23-2006
Posts: 3169
Website

Re: ATS Batch Process Orders won't complete

The trackitem_id is supposed to be unique.  I suspect you are correct that the bad line was messing it up.  The trackitem_id doesn't atually correlate to anything - it's just a unique number that should be assigned sequentially.  Afaik, you can just overwrite them with sequential numbers and it should be fine.


Rachael Katz
- Custom Focusing Screens for DSLR Cameras

Offline

 

#10 10-10-2008 18:41:13

stage
Member
Registered: 12-12-2005
Posts: 170

Re: ATS Batch Process Orders won't complete

I did that and switched to db mode and everything is cool groovy.  The Batch Process Orders completes now.  I'm sure it was timing out, I just don't know whether it was the script or my host that was responsible.  My host got thrown off track by the multiple reads of the csv file and thought it was a loop.  I didn't ask for a followup because I suspected the problem would go away when I switched to db.

Thanks for your help.

Nathan

Offline

 

#11 10-10-2008 18:52:24

rachaelseven
Member
From: Massachusetts, USA
Registered: 01-23-2006
Posts: 3169
Website

Re: ATS Batch Process Orders won't complete

You're quite welcome.  I'm glad you got it sorted.


Rachael Katz
- Custom Focusing Screens for DSLR Cameras

Offline

 

Board footer