Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

An SQL exception occurred: Length of LOB data (2102428) to be replicated exceeds configured maximum

in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered

Please provide a helpful suggestion here to resolve this -

Issue – Application P00092 is used for attaching Text Notes. Post saving when the attachment icon is clicked again against the same record the newly added text is not saved. This is happening for specific customers only in Production in all test environment it is working fine.

Cause find out in logs - An Error occured while Inserting a Record into Media Object table F00165 for User Name : Environment : JPD920, Role : *ALL com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Length of LOB data (2102428) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type..

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

E1 Tools & Output Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center