Question
CBA
IN
Last activity: 26 Sep 2018 15:40 EDT
literal does not match format string ORA-06512: at line 1
Could you please help on the below error. any suggestions?
There was a problem getting a list: code: 1861 SQLState: 22008 Message: ORA-01861: literal does not match format string ORA-06512: at line 1
Passing parameter as Job date (DateTime property in Pega side and Date format in Oracle side)
Tried solution: by changing property Job date to Date also . No luck
Please help me out of here
Pegasystems Inc.
IN
Hi Mohan,
Could you please check the SQL query against which you see the error.
Since its related to date time below could be the case with you.
https://stackoverflow.com/questions/1902173/ora-01861-literal-does-not-match-format-string
Please trace and respond back with the SQL that causes the issue.
Regards,
Ujjwal
Pegasystems Inc.
IN
It seems that Stored Procedure here is the custom one.
The issue is with format I would believe (20180625) where as SP must be expecting some other format.
Run the stored proc with this input directly on DB and try adjusting the Stored Proc if it is an option.
Regards,
Ujjwal
PEG
PL
How the table got created? Is it external table?
Try to see how date is mapped in from pega side.
Eg: The easy way out is to have a optimized OOTB date property. I used Data-Event pyStartDate and optimized to see what pega uses for date mapping. For postgres it is "character varying" length 8. I dont have oracle instance so, i could not test there.
CBA
IN
Hi Ranjr,
Thanks for the response, Could you please explain me what needs to be in ur case??
Still getting the same error and attachment having the tracer part
Pegasystems Inc.
US
Was there an attachment intended here. The key to circumventing this issue is providing a format string for the db engine to use in interpreting the column data (as mention in stackoverflow post).
Also, please review this article : https://community.pega.com/knowledgebase/articles/date-properties-are-mapped-varchar2-columns-not-date-columns-oracle