Author Topic: Field maximum length issue  (Read 1208 times)

MHassan

  • Jr. Member
  • **
  • Posts: 64
    • View Profile
Field maximum length issue
« on: February 03, 2022, 02:40:14 AM »
Hello,

I have an issue that My Field(Customer Name) its maximum length is 160 , but there are reports that Customer Name is coming with 164 character so CMOD fails to extract this value and failed to load the report
I am using PDF Indexer
So anyone have an idea how to handle this issue without deleting the application group , by increasing length of field or by applying regular expression to trim the value when it reach 160 character and extract this value

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 572
    • View Profile
Re: Field maximum length issue
« Reply #1 on: February 03, 2022, 09:54:27 AM »
One of two things I've done in the past.

A.
1) rename old app group, APPGROUP_OLD
2) Copy app group, APPGROUP , except make the field length whatever you need or expect
3) Copy corresponding application(s)
4) Map to existing folder(s)

B.   Push back on your business partners to keep it at 160.

I'm also sure there's pre/post processors that can work- but i've never done that approach.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

rjrussel

  • Full Member
  • ***
  • Posts: 137
    • View Profile
Re: Field maximum length issue
« Reply #2 on: May 12, 2022, 09:04:57 AM »
Reach out to me if you haven't solved this problem yet.

-Rob

MHassan

  • Jr. Member
  • **
  • Posts: 64
    • View Profile
Re: Field maximum length issue
« Reply #3 on: June 07, 2022, 04:47:24 AM »
Reach out to me if you haven't solved this problem yet.

-Rob

Hello Rob,
I have still same issue , do you have any solution for this

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 572
    • View Profile
Re: Field maximum length issue
« Reply #4 on: June 08, 2022, 09:55:11 AM »
Reach out to me if you haven't solved this problem yet.

-Rob

Hello Rob,
I have still same issue , do you have any solution for this

I just had a requirement to do this, I did the exact steps I gave on 2/3. Zero issues.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

rjrussel

  • Full Member
  • ***
  • Posts: 137
    • View Profile
Re: Field maximum length issue
« Reply #5 on: June 10, 2022, 09:04:09 AM »
Reach out to me if you haven't solved this problem yet.

-Rob

Hello Rob,
I have still same issue , do you have any solution for this

If you want to shoot me an email rob.russell@ibm.com we can discuss how I can help.