Import XML - Runtime Error 31592

  • Thread starter Thread starter Melissa M
  • Start date Start date
M

Melissa M

I've had a procedure in a db which has worked just fine for the last several
months, up until today. The procedure executes this line:
Application.ImportXML DataSource:="http://" & P2L_URL &
"/P2L_PICK_TO_LABEL.aspx?ORDER_I=" & _
Left(Forms!frm_MainMenu.txtSalesOrder.Value, 8) & "&PRINT_I=" &
strP, ImportOptions:=acAppendData

and I get: Run-time error '31592' [Database Name] has encountered an error
processing the XML schema in file
'P2L_PICK_TO_LABEL.aspx?ORDER_I=29204982&PRINT_I=001'. Illegal xml character.

Anybody have any ideas?
 
Melissa said:
I've had a procedure in a db which has worked just fine for the last several
months, up until today. The procedure executes this line:
Application.ImportXML DataSource:="http://" & P2L_URL &
"/P2L_PICK_TO_LABEL.aspx?ORDER_I=" & _
Left(Forms!frm_MainMenu.txtSalesOrder.Value, 8) & "&PRINT_I=" &
strP, ImportOptions:=acAppendData

and I get: Run-time error '31592' [Database Name] has encountered an error
processing the XML schema in file
'P2L_PICK_TO_LABEL.aspx?ORDER_I=29204982&PRINT_I=001'. Illegal xml character.

Anybody have any ideas?
Click to expand...

The messages of these methods are fairly reliable. Have you checked the
file content on illegal characters? There could be a control characters
outside the supported range:

http://www.w3.org/TR/2006/REC-xml11-20060816/#charsets

Can you open the file with another XML reader like IE or XML notepad? See http://www.microsoft.com/downloads/...49-787d-4118-ba5f-4f30fe913628&displaylang=en
 
The file opens just fine in IE - that's why this is so frustrating. When I
enter the actual string created by the expression in the IE Address, the file
displays immediately.

Any other thoughts?

Peter Doering said:
Melissa said:
I've had a procedure in a db which has worked just fine for the last several
months, up until today. The procedure executes this line:
Application.ImportXML DataSource:="http://" & P2L_URL &
"/P2L_PICK_TO_LABEL.aspx?ORDER_I=" & _
Left(Forms!frm_MainMenu.txtSalesOrder.Value, 8) & "&PRINT_I=" &
strP, ImportOptions:=acAppendData

and I get: Run-time error '31592' [Database Name] has encountered an error
processing the XML schema in file
'P2L_PICK_TO_LABEL.aspx?ORDER_I=29204982&PRINT_I=001'. Illegal xml character.

Anybody have any ideas?
Click to expand...

The messages of these methods are fairly reliable. Have you checked the
file content on illegal characters? There could be a control characters
outside the supported range:

http://www.w3.org/TR/2006/REC-xml11-20060816/#charsets

Can you open the file with another XML reader like IE or XML notepad? See http://www.microsoft.com/downloads/...49-787d-4118-ba5f-4f30fe913628&displaylang=en
Click to expand...
 
Melissa said:
The file opens just fine in IE - that's why this is so frustrating. When I
enter the actual string created by the expression in the IE Address, the file
displays immediately.

Any other thoughts?
Click to expand...

As you can open the file, you can check for illegal characters. If IE
doesn't show any, they may be skipped during rendering. You can use a hex
viewer, e.g. then one included in Total Commander http://www.ghisler.com/
 
Back
Top