Devart Forums

Hi

I'm trying to generate a report that includes data, but it errors because the temporary binary files are too long:

Error: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.

Here's my command:

And here's what the auto-generated filenames look like:

43078fa7-81af-46dd-a568-bea275184928QUERY_<TABLENAME>1234567891011121314151617181920212223242526272829303132.$$$

Questions
1) Do we need the prefix token? (e.g. 43078fa7-81af-46dd-a568-bea275184928)
2) Why is the postfix number appended like this?:
<TABLENAME>1
<TABLENAME>12
<TABLENAME>123
when it could be like this?:
<TABLENAME>1
<TABLENAME>2
<TABLENAME>3
For many changes, as you can see in the above example, there are a lot of seemingly unnecessary numbers added:

<TABLENAME>1234567891011121314151617181920212223242526272829303132

could become:

<TABLENAME>32

3) Is there a workaround?, as this is currently stopping us from doing a full report with data

Thanks,
Matt

We will review this post and will answer you as soon as possible.

Could you please provide us the following information:
1. Version of dbForge.
2. Version of the server.
3. The name of the table you are generating a report for.

1. 4.0.29
2. Oracle 11.2.0.4.0
3. TEACHINGASSIGN_COURSEREQUIREMEN

example filename:
0e941a25-e541-4745-bbf7-d40e8bada136TEACHINGASSIGN_COURSEREQUIREMEN123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051

(your forum text field is to narrow to display the full length, so here it is line-by-line):
0e941a25-e541-4745-bbf7-
d40e8bada136TEACHINGASSIGN_COURSEREQUIREMEN123456789101112131415161718
192021222324252627282930313233343536373839404142434445464748495051

Thank you for the reply.

Could you please also provide us the CREATE definition of the table and some sample data to fill the table, kind of: You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

You could try creating a *.bat file with the following command line string: Please note that if you don't specify a path to the file, the report will be generated in the same folder as the .bat file is located.