La version de Nexus 2.07 a permis de résoudre plusieurs problèmes, mais l'on a pu observer que si une table était abimée mais néanmoins fonctionnelle sous 2.05, vous devez effectuer une réparation pour ne poser aucun problème avec le Nexus 2.07 qui est plus rigoureux.
Cette réparation doit se faire plateau coupé, vous devez donc éteindre toutes les applications ABM2000 et le NexusDB 2.07
A la suite de cette opération, télécharger le >> Nexus Recover << et le désarchiver dans le répertoire où sont stockées vos tables.
Ouvrer ensuite votre dossier qui contient vos tables (dans notre exemple c:\abmdata) et double cliquer sur le fichier de commande: NXBatchRecover.bat
Il va reconstruire toutes vos tables une par une, ne faite rien pendant cette opération.
A la fin de cette opération, vous aller avoir ce message:
Nous exploitons actuellement la version 2.05 de Nexus.
Vous indiquez que "la version 2.07 a permis de résoudre plusieurs problèmes" sans apporter plus de détails. Le problème de perte de données consécutif à une corruption inopinée de tables dont nous avons souffert en janvier dernier - et dont la cause n'a pas été établie - fait-il partie des "problèmes" corrigés dans cette version ?
Plus généralement, peut-on savoir exactement ce qu'apporte cette version, en terme de nouvelles fonctions, de modifications d'interface ou de formats, de corrections d'anomalies ?
Par ailleurs, si vous estimez que cette mise à jour s'avère utile, que doit-on faire pour se la procurer et quel serait le mode opératoire d'installation/migration ? On peut en effet imaginer que vous ne prendriez pas la peine de rédiger ce fil si au moins UN de vos clients n'était pas concerné...
Merci d'avance pour ces informations, qui nous semblent aussi utiles pour la base de données que pour les autres modules ABM (voir notamment le fil http://public.abm2000.com/viewtopic.php?p=445).
Il s'agit d'une nouvelle version de la base de données et non d'ABM. Cela n'apporte donc aucune nouvelle fonctionnalité. La différence entre ces 2 serveurs est disponible sur leur site: http://www.nexusdb.com/
Cette mise à jour a été mise en place sur les sites qui avaient un retard sur leur mise à jour.
Pour la mettre en place, vous devez quiter tous les applicatifs ABM2000 y compris le NexusDB puis remplacer l'exécutable NexusDB par celui ci:
NexusDB étant une application serveur, elle n'a pas vocation a ajouter de fonctionnalité pour l'utilisateur. Néamoins, pour être précis, voici la liste des modifications apportées. Cette liste est livrée brute et ne fera pas l'objet de commentaire de notre part.
800 If explorer.exe crashes, tray icons should be recreated
2470 FULL JOIN returns non-matching rows
2472 Query throws stringlist out of bounds error
2473 I just bought NexusDB for replacing some FlashFiler applications. Conversion went OK except some SQL queries that do not work...
2475 Event log Max Size not persistant
2476 Attempting to create index on non-existing field throws AV
2479 Chess Script throws AV when executing
2480 Query wrongly returns empty resultset
2481 Swapping WHERE clause parts around throws assertion
2483 AV is thrown when attempting to open table in latest code
2484 SetRange on Seq Index with invalid strings cancels range
2485 Problem with NONSTRICTASSIGNMENT option in comparison of parameters
2486 Memory leak in nxsqlCondExp
2488 Incorrect overflow check for BCD values
2443 Adding blob to table slows down query with 2 orders of magnitude
2449 Repeatedly running live query throws unexpected exception
2451 Query without obligatory aliased table expression returns 1 record instead of raising error
2452 Meta query throws roottable unknown... not found
2454 Incorrect Unable to resolve the identifier message
2455 Widechar field returns ever changing data
2456 SELECT distinct table_name FROM #indexes AV's
2457 Compilation error in nxptTCPRequestTransport (.NET Provider support file)
2458 Fix D2007 Help installation startup page issues
2460 Missing UPPER() parameter causes AV
2461 Importing csv into word-type fields fails on negative integers
2462 Query throws AV in engine after division by 0 error is thrown
2463 Check for grouped selection list items is faulty
2464 Sharedmem transport does not work with win9x
2465 Query throws unknown exception in state of "capability not supported"
2466 Server writes config file although AutoSave is off
2467 LIKE '...%' causes range check error when Request Live is True
2471 Root table not found with INSERT INTO and temp tables
1953 Installer should use Borlands predefined localized path to store BPL files in non-Enghlish Delphi versions
1987 TnxQuery.RecordCount returns wrong value for filtered query
2046 Prepared stored proc always returns the same value
2048 Constraint name uniqueness should be enforced
2052 The service should not allow itself to start if the server is already running from the same directory
2110 Assert in SQL engine when cleaning up after client heartbeatfailure
2170 Function returning TABLE should require TABLE in FROM clause
2208 Add rename table, rename column and changecolumn type to sql
2216 Error message when attempting to access deleted blob could be improved (Exprected BlockOwnerID ...)
2229 Function returning TABLE cant be used as a
2312 Autosave on Exit setting can't be turned off
2318 Bug when comparing blank, non-localized strings
2319 Stored procedure throws assertion
2320 Stored proc returns no records
2321 Server cannot start as service when explicitly started from commmand line
2323 Temporary table is not removed when query execution stops on error
2324 Unable to resolve identifier in aliased table expression created with UNION
2325 Refreshing table inside transaction throws Block 0 has not the correct signature error
2326 SELECT ... IN (SELECT ...) does not return records
2327 Problem with IN and local variable
2328 Problem with IN workaround in stored procedure
2329 Problem with left join in stored proc only returning data for first record
2330 Problem resolving tablename in join
2331 Left Join returns null for some values when used inside stored procedure
2332 WHERE field LIKE 'Y023 %' does not find matching records where matching records exist
2333 Using multiple EXISTS in the WHERE clause fails with factor not found
2334 nxServer /HELP only shows /NOICON info
2335 Inconsistent line/pos error position values returned
2336 SELECT field, SUM()... without GROUP BY should throw error
2337 Engine does not delete blob contents from table (table size keeps growing when adding and clearing blob)
2338 Select field from v1 table with RequestLive = true throws AV
2339 Investigate massive slowdown with joins
2340 Shared memory transport throws "access denied" exception when used under Windows Vista
2343 Improve "alias does not exist" message with aliasname
2344 SELECT rightjoinalias.*, * From .. throws AV
2345 Problem with DWORD values
2346 Swapping WHERE clause parts around returns different resultsets
2347 Query returns no records where matching records exist
2348 TnxSqlRowBuilder.ApplyFilterRange seriously broken
2349 TnxSqlSELECT.NormalQueryResult frees unititialized variable FieldDefList
2350 ORDER BY orders on the wrong column
2351 Northwind example script fails to run
2352 Problem with IN and #temporary table
2353 Problem with IN and repeated list value causing multiple copies of rows to be returned
2354 CONTAINS(non-fulltext-index,...) should throw error
2355 Query throws integer overflow error
2356 Invalid column reference not caught
2357 Query in trigger throws scalar subquery expected error
2358 UPPER() does not take table locale into consideration
2360 UPDATE query throws "Expected BlockOwnerID ..." error on temp table
2362 Typing something other than a number in the MaxRam field throws AV
2363 Using RETURN in stored procedure should produce sensible error message
2364 Query with ORDER BY...DESC does not correctly order the resultset
2365 Meta table caching problem
2367 Problem resolving identifier in correlated subquery
2368 Query throws AV on freeing function reference
2369 Query on CHAR() variable in SELECT list gives "could not convert variant ..." eror
2372 Query returning more than one column should not be allowed in calculations
2373 Query throws "error in addindex list: unknown column..."
2374 Query is slow/never times out (timeout = 10 sec)
2375 Add option to session to direct server to use specific client locale for string constants in SQL
2376 ToString should allow for longer input than 256 characters
2377 Query triggers assertion in nxSqlProxies.pas
2379 Query throws assertion; result unable to resolve identifier
2380 Nonexisting column name should throw error
2382 mapping empty string to blob can cause corruption
2383 MIN/MAX on nonpadded nullstrings should not return padded strings
2384 Query takes a long time and eats up memory
2385 SELECT LIST(field) FROM TABLE does not throw error on non-charachter fields
2387 TnxTable.AddIndexEx updates datadictionary even if operation fails
2388 Server does not Apply new settings but reverts to old
2389 GROUP BY on date/time fields from memorytable return strange values
2393 Query throws AV in engine
2394 Extra asterisks in comment specifier results in syntax error
2395 Query throws range check error
2396 Add support for unicode special characters (NCHR function?)
2397 SELECT ... DISTINCT ... returns NULL date fields
2398 Incorrect Union Result
2399 Large object columns not allowed in grouping operations
2400 Query throws integer overflow
2402 Query never stops executing
2403 Client method to fetch list of users (sessions) logged in
2406 Query throws integer overflow
2408 Heap engine sometimes corrupts blobs or variable size records
2410 Table with SQL filter created pre-localization switch code can't be opened with new server
2411 Multiple EXTRACT() calls combined with AND returns too many records
2412 TIME/TIMESTAMP assignment issues
2413 Engine should not assume any indexes exist (AV occurs if no indexes exists)
2414 Query throws "field out of range" error
2415 Turning on transport compression would fail at design-time with lost connection
2416 Assert may trigger erroneously
2417 Ambiguous error displays blank table/alias name
2418 Column binding error
2420 New client-side selected locale does not work for parameters
2421 Remove #0 from Client IP log entry
2423 If started twice from the same folder, nxServer now shows error dialog twice
2424 Range error thrown with this query
2425 Server should not save files under Program Files directory under Windows Vista
2426 Server Mutex should be created with an "all access"DACL
2427 Query throws AVs internally (they are handled but should not occur in the first place)
2430 Query erroneously throws ambiguous column error
2431 Dropping table erroneously throws "referred to from another table" error
2432 Stored procedure throws AV
2433 Using live queries could lead to AVs in the engine
2434 Server does not correctly remember windowposition between restarts
2435 When FreeFieldBuffers fails (e.g. timeout) inside Post the dataset remains in dsInsert and the same record can be posted again, possibly leading to multiple records referencing the same blob.
2436 TnxBaseSessionPool.bspTimeout not initialized
2439 Blobfield.IsNull returns wrong value after Post
2440 Query timeouts cause AVs
2441 Query throws AV
2443 Adding blob to table slows down query with 2 orders of magnitude
2444 Other AV in SQL engine on Win98
2445 Opening table with child table throws assertion
2447 Parser doesn't recognize "national character large object" and "nchar large object" anymore
2448 INNER join USING is broken
1556 Problem with passed in proc parameter using INOUT/OUT
2193 Problem with outer reference in HAVING clause
2195 Aggregate functions in the WHERE clause
2241 CONTAINS... used with ORDER BY does not correctly order
2259 Delimited identifiers resolved wrong in VIEWS
2261 Server not working in Win98
2268 Wrong query evaluation
2283 Script with large numbers of INSERT statements runs very slowly
2285 UPPER comparison with national characters fail
2301 Char() type variable and cast does not return correct length
2303 Engine should not try to optimize field comparisons using an index when there is no global- or field-level locale defined
2304 Query with DISTINCT causes AV
2305 Double CAST on datetime returns integer
2307 SELECT *, a.blob from ablob a with requestlive = true throws errors
2308 Converting v1 table to v2 and then restructuring throws invalid property value error
2309 Query throws invalid floating point operation error
2310 Query wrongly throws "unable to resolve" error on alias used only in valid table expression
2311 OPTION function wrongly returns char(6)
2313 IN (NULL, ...) fails
2314 IN (CAST(NULL as [var]char()))... fails
2315 TnxSqlRowBuilder.SetSortedState does not take ReadReversed into account
2317 Joins unnecessarily copy blobs under certain circumstances
2169 Problem with qualified * in while blocks
2179 Query returns "index does not exist" instead of correctly returning timeout error
2199 Unable to resolve identifier in multijoin
2207 Query returns spurious extra characters in stringfields with MBCS data
2211 Problem with preparing queries
2226 GROUP BY columns return NULL for query on large table
2233 Problem resolving qualifier in stored procedure
2252 Performance regression with sudoku query
2255 Unable to resolve identiedier with select t1.*, t2.* ...
2257 Table lookup is Case sensitive in certain circumstances
2258 unable to resolve the identifier with left joins
2262 Slow Query - Optimizer problem
2263 Invalid Cast in View
2265 Field after * stays empty with distinct
2266 Table_Type set wrong for local temporary tables
2267 Equivalent joins return different results
2269 Non-scalar subquery in the select list
2270 Subquery in the select list returns null in grouped query
2271 Dependency check bugs
2272 Engine throws No explicit transaction in progress error
2273 Method parameter name matching reserved word should throw error
2274 Delimited parameter name should not be interpreted as reserved word
2275 Trigger returns wrong result the 2nd time it is called
2276 Statement makes server process disappear
2277 Cross database insert query does not insert data
2278 Invalid syntax not caught in insert
2279 Problem resolving column
2282 Query uses excessive amounts of RAM
2284 #Fields.Field_DefaultValue returns nonstandard values
2286 SELECT should not attempt to return and resolve columns removed with USING
2287 Multiple "Select Distinct" throws AV
2288 DISTINCT returns NULL for field with value
2289 Error message should include tablename
2290 Query throws Invalid index descriptor error
2291 Group By returns wrong value
2293 Setting default value on char,widechar,formatted bcd throws error
2294 Trigger updating 2nd table causes AV
2295 Parsing should throw error on missing default columntype specifiers and wrong default value formats
2296 IN (subquery) should throw error on multi-column subquery regardless of prescence of index
2297 Trigger causes AV on 2nd delete from table
2298 Error should be thrown on subquery column not in group by
2302 Trying to open the MasterFields link dialog on a password-protected table throws error even though password is present in Password property
1411 Engine should use correct TargetCursorDescriptor for RI links depending on type of link
1563 Engine needs to evaluate passed in parameter types
2227 Regression: Fix for 2201 causes AV at shutdown
2237 Where clause without parentheses in stored proc does not return all records
2243 CREATE TABLE ... LIKE fails with AV across different databases
2248 IN does not correctly check for datatype match
2249 Error should be thrown on use of column from second table inside table expression
2250 CROSS join returns NULL for 2nd table expression columns
2253 Regression in cross database queries
2256 Range check error in left join with double
2197 Problem resolving JOIN alias in stored procedure / AV
2206 Uncorrelated IN subquery returns wrong number of records
2213 Query on #functions does not return data for all rows
2214 DROPping table should fail if there are password-protected tables present and the passwords have not been added to the session's password list
2219 LEFT JOIN does not return data for joined table
2220 Missing ORDER BY column does not throw error
2222 Meta query does not return rows when aliased
2224 Query should fail on LIKE '..' OR '...' OR ...
2225 AV when calling function and passing in select result
2228 SELECT DISTINCT...WHERE field IS NULL returns non-NULL records
2231 TOP n with ORDER BY returns all records
2232 SELECT...INTO should be allowed in function routine body
2235 Old-style join with where clause returns no records
2236 Left outer join ... on upper(s) = upper(s) fails to return records
2238 CREATE TABLE wrongly throws "multiple unique constraints defined..." error
2240 Improve "index does not exist" error with indexname
2242 ORDER BY 2 with requestlive = true causes AV
2244 Wrong number of columns in INSERT INTO...() SELECT ... could throw better error message than "list index out of bounds"
2245 Shortstring to shortstring field transformation fails
2246 Remove SQL parameter name 20 char length limitation
1069 Add fulltext syntax to parser
1896 Simple fulltext demo should not require XML file or XML Partner
1926 Setting memo fields to '' (empty string) should be allowed and autoconvert value to NULL
1944 Engine should allow assigning empty string to blob memo (translate to NULL)
1963 Message on key violation could be improved with table and indexname
1982 Show query log even when error stops query processing
2007 Query triggers EVariantBadVarTypeError on Windows 2000
2050 Setting BlockReadSize back to 0 does not do a proper resync (IsEmpty returns True)
2176 Table with RecNo support on should not throw Record/Key deleted errors for records deleted by others when fetching RecNo
2190 Server does not free all cursors etc when connection is lost (record can still remain locked)
2205 Adding index that would require blocksize to be increased should return proper error message instead of "dictionary is readonly"
2209 Query throws range check error
2210 alter table Table1 drop constraint "" deletes first index
2212 Order by on out of range column number causes AV
2217 Query throws BCD overflow
2218 Query errs with "could not convert olestr to type double"
2221 Setup issue of BDS2006 DCU edition
2039 Parser error with bracketed joins
2168 Ambiguous column reference not raised
2173 Ambiguous column problems with natural join
2175 Stored procedure with ATOMIC which mixes DDL and DML should trigger appropriate error
2180 Query does not return data for grouped column
2188 Query throws list index out of bounds
2191 Problem with column from aliased outer table not in scope in subquery
2196 Select max(field) should take advantage of index on field
2200 Function should return NULL and not False
2201 Query across databases throws AV
2202 Can't resolve variables in subselects
2040 Trigger should not cache query result between executions
2135 Slow left join with where clause
2140 Wrong column naming in join
2150 Assertion in TnxModifiedBlock.DecreaseTransLevel during recoverrecords
2157 Wrong error position returned
2160 Wrong error position returned
2165 Natural join should not throw unknown column error on unqualified use of joined column
2171 View with wrong number of parameters should throw better error than "list index out of bounds"
2172 Wrong column type from COALESCE
2173 Ambiguous column problems with natural join
2178 Aggregate query throws operation aborted error message
2181 Unable to resolve qualified identifiers in mutliple joins
2182 Query should not attempt to resolve using() columns in "select table.* ..."
2183 Query with parentheses should trigger error on division by 0
2184 Hello Nexus-Support....
2185 Display variant keyfield column when viewing fulltext index in tablebrowser
2186 Column1 / (Column2) gives multiplied result instead of division
2189 Trigger causes access violation
2194 Multiway outer join is broken
1522 ORDER BY used in UNION query expression should be detected as an error
1565 UNION gives list index out of bounds without parentheses
1572 Problem comparing CHAR types, trailing spaces should not be used for comparison
1929 AV when creating mappingcursor
2153 Query raises abstract error
2155 GROUP BY without aggregate should throw error
2174 Query throws "no user transaction is currently in progress"
2160 Wrong error position returned
2177 Adding records to live resultset duplicates data from previous record
1582 Speed issues in views
1684 AV when attempting snapshot trans and read-write trans is active
1876 Query should throw "unknown column" error
1912 Query throws AV on missing tables
2026 Quantified Comparison Predicate problems
2080 RESTRICT drop behavior (dependency check) is not enforced when dropping a routine
2128 Posting records on table with trigger throws AV
2129 Updating table with triggers throws AV
2142 COUNT should return BIGINT, not DOUBLE PRECISION
2151 Hash join speed regression
2154 BCD overflow in BDS2006
2156 Error message could be improved on unknown order by identifier
2158 Check if errorposition can be returned for this type of query
2159 Query erroneously complains about qualified field in USING
2161 Nullstring string conversions failed for fields longer than 255 chars during restructure
2162 Query slowdown regression in 2.0594
2163 Single-column inner query should not throw "single-column query expected" error when order by is used
2164 Calling function with top/order by throws "order by in union not supported" error message
2166 order by and top in functions trigger av
2167 Query wrongly returns "Single-column query expected"
1912 Query throws AV on missing tables
1949 SELECT function(..)... gives AV
2008 Timeout not checked during LIKE processing
2014 Previous page is not hidden in restructure window
2140 Wrong column naming in join
2142 COUNT should return BIGINT, not DOUBLE PRECISION
2143 Left Outer Join slowness in 2.0593
2144 Query fails to return records
2145 Field NOT IN (Select...) returns wrong result
2146 Query with NOT EXISTS() throws AV
2147 Where used with Group by returns no records
2148 Query with ORDER BY 2 throws AV
2152 Cursor stays open after ExecSQL due to Unprepare not called autmatically.
1663 Old-style cartesian join returns fields in wrong order
1925 Column order incorrect in cross product query
2081 RESTRICT drop behavior (dependency check) is not enforced when dropping a table
2082 RESTRICT drop behavior (dependency check) is not enforced when dropping a view
2112 Result sets have incorrect column order
2130 Cannot drop table with same name as tablealias used in trigger
2132 Invalid-Pointer-Exception using MemoryManager V3.04 - see "Steps to reproduce"
2133 HAVING is not evaluated
2134 Referencing same column twice in group by gives "stringlist does not allow duplicates"
2136 Natural/Using join issues
2137 regression issue grouping/having
2138 Query generates AV.
2139 Index already exists [$272B/10027] [$272B/10027]
2140 Wrong column naming in join
2141 Unable to resolve qualified column in where clause
1875 UNION should not require parentheses around the
1902 UNION gives column number mismatch error
1904 Problem evaluating variable in loop
1907 Function should not throw type mismatch between RETURN and RETURNS
1927 Make column renaming consistent
1941 SQL filter on table throws AVs internally
1962 Ambiguous column error should not be raised
1968 Query slowdown regression
1971 Error should be raised on unknown table alias in inner table scope
2029 Grouping does not return all needed values
2083 RESTRICT drop behavior (dependency check) is not enforced when dropping a column
2114 Natural join does not return expected row
2115 Natural join returns wrong data types for common columns
2116 Natural join should throw error on qualified common column in where clause
2124 AV when accessing qualified database
2131 Group By broken!
1250 Predicates in SELECT should not require parenthesis around them
1263 Optimize joins
1766 Query should throw syntax error on wrong ON part
1800 Slow IN predicate
1803 Implement String types to String types / BlobMemo types data conversion
1877 ORDER BY should trigger exception on nonexisting column
1891 Parameters used in "Create Table as ..." leads to type mismatch error
1905 WHERE clause could optmize the join further
1927 Make column renaming consistent
1942 SELECT ... WHERE IN (SELECT ...) could be optimized for live queries
1955 Recursive function that returns table throws AV
1956 Review transaction fixes
1965 Check if old-style join can be optimized for this query
1969 Query gives list index out of bounds
1970 Query gives string list does not allow duplicates
1973 Join on #meta tables takes forever and all RAM
1974 Join on Procedure/Procedure_arguments meta tables returns joins of all records regardless of join match
1975 Performance could be better on simple selects
1976 Problem with GUID comparison in stored procedure
1977 Prepared query does not change if parameter value changes
1978 Problem compiling nxSqlCondExp with BCB6
1979 Error message correction
1980 TnxStoredProc with params causes AV in server
1984 Query throws list index out of bounds error
1986 Use recordcount estimates to decide on driving table for joins
1988 AllocatedBytes gives wrong result under BCB6/BDS 2006
1992 Calling First after setting BlockReadSize should not cancel an active range
1993 If $DEFINE SecureServer in nxDefine.inc is undefined, the server does not compile
1998 INSERT in SQL throws AV in Delphi 5
1999 Meta Query causes AV
2000 Running query twice causes AV
2006 Invalid field name character """ triggered
2009 Ability to cancel live backup/restore
2010 Stored procedure adding foreign keys fails to execute
2011 DISTINCT does not return distinct rows
2016 Select a.*... returns NULL for all fields
2018 NexusDB: Block number is out of range (EnxCachedHeapEngineException)
2022 IN subquery taking very long
2025 TRIM issues
2029 Grouping does not return all needed values
2030 Null values not returned if "no nulls" index exists
2032 Tablename should be readonly on restructure
2033 V2 slowdown of query
2037 Column name in ORDER BY not recognized
2038 SELECT TOP ... ORDER BY returns no records
2041 Client does not receive proper error message
2043 Join columns should require table qualifiers
2044 Table with variable record engine fails to recover the whole table
2045 Date/time functions should be evaluated once per statement, not per script
2046 Prepared stored proc always returns the same value
2047 Join should give proper error when expression is not boolean
2049 Query could give "you need to roll back this transaction" error when no explicit transaction was started
2051 Aggregate query with simple fields last in SELECT list should trigger error
2053 TOSTRING should return Ansi format strings for date/time fields
2055 Comparison with negative number on DWord column should not fail
2056 ELSEIF causes AV
2057 Query with ambiguous column names should raise error
2060 Meta query gives "could not convert variant..." error
2061 EXISTS is much slower in 2.05 than in 2.02
2062 DROPping a number of indexes in the same script throws AV
2063 Order By n... should show sensible error if n is larger than columncount
2065 TnxStoredProc triggering AV when the proc returns a row set
2066 Range check error with inner join and negative values
2067 Timeout handling could cause integer overflow error
2068 Int64 not handled properly
2069 IN Query takes forever to run
2070 Slow join execution
2071 IN clause in constraint not working correctly
2072 Implicit columns in REFERENCES not working to standard
2074 Tablebrowser should reset the flip order flag when opening
2075 Function returning Table throws AV
2077 Indexed and aliased column should find an index match during query processing
2079 IN (subselect) erroneously matches all records
2084 Update statement with SELECT...ORDER BY should throw error and update the correct record
2085 DELETE query does not check timeout
2086 Query throws "could not convert variant of type olestr into type double" when comparisons are on string fields
2087 Adding fulltext index with invalid ident characters fails
2088 Lower and Upper fulltext index checkbox states are not saved
2089 Query throws "error in AddIndex list. unknown column:..."
2090 DECLARE...DEFAULT does not set the default variable value
2091 Message when attempting to drop column used by unique constraint should say constraint, not index
2092 Expression/Func filters were not nulled when closing dataset
2093 Dropping procedure throws wrong dependency error message
2094 nxParamToSqlParamDesc function fails with a NULL ftWideString
2095 BlobMemo/BlobWideMemo fields in table/querybrowser should only save data back if they were modified
2096 Add check/uncheck all buttons to backup window
2098 Investigate Knowall queries slowdown regression
2099 Query cant resolve table.field identifier in where clause
2100 Installer should use win32 executable to unzip downloads (dos exe fails on win64)
2102 Deleting or renaming database throws "invalid class typecast"
2103 Changes to accomodate SQL filters result in all queries run from EM throwing AV
2104 ORDER BY throws unknown column exception on single aggregate column
2106 AV in SQL engine
2107 Support creation of conditional (filtered) indexes
2108 CASE statement in SELECT returns NULL instead of correct data
2109 AV in SQL query on empty table
2111 Engine should throw error on attempt to GROUP BY expression column
2113 Query throws invalid pointer operation
2117 Query returns inconsistently named columns
2118 Slow outer join
2119 Order by desc not properly applied in subquery
2120 Query throws "Error in AddIndex list Unknown column" error
2121 Problems inserting and comparing with chr() function
2122 Unckecking fields in fulltext index fieldlist throws name not unique error
2123 ORD does not return the expected values
2125 Error position in SQL statement is incorrectly calculated if running selected text
2126 Add index operation on server with low MaxRam setting terminates prematurely without error, losing records
2127 Update on Int64 column with Case throws type mismatch error
Est-ce que l'installation de la version 2704701NX comprend la MAJ de la BDD en 2.07 ou est-ce qu'il faut le faire en plus ?
Si oui, est-il obligatoire de passer l'outil NxRecover également ?
Merci de votre réponse rapide !
Est-ce que c'est en Prod quelque part ? et depuis combien de temps ?
Parce qu'un fois les tables reconstruites, je me doute qu'il n'y a pas de retour arrière possible...
Bonjour,
Suite à des problèmes rencontrés sur les agendas j'envisage, sous les conseils d'antonio, de faire un nxrecover sur ma base.
Ma base nexus a pour version 2.05.
Puis je malgré tout faire ce nxrecover et la version téléchargé sur le forum est elle la bonne version pour ma version nexus.
Pour info quand j'ai passé cet utilitaire en test sur une copie de mon répertoire Data, ça a duré 1h40 et ça a généré des tas de fichiers Recovered.nx1 Recovered_Recovered.nx1 et plus inquiétant Recovered_Failed.nx1
Mais Antonio m'a dit que c'était tout à fait normal.[/img]
Les recover sont assez long, provoyez au minimum 1h.
Les fichiers générés à la suite de ce recover sont de type MaTable_Backup_année_mois_jour_heure_minute_seconde.nx1
Un autre fichier nommé nxRecoverEvent.log est lui aussi généré, comportant l'historique de la réparation.
En ce qui concerne les autres type de fichiers le recover n'à pas être pas reussi la totalité des tables, il faut voir précisement quelles tables et la raison. En tout cas cela n'affecte pas les tables abm.
Avez vous bien fermer toutes les applications ainsi que le Nexus avant de commencer?
A l'aide de l'explorateur de base de données (NxEnterpriseManager) qu'avez vous dans ces tables?
