Skip to main content
Skip table of contents

Raise Error Messages

Raise Error Messages

Messages returned from stored procedures

Raise Error Stored Procedure

Messages are returned from the stored procedure Utility.pRaiseError. Stored procedures that uses RAISERROR to show user error messages must use Utility.pRaiseError. Stored procedures that uses RAISERROR in a try catch should not use these messages to show exception messages.

Note:

If a message is changed or added in a stored procedure, remember to update this list.

The Message Format

This example shows the message format:

Messages Format

XML
<EdiPortalMessage>
  <MessageCode>89</MessageCode>
  <Message>EdifactConfig id not found.</Message>
  <ExtendedMessage></ExtendedMessage>
</EdiPortalMessage>
TagDescription
MessageCodeThe id of the message
MessageThe translateable user-friendly text.
ExtendedMessageOptional. An extended message to show along with the user friendly message.

Messages

IdStored ProcedureMessage
4p_CheckForIssues_Configurationp_CheckForIssues_Configuration Failed test 1: Read committed snapshot is not enabled.
5p_CheckForIssues_TrackingCleanupp_CheckForIssues_TrackingCleanup Failed test 1: Documents exist that should have been deleted by maintenance jobs.
6p_CheckForIssues_TrackingCleanupp_CheckForIssues_TrackingCleanup Failed test 2: Ingoing interchanges exist that should have been deleted by maintenance jobs.
7p_CheckForIssues_TrackingCleanupp_CheckForIssues_TrackingCleanup Failed test 3: Outgoing interchanges exist that should have been deleted by maintenance jobs.
8p_CheckForIssues_TrackingCleanupp_CheckForIssues_TrackingCleanup Failed test 4: Interchanges exist that are not referenced from documents.
9p0_CheckForInternalDuplicateIdentificationsAnother Internal Partner uses the same Identification and IdentificationType.
10p0_CheckForInternalDuplicateIdentificationsAnother Partner uses the same Identification and IdentificationType.
13p0_GetDistributionDocumentByDocumentConfigsIdThe DistributionDocument could not be found.
14p0_GetDistributionDocumentByDocumentConfigsIdNo Itinerary could be found.
15p0_GetResubmitPathCould not find ReceivePort in BizTalk management database.
16p0_GetResubmitPathThe ReceivePort did not have any Resubmit location
19p0_UpdateDistributionDocumentByDocumentConfigsIdAndDistributionsIdThe Distribution could not be found, Cannot update.
20p0_UpdateDistributionDocumentByDocumentConfigsIdAndDistributionsIdThe DocumentType could not be found.
21p0_UpdateDistributionDocumentByDocumentConfigsIdAndDistributionsIdThe DocumentConfig could not be found.
32pApplicationServers_GetByApplicationServerNameThe ApplicationServer could not be found.
34pApplicationServers_GetByIdThe ApplicationServer could not be found.
38pBatchingConfigLogs_GetByIdThe BatchingConfigLog could not be found.
40pBatchingConfigs_Delete@iBatchingConfigsId and @iDistributionsId cannot both be NULL.
44pBulkInsertDeltaGs1GLN@iFileLocation is null.
45pBulkInsertDeltaGs1GLN@iFormatFileLocation is null.
46pBulkInsertDeltaGs1GLN@iDataOwnerName is null..
47pBulkInsertDeltaGs1GLN@iPartnerName is null.
52pData_DeleteByFileGuidTableThe FileTypeName could not be found.
63pDataOwners_GetByIdNo DataOwner found.
78pDistributionConfigurations_GetByIdNo DistributionConfigurations found.
83pDistributionLogs_GetByIdThe DistributionLog could not be found
85pDistributionObjectAlternativeNames_CreateThe given AlternativeName is already in use.
86pDistributionObjectAlternativeNames_CreateThe given AlternativeName is already in use.
87pDistributionObjectAlternativeNames_GetByAlternativeNameOrNameThe DistributionObject could not be found.
89pDistributionObjectFieldChoices_GetParamteters @iDistributionObjectFieldChoicesId and @iDistributionObjectFieldsId can't both be NULL
90pDistributionObjectFieldConditions_GetAll parameters can't be NULL!
91pDistributionObjectFieldConditions_ValidationFieldRules_DeleteOne of the following parameters must be provided: @iDistributionObjectFieldConditions_ValidationFieldRulesId, @iValidationFieldRulesId or @@iDistributionObjectFieldConditionsId
92pDistributionObjectFieldConditions_ValidationFieldRules_GetParameters @iDistributionObjectFieldConditions_ValidationFieldRulesId and @iValidationFieldRulesId
93pDistributionObjectFields_GetAt least one parameter must have a value
95pDistributionObjects_UpdateThe DistributionObject could not be found. Cannot update.
97pDistributions_DeleteByIdThe Distribution could not be found. Cannot delete.
99pDistributions_GetAllBySearch@iCurrentUsersId cannot be NULL if @iUseDataAccessRestriction is not NULL or @iUseDataAccessRestrictionStrictMode is not NULL.
100pDistributions_GetAllBySearch@iCurrentUsersId cannot be NULL when @iUseDataAccessRestriction is 1.
101pDistributions_GetAllBySearch@iCurrentUsersId cannot be NULL when @iUseDataAccessRestrictionStrictMode is 1.
102pDistributions_GetAllBySearch@iUseDataAccessRestrictionStrictMode cannot be 1 when @iUseDataAccessRestriction is 0.
104pDistributions_UpdateThe Distribution could not be found. Cannot update.
105pDistributions_UpdateCannot change transport configuration. Make sure that the outbox is empty first
108pDocumentConfig_GetBySearch@iDirection must be either ''In'' or ''Out''.
498pDocumentConfig_GetBySearch@iCurrentUsersId cannot be NULL when DataAccessRestriction is requested.​
109pDocumentConfig_GetFullyQualifiedSchemaNameNo unique FullyQualifiedSchemaName was found
110pDocumentConfigs_GetByIdThe DistributionDocument could not be found.
111pDocumentConfigs_GetByIdNo Itinerary could be found.
112pDocuments_DeleteThe Document could not be found. Cannot delete.
114pDocuments_GetAt least one input parameter must be != NULL
115pDocuments_Get@iDirection was not valid. Must be 'In' or 'Out'.
118pDocuments_GetAllAsPresentationBySearch@iCurrentUsersId cannot be NULL if @iUseDataAccessRestriction is not NULL or @iUseDataAccessRestrictionStrictMode is not NULL.
119pDocuments_GetAllAsPresentationBySearch@iCurrentUsersId cannot be NULL when @iUseDataAccessRestriction is 1.
120pDocuments_GetAllAsPresentationBySearch@iCurrentUsersId cannot be NULL when @iUseDataAccessRestrictionStrictMode is 1.
121pDocuments_GetAllAsPresentationBySearch@iUseDataAccessRestrictionStrictMode cannot be 1 when @iUseDataAccessRestriction is 0.
134pDocuments_GetNextQueuedDocumentsThe value of @iStatusTypeName is not a Document status.
135pDocuments_GetNoOfActiveDocumentsDistributionObject not found.
136pDocuments_GetOutboxDocuments@iPartnersId or @iTransportTypeName must contain a value.
141pDocuments_Save[Tracking].[pDocuments_Save] affected more than one row. That should not happen.
142pDocuments_Save[Tracking].[pDocuments_Save] affected less than one row. That should not happen.
143pDocuments_Save[Tracking].[pDocuments_Save] did not find the document specified by @iDocumentsId.
144pDocuments_SaveManyInput list cannot be empty.
147pDocuments_StatusTypes_SaveEither @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList must be != NULL.
148pDocuments_StatusTypes_SaveOnly one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
149pDocuments_StatusTypes_SaveOnly one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
150pDocuments_StatusTypes_SaveOnly one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
151pDocuments_StatusTypes_SaveOnly one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
152pDocuments_StatusTypes_SaveOnly one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
153pDocuments_StatusTypes_SaveNo documents found.
154pDocuments_StatusTypes_SaveEither @iStatusTypesId or @iStatusTypeName must be != NULL.
155pDocuments_StatusTypes_SaveOnly one of @iStatusTypesId and @iStatusTypeName can be != NULL.
156pDocuments_StatusTypes_SaveOnly one of @iStatusTypesId and @iStatusTypeName can be != NULL.
157pDocuments_StatusTypes_SaveNo statusType found for that name.
158pDocuments_StatusTypes_SaveNo Application server found with the supplied name.
159pDocuments_StatusTypes_SaveManyEither DocumentsId og DocumendtGuid must be filled out. Not both!
160pDocumentTypes_Get@iDirection must be either 'In' or 'Out'.
164pEdifactConfigLogs_GetByIdThe EdifactConfigLog could not be found.
167pEdifactConfigs_SaveThe EdifactConfigId could not be found. Cannot update EdifactConfig.
170pEdifactSegmentSuffixes_GetByIdThe EdifactSuffix could not be found.
172pEdifactSegmentSuffixes_GetBySegmentSuffixThe EdifactSuffix could not be found.
176pEdifactSyntaxes_GetByIdThe EdifactSyntax could not be found.
178pEdifactSyntaxes_GetByIdentifierAndVersionThe EdifactSyntax could not be found.
181pEnvironmentTypes_GetByIdThe EnvironmentType could not be found.
183pEnvironmentTypes_GetLocalEnvironmentTypeNameThe local sql server is not classified as any environment.
185pEnvironmentTypes_GetLocalEnvironmentTypesIdThe local sql server is not classified as any environment.
190pExceptionCategories_GetByIdNo ExceptionCategory found.
192pExceptionInstances_GetByFaultGuidNo ExceptionInstance found.
194pExceptionInstances_GetByIdNo ExceptionInstance found.
199pExceptionTypes_GetByErrorCodeNo ExceptionType found.
201pExceptionTypes_GetByIdNo ExceptionType found.
203pExceptionTypes_GetByNativeErrorCodeAndOriginatingSystemNameNo ExceptionType found.
206pFileAttachments_DeleteThe FileAttachment could not be found. Cannot delete FileAttachment.
209pFileAttachments_GetByIdThe FileAttachment could not be found.
211pFileAttachments_PartnerAgreement_CreateThe partner already has a partner agreement, a new one cannot be created.
216pFileAttachments_PartnerAgreement_UpdateThe PartnerAgreement could not be found. Cannot update FileAttachment.
218pFileAttachments_UpdateThe FileAttachment could not be found. Cannot update FileAttachment.
220pFilenamingConfigs_DeleteBoth iFilenamingConfigsId and iDistributionsId are NULL. At least one of them must have a value. Cannot delete.
223pFlowConvoyPatterns_GetByIdThe FlowConvoyPattern could not be found.
225pFlowConvoyPatterns_UpdateThe FlowConvoyPattern could not be found. Cannot update FlowConvoyPattern.
229pFormats_GetByIdThe Format could not be found.
231pFormats_GetByNameThe Format could not be found.
234pFormatTypes_GetByIdThe Format could not be found.
237pGateways_GetByIdThe Gateway could not be found.
239pGetAllPartnersByFreeText@iCurrentUsersId cannot be NULL when @iUseDataAccessRestriction is 1.
247pIdentificationTypes_GetByIdThe IdentificationType could not be found.
250pInConfigurations_GetByIdThe InConfiguration could not be found.
252pInConfigurations_UpdateThe In Configuration could not be found. Cannot update Configuration.
254pInterchanges_CreateInvalid direction. Direction must be either "In" or "Out".
258pInterchanges_GetByIdThe Interchange could not be found.
260pInterchanges_GetByInterchangeGuidThe Interchange could not be found.
262pInterchanges_SetFileLocationByIdThe Interchange could not be found.
264pInterchanges_SetFileLocationByInterchangeGuidThe Interchange could not be found.
266pInterchanges_SetInterchangeNumberByIdThe Interchange could not be found.
269pInterchanges_SetIsBatchByInterchangesGuidThe Interchange could not be found.
271pInterchanges_SetIsBatchByInterchangesIdThe Interchange could not be found.
273pInterchanges_SetPortNameByInterchangesIdThe Interchange could not be found.
275pInterchanges_SetTransportConfigurationsIdByIdInterchange was not found in database.
277pInterchanges_SetTransportConfigurationsIdByInterchangeGuidThe interchange could not be found.
279pInterchanges_SetTransportLogFileByInterchangeGuidThe Interchange could not be found.
281pInterchanges_UpdateThe Interchange could not be found. Cannot update Interchange.
287pOriginatingSystemReflections_GetByIdNo OriginatingSystemReflection found.
292pOriginatingSystems_GetByIdNo OriginatingSystem found.
295pOutConfigurations_GetByIdThe OutConfiguration could not be found.
297pOutConfigurations_UpdateThe Out Configuration could not be found. Cannot update Configuration.
301pPartner_IdentificationTypeLogs_GetByIdThe Partner_IdentificationTypeLog could not be found.
304pPartner_IdentificationTypes_DeleteThe Partner_IdentificationType could not be found, Cannot delete.
307pPartner_IdentificationTypes_GetByIdThe Partner_IdentificationType could not be found.
310pPartner_IdentificationTypes_UpdateThe Partner_IdentificationType could not be found, Cannot update.
318pPartnerLogs_GetByIdThe PartnerLog could not be found.
320pPartners_DeleteThe Partner is used on a distribution. Cannot delete.
321pPartners_DeleteThe Partner could not be found. Cannot delete.
322pPartners_DistributionObjectFieldChoices_DeleteOne of the following parameters must be provided: @iPartners_DistributionObjectFieldChoicesId, @iPartnersId or @iDistributionObjectFieldChoicesId
323pPartners_Get@iDoSearchByMainIdentification cannot be NULL when @iIdentificationValue is not NULL.
324pPartners_GetiDoSearchByMainIdentification cannot be NULL when @iIdentificationTypeName is not NULL
327pPartners_SaveThe save procedure affected more than one row.
330pPartnerTypes_GetByIdThe PartnerType could not be found.
334pPermissions_GetByIdNo Permission found.
336pProxyPartnerConnections_SaveThe supplied proxy partner is not configured as one.
337pProxyPartnerConnections_SaveNot all supplied non-proxy partners are configured as non-proxy partners.
345pRolePermissions_GetByIdNo RolePermission found.
347pRoles_DeleteNo Role Found, cannot delete.
351pRoles_GetByIdNo Role found.
352pRoles_UpdateNo Role Found, cannot update.
358pSequences_NextValueByIdThe Sequence could not be found.
365pSqlServers_GetBySqlServerNameThe SqlServer could not be found.
370pStakeholderTypes_GetByIdNo StakeholderType found.
380pStatusResponses_SetStatusNo StatusResponsesId found.
499pStatusResponses_SetStatusNo ResponseStatusType found.
384pStatusTypeGroups_GetByIdNo StatusTypeGroup found.
386pStatusTypeGroups_GetByStatusTypeGroupNameNo StatusTypeGroup found.
388pStatusTypeGroups_UpdateThe StatusTypeGroup could not be found. Cannot update group.
394pStatusTypes_GetByIdNo StatusType found.
396pStatusTypes_GetByStatusTypeNameNo StatusType found.
398pStatusTypes_UpdateThe StatusType could not be found. Cannot update type.
400pTrackingFields_DeleteAt least one parameter must be != NULL.
401pTrackingFields_GetAt least one parameter must be != NULL.
409pTrackingFieldTypes_GetAt least one parameter must be != NULL.
412pTrackingFieldTypes_UpdateThe TrackingFieldType could not be found. Cannot update type.
416pTransportConfigurationLogs_GetByIdThe TransportConfigurationLog could not be found.
419pTransportConfigurations_DeleteThe TransportConfiguration is used on a distribution. Cannot delete.
420pTransportConfigurations_DeleteThe TransportConfiguration could not be found. Cannot delete.
424pTransportConfigurations_GetByIdAndPartnersIdThe TransportConfiguration could not be found.
427pTransportConfigurations_Update5ssThe TransportConfiguration could not be found. Cannot update TransportConfiguration.427
428pTransportConfigurations_UpdateCannot change transport type. Make sure that the outbox is empty first.
432pTransportConvoyPatterns_GetByIdThe TransportConvoyPattern could not be found.
434pTransportConvoyPatterns_UpdateThe TransportConvoyPattern could not be found. Cannot update TransportConvoyPattern.
437pTransportResponseTypes_GetByIdThe TransportResponseType could not be found.
442pTransportTypeFieldInstances_GetByIdThe TransportTypeFieldInstance could not be found.
446pTransportTypeFields_GetByIdThe TransportTypeField could not be found.
450pUserGroups_deleteUser group cannot be found.
451pUserGroups_deleteThe user group has failed documents assigned to it and cannot be deleted. Please handle the failed documents or assign them to another user group.
452pUserGroups_deleteThe user group is used for assigning errors and cannot be deleted. Please use another usergroup for error assignments.
457pUserGroups_GetByIdNo UserGroup Found.
458pUserGroups_UpdateNo UserGroup Found, cannot update.
461pUserGroupUsers_DeleteByUsersIdAndUserGroupsIdNo UserGroupUser Found, cannot delete.
463pValidationFieldRules_GetParameters @iValidationFieldRulesId, @iDistributionObjectsId and @iDocumentConfigsId can''t all be NULL
464pValidationFieldRules_SaveCould not insert DocumentConfigsId. The DistributionObjectField and DocumentConfig are not related.
465pValidationRequirementTypes_GetParameters @iDataOwnersId and @iValidationRequirementTypesId can''t both be NULL
466pValidationRules_GetParameters @iDistributionObjectsId and @iDocumentConfigsId can't both be NULL
467pValidationRules_SaveParameters @iDistributionObjectsId and @iDocumentConfigsId can''t both be NULL
468pValidationRules_SaveParameter @iValidationFileGuid can''t be NULL
471pVariants_GetByIdThe Variant could not be found.
473pVariants_GetByNameThe Variant could not be found.
477pVariantVersions_GetByIdThe VariantVersion could not be found.
479pVariantVersions_GetByVariantVersionThe VariantVersion could not be found.
480pDistributions_UpdateCannot delete distribution. Make sure that no active alert configurations exist.
481pAlertConfigurations_Delete

Cannot delete alert configuration. Make sure that no unhandled alert events exist for this alert configuration.
​​482​pDistributions_GetAllBySearch​Value of @iDataAccessRestriction is invalid.​

Content on this page:

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.