Author Topic: Problem with ODWEK v8.5.0.10 accessing database with Decimal field  (Read 3777 times)

cwkong8

  • Guest
Problem with ODWEK v8.5.0.10 accessing database with Decimal field
« on: September 11, 2016, 07:04:57 PM »
Hi all,

I have an application that uses ODWEK v8.5.0.10 to access the OnDemand server. It has been working fine until we change a field on a folder to "Decimal". Whenever I query on the folder using the ODWEK, the application crashed. I have traced down to the point that the crash come from the icuuc44.dll with Segmentation Error. I believe it has something to do with how Decimal field is handled by ODWEK and resulting in the icuuc44.dll crashed.

Anyone has any idea what I could do with it?

Best regards,
Conrad

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Problem with ODWEK v8.5.0.10 accessing database with Decimal field
« Reply #1 on: September 12, 2016, 06:40:47 AM »
You're on an old and unsupported version of ODWEK (and probably CMOD).  Your best way forward is an upgrade to a supported version, unfortunately.

Check the README files for CMOD v9.0 and v9.5 to see if this specific issue has been resolved already.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
Re: Problem with ODWEK v8.5.0.10 accessing database with Decimal field
« Reply #2 on: September 12, 2016, 09:37:00 AM »
Hi all,

I have an application that uses ODWEK v8.5.0.10 to access the OnDemand server. It has been working fine until we change a field on a folder to "Decimal". Whenever I query on the folder using the ODWEK, the application crashed. I have traced down to the point that the crash come from the icuuc44.dll with Segmentation Error. I believe it has something to do with how Decimal field is handled by ODWEK and resulting in the icuuc44.dll crashed.

Anyone has any idea what I could do with it?

What is missing here is the server version, where you do all your connections. Would it be possible to have also that information?
And in addition to that, would it be possible to know if the java code using the decimal field was "static" to the old value, or this is something that takes the information dynamically and with it adapt the search criterias according to the type needed?

If that's static, then you must recode something and recompile it.
If that's dynamic, then something is off. And I would suggest first, to check with the developers that everything was correctly coded. Maybe they have simply forgot to add a special use case for decimals.
Or if everything seems ok, then maybe this is a bug, and in that case, as Justin suggested, try to use the latest ODWEK available (9.5.0.6 at the moment), and if that doesn't work, then open a ticket by IBM, because there should be no issues at my knowledge.
Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML

cwkong8

  • Guest
Re: Problem with ODWEK v8.5.0.10 accessing database with Decimal field
« Reply #3 on: September 13, 2016, 08:05:14 PM »
You're on an old and unsupported version of ODWEK (and probably CMOD).  Your best way forward is an upgrade to a supported version, unfortunately.

Check the README files for CMOD v9.0 and v9.5 to see if this specific issue has been resolved already.

-JD.

FYI. The OnDemand server we are using is v9.0

I have tried a more recent version of ODWEK 8.5.0.11 released on May 11, 2016 which still fail the same. I did try 9.0 and it worked properly. It just feel strange to me that OnDemand server 9.0 is supposed to be compatible with ODWEK 8.5 which obviously isn't the case because I am hitting the problem: http://www-01.ibm.com/support/docview.wss?uid=swg21392275

Anyway, maybe it is the way how cross version stuff would work here.

Best regards,
Conrad

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Problem with ODWEK v8.5.0.10 accessing database with Decimal field
« Reply #4 on: September 14, 2016, 04:51:35 AM »
The best practice is to always have the same version of the Content Manager OnDemand client, server, and ODWEK.  Backwards compatibility is provided as a temporary convenience, not something to be relied upon for several years.

CMOD v8.5 went out of support in April 2016, so I'm surprised there was an update with 8.5.0.11.  I'll check into it.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
Re: Problem with ODWEK v8.5.0.10 accessing database with Decimal field
« Reply #5 on: September 14, 2016, 03:16:58 PM »

FYI. The OnDemand server we are using is v9.0

I have tried a more recent version of ODWEK 8.5.0.11 released on May 11, 2016 which still fail the same. I did try 9.0 and it worked properly. It just feel strange to me that OnDemand server 9.0 is supposed to be compatible with ODWEK 8.5 which obviously isn't the case because I am hitting the problem: http://www-01.ibm.com/support/docview.wss?uid=swg21392275

Anyway, maybe it is the way how cross version stuff would work here.


WWwwwwwwwwwoooooooooooooooowwwwwwwwwwwww .... please...

You are using CMOD V9 and ODWEK V8.5.
You are using a new field "Decimal" which is something that comes with CMOD V9+ and you are wondering why the ODWEK V8.X doesn't recognize something that was not available on V8.X but only with V9+ ???
IBM has ALWAYS said that if you use old client/odwek then they will NOT have the new features of the new version.
That includes for example in your specific case the decimal data type and of course the new date format.

The advice of IBM was always to use a client which the or higher version. So that you are not in a difficult position. It is not always possible, and sometimes for many reasons older version of client/odwek are used even if the server is an higher version. BUT of course, even if you have the latest version of an old main version, you will never have the new features of the higher version.

That is the same on any other product on the market...

Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML