4GL Stop Error When Adding new Part

I wonder if there are any Part or PartPlant records without a valid
PROGRESS_RECID or PROGRESS_RECID_IDENT_ column. If there was one, you
might try deleting it by hand from SQL Management Studio.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of kkearnscirmi
Sent: Wednesday, October 27, 2010 10:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 4GL Stop Error When Adding new Part

Unfortunately the log file is not very helpful

If you have any ideas, please let me know.

- (Procedure: 'as/activate.p' Line:380) Incoming call from TMR-03:0
TRACE: SINGLE-RUN Procedure bo/ReportMonitor.p:GetRowsKeepIdleTime START
(8458)
TRACE: SINGLE-RUN Procedure END SUCCESS. (8458)
Unknown data source error. (6159)
** 4GL Debug-Alert Stack Trace **
ttPartPlantRefresh bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at
line 81895
partAfterUpdate bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at line
64365
PartCreateRow bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at line
9162
PartUpdate bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at line 9349
Update bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at line 44313
Tried to access a record without a valid id. (6167)


--- In vantage@yahoogroups.com, "Brian W. Spolarich" <bspolarich@...>
wrote:
>
> Go and look at the MfgSys803.server.log file. There should be some
> messages there that probably bubbled up from MSSQL telling you what's
> wrong.
>
> -bws
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of kkearnscirmi
> Sent: Wednesday, October 27, 2010 9:51 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] 4GL Stop Error When Adding new Part
>
> We are experiencing a 4 GL Stop error when we attempt to add new part
to
> the system. We think the problem started when we experienced a failed
> insert of a part into the part and partplant tables. The data was
only
> added to the part table. We have backed up the SQL database and the
> Progress database and restored over Test.
>
> We ran the data conversion processes from the admin tools but that did
> not help. We are on 8.04.405b SQL
>
> Error message
>
> Error Detail
> ============
> 4GL STOP condition: The Server application has returned an error.
(7243)
> (7241)
>
>
> Stack Trace
> ===========
> at Progress.Open4GL.DynamicAPI.Session.runProcedure(String
requestID,
> String procedureName, ParameterSet parms, Boolean persistent, Boolean
> internal_Renamed, Int64 procId, MetaSchema localSchema, Int32
> stateModel)
> at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String
> requestID, String fullProcedureName, ParameterSet inparams, Object
> procId, MetaSchema localSchema, Int32 stateModel)
> at
Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String
> requestID, String procedureName, ParameterSet parms, MetaSchema
schema)
> at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String
> procedureName, ParameterSet parms, MetaSchema schema)
> at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
> at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
> at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
> at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()
>
>
> Any suggestions or ideas would be greatly appreciated.
>
> Thanks
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.
)
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>





------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
We are experiencing a 4 GL Stop error when we attempt to add new part to the system. We think the problem started when we experienced a failed insert of a part into the part and partplant tables. The data was only added to the part table. We have backed up the SQL database and the Progress database and restored over Test.

We ran the data conversion processes from the admin tools but that did not help. We are on 8.04.405b SQL

Error message

Error Detail
============
4GL STOP condition: The Server application has returned an error. (7243) (7241)


Stack Trace
===========
at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()


Any suggestions or ideas would be greatly appreciated.

Thanks
Go and look at the MfgSys803.server.log file. There should be some
messages there that probably bubbled up from MSSQL telling you what's
wrong.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of kkearnscirmi
Sent: Wednesday, October 27, 2010 9:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 4GL Stop Error When Adding new Part

We are experiencing a 4 GL Stop error when we attempt to add new part to
the system. We think the problem started when we experienced a failed
insert of a part into the part and partplant tables. The data was only
added to the part table. We have backed up the SQL database and the
Progress database and restored over Test.

We ran the data conversion processes from the admin tools but that did
not help. We are on 8.04.405b SQL

Error message

Error Detail
============
4GL STOP condition: The Server application has returned an error. (7243)
(7241)


Stack Trace
===========
at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID,
String procedureName, ParameterSet parms, Boolean persistent, Boolean
internal_Renamed, Int64 procId, MetaSchema localSchema, Int32
stateModel)
at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String
requestID, String fullProcedureName, ParameterSet inparams, Object
procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String
requestID, String procedureName, ParameterSet parms, MetaSchema schema)
at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String
procedureName, ParameterSet parms, MetaSchema schema)
at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()


Any suggestions or ideas would be greatly appreciated.

Thanks



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Unfortunately the log file is not very helpful

If you have any ideas, please let me know.

- (Procedure: 'as/activate.p' Line:380) Incoming call from TMR-03:0
TRACE: SINGLE-RUN Procedure bo/ReportMonitor.p:GetRowsKeepIdleTime START (8458)
TRACE: SINGLE-RUN Procedure END SUCCESS. (8458)
Unknown data source error. (6159)
** 4GL Debug-Alert Stack Trace **
ttPartPlantRefresh bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at line 81895
partAfterUpdate bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at line 64365
PartCreateRow bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at line 9162
PartUpdate bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at line 9349
Update bo/Part.p (D:\epicor\mfgsys803\Server\bo\Part.r) at line 44313
Tried to access a record without a valid id. (6167)


--- In vantage@yahoogroups.com, "Brian W. Spolarich" <bspolarich@...> wrote:
>
> Go and look at the MfgSys803.server.log file. There should be some
> messages there that probably bubbled up from MSSQL telling you what's
> wrong.
>
> -bws
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of kkearnscirmi
> Sent: Wednesday, October 27, 2010 9:51 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] 4GL Stop Error When Adding new Part
>
> We are experiencing a 4 GL Stop error when we attempt to add new part to
> the system. We think the problem started when we experienced a failed
> insert of a part into the part and partplant tables. The data was only
> added to the part table. We have backed up the SQL database and the
> Progress database and restored over Test.
>
> We ran the data conversion processes from the admin tools but that did
> not help. We are on 8.04.405b SQL
>
> Error message
>
> Error Detail
> ============
> 4GL STOP condition: The Server application has returned an error. (7243)
> (7241)
>
>
> Stack Trace
> ===========
> at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID,
> String procedureName, ParameterSet parms, Boolean persistent, Boolean
> internal_Renamed, Int64 procId, MetaSchema localSchema, Int32
> stateModel)
> at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String
> requestID, String fullProcedureName, ParameterSet inparams, Object
> procId, MetaSchema localSchema, Int32 stateModel)
> at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String
> requestID, String procedureName, ParameterSet parms, MetaSchema schema)
> at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String
> procedureName, ParameterSet parms, MetaSchema schema)
> at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
> at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
> at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
> at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()
>
>
> Any suggestions or ideas would be greatly appreciated.
>
> Thanks
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>