hi,
I wonder if anybody can help,
A user received the following error whilst in an ABF application (they have
since completed the same process with no error):
A database error has occurred….The database error number is 590342 and the
generic error is 39100
the database error message is E_SC0206 an internal error prevents further
processing of this query, Associated error messages which provide more
detailed information about the problem can be found in errlog.log
Here is the error from the errlog.log file:
SADEV1 ::[39417 , 30e70be0]: Mon Apr 18 12:16:09 2005
E_QE0236_DMU_TO
O_MANY Transactions cannot contain more than 255 DMF temporary files.
SADEV1 ::[39417 , 30e70be0]: Mon Apr 18 12:16:09 2005
E_PS0D20_QEF_ER
ROR An error occurred calling QEF while destroying view or table.
SADEV1 ::[39417 , 30e70be0]: Mon Apr 18 12:16:48 2005
E_SC0215_PSF_ER
ROR Error returned by PSF.
SADEV1 ::[39417 , 30e70be0]: Mon Apr 18 12:16:48 2005
E_PS0007_INT_OT
HER_FAC_ERR PSF detected an internal error when calling other facility.
SADEV1 ::[39417 , 30e70be0]: Mon Apr 18 12:16:48 2005
E_SC0206_CANNOT
_PROCESS An internal error prevents further processing of this
query.
Associated error messages which provide more detailed information about
the pro
blem can be found in the error log, II_CONFIG:errlog.log
I wonder if anybody knows what caused the error,
thanks,
regards,
Mark
Karl & Betty Schendel - 18 Apr 2005 15:35 GMT
>hi,
>
[quoted text clipped - 6 lines]
>E_QE0236_DMU_TO
>O_MANY Transactions cannot contain more than 255 DMF temporary files.
The ABF program tried to do more than 255 DDL statements without a
COMMIT. This is an internal limit that was eliminated in release 3.
There is no workaround other than doing a COMMIT at some point.
(relevant DDL = create/drop table, view, index; also modify, alter table.)
Karl
Mark Cull - 19 Apr 2005 08:30 GMT