I am running the Database Compact command on my database. I am getting a message that a table "supwork" cannot be updated and do I want to drop it Yes, No or Cancel. I choose no and the compacting goes on. Again a message comes up that supwork could not be updated "Ok or Cancel". I choose OK and get database compact is complete.
I have checked several times to be sure that the supwork table is not open before compacting. I have looked at the trace window and this is what it showes for errors.
q:\dtest0214\H_DM_DAT.ddd
q:\dtest0214\BRGDIMS.ddd
q:\dtest0214\STELLINE.ddd
q:\dtest0214\wheelcyl.DDD
q:\dtest0214\CLUCHMST.ddd
q:\dtest0214\complain.DDD
q:\a5v8data\Quality.ALB
Warning [1]: Error(s) opening rules for field: TQ
Warning [2]: Error parsing 'validation' rules conditional expression.
Warning [3]: - Table line: 1
q:\dtest0214\HDWARE.ddd
q:\dtest0214\Dtest Qualis Quality.ALB
q:\dtest0214\temp_rh.DDD
q:\dtest0214\FITTINGS.ddd
q:\dtest0214\DRUMDAT.ddd
q:\dtest0214\EXTDOC.ddd
q:\dtest0214\CORRANDPREVACTION.DDD
q:\a5v8data\Qualis Quality.ALB
q:\dtest0214\CLUSLV.ddd
q:\dtest0214\zipcode.DDD
q:\dtest0214\rgalog.DDD
q:\dtest0214\SUPPLIER.ddd
q:\dtest0214\OEM to Qualis Interchange.ddd
q:\dtest0214\Plant Regiatration.DDD
q:\dtest0214\270NEW.ddd
q:\dtest0214\upccodes.DDD
q:\dtest0214\menues.DDD
q:\dtest0214\DISCDAT.ddd
q:\dtest0214\SEN_RING.ddd
q:\dtest0214\INTEGDAT.ddd
q:\dtest0214\tools.DDD
q:\dtest0214\SUPWORK.ddd
q:\dtest0214\develop qualis quality.alb
q:\dtest0214\HYDR_HDW.ddd
q:\dtest0214\a_holidays.DDD
q:\dtest0214\MASTRCYL.ddd
q:\dtest0214\CustMstr.ddd
q:\dtest0214\PNSOURCE.ddd
q:\dtest0214\qualis quality.alb
q:\dtest0214\quality.alb
q:\dtest0214\Ball Joint Data.DDD
q:\dtest0214\SAMPLOG.ddd
Three questions 1) Is everything on this list an error or only the Warnings?
2) To what table are the warnings related to ?
3) Any idea as to why supwork table cannot be compacted?
Bob Okrzynski
I have checked several times to be sure that the supwork table is not open before compacting. I have looked at the trace window and this is what it showes for errors.
q:\dtest0214\H_DM_DAT.ddd
q:\dtest0214\BRGDIMS.ddd
q:\dtest0214\STELLINE.ddd
q:\dtest0214\wheelcyl.DDD
q:\dtest0214\CLUCHMST.ddd
q:\dtest0214\complain.DDD
q:\a5v8data\Quality.ALB
Warning [1]: Error(s) opening rules for field: TQ
Warning [2]: Error parsing 'validation' rules conditional expression.
Warning [3]: - Table line: 1
q:\dtest0214\HDWARE.ddd
q:\dtest0214\Dtest Qualis Quality.ALB
q:\dtest0214\temp_rh.DDD
q:\dtest0214\FITTINGS.ddd
q:\dtest0214\DRUMDAT.ddd
q:\dtest0214\EXTDOC.ddd
q:\dtest0214\CORRANDPREVACTION.DDD
q:\a5v8data\Qualis Quality.ALB
q:\dtest0214\CLUSLV.ddd
q:\dtest0214\zipcode.DDD
q:\dtest0214\rgalog.DDD
q:\dtest0214\SUPPLIER.ddd
q:\dtest0214\OEM to Qualis Interchange.ddd
q:\dtest0214\Plant Regiatration.DDD
q:\dtest0214\270NEW.ddd
q:\dtest0214\upccodes.DDD
q:\dtest0214\menues.DDD
q:\dtest0214\DISCDAT.ddd
q:\dtest0214\SEN_RING.ddd
q:\dtest0214\INTEGDAT.ddd
q:\dtest0214\tools.DDD
q:\dtest0214\SUPWORK.ddd
q:\dtest0214\develop qualis quality.alb
q:\dtest0214\HYDR_HDW.ddd
q:\dtest0214\a_holidays.DDD
q:\dtest0214\MASTRCYL.ddd
q:\dtest0214\CustMstr.ddd
q:\dtest0214\PNSOURCE.ddd
q:\dtest0214\qualis quality.alb
q:\dtest0214\quality.alb
q:\dtest0214\Ball Joint Data.DDD
q:\dtest0214\SAMPLOG.ddd
Three questions 1) Is everything on this list an error or only the Warnings?
2) To what table are the warnings related to ?
3) Any idea as to why supwork table cannot be compacted?
Bob Okrzynski
Comment