This error is usually due to a User Query (in list window, menu select).

Short term solution: Select the Standard Query.

Long term solution: Check that the order field is in the displayed fields

1. Error:E090: 23000 [Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: No primary key value for foreign key ’Product’ in table ’Dyelot_ColorRecipe_Line’ STMT:insert into Dyel
2. Exception EDBE Engine Error Invalid string or buffer length. You use a Sybase engine (not Sybase Server/Client) and no user is defined in BDE Administrator
3. Error BDE: Database not connected. General SQL error. [Sybase][ODBC driver][Adaptive Server Anywhere] Syntax error or access violation: Request to start/stop database
4. Key violation! Sybase ODBCDriver Adaptive server Anywhere Integrity constraint violation. Column ’Prodctrloperation_Id’ in table general sql error ’combprocess_treat_oper_crtloperlist’ cannot be null
5. Error: Start_IP.exe - Entry Point Not Found. The procedure entry point @Udmitmsecurity ... could not be located in the dynamic link library ITM_DBCommUnit.bpl.
6. Error 3070 when reading Black Trap
7. When I start Sybase server, I get the following error message: I/O error Fatal error: Unknown device error -- transaction rolled back
8. How do I create and use a palette in Lab Paintmaker?
9. General SQL error. Sybase ODBC Driver Adaptive Server Anywhere Syntax error or access violation: Commit/Rollback not allowed within atomic operation
10. How to load Chroma-Calc under DOS or Windows
11. Error BC453RTL.DLL. Floating Point Invalid
12. Hardware Problem or No security key Found
13. Error: Start_IP.exe - Entry Point Not Found. The procedure entry point @Easysize@initialization$qqrv could not be located in the dynamic link library ITM_DataAccess.bpl.
14. Running Color Tools 1.3r3 or 1.3r4 on a Windows NT can cause error message : “Newlocale.dll not found.”
15. Unable to open file USERS.BTR
16. Cannot load BPROP20.DLL
17. When doing support over modem with pcAnywhere and opening Sybase central 4.0, Sybase central windows don’t refresh properly.
18. I am getting Paradox errors, when trying to retrieve a sample from my database, in ColorTools.
19. The dyelot generation does not match with the combined process. Why?
20. Problem in correction options in DM PPI. When the customer try to put all the add in zero, and these numbers not changed!.
21. Error message = Please connect or reset your instrument !
22. When I am waiting for a generation preview, I get the error message: Exception violation ... in module RBRCL66.bpl ...
23. Error BC520RTL.DLL
24. How can I print a RGB color?
25. SQL Error : Integrity Constraint violation : column "NoOfWeights" in table "DyeLot_Bulked Recipe_Out" can’t be NULL
26. What is ResetRegistry ?
27. E099 Invalid floating point operation
28. Error: PDOXUSRS.NET when creating a new record
29. When I create a new dyelot, I get the error message Index does not exist !.
30. No match found!
31. The following message coming when the customer try to store the formula in the formula input : DCPPI provocó un fallo de protección general en el módulo MFC250.DLL de 0001:00001866 .
32. Unable to read white tile data ! White tile data failed !
33. Units kg/l (liquor ratio) and °C/min don’t appear in the pop up menu of the ITMRegistry. Why ?
34. I am using ColorTools with one instrument, how can I add a second spectrophotometer
35. Error AfxthrowDCIDBE Exception
36. How do I edit PFs in Lab Paintmaker?
37. Error messages while running DM 1.7.2 or earlier Formula Input, after storing the amounts,etc, then hitting save and the message shown is : "No valid Illum/Obs information. Please check your setu
38. After weighing products: Error Message: SQL Error: General Error: SELECT returns more than one row.
39. Floating-point : divided by 0!
40. I have defined a query in table DYELOT but it doesn’t work (empty result).
41. I have done a user query in Dyelots but the result is always empty. Why?
42. Units kg/l (liquor ratio) and °C/min do not appear in the pop up menu of ITM Registry | System settings | Prod unit. Why?
43. Unable to generate a dyelot or to customize a production form
44. We cannot delete one auxiliary. It will shown the error message: Delete not allowed! Auxiliaries : ARO-BLN--> 1 Inventory Operations ... We have checked all stock operations but none uses it. I get
45. How can I test the alphanumeric value of a parameter?
46. When I start ITMRegistry, I get the error message:ExceptionEDBEEngine Error Invalid string or buffer length
47. Green tile fail in DM PPI
48. Temporary files appear on the desktop during ITMProcess utilisation.
49. Floating-point : invalid.
50. I have loaded an ITMProcess expert level certificate but my ITMProcess is still in entry level
51. Some dyelots appear twice in SmartWeigh.
52. The calculation of OperTotTime does not work properly. It doesn’t calculate the time for heating or cooling.
53. When starting SmartWeigh3 Setup, I get the message: Data source name not found and no default driver specified
54. The calculation of OperTotTime does not work properly. It doesn’t calculate the time for heating or cooling.
55. When I have done additions or corrections, how can I test the original recipe in a formula? Use of KuseOrigConc and KuseOldConc
56. How to use the minimum and maximum fields of parameter or products records?
57. SmartWeigh does not display the same number of decimals than ITMProcess. Why?
58. Data location not found in DCIGLOB.INI
59. The sofware can not calculate the right cost in matching
60. A column / field is missing in one ITMProcess window. On the other workstations, it is visible.
61. When generating a dyelot, I get the following error: Constraint violation: Column Amount Reserved in table Products cannot be null