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. General SQL error. Sybase ODBC Driver Adaptive Server Anywhere Syntax error or access violation: Commit/Rollback not allowed within atomic operation
9. How to load Chroma-Calc under DOS or Windows
10. Error BC453RTL.DLL. Floating Point Invalid
11. Hardware Problem or No security key Found
12. 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.
13. Running Color Tools 1.3r3 or 1.3r4 on a Windows NT can cause error message : “Newlocale.dll not found.”
14. Unable to open file USERS.BTR
15. Cannot load BPROP20.DLL
16. When doing support over modem with pcAnywhere and opening Sybase central 4.0, Sybase central windows don’t refresh properly.
17. The dyelot generation does not match with the combined process. Why?
18. I am getting Paradox errors, when trying to retrieve a sample from my database, in ColorTools.
19. Error message = Please connect or reset your instrument !
20. Error BC520RTL.DLL
21. When I am waiting for a generation preview, I get the error message: Exception violation ... in module RBRCL66.bpl ...
22. How can I print a RGB color?
23. How do I create and use a palette in Lab Paintmaker?
24. SQL Error : Integrity Constraint violation : column "NoOfWeights" in table "DyeLot_Bulked Recipe_Out" can’t be NULL
25. What is ResetRegistry ?
26. E099 Invalid floating point operation
27. When I create a new dyelot, I get the error message Index does not exist !.
28. Error: PDOXUSRS.NET when creating a new record
29. 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 .
30. Unable to read white tile data ! White tile data failed !
31. Units kg/l (liquor ratio) and °C/min don’t appear in the pop up menu of the ITMRegistry. Why ?
32. No match found!
33. I am using ColorTools with one instrument, how can I add a second spectrophotometer
34. Error AfxthrowDCIDBE Exception
35. How do I edit PFs in Lab Paintmaker?
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. Unable to generate a dyelot or to customize a production form
45. When I start ITMRegistry, I get the error message:ExceptionEDBEEngine Error Invalid string or buffer length
46. How can I test the alphanumeric value of a parameter?
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. 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. 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