Bursting output file name character limit

JYOTI MAURYA

Content

Hi,

I have defined Bursting Output file name in the query as below-

LegalEntityName || BusinessUnitName || 'Report' || To_CHAR(SYSDATE,'YYYYMONDDHH24MISS','NLS_DATE_LANGUAGE = American')

Now, It is ending up in "Problem" state after scheduling it due to long file name.

I would like to know if there's any possibility to increase the output file name character limit as we have a client requirement to maintain the filename as specified above. Please help.

Thanks in advance.

Jyoti.

 

Dimple-Nagesh-Support-Oracle

Hi Jyothi,

  What is the error message, can you please share it and also please add the bursting definition.

JYOTI MAURYA

Hi Dimple,

My report should generate 5 documents after scheduling it. But Due to long file name, it generated only 3 documents and then the Job ended up in "problem" state rather than "error" state.

After altering file name, issue got resolved and it processed documents correctly.

So I concluded that it was due to long file name.

Please let me know your inputs on this.

Dimple-Nagesh-Support-Oracle

Hi Jyothi,

  Thanks for the confirmation, so now the issue has been resolved ?
We may need to check for the limit of the output file passed in delivery options during bursting.

Robert Fighiroae-Oracle

Hi Jyoti,

The limitation of BI Publisher bursting parameter OUTPUT_NAME is 100 chars.

Best regards,

Robert

SR_CC

Hi Robert

Our file name is only 91 characters only and still the BI ended in Problem status. If we reduce the file name to less than 90. it completed in success.

P.S: The file names are in French.

e.g: Lettre de cessation d’emploi (EXT.) – Cessation d’emploi à l’intérieur du période_07326771 -- Failed file name

e.g: Lettre de cessation d’emploi (EXT.) – Cessation d’emploi à l’intérieur du_07326771 -- This file name worked

Robert Fighiroae-Oracle

At the physical level, the first example actually has 101 characters, because of the special chars:

Robert Fighiroae-Oracle

You see the length as 90 chars, indeed, but the size in bytes is over 100.

You can test directly in BI Publisher, data model, using the below function:

select

lengthb('Lettre de cessation d’emploi (EXT.) – Cessation d’emploi à l’intérieur du période_07326771') as test_column_len_in_bytes

from dual

SR_CC

Thanks Robert. It is helpful