Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Ingres Topics / April 2005

Tip: Looking for answers? Try searching our database.

ABF application error DMF/QEF/PSF

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mark Cull - 18 Apr 2005 14:30 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.