We have upgrdaded DMX3 to DMX4 and have run all needed Scripts how "Upgrade DMX3 to DMX4" and Reindex. We see the complete Folder-Structure and also Documents. We see also teh Details-Informations from Dokuments and can publish Documents without any error.

Here is all ok! But when we search with Title, Searchword, Author nothing is found in the Results.

The search bring also nothing results when we use a fulltext search in PDF Documents, we have installed Adobe iFilter and reindexed the Portal and installation.

We see in the Filestructure from our Portal that now the Files a have a resourses Extension instead of the original, older Documents have the original Extension.

We check the Database and see here also that older Files have the original extension and new Entries have the Extension .resources in the Field Entry.

Files in Folder DMX\Lucene\Index and DMX\Lucene\Temp are created when we reindex the Portal.

 

 

Used DMX Verison 4.0.1

Used DNN Version 4.5.5

Additional Effects:

• We define the Title by Objects for Language EN and DN.
• We create for a Sample a Folder and a Document
• We login with DE User and nothing is found when we search the Title
• We login with EN user and only the Folder is Found but not the Document
• We have re-index the Installation and the Portal but to better Result.
• The Fulltext-Search works not by EN or DE, we have this tested with PDFs and Text-Files, the iFilter from Adobe is installed on the System

SQL-Profiler:

We have see with the MS SQL Profiler what Select Statement is send to teh SQL Server by the Search. We have remarkt the last part of the Select to see the Result. When we execute the select on the Server directly the Result conains also only one Entry (The Folder) and not the Documents!

-----------------------------------------

SELECT

e.*, sr.Rank, CAST (CASE WHEN e.LockedUntil > GETDATE() THEN 1 ELSE 0 END AS BIT) AS IsLocked, ext.ControlToLoad, ext.Custom, ext.DownloadUrl, ext.EntryTypes, ext.Icon16, ext.Icon32, ext.IsPrivate, ext.MimeType, ext.ResourceFile, ext.SettingsControl, ext.ViewByDefault, CAST(CASE WHEN (PATINDEX('Collection',e.EntryType)>0) THEN 1 ELSE 0 END AS BIT) AS IsCollection, CASE WHEN (SELECT COUNT(*) FROM dbo.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='de-DE') >0 THEN (SELECT [Text] FROM dbo.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='de-DE') ELSE (SELECT [Text] FROM dbo.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='') END Title, CASE WHEN (SELECT COUNT(*) FROM dbo.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale='de-DE') >0 THEN (SELECT [Text] FROM dbo.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale='de-DE') ELSE (SELECT [Text] FROM dbo.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale='') END Remarks, (SELECT [Value] FROM dbo.DMX_EntryAttributes ea WHERE ea.EntryId=e.EntryId AND ea.AttributeId=1) [Geschaeftszahl], (SELECT [Value] FROM dbo.DMX_EntryAttributes ea WHERE ea.EntryId=e.EntryId AND ea.AttributeId=2) [SSR Erlass], (SELECT [Value] FROM dbo.DMX_EntryAttributes ea WHERE ea.EntryId=e.EntryId AND ea.AttributeId=3) [Ersetzt durch], (SELECT [Value] FROM dbo.DMX_EntryAttributes ea WHERE ea.EntryId=e.EntryId AND ea.AttributeId=4) [Ersatz fuer], (SELECT [Value] FROM dbo.DMX_EntryAttributes ea WHERE ea.EntryId=e.EntryId AND ea.AttributeId=5) [Gefertigt von], (SELECT [Value] FROM dbo.DMX_EntryAttributes ea WHERE ea.EntryId=e.EntryId AND ea.AttributeId=6) [ER-Nummer], (SELECT [Value] FROM dbo.DMX_EntryAttributes ea WHERE ea.EntryId=e.EntryId AND ea.AttributeId=7) [Sachgebiet], (SELECT [Value] FROM dbo.DMX_EntryAttributes ea WHERE ea.EntryId=e.EntryId AND ea.AttributeId=8) [Schultyp] FROM dbo.DMX_Entries e INNER JOIN dbo.DMX_Extensions ext ON e.EntryType=ext.ExtensionKey INNER JOIN dbo.DMX_SearchResults sr ON sr.EntryId=e.EntryId WHERE e.PortalId=0 AND ext.PortalId=0 -- AND sr.SearchId='20070923jiigfe45u3faozacpbx3jtyg'

-----------------------------------------

Please we need very important the Search Functionality!!!

Thank You!!!

 

 

 

Hi Guido,

1. Are there files in Lucene/Index? If not, do you run full or medium trust? Try full trust to see if this is the issue. I'm in pursuit of medium trust issues in Lucene (not my code).

2. If you do see files under Lucene/Index: Have you tried to open the index using Luke? What is the result?

Peter

1.Yes Index Files are created by Lucene. We have removed the files and startet a re-indexing no better result.
2.We have make Tests with luke and luke brings more results as the search from DMX4!

Additional:

But we have see that Lucene have not indexed contents from pdf files!

This Problem is very important we must go online in one week with many many peoples and need the Search Feature full functional!!!

When you need additional information inform us we send it to you when we can.

Thank You!!

View Roles after Upgrade from DMX3 to DMX4:
----------------------------------------------------------------------------------------------------
All Objects created after Upgrade to DMX 4 have in the Table DMX_Entries and the Field ViewRoles Null instead of Roles.

When we start the script Upgrade from DMX3 to DMX 4 we see followed in the Script:

