Dossier exception !!! please help me !!!

[ng-first]

hi all !!!

does anyone help me to solve the problem I paste below?
When Model Manager starts, it give me the following error:

Error Messages =
33027 - *** ERRORE: Nome di ricerca 'Fascicoli personali$WM_SAVED_QUERY' non valido

com.osm.exception.WMException: *** ERRORE: Nome di ricerca 'Fascicoli personali$WM_SAVED_QUERY' non valido
at com.osm.exception.WMExceptionFactory.createExceptionForCode(Unknown Source)
at com.osm.exception.WMException.createExceptionFromJNI(Unknown Source)
at com.osm.biz.pdm._query_desc_for_name(Native Method)
at com.osm.biz.pdm.query_desc_for_name(Unknown Source)
at com.osm.biz.WMSession.openQuery(Unknown Source)
at com.osm.biz.WMSession.openQuery(Unknown Source)
at com.osm.biz.WMQueryFile.initializeQuery(Unknown Source)

....

as result, i can't work with Dossier.

thank you all,
nadia

[ng-first]

ops ... for dossier I mean packet ...

[mgb]

Take a look at the queries saved on your system. On an English system:
C:\Documents and Settings\mgb\Application Data\CoCreate\Model Manager\15.50\queries
You may be able to locate the bad query and repair it. Typically you would also have to check the query back into the database using the Classic client.

[alexniccoli]

Hi ng
Do you see this error after a database schema upgrade (for example from 14.00B to 15.50B)?
I had some problem similar after an upgrade.
In this case i can tell you how repair.

Alessandro

[ng-first]

Hi all.
Read what a collegue says to me:

"
Please do a count of the physical files in this directory (right click properties) and compare with the count of wm_files and related_files, I.e. in SQL
SELECT count(*)
From wm_files;
&
SELECT count(*)
From wm_related_files;
If the two added together are different to the number of files in the storage are, you have a problem!
"

... I have not yed do this check .... I'm afraid to do it ;-) !!!

By,
Nadia

[mgb]

Hi Nadia,
What your colleague said may be correct but is unrelated to the problem you are inquiring about.
With regard to your colleague's comments:
1) If the file count is greater than the count from the database, that implies that some files which should have been deleted were not, or that duplicate files were stored by the file server. You would notice this problem if the disc seems to fill faster than expected.
2) If the file count is less than the count from the database, some process has removed files which need to be restored from backup. You will know this is a problem if the file server reports that it cannot find a requested file.

As you have not reported either problem you should try to resolve the query issue.

[ng-first]

Hi all,

I have this problem after a migration from OSM 14 to OSM 15.
Ale, can you tell me how you solve this problem?

thanks to all,
Nadia

[alexniccoli]

Hi Ng
Can you tell me result of this query?
select * from WM_LOCAL_LANGUAGE where LANG_INDEX=-6;

Alessandro

[ng-first]

Hi all,

Alex I tryed the sql statement you suggest me, but nothing is returned ... The query returned zero row.

Any other suggests?

By,
Nadia