Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Date Field Error

Highlighted
sevcan
Collector

Date Field Error

Hey all,

 

In a project details tab,

 

There is a date field, when it is filled with a date and saved we got 'For input string: "2012-10-01 00:00:00"' error.

 

Do you have any idea what cause this?

 

Thanks in advance,

Sev

15 REPLIES
Celil
Esteemed Contributor

Re: Date Field Error

Did you check OS Reginoal Settings ? This is related with OS settings.
Celil

IT Governance Professional
& PPM Solution Architect
sevcan
Collector

Re: Date Field Error

I checked the time zone in the OS and it is Turkey time zone. Where can I check the OS Regional Settings.

Should I check the user's manchne or the application server?

 

 

Thanks

Celil
Esteemed Contributor

Re: Date Field Error

Please check application server regional settings.
Celil

IT Governance Professional
& PPM Solution Architect
sevcan
Collector

Re: Date Field Error

THe application server regional settings are set to United states.

Celil
Esteemed Contributor

Re: Date Field Error

In the error, PPM says that your input date format and system that I work date format can not match.
Application server date format and validation date format are match ? when I said regional settings I mean to say date format.
Celil

IT Governance Professional
& PPM Solution Architect
sevcan
Collector

Re: Date Field Error

The application server date format is ‎like following Tuesday, ‎November ‎20,2012 or ‎11/‎20/‎2012.
The date format for PPM is like 11/20/12
Medium date: Nov 20, 2012
Long date: November 20, 2012
sevcan
Collector

Re: Date Field Error

Actually,
I tried with the user having this problem. It is using turkish and its date format is like
short 20.11.2012
medium 20.Kas.2012
long 20 Kasım 2012 Salı
Celil
Esteemed Contributor

Re: Date Field Error

God !
What is Oracle date format ?
Is this problem occour after a change or exist before a long time ago ?
Celil

IT Governance Professional
& PPM Solution Architect
sevcan
Collector

Re: Date Field Error

This happens fro the first time. But, they never enter the date fields before.
I did a select and the date format in oracle like 13/11/2012 this.
sevcan
Collector

Re: Date Field Error

I changed the users ppm regional settign to united states and try again. I got the below error in the log. there is a rule try to fill the planned start date according to this date. the below error is related with it.

select '2012-10-01 00:00:00',October 1, 2012' from dual (KNTA-10521)
at com.kintana.core.server.RulesAgent.parseAndExecuteSQL(RulesAgent.java:356)
at com.kintana.core.server.RulesAgent.processResults(RulesAgent.java:133)
at com.kintana.core.server.BasePluginImpl.processResults(BasePluginImpl.java:3380)
at com.kintana.core.web.ctrl.AutoPopulateController.getJSForSQL(AutoPopulateController.java:715)
at com.kintana.core.web.ctrl.AutoPopulateController.getFieldSettingJavascript(AutoPopulateController.java:412)
at com.kintana.core.web.ctrl.AutoPopulateController.loadData(AutoPopulateController.java:180)
at com.mercury.itg.servlet.ActionMonitorFilter.doFilter(ActionMonitorFilter.java:86)
at com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:88)
at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:111)
at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)
at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:145)
at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:80)
at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:81)
at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)
at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:861)
at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1378)
at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:40)
at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:51)
at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)
at com.kintana.core.web.filter.PerformanceFilter.applyFilter(PerformanceFilter.java:57)
at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)

Filtered Out 49 Stack Trace Lines.
Celil
Esteemed Contributor

Re: Date Field Error

now It's more clear :)
please use to_char function to match date formats
eg: TO_CHAR(SCHED_FINISH_DATE, 'dd-mm-yyyy')
Celil

IT Governance Professional
& PPM Solution Architect
sevcan
Collector

Re: Date Field Error

The select like this select '[REQD.P.VB_GT_C_BAS_TARIH]','[REQD.VP.VB_GT_C_BAS_TARIH]' from dual
and the result is equaled to planned start date which is a date format. Shoud I do select to_char('[REQD.P.VB_GT_C_BAS_TARIH]'),to_char('[REQD.VP.VB_GT_C_BAS_TARIH]') from dual or should I use to_date('[REQD.P.VB_GT_C_BAS_TARIH]'),to_date('[REQD.P.VB_GT_C_BAS_TARIH]'). The tokens are the date fields I fill and which throw errors.
Celil
Esteemed Contributor

Re: Date Field Error

try below code in both
to_char('[REQD.P.VB_GT_C_BAS_TARIH]', 'dd.mm.yyyy')
or
to_char('[REQD.P.VB_GT_C_BAS_TARIH]', 'dd/mm/yyyy')
Celil

IT Governance Professional
& PPM Solution Architect
sevcan
Collector

Re: Date Field Error

Thanks Celil, I will try it.
Celil
Esteemed Contributor

Re: Date Field Error

Don't forget; If the post resolves your issue, please mark it as Accepted Solution and please click KUDOS star icon
Celil

IT Governance Professional
& PPM Solution Architect
//Add this to "OnDomLoad" event