Cannot create a record in Message Table (AifMessageLog)

(0) Share

Report

Posted on by Community Member

Hi guys,

When I'm finding the item keys by using Findkeys method it throws an error like below.

AifRequestProcessor-processServiceRequest Cannot create a record in Message Table (AifMessageLog). Message ID: {23BD3FCE-C766-4CC5-B048-144477EFEE02}, InventItemService.findKeys.
The SQL database has issued an error.
Cannot create a record in Exceptions (SysExceptionTable). Exception type: Error, Cannot create a record in Message Table (AifMessageLog). Message ID: {23BD3FCE-C766-4CC5-B048-144477EFEE02}, InventItemService.findKeys.
The SQL database has issued an error..
The SQL database has issued an error.

Code is looking like below :

CriteriaElement elem = new CriteriaElement();
elem.DataSourceName = "InventTable";
elem.FieldName = "ItemId";
elem.Operator = Operator.Equal;
elem.Value1 = "1151";
QueryCriteria crit = new QueryCriteria();
crit.CriteriaElement = new CriteriaElement[1] { elem };
EntityKey[] ekey = proxy.findKeys(crit);

Item is already in AX .But i'm getting this Error.

Any suggestions ?.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Martin Dráb 239,392 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Code Beginner, please pay attention to what you use as tags; "The SQL database has issued an error. Cannot create a record in Exceptions (SysExceptionTable)." isn't a very useful category of questions. Let me update it; I'll also remove the AX version from the title, because it merely duplicates the version tag.

Was this reply helpful? Yes No
Martin Dráb 239,392 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

In strongly recommend that you try to reproduce the problem directly in AX, instead of going through all the proxy classes and the web service call. It will make debugging much easier.

Try writing to SysExceptionTable from AX, maybe you'll get an error and you'll learn more about what DB error was thrown.

Check event logs. It may also be worth synchronizing DB, in case your problem is caused by problems with synchronization.

If you fail reproducing the problem, try debugging X++ executed during the service call; it might reveal more details.

Was this reply helpful? Yes No
Suggested answer

JII SAADUDDIN 1,832 on at

Like (0)

Report
Copy link

Link copied!

Hi, I think this is no longer connected on the issue. Do you config or change security roles?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi jii,

I don't change any roles Saaduddin.

Was this reply helpful? Yes No