Capture COS/WIP Error - Help!

Hi Mike; Restarting the appservers resolved the problem. I have not had the problem since. Wish I could be of more help.

Virginia Joseph
Deep Hole Specialists
440-708-5239


--- In vantage@yahoogroups.com, mark@... wrote:
>
> Hi Virginia, did you ever get resolution on this? We just did a new install on a test server and we get the same error. Its a copy of our live that works fine but in test we get errors? We are on 904.506B.
>
> --- In vantage@yahoogroups.com, "Mike Anstey" <manstey@> wrote:
> >
> > Have you checked you mfgsys.lg in your data directory for the following
> > error:
> >
> >
> >
> > [2012/01/20@18:23:21.877-0400] P-19432 T-1 F APPSRV 52: (14675)
> > SYSTEMERROR: Attempt to define too many indexes for area 6 database
> > DBI1019432. (40)
> >
> > [2012/01/20@18:23:21.943-0400] P-19432 T-1 I APPSRV 52: (439)
> > ** Save file named core for analysis by Progress Software Corporation.
> >
> >
> >
> > We had this issue in V8.03 (progress 10.1c) and it caused database
> > corruption. We still have this issue in 9.05.606, but are on progress
> > 10.2a and it now backs out the failed transactions. We still have no
> > resolution from epicor.
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of Virginia Joseph
> > Sent: Monday, January 23, 2012 7:48 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Capture COS/WIP Error - Help!
> >
> >
> >
> >
> >
> > We are on 8.03.408. The entire posting process did not fail. It seems to
> > have posted everything except AR Clearing, WIP and COS. All other GL
> > activity posted. Before running capture, I had $1,246,685.88 of
> > transactions to post. After running it the first time, remaining
> > transaction not posted was $599,357.04. I ran it again and get the same
> > error and it seemed to post a few more transactions but there is still
> > $358,047.71 remaining not posted. When I ran it again, no additional
> > transactions were posted and the value in the WIP Reconciliation report
> > remains $358,047.71. I ran it 2 more times with the same error and
> > $358,047.71 of December transactions remain unposted.
> >
> > Thanks,
> > Virginia
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "cooner_55421" <cooner_55421@> wrote:
> > >
> > > What version are you on?
> > > Did you try running it again?
> > >
> > > In older versions of 8.03 I had problems with COS not posting.
> > > I had to get a fix from Epicor.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Virginia Joseph" <vjoseph@> wrote:
> > > >
> > > > Hello: When running COS capture, I get the following error:
> > > > Type:3
> > > > Program:agent/RunTask.p
> > > > Method:Main-Block
> > > > Table:
> > > > Field:
> > > > Rowid:
> > > > Message:Program jc/CaptureCOSWIP.p rasied the 4GL Stop condition
> > with the following message:
> > > >
> > > > Before you ask, I did not forget to paste the rest of the message.
> > There just isn't one.
> > > >
> > > > The entire posting process did not fail. It seems to have posted
> > everything except AR Clearing, WIP and COS. All other GL activity
> > posted.
> > > >
> > > > Any ideas?
> > > >
> > > > Thanks,
> > > > Virginia Joseph
> > > > Deep Hole Specialists
> > > > 440-708-5239
> > > > vjoseph@
> > > >
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Hello: When running COS capture, I get the following error:
Type:3
Program:agent/RunTask.p
Method:Main-Block
Table:
Field:
Rowid:
Message:Program jc/CaptureCOSWIP.p rasied the 4GL Stop condition with the following message:

Before you ask, I did not forget to paste the rest of the message. There just isn't one.

The entire posting process did not fail. It seems to have posted everything except AR Clearing, WIP and COS. All other GL activity posted.

Any ideas?

Thanks,
Virginia Joseph
Deep Hole Specialists
440-708-5239
vjoseph@...
What version are you on?
Did you try running it again?

In older versions of 8.03 I had problems with COS not posting.
I had to get a fix from Epicor.

