topic Database Isuue in Product Forum

Database Isuue

Mahrous — Mon, 06 Jan 2025 07:47:56 GMT

I am getting the error: Internal : Could not execute code stage because exception thrown by code stage: ORA-01861: literal does not match format string
ORA-01861: literal does not match format string

While the query works fine in the database. In fact, I get the same error when I try to run any query, does anyone have an idea how to solve this?

Re: Database Isuue

Jrwork — Mon, 06 Jan 2025 12:57:28 GMT

If you are dealing with dates, the error may occur because the date string you provided does not match the format expected by the database. Oracle uses the format 'DD-MON-YYYY' or 'YYYY-MM-DD', depending on the instance configuration.

Can you share the query?

@Mahrous

Re: Database Isuue

faheemsd — Mon, 06 Jan 2025 20:38:04 GMT

@Mahrous
Could you please explain the scenario for more understanding?

If possible, please share query as well.

Re: Database Isuue

Mahrous — Tue, 07 Jan 2025 07:49:14 GMT

Hi all,

I changed the Oracle object that I was using. I was using the OLED8 object and I tried the Oracle MDA, and it is now working fine.

The problem I had was not really related to dates, as I was trying to run any query in general and I was getting the same error as well. I was not able to identify where the problem was. However, it is working with the new Object now.

Thank you.

Re: Database Isuue

Jrwork — Tue, 07 Jan 2025 11:12:51 GMT

@Mahrous Okay, if you have any questions, I'm at your disposal. Have a good week.