Append Web Application Error

[secondcircuits]

I created a desktop operation to append from one tabled to another based upon the location of the data. Then took the xbasic (changing bits of it for the web application) and placed it on a page by itself. A link on a different page fires this page (firing the append code)


I am getting the following error.

500 Internal Server Error
"Script Error
Error:Error running Append Operation
The system cannot find the file specified.
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\27\VIOLATED.MDX"

This is the code that I am using to run the Append.

DIM Append as P

a_tbl = table.open("[pathalias.adb_path]/sold")
append.t_db = "[pathalias.adb_path]/inventory"
ON ERROR GOTO ERROR23102008165318187

append.m_key = ""
append.t_key = "recno()"
append.m_filter = ""
append.t_filter = "Location = \"Sold\""
append.type = "All"
append.m_count = 8
append.m_field1 = "Id"
append.m_exp1 = "@Inventory->Id"
append.m_field2 = "Serial_Number"
append.m_exp2 = "@Inventory->Serial_Number"
append.m_field3 = "Stock_Code"
append.m_exp3 = "@Inventory->Stock_Code"
append.m_field4 = "Description"
append.m_exp4 = "@Inventory->Description"
append.m_field5 = "Condition"
append.m_exp5 = "@Inventory->Condition"
append.m_field6 = "Location"
append.m_exp6 = "@Inventory->Location"
append.m_field7 = "Notes"
append.m_exp7 = "@Inventory->Notes"
append.m_field8 = "Accessories"
append.m_exp8 = "@Inventory->Accessories"
append.t_count = 0

a_tbl.append()

GOTO CONTINUE23102008165318187
ERROR23102008165318187:
ON ERROR GOTO 0
error_generate("Error running Append Operation"+crlf()+error_text_get())
END
CONTINUE23102008165318187:
a_tbl.close()

I do not understand the error that I am getting. Does anyone have an idea or clue to help me along this process?

[Steve Wood]

Re: Append Web Application Error

How odd, I just had that error message for the first time ever last week too. Start by changing your slash to a back-slash in the path for your database files. It should be a back-slash.

I don't see anything else obvious although I have never used ON ERROR GOTO functions in a web app, so try removing them.

[secondcircuits]

Re: Append Web Application Error

Hi Steve, Thanks for the post, oops @ the slashes-that-should-be-backslashes. Still getting the error.

500 Internal Server Error
"Script Error
Error:Script: /appendsold.a5w line:42
a_tbl.append()
The system cannot find the file specified.
C:\DOCUME~1\Owner\LOCALS~1\Temp\VIOLATED.MDX"

I have changed my append coding to take out the "GOTO" functions.

DIM Append as P

a_tbl = table.open("[pathalias.adb_path]\sold")
append.t_db = "[pathalias.adb_path]\inventory"

append.m_key = ""
append.t_key = "recno()"
append.m_filter = ""
append.t_filter = "Location = \"Sold\""
append.type = "All"
append.m_count = 8
append.m_field1 = "Id"
append.m_exp1 = "@Inventory->Id"
append.m_field2 = "Serial_Number"
append.m_exp2 = "@Inventory->Serial_Number"
append.m_field3 = "Stock_Code"
append.m_exp3 = "@Inventory->Stock_Code"
append.m_field4 = "Description"
append.m_exp4 = "@Inventory->Description"
append.m_field5 = "Condition"
append.m_exp5 = "@Inventory->Condition"
append.m_field6 = "Location"
append.m_exp6 = "@Inventory->Location"
append.m_field7 = "Notes"
append.m_exp7 = "@Inventory->Notes"
append.m_field8 = "Accessories"
append.m_exp8 = "@Inventory->Accessories"
append.t_count = 0

a_tbl.append()
a_tbl.close()

The only other thing on this page becides this code, is 3 lines of text separated by breaks (<br> tags) .

I also have a meta tag function that forwards the page after so many seconds, but whenever I started this page I did not apply it to make sure the code alone worked before adding in different functions.

I did test this coding on my VPS and my localhost computer. I received the same error.

Attempting to do some google searches on the filename, but not too much is showing up. Also will attempt to even check the file type. I am not familiar with the .MDX file type.

