Dear guest !

Welcome to Team Developer Community Forum. A place created by the community, for the community !

This is a resource for Q & A and discussion about everything related to OpenText Gupta Team Developer, SqlBase, TD Mobile and Report Builder.
It is the alternative for the OpenText customer forums which can only be accessed with an active support contract.

Please register your account now. It will make you part of the active community.
Also, this guest message will not be displayed for registered users.

As a bonus, registered users have access to the 'Newsgroups' subforum, holding 10 years worth of posts from the good old Gupta newsgroups.

Having an account gives you the opportunity to ask questions and get help from others.
We hope this free gathering will help you and the community getting forward!

Best regards,
The forum site admins.

Solved TD-23468: Error 146 “Input message buffer set too small” or hang with 100% CPU usage fetching Oracle CLOB

Post found bugs and possible workarounds.
Post Reply
Dave Rabelink
Founder/Site Admin
Netherlands
Posts: 209
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands
Contact:

TD-23468: Error 146 “Input message buffer set too small” or hang with 100% CPU usage fetching Oracle CLOB

Post by Dave Rabelink » 11 May 2017, 11:39

Applies to:
Gupta Team Developer (TD) 6.1, 6.2, 6.3, 7.0

Summary:
In Team Developer, when connecting to Oracle using native router and fetching Oracle CLOB data, you might receive error 146 “Input message buffer set too small” or experience an application hang with 100% CPU usage depending on the size of the CLOB data fetched.

This issue occurs in (but may not be limited to): 6.3 SP2 Update 2, 7.0 Update 1

Resolution:
The current status of this issue is Open. Please check this article later for status updates.

Tracking Number:
TD-23468
Regards,
Dave Rabelink

Image
Join & participate on Team Developer Tips & Tricks Wiki
Download samples from TD Sample Vault
Videos on TDWiki YouTube Channel

H3PO4
Germany
Posts: 21
Joined: 10 Mar 2017, 07:53
Location: Rohlstorf, Germany
Contact:

Re: TD-23468: Error 146 “Input message buffer set too small” or hang with 100% CPU usage fetching Oracle CLOB

Post by H3PO4 » 12 May 2017, 09:57

Hello Dave,

we did come into this too.

For us this issue appears only at 64k. Depending on the type of data, we add a comment or some byte of NULL data ( in Insert/Update-Trigger) to jump over 64k...

The error appears first some bytes before 64k, I made some test runs adding one byte from cycle to cycle, it seems that the calculation for the needed buffersize fails at 64k.
Also the point where the error occurs depends on the additional data size your are fetching with the CLOB

Did you already test this with TD7?

Best regards
Henning

Dave Rabelink
Founder/Site Admin
Netherlands
Posts: 209
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands
Contact:

Re: TD-23468: Error 146 “Input message buffer set too small” or hang with 100% CPU usage fetching Oracle CLOB

Post by Dave Rabelink » 19 Jul 2017, 07:09

This defect has been fixed in TD 6.3.9
Regards,
Dave Rabelink

Image
Join & participate on Team Developer Tips & Tricks Wiki
Download samples from TD Sample Vault
Videos on TDWiki YouTube Channel

H3PO4
Germany
Posts: 21
Joined: 10 Mar 2017, 07:53
Location: Rohlstorf, Germany
Contact:

Re: TD-23468: Error 146 “Input message buffer set too small” or hang with 100% CPU usage fetching Oracle CLOB

Post by H3PO4 » 19 Jul 2017, 07:14

THX Dave,

that will be a great help with upgrading to TD 7.

Best regards
Henning

Post Reply

Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 1 guest