My Oracle Support Banner

Attribute Values are Removed from Form if Attempting to Save Asset with Attribute that Exceeds the Max Characters for that Field: (Asset.SaveAll : Error: errno=-105 is receiving as expected but asset values are lost) (Doc ID 2378498.1)

Last updated on JULY 26, 2018

Applies to:

Oracle WebCenter Sites - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When creating a page flex asset and adding more than 2000 characters in an attribute field, after saving it, the system presents the below error followed by a blank page below the error message, instead of displaying the asset form with current input values.
- The result is that all asset attribute values that were edited in the form are not preserved, requiring the asset to be loaded/edited again and all the updates re-input in the form.


Below you can find the error and the problem-scenario:

1) error in UI: 
    "Cannot save asset. 
          This attempt to save the Page has failed. 

          Possible causes: 
         (1) Another Page already exists with the same information in a field 
that must be unique. 
         (2) The text you have entered in one or more fields in the form does 
not fit in the corresponding database field. 
         (3) The text you have entered in a field does not match the format 
required by the corresponding database field. 

          Please return to the Edit form, make the necessary changes, and 
retry this operation. If the problem persists, please contact your system 
administrator. 


          Error saving an asset Asset.SaveAll : Error: errno=-105 on call to 
catalog manager for table 'Page_Mungo' " 
  

2) replication steps:

a) Admin UI, for FSII site, create a new Page Attribute with: 
    - named TestDescription 
    - Description Description_Test 
    - Attribute Type String 
    - Number of values single 
    - Attribute Editor TextArea 
    - save it 
b) create a new Page Definition with: 
    - named GenericPage 
    - Attribute optional for TestDescription 
    - save it 
c) Go to Contributor UI: 
    - Content -> New -> New Page 
    - named OGAttribTest1 and choose GenericPage Definition 
    - in the field for TestDescription add a string (or multiple) that round up 
to max 2000 characters like: 
"OJdq09LUGo0wzVkEFkO9llL2G6D8njwrPUvwjaPeHtGjkq069vb5IAhOkBGedJ0WtmYxHlH3kjN 
tI9Cj3hayDSKyKGRiBSB2iHVmbaO4iqSYFBiisbxzqOxqBHqGEdIbNMHQvZXDpzjfZRvCANg5dY8Ka 
ktqXDeXbhUAUGGmRbxAbYHrs7w9ss57FrOi7tUgNYjHFj628kBMovVI9aWWxO6EqGClUAUVaPg6prr 
pdHGzCyEXQ3vhiKd1YN3lYxAdwRQiRQwDXUB0j2vmX1PtWnpdSZ9u3ZJPKVtH3PcaN5n7hHmFxIUQf 
DpCmeew0hNDDHEktf2h7XONK1Cv0aZB7E264H8HQqsux15sbafOt4yuWqLUv82EAUVw3RnGyOHT8jB 
Sq3XM8LP4lFu1p76YOjrS5J3SeVOpI2UsQPZXOcYMZhkkdpwl4YVPPUctYsR0Ad7wgHrwiOwL1B31F 
7nr8XsOocCekAXegTRF7GjCWk2PQc5OIEfPmmo9XPJEbKF16BjU3rWJq1T2roE6dgRX9Moj8oMhsf0 
Dc6w51UQj6ewqW6qbjCvdjKUqeMILIpSPNiJBSJyLfAjNNe19JtCjT4W7scSjj37ujahdfWaMQ0ZxH 
QSfAMvnbxT8X8wRyL97XPGHuSGh9jtdLtzkMZfDaTbeTREoeMzNZ8BHbsO2SCopBhyv6N2yJmqKYRM 
Dt0EhI8pkmIl3AwfW5ko5hNAHE8TgK1TJCRmVIyQ6pD1ttkVnOW5l3HqsEaT9YGEOGrmMx9NZXs5V1 
vt7LLOHKKIxvwDN2WkaSd2RlJ91zAnhzVSE0XGIYWgUXJ5bvcGjmFfmgpqr9SEvTMjaLvRnzAWvw5G 
uaA6g63E4AyTdbM5gn4g96VEo1EleJTQBLALpPgYZiXYhNP7cnQBFbEA71CuxHTTEVjb4km1gZH2yT 
n7SY3U1QEZacoR4ifb5UwlglhvlMfSy7TXFbBBvZSJo4rVWfrsuPrB57rcAZOLujiIo5oKyMprkCWS 
xnkehcW2tpjjS1vQIr8n12PVTbYXgXoji1WjdLUefn5Q12Q2YXtBhzH5i1RUoFCziWsJ2XCbSS0Xlj 
GpxQnaDkKLkpgC9atJQueFsnHEt8pa0r5spb5gUPaQ0VkSHHj4yxTRTamjsFznMnPatbsH19Ir0RAk 
2NL14CbF9nW3dEDUzNNAdMzrH365EzA62P66RhMSaRQ2XGnjsHdkvjU9DnMM0wrL4OvdDkY3o7jS6h 
pkunuLPpKPXhHYT8VfW87ed4jtXOR7NdcTb8m16VBHOYr6nOZLVsfim6PNnXMAbBabZNVdJLCkKZ1L 
n86APe41gbcY9rCV3o8f3r9dqLBb9hyQl8sSh68pSKN2EOQMTWCGK7rPTL2uoknYeojHTpWuHzAQ8S 
aMMSBGyX5DYkTsQ2qALwutTz3NS4y05XOMPpi3lcmxQSUaNeVXMHUFcAB5URAbBwwIoKnPOODtJxqw 
R3wU74s7vEzzSGtqsvNJAFlr2nnRIHTjROxgQ1joMOBwxTKgVXhjBr042YrJf30KWBXbdkyURuLwNl 
O1ep55HdnbodvzHOcSz8cRI2bmFYNACaHNxp9i8NC3BxAQ9RWzXly6hWNP1KeX6T7u4ZibDjgp2h7q 
s9OyL2ljuPFmkmyQB8hY8JOtNNjbaGfV7ENGUB9xIiwa46no2lldxn0xzxWn66fHiZcih2DkF6o2Dy 
Dn4EsjmYu5udI2jADKABkUODELc87mdiwZkrPGP8Ot720bj9wtW8uBHOKWewIHr7fyfUogHwnV1eYJ 
Jv1An6r2CPxwfyAND6btH2hUNngfwzOqb6TfVD0nVCR2YW5Wu0IToFq8Un73B4WCONUOZje8a4w0Ef 
W9l3KpzZMpEdfm0xVCZghsSOlYHFUzLVY3X9qXC0EmRTab3yKvC6hCZbzmrruya7k61rq7NrZ9PkFS 
QXERP7bJCkCZrub6gqY4ac0dMkQ6hzu4Xw9veFKChCrFRvRkjp3U0" 
   
   - save it -> it will save perfectly 
   - if the asset is Edited and one more character added and saved, it will 
throw an error like the one below 
   - nothing else is present in result-SAVE page other than the error message 
red box, only blank white space below the error message, value for the 
attribute using TEXTAREA is lost if BACK button is used, error message has a 
closing button marked with "X" and if clicked only the white blank space will 
remain 

Changes

 This behavior is present in all 12c Sites versions including the latest (12.2.1.3.0 BP1) .

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.