Categories
Bursting output file name character limit
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.
Comments
-
Hi Jyothi,
What is the error message, can you please share it and also please add the bursting definition.
0 -
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.
0 -
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.0 -
Hi Jyoti,
The limitation of BI Publisher bursting parameter OUTPUT_NAME is 100 chars.
Best regards,
Robert
0 -
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
0 -
At the physical level, the first example actually has 101 characters, because of the special chars:
1 -
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
0 -
Thanks Robert. It is helpful
1
