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

Avatar

Avatar
Boost 1
Level 1
javierc50744734
Level 1

Like

1 like

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
javierc50744734
Level 1

Like

1 like

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
javierc50744734
Level 1

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

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

179 likes

Total Posts

273 posts

Correct reply

160 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

179 likes

Total Posts

273 posts

Correct reply

160 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
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

Avatar

Avatar
Validate 1
Level 1
jims52473243
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile

Avatar
Validate 1
Level 1
jims52473243
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile
jims52473243
Level 1

12-03-2021

We are experiencing a similar issue today. What was the resolution on this?

 

Oracle 19c, 9032v5 build.

 

We did recently upgrade to 19c, but 10 days ago and haven't encountered this issue until today.

 

Thanks,

Jim