Auto-generated Filename is too long in DBCompare Report

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Mattje
Posts: 2
Joined: Thu 01 Mar 2018 15:35

Auto-generated Filename is too long in DBCompare Report

Post by Mattje » Thu 01 Mar 2018 15:59

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:

Code: Select all

 <Directory tree> /datacompare /compfile: <Filename>.dcomp /report: <Directory tree>\<Filename>.xls /incdata:yes /reportformat:XLS 


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

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Auto-generated Filename is too long in DBCompare Report

Post by alexa » Thu 01 Mar 2018 18:05

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

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Auto-generated Filename is too long in DBCompare Report

Post by alexa » Sat 03 Mar 2018 16:54

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.

Mattje
Posts: 2
Joined: Thu 01 Mar 2018 15:35

Re: Auto-generated Filename is too long in DBCompare Report

Post by Mattje » Mon 05 Mar 2018 20:03

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

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Auto-generated Filename is too long in DBCompare Report

Post by alexa » Mon 12 Mar 2018 15:18

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:

Code: Select all

insert into TEACHINGASSIGN_COURSEREQUIREMEN values(...);
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Auto-generated Filename is too long in DBCompare Report

Post by alexa » Thu 29 Mar 2018 11:02

You could try creating a *.bat file with the following command line string:

Code: Select all

"C:\Program Files\Devart\dbForge Data Compare for Oracle\datacompare.exe" /datacompare /compfile:"file.dcomp" /report:"report.xls" /reportformat:XLS
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.

Post Reply