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>
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: