nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

OBIEE Error: ORA-01401: too big value entered for the column at OCI call OCIStmtFetch.

Carina Mendes

Hi!

I ma column in my table database with the Data Type 'VARCHAR(4000)' and I can not show your data in my OBIEE report.

(The types of column data in the database and RPD Physical Layer are identical, already checked).

Error message:

"OBIEE Error: ORA-01401: too big value entered for the column at OCI call OCIStmtFetch."

Can you help me?

Regards,
.

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Hi,

Is it really OBIEE giving you the error? Because "ORA-01401" is a database error, and I found it quite strange that OBIEE use a ORA code for it's own errors.

(Seeing an error in OBIEE doesn't mean the error is generated by OBIEE)

Carina Mendes

Hi Mr. @Gianni Ceresa

Yes, the error is show in OBIEE report:

If I make an select in data base, I don't have this error:

I thought it was some limitation of the base date of the RPD but found no configuration related to this problem.

Thanks,
Carina Mendes.

Gianni Ceresa

I don't have a running 11.1.1.9 (yours seems to be a 11.1.1.9) but in a 12.2.1.1 the QUERY_TEXT column of the usage tracking table is a lot smaller than 4000 (actually it's 1024 bytes).

OBIEE varchar are limited at 4000 if I don't remember wrong, so you maybe have an error with encoding?

As you use a system in Spanish (I guess) maybe your 4000 characters in the DB actually take more than that because of encoding and so you go over the max size OBIEE manage in a varchar ....

Did you try to reduce the column to a VARCHAR3000 in the RPD and see if you still have the issue?

(Waiting for my SA to boot to check how Oracle imported it into their RPD....)

Gianni Ceresa

Actually few SampleApp I checked all use that column as a VARCHAR 1024 (matching the size I found in the DB).

How come yours is 4000? Where does your S_NQ_ACCT table come from?

Carina Mendes

Hi Mr. @Gianni Ceresa,

Yes, I'm using the 11.1.1.9 version of OBIEE.

I made the adjustment that recomedou to varchar (100) forcing the application to bring a smaller number of characters in the column, but the error in OBIEE continues.

Thanks,

Carin Mendes.

[Deleted User]

Ah well you should set it to what's in the DB. As Gianni said normally it's 1024 BYTE in SA.

Carina Mendes

Hi, Mr. Christian Berg

I changed the datatype in the database and the problem was solved!

Thank you!

Gianni Ceresa

The question is more why it was wrong in the DB?

If somebody put its hands on the table changing the type of the column to collect more content .... simply avoid that!

(I love to talk to myself ...)

Gianni Ceresa wrote:Actually few SampleApp I checked all use that column as a VARCHAR 1024 (matching the size I found in the DB).How come yours is 4000? Where does your S_NQ_ACCT table come from?

Carina Mendes

Hi @Gianni Ceresa

Actually the problem was dataype column in the table, but the error only appeared in OBIEE.

How is not a adminsitrado environment only for myself, I can not say why this VARCHAR (4000) was set.

Anyway, your help was of great value, thank you!

Regards!
Carina Mendes.

Upcoming Event

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion CX Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…

Top Leaders