Report deleted by mistake

Jean_Francois_Leclercq

While in the combo box of all reports I right click on a report, selected copy and immediately paste. The system stopped me and told me that I had no authorization to copy this report, which is fine.

When I click OK, the system actually created a report with the same ID, for instance 204. Then I clicked ESC and the original report 204 is now gone !!!

1. How can this happens ?
2. Can I recover deleted report ?

Thanks

Marije_Brummel

The only way to recover is to extract the report from a backup database.

Savatage

Maybe it's just me but I have read over your explanation of what happened & I still don't get it..
:-k

you tried to copy a report on a report that already existed and the system got rid of both and created a new blank report??????

Marije_Brummel

Yes, this part is very awkward! :shock: Never happened to me, and I do this quite often... :?

themave

This happens all the time if you are not careful. It doesn't happen if your license allows you to modify the particular report. So it doesn't really happen to developers, just end users.

His discription is accurate.


if you click and copy a report and paste it, before you leave the line you are on, you must give it a new number, or when you hit esc. both are gone.

The error message is "The report could not be pasted. Change the report and insert the record pr press Esc to cancel" the option button on the error dialog box is "OK" if you press ok, the record is inserted with the same report number. so while you are on the line you can see two report 204's for example, at this point you have to change the report number and the description and when you leave the line, you will have the new copied report with it's new number. If you press esc. here without changing the number, you will lose both reports.

the place you need to hit esc, is when the error dialog box is on the screen.

On occation when it happens to me, I have to import the report back from our test company.

DenSter

Copy/paste was not meant to be used that way, and it's no wonder to me that it causes issues like this. I've seen people pasting objects into an excel sheet and back into another database with big grins on their faces, only to see those grins disappear when they corrupt their system by trying to use a 'smart' shortcut. But I digress .

If you want to make a copy of a report, you should open it in design, and use the 'save as' selection on the file menu. You will get a dialog box where you can enter a new number and name, and it will not screw anything up if you use either one with an existing value.

themave

Thats the proper way to copy a report, but if you don't have access to a report and you want to see how it works so you can learn about navision, you can do this, and renumber it to a number range you have access to. then you can see how it works to learn more, Not that I would do that though.

Jean_Francois_Leclercq

Thanks to everyone for acknowledging the problem.

I know now that its better to do a save as while editing a report than a copy /paste.

I have now lost 8 hours of work but thats can happen sometimes. Still, I find it surprising that a software would not control this sequence more accurately and I would certainly qualify this as a bug.

DenSter

Actually I think it is the other way around. The copy/paste working at all the way that it does is a bug itself. It was never meant to do what you want it to do. Iam speculating of course, but I do not believe that Navision meant for us to be able to simply copy and paste intellectual property and give just any user access to all source code.

Don't expect MS to make this work the way you want it to. If they do anything, they will disable that feature altogether.

jjanauskas

If you are working with MSSQL DB there is a way to recover any accidentally deleted information. Since reports are stored to table "Object", you can also recover and lost objects.

In order to do that must use Log Explorer from Lumigent. I posted a short blog entry about it here

Marije_Brummel

Does this also recover the actual BLOB containing the object or only the line in the object table?

jjanauskas

I haven't tried it with blob fields, but the general concept of transaction log forces me to believe, that yes!

How would SQL Server rollback the trasaction if the blob information would not be stored @ t-log?

Marije_Brummel

If it can trace/restore the BLOB you can also use it for version control. 8)

jjanauskas

if the recovery mode of sql database is "Simple" or "Bulk", so you cannot use it for vesion control because the t-log is truncated when MSSQL server "thinks" that it is a good time to truncate.

but if your recovery mode is "Full" then ALL transactions are loged in this log and t-log is not truncated. But this consumes lot of disk space.. and in if you want you can trace all the changes of table "Object"