Problem when running Report 795 (Adjust Cost - Item Entries)

poppins

Hi everyone,

I have encountered this problem when running the standard report 795 Adjust Cost - Item Entries:
I started running the report and got the following error message:

The item ledger entry already exists.Identification fields and values: Entry No.='368156'

Iwent to table 339 (Item Application Entry), filtered on Item Ledger Entry No.=368156 and deleted the associated lines.
When I got back to the report again, it started running normally but then gave me the following error message:

A fatal error occurred. The connection to SQL server cannot be established or is no longer usable. This can be caused by one of the following reasons:

* The server has been shut down manually or because of an error.
* The SQL server connection settings are not correct
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer.

Try again later or contact your system administrator.

Why is that?What shall I do?

bbrown

What was your diagnostic process that brought you to delete those records?

poppins

bbrown wrote:

What was your diagnostic process that brought you to delete those records?

No diagnostic process, infact :oops:
This is the first time I deal with this issue, and the deletion action was suggested by a user who is normally in charge of this task...
What do you suggest that I do?

rdebath

The fatal error message usually means that either the SQL server was restarted or your session was terminated by someone. (It can also mean that your lan connection is very flaky)

The duplicate key in the ILE table would imply that the locking or transactions have been damaged in some way. Perhaps the SQL database has been corrupted by bad disks or controllers. Perhaps a native database has been corrupted by a flaky network card. Perhaps someone has been adding 'COMMIT's where they shouldn't.

We'd need to known more about your system before we can tell what might be happening.

bbrown

I would have suggested some further investigation before deleting those records. Adjust Cost does not create Item Ledger Entry records. So the fact that you get an error related to the insert of such a record, would/should raise questions.


Does the Item Ledger Entry record referred to in the error message exist? If so, what is the entry type and value of the field POSITIVE?

poppins

bbrown wrote:

I would have suggested some further investigation before deleting those records. Adjust Cost does not create Item Ledger Entry records. So the fact that you get an error related to the insert of such a record, would/should raise questions.


Does the Item Ledger Entry record referred to in the error message exist? If so, what is the entry type and value of the field POSITIVE?

Yes, the item ledger entry record exists.
Entry Type:Sales
Positive:False

bbrown

I would start by putting those deleted records back. I very much doubt that they were the problem. Deleting them, more likely, simply "fixed" the issue by making Adjust Cost skip over the part causing the problem.

Then I would sort out exactly where the process is breaking.

poppins

bbrown wrote:

I would start by putting those deleted records back. I very much doubt that they were the problem. Deleting them, more likely, simply "fixed" the issue by making Adjust Cost skip over the part causing the problem.

Then I would sort out exactly where the process is breaking.

OK, but how can I put them back?

bbrown

Run the table in the Object Designer and re-enter the missing records.

poppins

bbrown wrote:

Run the table in the Object Designer and re-enter the missing records.

I know that but I don't remember which values were in the deleted records...

bbrown

Do you have a backup from which you could retrieve them? What was the date of that Item Ledger?