[HELP] CommitCRMQueryDataRequest Error "2000"

[Christophe Morez]

I'm using your CmtDbQry.dll but i have an error with CommitCRMQueryDataRequest

CmtInitDbQryDll : OK

CmtGetQueryRecIds : OK
XML Sample :

<?xml version="1.0" ?><?commitcrmxmlqueryrequest version="1.0" ?><CommitCRMQueryDataRequest><ExternalApplicationName>Ioware.ioCommitCRM</ExternalApplicationName><Datakind>ACCOUNT</Datakind><MaxRecordCount>9999</MaxRecordCount></CommitCRMQueryDataRequest>

CmtGetRecordDataByRecId : Error 2000
And CmtGetDescriptionByStatus : "General Error Occurred"


XML Sample :
<?xml version="1.0" ?>
<?commitcrmxmlgetrecorddatarequest version="1.0" ?>
<CommitCRMGetRecordDataRequest>
<ExternalApplicationName>Ioware.ioCommitCRM</ExternalApplicationName>
<GetRecordByRecId>CRDSVHJK86TQVJE5WLAX</GetRecordByRecId>
<SelectFieldsList>FLDCRDCOMPANY, FLDCRDFULLNAME</SelectFieldsList>
</CommitCRMGetRecordDataRequest>

And the response :

<?xml version="1.0" ?>
<?commitcrmxmlgetrecdatarequest version = "1.0" ?>
<CommitCRMGetRecordDataResponse>
<Status>FAILURE</Status>
<ResultCodes>50122</ResultCodes>
<ResultMessage></ResultMessage>
<RecordData></RecordData>
</CommitCRMGetRecordDataResponse>

Error 2000 and 50122 are not referenced in this article

What is wrong with this?

Your wiki with this function is : this article

<?xml version="1.0" ?>
<?commitcrmxmlgetrecorddatarequest version = "1.0" ?>
<CommitCRMGetRecordDataRequest>
<ExternalApplicationName>MySoftwareName</ExternalApplicationName>
<GetRecordByRecId>CRDC1VTHMDF627HJECG7</GetRecordByRecId>
<SelectFieldsList>
FLDCRDCOMPANY,
FLDCRDCONTACT,
FLDCRDADDRESS1,
FLDCRDCITY,
</SelectFieldsList>
</CommitCRMGetRecordDataRequest>

[Support Team]

Hi Christophe Morez,

Thank you for posting this. We will add the relevant items to our Wiki.

Anyway, we believe that the problem with the samples you send is that the application name you used (for the <ExternalApplicationName> token) is too long. Application names should be anywhere between 3 to 15 characters.

Please shorten it and give it another try.

Hope this helps,
Sheli

[Christophe Morez]

Hi,

I changed Ioware.ioCommitCRM with ioCommitCRM (11 characters) and i have the same error.


Another idea?

[Support Team]

Christophe, please try the following XML, I believe the wiki misguided you and that the following XML may work with the version of RangerMSP you have installed. The Wiki is updated to the coming API release which includes a few changes (like for token names) and that might have prevented this from working.

<?xml version="1.0" ?>
<?RangerMSPxmlgetrecdatarequest version = "1.0" ?>
<RangerMSPGetRecDataRequest>
<ExternalApplicationName>ioRangerMSP</ExternalApplicationName>
<GetRecordByRecId>CRDSVHJK86TQVJE5WLAX</GetRecordByRecId>
<SelectFieldsList>FLDCRDCOMPANY, FLDCRDFULLNAME</SelectFieldsList>
</RangerMSPGetRecDataRequest>


Let us know how it goes.

Thanks,
Sheli

[Christophe Morez]

Hi,

With your XML i have an "Ooooopppppssss exception" : "External exception E0434F4D"

I'm using a demo v5.5.0.3.

[Support Team]

Hi Christophe,

Please send us your log files using the Help > Technical Support menu in RangerMSP. We will analyze them and will get back to you with our findings.

Thanks,
Sheli