HomeGuidesAPI ReferenceAnnouncements
HomeGuidesAPI ReferenceChangelogDeveloper Q&A
HomeGuidesAPI ReferenceAnnouncementsLog In
Developer Q&A

Developer Q&A

Ask a Question
Back to All

Document.Blob scalar property must be the last in property path

about 6 years ago by Myron

Have you even dealt with something like this?
I am trying to make a call to their API to get our Documents. I am using almost the exact same code as before. I had to change from using "AllProperties" to a "PropertySet" in an attempt to get the Blob variable stored in the Document object.

I am getting the following error:
"faultString: System.Web.Services.Protocols.SoapException: Document.Blob scalar property must be the last in property path."

Using this code:
QueryExpression query = new QueryExpression();
query.setEntityType(EntityType.Document);
PropertySet propertySet = new PropertySet();
propertySet.setProperties(new String[] { "id", "title", "startDate", "updatedDate", "wonId", "blob","docType" });
query.setPropertySet(propertySet);

//query.setPropertySet(new AllProperties());
FilterExpression criteria = new FilterExpression();
FilterExpression[] filters = new FilterExpression[1];
filters[0] = new FilterExpression();
ConditionExpression[] actionConditions = new ConditionExpression[1];
actionConditions[0] = new ConditionExpression();
actionConditions[0].setOperator(ConditionOperator.GreaterThan);
actionConditions[0].setPropertyName("updatedDate");
Calendar reLoad = this.retrieveLastDate();
// reLoad.set(Calendar.HOUR, 1);
actionConditions[0].setValues(new Calendar[] { reLoad });
filters[0].setConditions(actionConditions);
filters[0].setFilterOperator(LogicalOperator.And);
criteria.setFilters(filters);
query.setDistinct(true);
criteria.setFilterOperator(LogicalOperator.And);
query.setCriteria(criteria);

AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Client
faultSubcode:
faultString: System.Web.Services.Protocols.SoapException: Document.Blob scalar property must be the last in property path.
at Corrigo.Web.Services.CorrigoService.Core.ServiceExecutionContext.SoapExceptionBlock(Action action) in C:\Builds\3\Main Product\CorrigoNet9.1SU3\Sources\Source\BusinessObjects\Corrigo.BO.CorrigoService\Core\ServiceExecutionContext.cs:line 268
at Corrigo.Web.Services.CorrigoService.Core.ServiceExecutionContext.SoapExceptionBlockWithSession[T](Func1 func) in C:\Builds\3\Main Product\CorrigoNet9.1SU3\Sources\Source\BusinessObjects\Corrigo.BO.CorrigoService\Core\ServiceExecutionContext.cs:line 301 at Integration.CorrigoService.RetrieveMultiple(QueryBase queryExpression) in C:\Builds\3\Main Product\CorrigoNet9.1SU3\Sources\Source\Web\Services\Integration\CorrigoService.asmx.cs:line 88 faultActor: http://am91ap.corrigo.com/wsdk/CorrigoService.asmx?wsdl faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:System.Web.Services.Protocols.SoapException: Document.Blob scalar property must be the last in property path. at Corrigo.Web.Services.CorrigoService.Core.ServiceExecutionContext.SoapExceptionBlock(Action action) in C:\Builds\3\Main Product\CorrigoNet9.1SU3\Sources\Source\BusinessObjects\Corrigo.BO.CorrigoService\Core\ServiceExecutionContext.cs:line 268 at Corrigo.Web.Services.CorrigoService.Core.ServiceExecutionContext.SoapExceptionBlockWithSession[T](Func1 func) in C:\Builds\3\Main Product\CorrigoNet9.1SU3\Sources\Source\BusinessObjects\Corrigo.BO.CorrigoService\Core\ServiceExecutionContext.cs:line 301
at Integration.CorrigoService.RetrieveMultiple(QueryBase queryExpression) in C:\Builds\3\Main Product\CorrigoNet9.1SU3\Sources\Source\Web\Services\Integration\CorrigoService.asmx.cs:line 88
at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.corrigo.webservices._6_x.CorrigoServiceStub.retrieveMultiple(CorrigoServiceStub.java:2957)
at com.ifmrestoration.corrigo.Document.run(Document.java:111)
at com.ifmrestoration.corrigo.DocumentServlet.doGet(DocumentServlet.java:16)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:867)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1623)
at com.google.appengine.tools.development.ResponseRewriterFilter.doFilter(ResponseRewriterFilter.java:134)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
at com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:34)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
at com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:63)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
at com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:48)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
at com.google.appengine.tools.development.jetty9.StaticFileFilter.doFilter(StaticFileFilter.java:123)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
at com.google.appengine.tools.development.DevAppServerModulesFilter.doDirectRequest(DevAppServerModulesFilter.java:366)
at com.google.appengine.tools.development.DevAppServerModulesFilter.doDirectModuleRequest(DevAppServerModulesFilter.java:349)
at com.google.appengine.tools.development.DevAppServerModulesFilter.doFilter(DevAppServerModulesFilter.java:116)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
at com.google.appengine.tools.development.DevAppServerRequestLogFilter.doFilter(DevAppServerRequestLogFilter.java:44)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1588)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1557)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
at com.google.appengine.tools.development.jetty9.DevAppEngineWebAppContext.doScope(DevAppEngineWebAppContext.java:94)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at com.google.appengine.tools.development.jetty9.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:595)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:502)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:132)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)

{http://xml.apache.org/axis/}hostname:instance-1