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. 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.
5. 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
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. General SQL error. Sybase ODBC Driver Adaptive Server Anywhere Syntax error or access violation: Commit/Rollback not allowed within atomic operation
9. Error BC453RTL.DLL. Floating Point Invalid
10. How to load Chroma-Calc under DOS or Windows
11. 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.
12. Running Color Tools 1.3r3 or 1.3r4 on a Windows NT can cause error message : “Newlocale.dll not found.”
13. Hardware Problem or No security key Found
14. Unable to open file USERS.BTR
15. Cannot load BPROP20.DLL
16. The dyelot generation does not match with the combined process. Why?
17. When doing support over modem with pcAnywhere and opening Sybase central 4.0, Sybase central windows don’t refresh properly.
18. Error BC520RTL.DLL
19. When I am waiting for a generation preview, I get the error message: Exception violation ... in module RBRCL66.bpl ...
20. I am getting Paradox errors, when trying to retrieve a sample from my database, in ColorTools.
21. Error message = Please connect or reset your instrument !
22. How do I create and use a palette in Lab Paintmaker?
23. What is ResetRegistry ?
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. E099 Invalid floating point operation
27. When I create a new dyelot, I get the error message Index does not exist !.
28. 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 .
29. Error: PDOXUSRS.NET when creating a new record
30. Units kg/l (liquor ratio) and °C/min don’t appear in the pop up menu of the ITMRegistry. Why ?
31. Unable to read white tile data ! White tile data failed !
32. I am using ColorTools with one instrument, how can I add a second spectrophotometer
33. How do I edit PFs in Lab Paintmaker?
34. Error AfxthrowDCIDBE Exception
35. No match found!
36. After weighing products: Error Message: SQL Error: General Error: SELECT returns more than one row.
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. I have defined a query in table DYELOT but it doesn’t work (empty result).
39. Floating-point : divided by 0!
40. Units kg/l (liquor ratio) and °C/min do not appear in the pop up menu of ITM Registry | System settings | Prod unit. Why?
41. I have done a user query in Dyelots but the result is always empty. Why?
42. Problem in correction options in DM PPI. When the customer try to put all the add in zero, and these numbers not changed!.
43. 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
44. How can I test the alphanumeric value of a parameter?
45. Unable to generate a dyelot or to customize a production form
46. Green tile fail in DM PPI
47. When I start ITMRegistry, I get the error message:ExceptionEDBEEngine Error Invalid string or buffer length
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. When I have done additions or corrections, how can I test the original recipe in a formula? Use of KuseOrigConc and KuseOldConc
55. How to use the minimum and maximum fields of parameter or products records?
56. The calculation of OperTotTime does not work properly. It doesn’t calculate the time for heating or cooling.
57. Data location not found in DCIGLOB.INI
58. SmartWeigh does not display the same number of decimals than ITMProcess. Why?
59. A column / field is missing in one ITMProcess window. On the other workstations, it is visible.
60. The sofware can not calculate the right cost in matching
61. When generating a dyelot, I get the following error: Constraint violation: Column Amount Reserved in table Products cannot be null