Q-DM (Upload) Error Codes

The list of Upload messages below contains just some example.
It is not a complete list of possible messages. Also, it does NOT provide a universal or complete solution or all causes for the messages! Depending on the system setup, there might be other causes and effects. Some messages as well as whether the original source files are moved to the Upload error folder may also depend on the system setup and database server setup itself. For example databases in Access, MS-SQL or Oracle may behave differently, the selected character set of the database can have an impact, or whether the database was setup as case-sensitive or not. Some messages displayed in the Upload log may even be forwarded from the database system itself, e.g. messages containing the term “ORA…” are forwarded from the Oracle database system

Code	Error message	Error description and troubleshooting
-99	-99 Data file contains a corrupt characteristic or group: group #xx / characteristic #xx -99 Error reading file	The group structure of the characteristics in the data set to be uploaded is incomplete. The data set position of the characteristic with incomplete group information is indicated in the error message. For a quick analysis, open the file in qs-STAT and a text editor and compare the contents.
-97	Data cannot be stored in database. K00xx cannot be written! Field WVxxx is missing	In the files to be uploaded there are additional data fields which are not activated in the databases. The database options describe how to activate them. Link to: Value Database - Functions and Administration
-93	Data cannot be stored in database. K00xx cannot be written! Field WV00xx is too small	This message can have 2 reasons. 1) In the case of K0009 (Text) or K0005 (Event): The fields were created too small in the database options. As of version 13, these can be enlarged in the database options. Link to: Value Database - Functions and Administration 2) In the case of other additional data fields: In the course of the versions, many fields were updated and field lengths extended, also in the area of additional data. The reason for the error message is then a failure to update the values databases.
-57	Duplicated values found => K00xx =	In the Upload the setting "Reject duplicates based on "K-field"" is set and the upload reject the files.
-47	<UNC> path: Directory not found	UNC path for gage PC configured in Upload, but network connection or PC is not available.
-37	Duplicate characteristics found in loaded data ==> ...	The option to check for duplicate characteristics in the file to be uploaded is active. Only the contents of the K fields that are configured as key fields are checked. The error message contains additional information: 1) If a duplicate is found based on the same content, the position of the last duplicate characteristic with the K fields and the duplicate content is listed. For example: Duplicate characteristics found in loaded data ==> Part 1, Characteristic 3: K2001, K2002( 2, Characteristic_2 ). 2) If a duplicate is found based on the missing content, e.g. K field is missing or K field has no content, only the position of the last duplicate characteristic is listed. For example: Duplicate characteristics found in loaded data ==> Part 1, Characteristic 3( ). In case it is really necessary to upload files with duplicate characteristics into the database, this is also possible with Q-DM. With the options "Part measurement" and "Check for duplicate characteristics" deactivated, duplicate characteristics will be uploaded in cumulated form.
-32 -19	Exception loading tree. Closing database connection -19 is a follow-up error to -32	Result of very many upload errors in sequence
-13	DBError writing values (Table WERTEVAR) [Execution of WVINSERT failed] => [FireDAC][Phys][ODBC][Microsoft][ODBC Driver xx for SQL Server] [SQL Server] Could not find stored procedure	Multiple reasons possible: The Upload (Service) has not been restarted after changings on the additional data. The stored procedures have been created with another SQL-User and the actual SQL-User is not allowed to use them or to create new.
-13	DBError writing values (Table WERTEVAR) [Execution of WVINSERT failed] => [FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK_WERTEVAR'. Cannot insert duplicate key in object 'dbo.WERTEVAR'. The duplicate key value is (123, 1, 0, 123456)	A duplicate characteristic was identified based on the key fields stored at characteristic level. To receive a meaningful message for duplicate characteristics, please use the “check for duplicate characteristics” option in Q-DM.
-8	Part is locked by <Q-DAS user name>	A part in the database may only be written to by one system at the time. All Q-DAS products therefore put a lock on the part in the database that is being written to. All other Q-DAS-users –including the Upload - will have “read-only” access to that part while locked. The lock will be removed once the part in the database is properly closed by the current user, and be available for write access, e.g. for the Upload again.
103	Error reading file	file is locked by another client uploading the same file, or temporarily from another software
112	Error reading file	Correctly written DFQ files are moved to the upload error directory if the hard disc is full. [Hard disc where the Q-DM application is installed and running]
600	Error reading file	The named file is not a DFQ / DFD / DFX file.
709	Error reading file	Data file empty.

Recommended