BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
  • 1.  Case Manager String Field Maximum Length Incease

    Posted 26 days ago

    Hi All,

    Requirement: I have an existing case filed called S1(String, Maximum length=20). I want to increase the maximum length to 2000.

    What I have tried: I changed the maximum length to 2000 in ACCE property template. I did the changes in the solution. Committed and deployed the solution. It resets the maximum length to 20 in ACCE.

    Issues: I could not change the maximum length of the same field in solution properties.

    Please help.



    ------------------------------
    RAVI KUMAR
    ------------------------------


  • 2.  RE: Case Manager String Field Maximum Length Incease

    Posted 26 days ago

    Hello Ravi,

    You said you did the changes in the solution. What changes did you do in the solution to change the maximum length?

    Try these steps if not done already and see if it works.

    1. Updated property template maximum length through ACCE in Property Templates section.
    2. Go to the Case Type folder class through ACCE and update maximum length of the property.
    3. Deploy the solution 
    4. Test the solution to see if the desired results are achieved.

    Thanks



    ------------------------------
    Krishna
    ------------------------------



  • 3.  RE: Case Manager String Field Maximum Length Incease

    Posted 24 days ago

    Hi,

    we had the same need but with a message to override the case maximum length (1333 characters). Even if now we create a document with the message as content, we have extended the size of the case property template in CPE through ACCE, and DB2.

    When the solution is deployed on TOS object store the XML definition of the property template set the maximum kength (1333) defined in Case buirder.

    Then the changes on CPE TOS (Property template with propagation) may be applied.

    A FDM package is then prepared with the property template, case folder class.

    On Test, UAT, production environments, deploy the FDM package after deploying the solution.

    Note : if the case property is used in BAW, which isn't our case here, may be the 1.333 maximum length is filled.

    BR



    ------------------------------
    Yannick Martin
    ------------------------------



  • 4.  RE: Case Manager String Field Maximum Length Incease

    Posted 23 days ago

    Hi Yannick,

    If I understood correctly, you modified the maximum length directly in the Object store Database (Table PropertyDefinition) ? Please confirm.

    Regards,

    Ravi



    ------------------------------
    RAVI KUMAR
    ------------------------------



  • 5.  RE: Case Manager String Field Maximum Length Incease

    Posted 23 days ago

    Hi Krishna,

    Thank you for the reply. I could not change maximum length in the solution properties. I tried the steps you mentioned.

    After I deploy the solution, the changes I did in ACCE are getting reset.

    Regards,

    Ravi



    ------------------------------
    RAVI KUMAR
    ------------------------------



  • 6.  RE: Case Manager String Field Maximum Length Incease

    Posted 23 days ago

    Yes, in fact the case property template wasn't changed, we've change only the property definition placed in the "Case Subfolder" subclass we use.

    And this Case Subfolder subclass isn't part of the solution native deployment, we always use the FDM package to deploy such class definition.

    About the extension of the property size on the database server, since v21.0.3 the update of the size on ACCE seems to be automatically applied on database server (DB2).
    In our case (Property definition changed) we have to extend manually the property length in the database server.

    BR



    ------------------------------
    Yannick Martin
    ------------------------------



  • 7.  RE: Case Manager String Field Maximum Length Incease

    Posted 23 days ago

    Hi Yannick,

    We are using SQL Server. Currently 4000 characters is allowed in CPE. I want to set the same. After I set the maximum string length in ACCE (Case Folder and Property Template), I could see the 4000 in Database Tables "Process Definition" and "Column Definition". After I deploy the solution, the changes I did in ACCE are getting reset. Hence the value in tables "Process Definition" and "Column Definition" are getting reset.

    Could you please let me know in which table I should override this value. If possible, send me the screen shot.

    Regards,

    Ravi

    Regards,

    Ravi



    ------------------------------
    RAVI KUMAR
    ------------------------------



  • 8.  RE: Case Manager String Field Maximum Length Incease

    Posted 22 days ago

    Database table widths are limited.. For SQL server, creatre a new file group. 
    Think of it as a LOB partition with it's own tablespace. The LOB columns will
    be stored in the dedicated file group. 

    From the docs: You can define a custom string property to be stored in either a "short" or "long" database column. "Short" corresponds to vargraphic for IBM® DB2® (with a maximum length of 4000 characters), nvarchar for SQL Server (with a maximum length of 4000 characters), or varchar2 for Oracle (with a maximum length of 1333 characters). "Long" corresponds to dbclob for DB2, ntext for SQL Server, or clob for Oracle (with a maximum length of 1073741823 characters for both).



    ------------------------------
    Stephen Weckesser
    ------------------------------