Oracle 10g – Duplicate reports – double printing

45 pts.
Tags:
duplicate print
Duplicate reports
Oracle
print
Reports
Hello there, when we send a report to print, we get duplicate prints, checking on the report server for a test (printing two reports) i got this:
Job ID Job Type Job Name Job Status Job Owner Output Type Output Name Server Name Queued At Started At Finished At
203196 report CXC RECIBO DE CAJA ANONYMOUS Printer RECSJ rep_mbacase Aug 11, 2014 9:20:14 AM Aug 11, 2014 9:20:14 AM Aug 11, 2014 9:20:14 AM
203195 report CXC RECIBO DE CAJA ANONYMOUS Printer RECSJ rep_mbacase Aug 11, 2014 9:20:14 AM Aug 11, 2014 9:20:14 AM Aug 11, 2014 9:20:14 AM
203194 report CXC RECIBO FACTOREO ANONYMOUS Printer RECSJ rep_mbacase Aug 11, 2014 9:20:09 AM Aug 11, 2014 9:20:09 AM Aug 11, 2014 9:20:09 AM
203193 report CXC RECIBO FACTOREO ANONYMOUS Printer RECSJ rep_mbacase Aug 11, 2014 9:20:08 AM Aug 11, 2014 9:20:08 AM Aug 11, 2014 9:20:09 AM

.... 4 prints at the output, how can i solve this problem?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Splat
    Going by the Job ID those appear to be separate jobs.  Is it possible your process is generating multiple jobs all executing the same program?
    7,215 pointsBadges:
    report
  • brayvargas
    How can I do to find it?
    45 pointsBadges:
    report
  • carlosdl
    I'm not sure to understand (and the formatting of the data you posted doesn't help).

    What exactly do you mean by "duplicate prints".  Do you mean duplicate records?  As Splat pointed out, the first field (Job ID) seems to be different, so the records are not duplicates.

    Does it happen only when you print the report?  If you generate it to the screen, do you get different results?

    Can you post the query (or the data source, if not a query) of the report?

    The more info you provide, the better.
    69,475 pointsBadges:
    report
  • Splat
    Unfortunately, that I can't advise you on.  For some reason the title of the post didn't register until after I'd posted that comment.  I have no experience with Oracle, so the mechanics of tracking items down is not something I'm familiar with.
    7,215 pointsBadges:
    report
  • brayvargas
    Splat, thank you anyway!.
    carlosdl:,
    "What exactly do you mean by "duplicate prints".  Do you mean duplicate records?  As Splat pointed out, the first field (Job ID) seems to be different, so the records are not duplicates."
    The Job ID are diferent, but when it prints have the same content, like for example we send the report 123 and 456 to print, and we get 2 copies of each one, looking at the Oracle Application Server (report server) I found that where create 4 jobs instead of 2:
    JobID 203193 and 203194 are the same, 203195 adn 203196 same content.




    "Does it happen only when you print the report?  If you generate it to the screen, do you get different results?"
    Yes, just happen when we send the report(bills) to print (we use a dot matr epson printer), but the reports that are generate to screen (pdf) they does not have problem,
    45 pointsBadges:
    report
  • carlosdl
    Thanks.  It is clearer now.

    It could be an issue on the application server's side, which is definitely not my domain, so if that is the case I won't be able to help.

    But if possible, I would like to take a look at the code you use to generate and send the report to print, just in case.
    69,475 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following