00:00:52.044 - Entry 800: Abschluss von Sonderverträgen
00:00:52.044 - Setting permissions: Success
00:00:52.107 - Setting description and remarks: Success
00:00:52.107 - Entry 803:
00:00:52.107 - Entry 806:
00:00:52.107 - Entry 807:
00:00:52.107 - Entry 808:
00:00:52.107 - Entry 809:
00:00:52.107 - Entry 810:

Entries 803 to 810 created after the Upgrade and not visible in DMX-Module! When we copy the ViewRoles from other Entries to this and start the Upgrade-Script we have this result and the Objects are visible.

00:00:08.497 - Entry 800: Abschluss von Sonderverträgen
00:00:08.497 - Setting permissions: Success
00:00:08.497 - Setting description and remarks: Success
00:00:08.513 - Entry 803:
00:00:08.513 - Setting permissions: Success
00:00:08.513 - Entry 806:
00:00:08.513 - Setting permissions: Success
00:00:08.513 - Entry 807:
00:00:08.513 - Setting permissions: Success
00:00:08.528 - Entry 808:
00:00:08.528 - Setting permissions: Success
00:00:08.528 - Entry 809:
00:00:08.528 - Setting permissions: Success
00:00:08.528 - Entry 810:
00:00:08.528 - Setting permissions: Success
00:00:08.544 - Finished Running Script

The Result is the same : Search-Result is Empty

We have now verified the Effect on a seperate fresh System.

We have make followed Steps:

Config Fresh seperate Server-Hardware
Install Microsoft Windows 2003 Standard Server EN (32Bit)
Install Servicepack 2 for Windows 2003 Server
Install .Net 2.x
Install all Windows Updates.
Create a fresh Database on our seperate Microsft SQL-Server 2005 32-Bit with SP 2.0
Download DNN 4.5.5
Install DNN 4.5.5
Configure DNN Portal
Install DMX 4 in Trial Mode
Logout Host
Login as Admin
Create a Folder
Upload a Dokument
Search with Title = No Result
Search with Contents = No Result
We install DMX 4.0.1
Search with Title = No Result
Search with a Word = No Result.

The Effect is identical how on our other System!

We have now extend the test how followed.

1.Install SP 2 for .Net Framework x86 on the Websystem = No Dokument Search Results
3.Upgrade to DNN 4.6.0 = No Dokument Search Result

We use by our Searches every a word from the Title and one for Contents.

Sorry we make one search with a word from title and then a new search with a word from contents!

We have a other Portal running by our customer on the same systems and use here the Open-Search-Engine-Module was use also lucene. Open-Search-Engine from www.opendnn.com have no Problem with lucene indexing!

So we think the Problem is not alone by lucene.

Thank You

Hi Guido,
This is a different (newer) version of Lucene. I'll do what I can to get this to work for you. Can I see the site?
Peter

Currently our customer put the portal not to public access! Infom me was you need and i maked and send it to you!

 

Thank You!

Well, I cannot replicate your case. I've tried everything and search just works fine. So my only option was to dig into your installation. I cannot see any other way.
Peter

I clear this today with our customer, what access you need in detail.(Remote-Desktop to Web-Server or also Remote-Desktop to SQL-Server)?

Thank You!!!

The best is a combination of RDP and host access to DNN. I can send you a fixed IP from which I work.
Peter

Hi Peter,

one night sleeping is every a good idea so we have found the Source of all Problems and now a working Solution!

What we have make false:

We have running a DMX3 with configured "Fulltext-Search" and the Documents on a "Network-Share" <--!!!
We have make a Update to DMX4 and see not that in the Main-Options the Network-Path is removed. A other Employe have copy the Files in the DMX-Folder from the Portal because the Folder-Option in the Main-Options is after the Update set to Default (DMX). I cannot verify where is here the information to access the Network-Share instead of the local DMX-Folder when configured in the Main-Options. We must clear wy the Portal cannot access to the Network-Share as before!

How we have cleared the problem followed after a restore from DB and Portal.

We copy the Files from the Network-Share to the DMX-Folder in the Portal.
We set in DMX 3 (Document Exchange Options) the Directory to Default (DMX).
We detach the Catalog in the Document Exchange Options.
We test the Portal and Searching and see all is currently ok.
We upgrade DMX to 4.0.0 and then to 4.0.1
We start the script for Upgrade and Re-Indexing
We test the Portal and see all is ok all is found
We change in the Main-Options the Path to the Network-Share and see after a Re-Indexing nothing is found. The Share and the Documents within is the same was worket before in DMX3 but now not working.
We set the Directory in DMX4 back to Default (DMX) and see all is ok after a Re-Indexing.

I am irretated about this Effect because we have see that lucene create files and indexes so we have think all is ok but this is very false!

The other part was irretated us that DMX4 access in the Background to the Network-Share after the Update to DMX4 when set in the Main-Options Default (DMX) Directory.


But now works and we have learned many many in the last 2 Days!!!

Thank you Peter!

Hi Guido,

I'm happy you found the root of the problem. I'll have another look at the persistence of the 'repository' setting.

Note that permission to access to a network share is not governed by DMX but by the sys admin. The worker process needs to have full access, and this can be tricky. Especially since with each Windows update doors are shut for security reasons. Keeping network access in .NET apps constant is a real challenge for system administrators. There is no reason why DMX 4 should not work through a network share.

On another note: the indexer needs to find the documents to index them. This goes for Lucene as well. So if the repository is not correctly set, then the index process will not return the right results.

Sorry for all your irritations. I guess the conclusion of this ticket would be: check the repository location.

Peter

We are also very happy!

What you think is the best solution to work with a central share when we used in future a webfarm by our customer? SAN-Storage?

Thank You!

I couldn't say. But it sounds like a logical choice. I don't have a webfarm myself, so you're going to have to play around with it.
Peter