Highlighted

ORA-210000 Oracle error: ORA-24801: illegal parameter value in OCI lob function

Avatar

Avatar

javierc50744734

Avatar

javierc50744734

javierc50744734

04-06-2019

Hi,

I am getting the following error when attempting to open certain campaigns and attempting to create new campaigns:

1765667_pastedImage_0.png

1765668_pastedImage_1.png

Can someone provide some insight as to what might be the cause?

Thanks!

Replies

Highlighted

Avatar

Avatar

craigthonis

Employee

Avatar

craigthonis

Employee

craigthonis
Employee

05-06-2019

Hello Javier,

The issue appears to be related to Oracle, so my assumption is that you have an on premise instance and database not hosted by Adobe.  I looked internally on my end but have not seen any instance where this error has been seen previously.

Oracle documentation around this error states the following:

ORA-24801: illegal parameter value in OCI lob function

    Cause: One of the parameter values in the OCI lob function is illegal.

Action: Check every parameter in the OCI Lob function call to make sure they are correct. Offsets should be greater than or equal to one.

If you've checked, and it appears that all your parameters are coded properly and you still receive the ORA-24801, you may simply need to  upgrade the client.

Questions:

Have any upgrades to your environment or database taken place recently? 

With the specific Campaign's did these work before or have they always failed? 

And if they worked previously were any changes made? 

Are you only seeing these errors or are your colleagues seeing them as well?

If it's just you, did you try performing a hard and soft clear of your local cache?

Something else you could do is export the Campaigns and workflows in question and import them into your non-production environment and see if the same error occurs.

Regards,

Craig