Waiting for lock held by session -2147483565 in I:\...\ORDER2.dat
If "Track Locks" is specified (ecr #5432), the "Waiting for lock" message specifies the User ID holding the record. If not, the message specifies the Process ID holding the record.
This has been corrected.
This has been corrected but there is a related ECR 6678 that also details a similar memory leak. If the related ECR has not been fixed, you will still see memory being consumed and you will probably want to make sure you have the proper RETURN statements where needed.
This error only occurs if the SET statement is contained in an application whose version is something other than '00'. One or both of the fields referenced in the SET statement must be a group header in order for the error
to occur.
This has been corrected.
Rules:
1) Memo fields (in Access, SQL Server, Oracle, ...) can be arbitrarily long.
2) Appx alpha fields can be a max. of 32K.
3) When we READ long RDBMS data into a short Appx field, we silently truncate (there wouldn't be any way to manipulate the data in an Appx field).
4) When we READ with hold, implying that you might REWRITE, we generate an error, preventing possible data loss in the database.
The BEG/END READ statements should also set the --- STATUS CODE pdf.
Important Note: This incorrect definition also exists within the WIDGET structure files for all of the applications on an existing system. For this fix to be applied to all of your current applications, you must remove and re-create the WIDGET structure files for your apps. To do this, for each application on your system, you must:
1) Remove the WIDGET structure file: $APPXPATH/VV/AAA/Struct/WIDGET.dat where VV is the version and AAA is the appl ID. FMS override paths will effect this location.
!!! Make sure you are removing the WIDGET.dat file from your Struct directory and not your Data directory. Also do not remove the Struct/WIDGET.dat files from the $APPXPATH/00/0* directories. They have already been updated and your system may not run without them.
2) Run APPX and select System Admin -> Databases/Appl -> Design File Mgmnt.
3) Enter the Appl ID and Version.
4) Run File Selection and pick the WIDGET file.
5) Run Create Files. It should say File Already Exists for the WIDGET file.