One of our customers has a strange problem in their database. From one moment to another, all sales invoices created by a service order disappear when they post them. Nothing has been changed (no objects/settings as far as I know) and when importing objects from a copy of the database that was made a few days ago, the time and date fields of the objects are the same. The strange thing is however that the BLOB-size of the objects are different!![?] Has anyone encountered a similar problem??
You are talking about Objects Import/Export or Dataport Import/Export.
I’m talking about the objects import/export
Hey Marco, How are you, hope you are alright! I would export all related objects as text and do a search on a DELETEALL statement or a loop deleting the records. I think it’s something like that. I 99% sure that’s the problem if we are talking about version 3.00.
quote:
One of our customers has a strange problem in their database. From one moment to another, all sales invoices created by a service order disappear when they post them. Nothing has been changed (no objects/settings as far as I know) and when importing objects from a copy of the database that was made a few days ago, the time and date fields of the objects are the same. The strange thing is however that the BLOB-size of the objects are different!![?]
If the BLOB size of the objects is different the objects can have been changed (no matter if the date and time is the same,as it can always be changed). Try the same steps the user is doing on a copy of the database with the objects of that backup from a few days ago. If everything is working fine, import the backup objects replacing the ones you’ve on the database (if new changes have been made, check what has been done since that database and put the changes into the database with the backup objects and test again… if all continues to work put all the objects onto the real one REPLACING). Regards and good luck,
Well the problem is… there are no changes in the code. What I’m talking about here are codeunits that spontaneoasly change in blob-size. Well, maybe it’s nothing to worry about but it’s still strange …