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

<EdiPortalMessage>
  <MessageCode>89</MessageCode>
  <Message>EdifactConfig id not found.</Message>
  <ExtendedMessage></ExtendedMessage>
</EdiPortalMessage>

Tag	Description
MessageCode	The id of the message
Message	The translateable user-friendly text.
ExtendedMessage	Optional. An extended message to show along with the user friendly message.

Messages

Id	Stored Procedure	Message
4	p_CheckForIssues_Configuration	p_CheckForIssues_Configuration Failed test 1: Read committed snapshot is not enabled.
5	p_CheckForIssues_TrackingCleanup	p_CheckForIssues_TrackingCleanup Failed test 1: Documents exist that should have been deleted by maintenance jobs.
6	p_CheckForIssues_TrackingCleanup	p_CheckForIssues_TrackingCleanup Failed test 2: Ingoing interchanges exist that should have been deleted by maintenance jobs.
7	p_CheckForIssues_TrackingCleanup	p_CheckForIssues_TrackingCleanup Failed test 3: Outgoing interchanges exist that should have been deleted by maintenance jobs.
8	p_CheckForIssues_TrackingCleanup	p_CheckForIssues_TrackingCleanup Failed test 4: Interchanges exist that are not referenced from documents.
9	p0_CheckForInternalDuplicateIdentifications	Another Internal Partner uses the same Identification and IdentificationType.
10	p0_CheckForInternalDuplicateIdentifications	Another Partner uses the same Identification and IdentificationType.
13	p0_GetDistributionDocumentByDocumentConfigsId	The DistributionDocument could not be found.
14	p0_GetDistributionDocumentByDocumentConfigsId	No Itinerary could be found.
15	p0_GetResubmitPath	Could not find ReceivePort in BizTalk management database.
16	p0_GetResubmitPath	The ReceivePort did not have any Resubmit location
19	p0_UpdateDistributionDocumentByDocumentConfigsIdAndDistributionsId	The Distribution could not be found, Cannot update.
20	p0_UpdateDistributionDocumentByDocumentConfigsIdAndDistributionsId	The DocumentType could not be found.
21	p0_UpdateDistributionDocumentByDocumentConfigsIdAndDistributionsId	The DocumentConfig could not be found.
32	pApplicationServers_GetByApplicationServerName	The ApplicationServer could not be found.
34	pApplicationServers_GetById	The ApplicationServer could not be found.
38	pBatchingConfigLogs_GetById	The BatchingConfigLog could not be found.
40	pBatchingConfigs_Delete	@iBatchingConfigsId and @iDistributionsId cannot both be NULL.
44	pBulkInsertDeltaGs1GLN	@iFileLocation is null.
45	pBulkInsertDeltaGs1GLN	@iFormatFileLocation is null.
46	pBulkInsertDeltaGs1GLN	@iDataOwnerName is null..
47	pBulkInsertDeltaGs1GLN	@iPartnerName is null.
52	pData_DeleteByFileGuidTable	The FileTypeName could not be found.
63	pDataOwners_GetById	No DataOwner found.
78	pDistributionConfigurations_GetById	No DistributionConfigurations found.
83	pDistributionLogs_GetById	The DistributionLog could not be found
85	pDistributionObjectAlternativeNames_Create	The given AlternativeName is already in use.
86	pDistributionObjectAlternativeNames_Create	The given AlternativeName is already in use.
87	pDistributionObjectAlternativeNames_GetByAlternativeNameOrName	The DistributionObject could not be found.
89	pDistributionObjectFieldChoices_Get	Paramteters @iDistributionObjectFieldChoicesId and @iDistributionObjectFieldsId can't both be NULL
90	pDistributionObjectFieldConditions_Get	All parameters can't be NULL!
91	pDistributionObjectFieldConditions_ValidationFieldRules_Delete	One of the following parameters must be provided: @iDistributionObjectFieldConditions_ValidationFieldRulesId, @iValidationFieldRulesId or @@iDistributionObjectFieldConditionsId
92	pDistributionObjectFieldConditions_ValidationFieldRules_Get	Parameters @iDistributionObjectFieldConditions_ValidationFieldRulesId and @iValidationFieldRulesId
93	pDistributionObjectFields_Get	At least one parameter must have a value
95	pDistributionObjects_Update	The DistributionObject could not be found. Cannot update.
97	pDistributions_DeleteById	The Distribution could not be found. Cannot delete.
99	pDistributions_GetAllBySearch	@iCurrentUsersId cannot be NULL if @iUseDataAccessRestriction is not NULL or @iUseDataAccessRestrictionStrictMode is not NULL.
100	pDistributions_GetAllBySearch	@iCurrentUsersId cannot be NULL when @iUseDataAccessRestriction is 1.
101	pDistributions_GetAllBySearch	@iCurrentUsersId cannot be NULL when @iUseDataAccessRestrictionStrictMode is 1.
102	pDistributions_GetAllBySearch	@iUseDataAccessRestrictionStrictMode cannot be 1 when @iUseDataAccessRestriction is 0.
104	pDistributions_Update	The Distribution could not be found. Cannot update.
105	pDistributions_Update	Cannot change transport configuration. Make sure that the outbox is empty first
108	pDocumentConfig_GetBySearch	@iDirection must be either ''In'' or ''Out''.
498	pDocumentConfig_GetBySearch	@iCurrentUsersId cannot be NULL when DataAccessRestriction is requested.
109	pDocumentConfig_GetFullyQualifiedSchemaName	No unique FullyQualifiedSchemaName was found
110	pDocumentConfigs_GetById	The DistributionDocument could not be found.
111	pDocumentConfigs_GetById	No Itinerary could be found.
112	pDocuments_Delete	The Document could not be found. Cannot delete.
114	pDocuments_Get	At least one input parameter must be != NULL
115	pDocuments_Get	@iDirection was not valid. Must be 'In' or 'Out'.
118	pDocuments_GetAllAsPresentationBySearch	@iCurrentUsersId cannot be NULL if @iUseDataAccessRestriction is not NULL or @iUseDataAccessRestrictionStrictMode is not NULL.
119	pDocuments_GetAllAsPresentationBySearch	@iCurrentUsersId cannot be NULL when @iUseDataAccessRestriction is 1.
120	pDocuments_GetAllAsPresentationBySearch	@iCurrentUsersId cannot be NULL when @iUseDataAccessRestrictionStrictMode is 1.
121	pDocuments_GetAllAsPresentationBySearch	@iUseDataAccessRestrictionStrictMode cannot be 1 when @iUseDataAccessRestriction is 0.
134	pDocuments_GetNextQueuedDocuments	The value of @iStatusTypeName is not a Document status.
135	pDocuments_GetNoOfActiveDocuments	DistributionObject not found.
136	pDocuments_GetOutboxDocuments	@iPartnersId or @iTransportTypeName must contain a value.
141	pDocuments_Save	[Tracking].[pDocuments_Save] affected more than one row. That should not happen.
142	pDocuments_Save	[Tracking].[pDocuments_Save] affected less than one row. That should not happen.
143	pDocuments_Save	[Tracking].[pDocuments_Save] did not find the document specified by @iDocumentsId.
144	pDocuments_SaveMany	Input list cannot be empty.
147	pDocuments_StatusTypes_Save	Either @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList must be != NULL.
148	pDocuments_StatusTypes_Save	Only one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
149	pDocuments_StatusTypes_Save	Only one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
150	pDocuments_StatusTypes_Save	Only one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
151	pDocuments_StatusTypes_Save	Only one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
152	pDocuments_StatusTypes_Save	Only one of @iDocumentsId, @iInterchangeGuid, @iInterchangeNumber, @iMessageGuid or @iDocumentsList can be != NULL.
153	pDocuments_StatusTypes_Save	No documents found.
154	pDocuments_StatusTypes_Save	Either @iStatusTypesId or @iStatusTypeName must be != NULL.
155	pDocuments_StatusTypes_Save	Only one of @iStatusTypesId and @iStatusTypeName can be != NULL.
156	pDocuments_StatusTypes_Save	Only one of @iStatusTypesId and @iStatusTypeName can be != NULL.
157	pDocuments_StatusTypes_Save	No statusType found for that name.
158	pDocuments_StatusTypes_Save	No Application server found with the supplied name.
159	pDocuments_StatusTypes_SaveMany	Either DocumentsId og DocumendtGuid must be filled out. Not both!
160	pDocumentTypes_Get	@iDirection must be either 'In' or 'Out'.
164	pEdifactConfigLogs_GetById	The EdifactConfigLog could not be found.
167	pEdifactConfigs_Save	The EdifactConfigId could not be found. Cannot update EdifactConfig.
170	pEdifactSegmentSuffixes_GetById	The EdifactSuffix could not be found.
172	pEdifactSegmentSuffixes_GetBySegmentSuffix	The EdifactSuffix could not be found.
176	pEdifactSyntaxes_GetById	The EdifactSyntax could not be found.
178	pEdifactSyntaxes_GetByIdentifierAndVersion	The EdifactSyntax could not be found.
181	pEnvironmentTypes_GetById	The EnvironmentType could not be found.
183	pEnvironmentTypes_GetLocalEnvironmentTypeName	The local sql server is not classified as any environment.
185	pEnvironmentTypes_GetLocalEnvironmentTypesId	The local sql server is not classified as any environment.
190	pExceptionCategories_GetById	No ExceptionCategory found.
192	pExceptionInstances_GetByFaultGuid	No ExceptionInstance found.
194	pExceptionInstances_GetById	No ExceptionInstance found.
199	pExceptionTypes_GetByErrorCode	No ExceptionType found.
201	pExceptionTypes_GetById	No ExceptionType found.
203	pExceptionTypes_GetByNativeErrorCodeAndOriginatingSystemName	No ExceptionType found.
206	pFileAttachments_Delete	The FileAttachment could not be found. Cannot delete FileAttachment.
209	pFileAttachments_GetById	The FileAttachment could not be found.
211	pFileAttachments_PartnerAgreement_Create	The partner already has a partner agreement, a new one cannot be created.
216	pFileAttachments_PartnerAgreement_Update	The PartnerAgreement could not be found. Cannot update FileAttachment.
218	pFileAttachments_Update	The FileAttachment could not be found. Cannot update FileAttachment.
220	pFilenamingConfigs_Delete	Both iFilenamingConfigsId and iDistributionsId are NULL. At least one of them must have a value. Cannot delete.
223	pFlowConvoyPatterns_GetById	The FlowConvoyPattern could not be found.
225	pFlowConvoyPatterns_Update	The FlowConvoyPattern could not be found. Cannot update FlowConvoyPattern.
229	pFormats_GetById	The Format could not be found.
231	pFormats_GetByName	The Format could not be found.
234	pFormatTypes_GetById	The Format could not be found.
237	pGateways_GetById	The Gateway could not be found.
239	pGetAllPartnersByFreeText	@iCurrentUsersId cannot be NULL when @iUseDataAccessRestriction is 1.
247	pIdentificationTypes_GetById	The IdentificationType could not be found.
250	pInConfigurations_GetById	The InConfiguration could not be found.
252	pInConfigurations_Update	The In Configuration could not be found. Cannot update Configuration.
254	pInterchanges_Create	Invalid direction. Direction must be either "In" or "Out".
258	pInterchanges_GetById	The Interchange could not be found.
260	pInterchanges_GetByInterchangeGuid	The Interchange could not be found.
262	pInterchanges_SetFileLocationById	The Interchange could not be found.
264	pInterchanges_SetFileLocationByInterchangeGuid	The Interchange could not be found.
266	pInterchanges_SetInterchangeNumberById	The Interchange could not be found.
269	pInterchanges_SetIsBatchByInterchangesGuid	The Interchange could not be found.
271	pInterchanges_SetIsBatchByInterchangesId	The Interchange could not be found.
273	pInterchanges_SetPortNameByInterchangesId	The Interchange could not be found.
275	pInterchanges_SetTransportConfigurationsIdById	Interchange was not found in database.
277	pInterchanges_SetTransportConfigurationsIdByInterchangeGuid	The interchange could not be found.
279	pInterchanges_SetTransportLogFileByInterchangeGuid	The Interchange could not be found.
281	pInterchanges_Update	The Interchange could not be found. Cannot update Interchange.
287	pOriginatingSystemReflections_GetById	No OriginatingSystemReflection found.
292	pOriginatingSystems_GetById	No OriginatingSystem found.
295	pOutConfigurations_GetById	The OutConfiguration could not be found.
297	pOutConfigurations_Update	The Out Configuration could not be found. Cannot update Configuration.
301	pPartner_IdentificationTypeLogs_GetById	The Partner_IdentificationTypeLog could not be found.
304	pPartner_IdentificationTypes_Delete	The Partner_IdentificationType could not be found, Cannot delete.
307	pPartner_IdentificationTypes_GetById	The Partner_IdentificationType could not be found.
310	pPartner_IdentificationTypes_Update	The Partner_IdentificationType could not be found, Cannot update.
318	pPartnerLogs_GetById	The PartnerLog could not be found.
320	pPartners_Delete	The Partner is used on a distribution. Cannot delete.
321	pPartners_Delete	The Partner could not be found. Cannot delete.
322	pPartners_DistributionObjectFieldChoices_Delete	One of the following parameters must be provided: @iPartners_DistributionObjectFieldChoicesId, @iPartnersId or @iDistributionObjectFieldChoicesId
323	pPartners_Get	@iDoSearchByMainIdentification cannot be NULL when @iIdentificationValue is not NULL.
324	pPartners_Get	iDoSearchByMainIdentification cannot be NULL when @iIdentificationTypeName is not NULL
327	pPartners_Save	The save procedure affected more than one row.
330	pPartnerTypes_GetById	The PartnerType could not be found.
334	pPermissions_GetById	No Permission found.
336	pProxyPartnerConnections_Save	The supplied proxy partner is not configured as one.
337	pProxyPartnerConnections_Save	Not all supplied non-proxy partners are configured as non-proxy partners.
345	pRolePermissions_GetById	No RolePermission found.
347	pRoles_Delete	No Role Found, cannot delete.
351	pRoles_GetById	No Role found.
352	pRoles_Update	No Role Found, cannot update.
358	pSequences_NextValueById	The Sequence could not be found.
365	pSqlServers_GetBySqlServerName	The SqlServer could not be found.
370	pStakeholderTypes_GetById	No StakeholderType found.
380	pStatusResponses_SetStatus	No StatusResponsesId found.
499	pStatusResponses_SetStatus	No ResponseStatusType found.
384	pStatusTypeGroups_GetById	No StatusTypeGroup found.
386	pStatusTypeGroups_GetByStatusTypeGroupName	No StatusTypeGroup found.
388	pStatusTypeGroups_Update	The StatusTypeGroup could not be found. Cannot update group.
394	pStatusTypes_GetById	No StatusType found.
396	pStatusTypes_GetByStatusTypeName	No StatusType found.
398	pStatusTypes_Update	The StatusType could not be found. Cannot update type.
400	pTrackingFields_Delete	At least one parameter must be != NULL.
401	pTrackingFields_Get	At least one parameter must be != NULL.
409	pTrackingFieldTypes_Get	At least one parameter must be != NULL.
412	pTrackingFieldTypes_Update	The TrackingFieldType could not be found. Cannot update type.
416	pTransportConfigurationLogs_GetById	The TransportConfigurationLog could not be found.
419	pTransportConfigurations_Delete	The TransportConfiguration is used on a distribution. Cannot delete.
420	pTransportConfigurations_Delete	The TransportConfiguration could not be found. Cannot delete.
424	pTransportConfigurations_GetByIdAndPartnersId	The TransportConfiguration could not be found.
427	pTransportConfigurations_Update	5ssThe TransportConfiguration could not be found. Cannot update TransportConfiguration.427
428	pTransportConfigurations_Update	Cannot change transport type. Make sure that the outbox is empty first.
432	pTransportConvoyPatterns_GetById	The TransportConvoyPattern could not be found.
434	pTransportConvoyPatterns_Update	The TransportConvoyPattern could not be found. Cannot update TransportConvoyPattern.
437	pTransportResponseTypes_GetById	The TransportResponseType could not be found.
442	pTransportTypeFieldInstances_GetById	The TransportTypeFieldInstance could not be found.
446	pTransportTypeFields_GetById	The TransportTypeField could not be found.
450	pUserGroups_delete	User group cannot be found.
451	pUserGroups_delete	The user group has failed documents assigned to it and cannot be deleted. Please handle the failed documents or assign them to another user group.
452	pUserGroups_delete	The user group is used for assigning errors and cannot be deleted. Please use another usergroup for error assignments.
457	pUserGroups_GetById	No UserGroup Found.
458	pUserGroups_Update	No UserGroup Found, cannot update.
461	pUserGroupUsers_DeleteByUsersIdAndUserGroupsId	No UserGroupUser Found, cannot delete.
463	pValidationFieldRules_Get	Parameters @iValidationFieldRulesId, @iDistributionObjectsId and @iDocumentConfigsId can''t all be NULL
464	pValidationFieldRules_Save	Could not insert DocumentConfigsId. The DistributionObjectField and DocumentConfig are not related.
465	pValidationRequirementTypes_Get	Parameters @iDataOwnersId and @iValidationRequirementTypesId can''t both be NULL
466	pValidationRules_Get	Parameters @iDistributionObjectsId and @iDocumentConfigsId can't both be NULL
467	pValidationRules_Save	Parameters @iDistributionObjectsId and @iDocumentConfigsId can''t both be NULL
468	pValidationRules_Save	Parameter @iValidationFileGuid can''t be NULL
471	pVariants_GetById	The Variant could not be found.
473	pVariants_GetByName	The Variant could not be found.
477	pVariantVersions_GetById	The VariantVersion could not be found.
479	pVariantVersions_GetByVariantVersion	The VariantVersion could not be found.
480	pDistributions_Update	Cannot delete distribution. Make sure that no active alert configurations exist.
481	pAlertConfigurations_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: