Clarity

 View Only
  • 1.  Resource Planning - Filter issue

    Posted Feb 23, 2017 03:57 AM

    Hi,

     

    When I try to configure Top Down Planning portlet by adding a custom field to filter condition, I get error stating "System error. Contact system adminstrator". This was in PROD environment and when I try to replicate the same in DEV environment, I get no error and the field is added to filter condition as usual.

     

    Any idea on what is causing this issue?

     

    Thanks in advance.

     

    Monica 



  • 2.  Re: Resource Planning - Filter issue

    Posted Feb 23, 2017 04:53 AM

    What does the app log say?

     

    Is the field deactivated?

     

    NJ



  • 3.  Re: Resource Planning - Filter issue

    Posted Feb 23, 2017 05:14 AM

    Hi NJ,

     

    The error I see in log is :

     

     Internal Processing exception
    com.niku.union.persistence.PersistenceException:
    SQL error code: 1461
    Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01461: can bind a LONG value only for insert into a LONG column

     

    The attribute is active and I tried adding the same field in other environment and I didn't have issue over there and this exists only with PROD environment.

     

    Monica



  • 4.  Re: Resource Planning - Filter issue

    Posted Feb 27, 2017 01:30 AM

    Does this happen if you pre-filter to say just one or two records, and then add the custom field?