Hi Angus, This one seems to be a recurring issue. I'll have to put the details on fmepedia I think.
The problem appears to be writing to too many tables (layers) at once. Actually the number of tables isn't necessarily a problem, more that there is a setting that defines the maximum you are going to write. There are two solutions... 1) Use the MAX_OPEN_TABLES directive in FME. 2) Increase the MAXSTREAMS setting in Oracle. Hope this helps - it certainly seemed to fix the problem for anyone else who reported it. Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "angus_wood" <[EMAIL PROTECTED]> wrote: > > About 3 years ago this issue was raised, but there doesn't seem to be > any resolution in the discussion thread. Was a resolution determined > for the cause of the failure with message "All Channels have been > allocated"? > > Platform is Oracle 9i, and this occurs when more than 1 SDE layer is > being written to. > > Thanks > Angus Wood > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
