Hi, I have a big problem with Document Exchange: when I upload a file in any direcorty of the storage, I can see the file uploaded only the day after. The same situation appear when I create direcorties.
I didn't configure any time-out operations or strange policies. There are any setting parameter that configure Document Exchange for publish files only a lot of ours after the upload?
Thanks for your help.

Bye.

Matteo Simonetti

Hi Matteo,

Not sure what could cause this. Every time you look at DMX the data is drawn out of the database in real time. So if the data is there, it should come out. I can think of two things:

1. something is up with the triggers on the DMX_Entries table preventing the correct handling of a new record. After upload the LastVersionId should be set to EntryId for a new record. If this doesn't happen immediately then the triggers have either been switched off of not installed. You'll need to debug this on the SQL server.

2. Some kind of caching that is happening that I'm unaware of. This should be easily spotted using SQL profiler as there are no calls to DMX when you refresh your page. But I'm skeptical it is this. It's probably 1.

Peter

Hi, Since I upgraded from DNN 6 to 7 I'm having what appears to be the same problem as Matteos described where file uploads don't display until some random time later (he said the next day - for me it has been variable). On following through on the possible issues described by Peter, it appears it is something to do with a faulty trigger on the DMX Entries table because the items that won't display all have a LastVersionId of NULL and apparently they should be the same the EntryID. Any urgent assistance on how to fix this would be greatly appreciated, including any temporary fixes to get clients happy again.

[quote]
Posted By MatteoS on 16 Apr 2013 12:12:07
Hi, I have a big problem with Document Exchange: when I upload a file in any direcorty of the storage, I can see the file uploaded only the day after. The same situation appear when I create direcorties.
I didn't configure any time-out operations or strange policies. There are any setting parameter that configure Document Exchange for publish files only a lot of ours after the upload?
Thanks for your help.

Bye.

Matteo Simonetti
[/quote]

All users that have reported this issue have somehow disabled the triggers on the DMX_Entries table in SQL. It is abnormal and should not be done. Every so often (twice per day) DMX repairs any anomalies and you see the files appear. But really you need to enable those triggers. There should be three. If they're not there, then something has gone wrong during installation.

Peter