--- In vantage@yahoogroups.com, "Virginia Joseph" <vjoseph@...> wrote:
>
> Hello: When running COS capture, I get the following error:
> Type:3
> Program:agent/RunTask.p
> Method:Main-Block
> Table:
> Field:
> Rowid:
> Message:Program jc/CaptureCOSWIP.p rasied the 4GL Stop condition with the following message:
>
> Before you ask, I did not forget to paste the rest of the message. There just isn't one.
>
> The entire posting process did not fail. It seems to have posted everything except AR Clearing, WIP and COS. All other GL activity posted.
>
> Any ideas?
>
> Thanks,
> Virginia Joseph
> Deep Hole Specialists
> 440-708-5239
> vjoseph@...
>
Hope someone could help. Recently upgraded from 6.1 to 9.05. The company
accountant came across some General ledger accounts that didn't bring
through the opening balances.


I selected about 10 of them and ran the verify balances, those 10 have
updated but the rest of the accounts I didn't select that had opening
balances have now disappeared


Is this correct, does the system delete the balance if the GL code is
not selected

Do you need to select all codes for this process?




Best regards,

Mark Howard
Jaws Support


P +61 7 3277 7499
D +61 7 3277 7499
We are on 8.03.408. The entire posting process did not fail. It seems to have posted everything except AR Clearing, WIP and COS. All other GL activity posted. Before running capture, I had $1,246,685.88 of transactions to post. After running it the first time, remaining transaction not posted was $599,357.04. I ran it again and get the same error and it seemed to post a few more transactions but there is still $358,047.71 remaining not posted. When I ran it again, no additional transactions were posted and the value in the WIP Reconciliation report remains $358,047.71. I ran it 2 more times with the same error and $358,047.71 of December transactions remain unposted.

Thanks,
Virginia



--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> What version are you on?
> Did you try running it again?
>
> In older versions of 8.03 I had problems with COS not posting.
> I had to get a fix from Epicor.
>
> --- In vantage@yahoogroups.com, "Virginia Joseph" <vjoseph@> wrote:
> >
> > Hello: When running COS capture, I get the following error:
> > Type:3
> > Program:agent/RunTask.p
> > Method:Main-Block
> > Table:
> > Field:
> > Rowid:
> > Message:Program jc/CaptureCOSWIP.p rasied the 4GL Stop condition with the following message:
> >
> > Before you ask, I did not forget to paste the rest of the message. There just isn't one.
> >
> > The entire posting process did not fail. It seems to have posted everything except AR Clearing, WIP and COS. All other GL activity posted.
> >
> > Any ideas?
> >
> > Thanks,
> > Virginia Joseph
> > Deep Hole Specialists
> > 440-708-5239
> > vjoseph@
> >
>
Have you checked you mfgsys.lg in your data directory for the following
error:



[2012/01/20@18:23:21.877-0400] P-19432 T-1 F APPSRV 52: (14675)
SYSTEMERROR: Attempt to define too many indexes for area 6 database
DBI1019432. (40)

[2012/01/20@18:23:21.943-0400] P-19432 T-1 I APPSRV 52: (439)
** Save file named core for analysis by Progress Software Corporation.



We had this issue in V8.03 (progress 10.1c) and it caused database
corruption. We still have this issue in 9.05.606, but are on progress
10.2a and it now backs out the failed transactions. We still have no
resolution from epicor.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Virginia Joseph
Sent: Monday, January 23, 2012 7:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Capture COS/WIP Error - Help!





We are on 8.03.408. The entire posting process did not fail. It seems to
have posted everything except AR Clearing, WIP and COS. All other GL
activity posted. Before running capture, I had $1,246,685.88 of
transactions to post. After running it the first time, remaining
transaction not posted was $599,357.04. I ran it again and get the same
error and it seemed to post a few more transactions but there is still
$358,047.71 remaining not posted. When I ran it again, no additional
transactions were posted and the value in the WIP Reconciliation report
remains $358,047.71. I ran it 2 more times with the same error and
$358,047.71 of December transactions remain unposted.

Thanks,
Virginia

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"cooner_55421" <cooner_55421@...> wrote:
>
> What version are you on?
> Did you try running it again?
>
> In older versions of 8.03 I had problems with COS not posting.
> I had to get a fix from Epicor.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Virginia Joseph" <vjoseph@> wrote:
> >
> > Hello: When running COS capture, I get the following error:
> > Type:3
> > Program:agent/RunTask.p
> > Method:Main-Block
> > Table:
> > Field:
> > Rowid:
> > Message:Program jc/CaptureCOSWIP.p rasied the 4GL Stop condition
with the following message:
> >
> > Before you ask, I did not forget to paste the rest of the message.
There just isn't one.
> >
> > The entire posting process did not fail. It seems to have posted
everything except AR Clearing, WIP and COS. All other GL activity
posted.
> >
> > Any ideas?
> >
> > Thanks,
> > Virginia Joseph
> > Deep Hole Specialists
> > 440-708-5239
> > vjoseph@
> >
>





