So I've been trying to query the Case table for some data but for some strange reason when I add the field CreatedDate I get this odd error response: 'There is an error in XML document (1, 643).'

Here is the excerpt from my application log:
2006-11-07_07:15:22,[login] Begin
2006-11-07_07:15:22,[login] SessionID: QVHqo6ruXq9kcfcDlmhwvHJG49Se.kbDY7.TZS3gNOEvbq36HJoNxvhZcfpNwnzNk6L3jGyHnCfap_58z3RM0GpYnKO9AsNCSeX5jsUoLXQ=
2006-11-07_07:15:22,[login] ServerURL: https://na3-api.salesforce.com/services/Soap/c/7.0
2006-11-07_07:15:22,[login] Complete
2006-11-07_07:15:22,[getQuery] Executing query: 'Select CaseNumber, ClosedDate, ContactId, CreatedById, Description, Id, Origin, OwnerId, Priority, Self_Service_Portal_User__c, Status, Subject from Case where Self_Service_Portal_User__c = 'user@somesite.com''
2006-11-07_07:15:22,[getQuery] 1 found
2006-11-07_07:15:22,[getQuery] Done
2006-11-07_07:15:26,[login] Begin
2006-11-07_07:15:27,[login] SessionID: Y8MggXF9QD49D68qKtD.7q8El7QSc2ZlZd31dbmmzlydLUVo0qrWSXFcKZByV8kVl5BzpVc5fh7P2f1AIKZTOWpYnKO9AsNCSeX5jsUoLXQ=
2006-11-07_07:15:27,[login] ServerURL: https://na3-api.salesforce.com/services/Soap/c/7.0
2006-11-07_07:15:27,[login] Complete
2006-11-07_07:15:27,[getQuery] Executing query: 'Select CaseNumber, ClosedDate, ContactId, CreatedById, CreatedDate, Description, Id, Origin, OwnerId, Priority, Self_Service_Portal_User__c, Status, Subject from Case where Self_Service_Portal_User__c = 'user@somesite.com''
2006-11-07_07:15:27,ERROR getQuery(): There is an error in XML document (1, 643).

As you can notice there are 2 queries - one without the CreateDate field and the last with the CreatedDate field. With the CreatedDate field I get that error.. any insights?

Message Edited by eyeSea on 11-07-2006 07:19 AM

Hello, I'm trying to develope my own Self Service User Portal using the API. My first problem is how do I login using a self service account?

So I've been trying to query the Case table for some data but for some strange reason when I add the field CreatedDate I get this odd error response: 'There is an error in XML document (1, 643).'

Here is the excerpt from my application log:
2006-11-07_07:15:22,[login] Begin
2006-11-07_07:15:22,[login] SessionID: QVHqo6ruXq9kcfcDlmhwvHJG49Se.kbDY7.TZS3gNOEvbq36HJoNxvhZcfpNwnzNk6L3jGyHnCfap_58z3RM0GpYnKO9AsNCSeX5jsUoLXQ=
2006-11-07_07:15:22,[login] ServerURL: https://na3-api.salesforce.com/services/Soap/c/7.0
2006-11-07_07:15:22,[login] Complete
2006-11-07_07:15:22,[getQuery] Executing query: 'Select CaseNumber, ClosedDate, ContactId, CreatedById, Description, Id, Origin, OwnerId, Priority, Self_Service_Portal_User__c, Status, Subject from Case where Self_Service_Portal_User__c = 'user@somesite.com''
2006-11-07_07:15:22,[getQuery] 1 found
2006-11-07_07:15:22,[getQuery] Done
2006-11-07_07:15:26,[login] Begin
2006-11-07_07:15:27,[login] SessionID: Y8MggXF9QD49D68qKtD.7q8El7QSc2ZlZd31dbmmzlydLUVo0qrWSXFcKZByV8kVl5BzpVc5fh7P2f1AIKZTOWpYnKO9AsNCSeX5jsUoLXQ=
2006-11-07_07:15:27,[login] ServerURL: https://na3-api.salesforce.com/services/Soap/c/7.0
2006-11-07_07:15:27,[login] Complete
2006-11-07_07:15:27,[getQuery] Executing query: 'Select CaseNumber, ClosedDate, ContactId, CreatedById, CreatedDate, Description, Id, Origin, OwnerId, Priority, Self_Service_Portal_User__c, Status, Subject from Case where Self_Service_Portal_User__c = 'user@somesite.com''
2006-11-07_07:15:27,ERROR getQuery(): There is an error in XML document (1, 643).

As you can notice there are 2 queries - one without the CreateDate field and the last with the CreatedDate field. With the CreatedDate field I get that error.. any insights?

Message Edited by eyeSea on 11-07-2006 07:19 AM