BBPOHEAD
Jeff Park
Thank you,
Jeff Park
 |
| ||||||||||
Ryan Jeffs
--
You received this message because you are subscribed to the Google Groups "PSIUsers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to psiusers+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAEg3nehzQ-%3DH7bfZZy2A6H1DYZw6swvatH%2BNf76vY_6fLEkb6Q%40mail.gmail.com.
Randall Blinn
On Nov 4, 2023, at 9:08 PM, Ryan Jeffs <ryan....@jtsdirect.com> wrote:
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAFLe_FURkTwWuXW-343R4_3E1_S1SnjRxMuh%2BCcHkAAcV%2ByymQ%40mail.gmail.com.
Jeff Park
Thank you,
Jeff Park
|
| ||||||||||
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/9857DA55-6F27-4107-A5AD-E51E87D021EE%40gcc-inc.com.
Ryan Jeffs
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAEg3neiGwnWpNvX_tdsaZ%3Defj-LJFOhRBLHUvwFOGOi2eAGnTw%40mail.gmail.com.
Jeff Park
Thank you,
Jeff Park
|
| ||||||||||
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAFLe_FVA5nQiSB6LJj-Y9VxgcgkyHoH4Yj_MREz_PK2nHDoRYQ%40mail.gmail.com.
Andy Roth
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAEg3neh5M%2BY4EvztQh1X61gZqPqi1ZwXskkS9OTMkQdP%3DmH0NA%40mail.gmail.com.
Jeff Park
Thank you,
Jeff Park
|
| ||||||||||
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/3fb80e74-52dd-456a-8307-adc0b9f128de%40andyroth.com.
Andy Roth
invalid cost center or GL code?
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAEg3nehF%3Dv6bQDKsZBZkMqsmqbUwFV3f%3D_3JeeT4GXqUzsp-6g%40mail.gmail.com.
Jeff Park
Thank you,
Jeff Park
|
| ||||||||||
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/6bcfd6c9-1c8d-4ada-b20d-bb45da3520c6%40andyroth.com.
Jeff Park
Thank you,
Jeff Park
|
| ||||||||||
Tim Trinka
Possibly look for a process in part two with a zero value for the quantity.
Thank you,
Partners. Expertise. Teamwork. Solutions.
Randall Blinn
Good morning Jeff;
I have had this happen and it is a bear to troubleshoot. Some thoughts:
- If you have Crystal Reports:
- make a copy of your working Job Ticket
- Open the Job Ticket in Crystal and delete the sub-report in one section
- Try the Job Ticket
- Restore the original Job Ticket
- Delete another sub-report until you figure out which sub-report is bombing
- Each sub-report uses one SQL Stored Procedure, you could try to run the procedure in SQL and see if you can determine where the error is
- OR, once you know the sub-report, remove one field at a time and try the Job Ticket.
I know this is tedious, but it is the only way I was able to troubleshoot it (several times)
In one case, the error was caused by a “funny number” in one of the fields I have put a red box around:
I think it was “Trim To:” with a size that had too many decimals.
Hope this helps – GOOD LUCK!!!
Randall G Blinn
GRAPHIC COMPUTER CONSULTANTS, INC.
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/DM4PR19MB5811FFBC1B5518F716779AA3C9AAA%40DM4PR19MB5811.namprd19.prod.outlook.com.
Jeff Park
Thank you,
Jeff Park
|
| ||||||||||
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/PH0PR18MB507165FB75A6BAFACED8C7838EAAA%40PH0PR18MB5071.namprd18.prod.outlook.com.
Tim Trinka
Jeff,
If you do a preview of the job to the screen can you tell what page it stops at? Then look at the processes that are being used on that part in that area of the job.
Thank you,
Partners. Expertise. Teamwork. Solutions.
From: psiu...@googlegroups.com <psiu...@googlegroups.com>
On Behalf Of Jeff Park
Sent: Monday, November 6, 2023 3:17 PM
To: psiu...@googlegroups.com
Subject: Re: [External Sender] BBPOHEAD
Randall,
I did try your recommended method at first that was found in Yahoo Groups email :)
Removing sub report solved it and printed JT. So I went back to the original Crystal report file and started to remove the fields. It still wouldn't print. ONLY way was to remove the whole sub-report. Which I thought it was very odd
Thank you,
Jeff Park
|
|
|
||||||||||
On Mon, Nov 6, 2023 at 7:29 AM Randall Blinn <rbl...@gcc-inc.com> wrote:
Good morning Jeff;
I have had this happen and it is a bear to troubleshoot. Some thoughts:
- If you have Crystal Reports:
a. make a copy of your working Job Ticket
b. Open the Job Ticket in Crystal and delete the sub-report in one section
c. Try the Job Ticket
d. Restore the original Job Ticket
e. Delete another sub-report until you figure out which sub-report is bombing
f. Each sub-report uses one SQL Stored Procedure, you could try to run the procedure in SQL and see if you can determine where the error is
g. OR, once you know the sub-report, remove one field at a time and try the Job Ticket.
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAEg3neg0-sxTBqcdcRDNx9bJQSBriJTGRLMSyjseAESt6kbNhw%40mail.gmail.com.
Jeff Park
Thank you,
Jeff Park
|
| ||||||||||
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/DM4PR19MB5811ABAA790A20C32AD1A036C9AAA%40DM4PR19MB5811.namprd19.prod.outlook.com.
Tim Trinka
You would need to go through the job starting with part 1 then through each tab (part tab, stock & press, prepress, finishing, etc.) making sure you have valid process numbers and also the process quantity would need to be valid. Your estimator should be able to go through and see if everything looks as it should be. Every once in a while I have an estimator that would but in a zero process quantity for a process and multiplying by zero does not work.
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAEg3neitH%3D0uMchXOCSfTnuooPmc0633Ttj-mwRJKnb%3DiiTjew%40mail.gmail.com.
Randall Blinn
Hi Jeff;
I found that I had to remove one (or two) fields from the sub-report that was bad until I identified the corrupt field. It is time consuming, but it was the only solution. I’ve done it for several clients when this happens (probably 8-10 times).
Randall G Blinn
GRAPHIC COMPUTER CONSULTANTS, INC.
From: psiu...@googlegroups.com <psiu...@googlegroups.com>
On Behalf Of Jeff Park
Sent: Monday, November 6, 2023 3:17 PM
To: psiu...@googlegroups.com
Subject: Re: [External Sender] BBPOHEAD
Randall,
I did try your recommended method at first that was found in Yahoo Groups email :)
Removing sub report solved it and printed JT. So I went back to the original Crystal report file and started to remove the fields. It still wouldn't print. ONLY way was to remove the whole sub-report. Which I thought it was very odd
Thank you,
Jeff Park
|
|
|
||||||||||
On Mon, Nov 6, 2023 at 7:29 AM Randall Blinn <rbl...@gcc-inc.com> wrote:
Good morning Jeff;
I have had this happen and it is a bear to troubleshoot. Some thoughts:
- If you have Crystal Reports:
a. make a copy of your working Job Ticket
b. Open the Job Ticket in Crystal and delete the sub-report in one section
c. Try the Job Ticket
d. Restore the original Job Ticket
e. Delete another sub-report until you figure out which sub-report is bombing
f. Each sub-report uses one SQL Stored Procedure, you could try to run the procedure in SQL and see if you can determine where the error is
g. OR, once you know the sub-report, remove one field at a time and try the Job Ticket.
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAEg3neg0-sxTBqcdcRDNx9bJQSBriJTGRLMSyjseAESt6kbNhw%40mail.gmail.com.
Randall Blinn
SQL trace would help identify the SQL Stored Procedure, but you already know the Stored Procedure if you’ve identified the Crystal Reports sub-report (one Stored Procedure for each sub-report).
The error is in a field within the Stored Procedure. As I noted, I found the issue with a field (I think size) that had several decimal figures (i.e. like 4.589431).
It is a pain to trace, but it is an issue with some data.
Randall G Blinn
GRAPHIC COMPUTER CONSULTANTS, INC.
To view this discussion on the web visit https://groups.google.com/d/msgid/psiusers/CAEg3neitH%3D0uMchXOCSfTnuooPmc0633Ttj-mwRJKnb%3DiiTjew%40mail.gmail.com.