Does anyone else know what it is? Or how to fix this?

Does anyone else use append to move files around from their web application? If it works may I see a demo or sample of it to determine what may be done wrong?

[secondcircuits]

Re: Append Web Application Error

I am still receiving error above.

I was curious, so logged into my VPS and went to:
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\27\

and found the following files there:
VIOLATED.DBF
VIOLATED.DDD
VIOLATED.DDM
Violated.Ddx

Just to amuse myself, I created a new txt document named VIOLATED and changed the suffix to .MDX

Then I hit refresh on my append.a5w

500 Internal Server Error
"Script Error
Error:Script: /scc/appendsold.a5w line:33
a_tbl.append()
The filename, directory name, or volume label syntax is incorrect.
.DDD"

At this point I hit refresh again and it went back to the origional error.

500 Internal Server Error
"Script Error
Error:Script: /scc/appendsold.a5w line:33
a_tbl.append()
The system cannot find the file specified.
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\27\VIOLATED.MDX"

I checked my VPS and the same folder and noticed that the VIOLATED.MDX file I created has now been deleted.


I have tested these steps several times to make sure that it was a continuous problem.

I have recently copied all of the files in that folder and zipped it up. I ftp'd them to my desktop computer and opened it with my dummy database in alpha5. The .dbf has a similar layout to the appending tables, with an extra column at the end labeled "Remark".

There is no data saved into this file.


Any ideas?

[secondcircuits]

Re: Append Web Application Error

I have found out what is causing my problem.
append.t_filter = "Location = \"Sold\""

If I changed the coding to "" then I will append the entire file without the missing file error.
append.t_filter = ""

Perhaps the append filter is non-web usable. Does anyone else have an alternative that I can use to filter what appends?

I am also testing out appending the entire file, then using a delete function to delete everything but the Locations set as Sold.

I am afraid though that I will fall into the same problem as with the append though.

Any suggestions or ideas would be highly appreciated.

Thank you,

James

[Ren� Stout]

Re: Append Web Application Error

I get a similar problem. The odd thing is that when I copy the code into the Interactive Panel and execute it line by line, everything works fine.
But in review mode and after publishing, I get the about the same error:

 
Error in event handler code for OnClick event for 'Acceptgiro_s_voor_volgend_jaar': [Unknown DOS Error] C:\Users\GEBRUI~1\AppData\Local\Temp\VIOLATED.MDX

Any ideas. please?

'DIM Append as P
	a_tbl = table.open("[PathAlias.ADB_Path]\leden_contributies.dbf")
	append.t_db = "[PathAlias.ADB_Path]\leden.dbf"
	append.m_key = "LID_ID-JAAR)"							'Deze twee keys bepalen wanneer een record uniek is.
	append.t_key = "LID_ID-alltrim(str(year(date())+1))"	'Dat is dus de combinatie Lid_ID met Volgend jaar
	append.m_filter = ""

	'Leden en donateurs die een Lid_Van van VOOR 1-1 volgend jaar hebben en die volgend jaar lid zijn.
	'Leden die op of na 1-1-volgend jaar lid worden, hebben al een betaalverzoek gekregen naar aanleiding van
	'hun toelating.
	'Betaalplichtigen krijgen een betaalverzoek, en alleen zij krijgen dus een betaalregel.

	append.t_filter = "Betaalplichtig.AND.Lid_Van<>ctod(\"\").AND.Lid_Van<date_value(year(date())+1,1,1).AND.(Lid_Tot_En_Met=ctod(\"\").OR.year(Lid_Tot_En_Met)>year(date()))"
	append.type = "Unique only"
	append.m_count = 2
	append.m_field1 = "Lid_Id"
	append.m_exp1 = "@Leden->Lid_Id"
	append.m_field2 = "Jaar"
	append.m_exp2 = "alltrim(str(year(date())+1))"			'Volgend jaar. Alltrim om de spaties weg te werken
	append.t_count = 0

	a_tbl.append()
a_tbl.close()

[Sam_Mantom]

Re: Append Web Application Error

Any Help on this would be appreciated as I too have a similar issue.