7.0.7sr1a Broke DataPort Export
Posted: Mon Jul 25, 2011 9:21 am
We recently upgraded from 7.0.4 to 7.0.7sr1a (incrementally applied each interim update). Now, the dataport tool (using the latest) fails to successfully export the orders via the Custom XML option. We select Custom, orders, set a date range (last day or so) and when we hit the export button we get an error about being unable to convert a boolean to a byte.
I actually tried rolling back to 7.0.7 api/client as well as the 7.0.6 api/client with no success.
Any ideas?
[Edit 20:24 on 7/25/11]
Some further details:
The actual error message:
Exception Message: Object of type 'System.Boolean' cannot be converted to type 'System.Byte'.
at CommerceBuilder.DataClient.Api.ACRequestHandler.ProcessRequest(String requestXml) at
CommerceBuilder.DataClient.Api.AuthenticationHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext context)
The error as it appears in the Admin error log:
7/25/2011 5:52:52 PM Error Object of type 'System.Boolean' cannot be converted to type 'System.Byte'. Object of type 'System.Boolean' cannot be converted to type 'System.Byte'.
I *can* use the custom xml export of everything *but* the orders. Also, I can use the "download store data" function for everything other than the orders object.
I did some debug/tinkering, and the following is the xml blob/request being sent...
<?xml version="1.0" encoding="utf-8"?>
<ACCustomizedOrderRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<RequestId>824f60e8-faca-4d1f-a332-865b4258d4a5</RequestId>
<OrderCriteria>
<OrderDateFilter>
<StartDate>2011-07-25T00:00:00</StartDate>
<EndDate>0001-01-01T00:00:00</EndDate>
</OrderDateFilter>
<OrderStatusFilter>1,2,3,4,5,6</OrderStatusFilter>
</OrderCriteria>
<ChunkSize>50</ChunkSize>
<IsUPSWSRequest>false</IsUPSWSRequest>
<IsCSVRequst>false</IsCSVRequst>
<DownloadCCData>false</DownloadCCData>
</ACCustomizedOrderRequest>
I actually tried rolling back to 7.0.7 api/client as well as the 7.0.6 api/client with no success.
Any ideas?
[Edit 20:24 on 7/25/11]
Some further details:
The actual error message:
Exception Message: Object of type 'System.Boolean' cannot be converted to type 'System.Byte'.
at CommerceBuilder.DataClient.Api.ACRequestHandler.ProcessRequest(String requestXml) at
CommerceBuilder.DataClient.Api.AuthenticationHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext context)
The error as it appears in the Admin error log:
7/25/2011 5:52:52 PM Error Object of type 'System.Boolean' cannot be converted to type 'System.Byte'. Object of type 'System.Boolean' cannot be converted to type 'System.Byte'.
I *can* use the custom xml export of everything *but* the orders. Also, I can use the "download store data" function for everything other than the orders object.
I did some debug/tinkering, and the following is the xml blob/request being sent...
<?xml version="1.0" encoding="utf-8"?>
<ACCustomizedOrderRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<RequestId>824f60e8-faca-4d1f-a332-865b4258d4a5</RequestId>
<OrderCriteria>
<OrderDateFilter>
<StartDate>2011-07-25T00:00:00</StartDate>
<EndDate>0001-01-01T00:00:00</EndDate>
</OrderDateFilter>
<OrderStatusFilter>1,2,3,4,5,6</OrderStatusFilter>
</OrderCriteria>
<ChunkSize>50</ChunkSize>
<IsUPSWSRequest>false</IsUPSWSRequest>
<IsCSVRequst>false</IsCSVRequst>
<DownloadCCData>false</DownloadCCData>
</ACCustomizedOrderRequest>