[Non-text portions of this message have been removed]
We had problems with opening balances during our 6.1 -> 9.05 conversion.
The root cause for us was a purge done in 6.1 that left ver 9 confused
after the conversion. The fix was a journal entry with the correct
opening balances backdated a couple of years (to the purge date, our
fiscal year start). I think after posting those balances we had to run
the verify balances twice, the second time with update checked, then
rebuild display accounts. I can dig up my conversion notes if you need
more details.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Howard
Sent: Sunday, January 22, 2012 11:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Verify Balance records






Hope someone could help. Recently upgraded from 6.1 to 9.05. The company
accountant came across some General ledger accounts that didn't bring
through the opening balances.

I selected about 10 of them and ran the verify balances, those 10 have
updated but the rest of the accounts I didn't select that had opening
balances have now disappeared

Is this correct, does the system delete the balance if the GL code is
not selected

Do you need to select all codes for this process?

Best regards,

Mark Howard
Jaws Support


P +61 7 3277 7499
D +61 7 3277 7499





[Non-text portions of this message have been removed]
Hi Virginia, did you ever get resolution on this? We just did a new install on a test server and we get the same error. Its a copy of our live that works fine but in test we get errors? We are on 904.506B.

--- In vantage@yahoogroups.com, "Mike Anstey" <manstey@...> wrote:
>
> Have you checked you mfgsys.lg in your data directory for the following
> error:
>
>
>
> [2012/01/20@18:23:21.877-0400] P-19432 T-1 F APPSRV 52: (14675)
> SYSTEMERROR: Attempt to define too many indexes for area 6 database
> DBI1019432. (40)
>
> [2012/01/20@18:23:21.943-0400] P-19432 T-1 I APPSRV 52: (439)
> ** Save file named core for analysis by Progress Software Corporation.
>
>
>
> We had this issue in V8.03 (progress 10.1c) and it caused database
> corruption. We still have this issue in 9.05.606, but are on progress
> 10.2a and it now backs out the failed transactions. We still have no
> resolution from epicor.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Virginia Joseph
> Sent: Monday, January 23, 2012 7:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Capture COS/WIP Error - Help!
>
>
>
>
>
> We are on 8.03.408. The entire posting process did not fail. It seems to
> have posted everything except AR Clearing, WIP and COS. All other GL
> activity posted. Before running capture, I had $1,246,685.88 of
> transactions to post. After running it the first time, remaining
> transaction not posted was $599,357.04. I ran it again and get the same
> error and it seemed to post a few more transactions but there is still
> $358,047.71 remaining not posted. When I ran it again, no additional
> transactions were posted and the value in the WIP Reconciliation report
> remains $358,047.71. I ran it 2 more times with the same error and
> $358,047.71 of December transactions remain unposted.
>
> Thanks,
> Virginia
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "cooner_55421" <cooner_55421@> wrote:
> >
> > What version are you on?
> > Did you try running it again?
> >
> > In older versions of 8.03 I had problems with COS not posting.
> > I had to get a fix from Epicor.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Virginia Joseph" <vjoseph@> wrote:
> > >
> > > Hello: When running COS capture, I get the following error:
> > > Type:3
> > > Program:agent/RunTask.p
> > > Method:Main-Block
> > > Table:
> > > Field:
> > > Rowid:
> > > Message:Program jc/CaptureCOSWIP.p rasied the 4GL Stop condition
> with the following message:
> > >
> > > Before you ask, I did not forget to paste the rest of the message.
> There just isn't one.
> > >
> > > The entire posting process did not fail. It seems to have posted
> everything except AR Clearing, WIP and COS. All other GL activity
> posted.
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > > Virginia Joseph
> > > Deep Hole Specialists
> > > 440-708-5239
> > > vjoseph@
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>