Epicor 9.04.504 Printing Errors

Thanks Mark!

That seems to be working for us.

Troy

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: September-22-09 4:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Epicor 9.04.504 Printing Errors



vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> wrote:
> I've had the same issue, it hasn't prevented us from printing - I have
> reported it and not heard back.

This issue re-appeared in 9.03.504 for us too. Epicor may have discovered
the solution:

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

It looks like styles added or modified in V8.xx and upgraded to E9 have a
problem. Try the following workaround:

1. System Management > Company Maintenance > Report Style
2. Enter in the ReportStyle that you are receiving the error on.
3. For each Report Report Style, Uncheck the "Valid" checkbox.
4. Save.
5. For all of the above Report Style; check the "Valid" checkbox and
Save.

You should now be able to Print/Preview the report without error.

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

You may have to reset your Default Styles after doing this.

Mark W.



[Non-text portions of this message have been removed]
I was getting this error about violating DB constraints whenever I print
anything but not regularly:

Table: SysRptLst
DCDUserID=''
WorkStationID=''
CreateDate='(null)'
CreateTime='0' RecSeq='0'
RowIdent='0x0000000000d10b8e':
Column 'CreateDate' does not allow DBNull.Value

The RowIdent changes but it just pops up every so often. If I click through
a few of them, I'll get my preview or print out. I've found one other user
getting it, are there any others?

Thanks!

Mark W.
Hi Mark,
I'm currently working on this problem too. Although in this case it's
not happening randomly, it will do it every time I run a "stock status"
report.

Brian Johnson -- Epi-Center <http://epi-ctr.com>
Developer | direct: 413-531-2859


Mark Wonsil wrote:
>
>
> I was getting this error about violating DB constraints whenever I print
> anything but not regularly:
>
> Table: SysRptLst
> DCDUserID=''
> WorkStationID=''
> CreateDate='(null)'
> CreateTime='0' RecSeq='0'
> RowIdent='0x0000000000d10b8e':
> Column 'CreateDate' does not allow DBNull.Value
>
> The RowIdent changes but it just pops up every so often. If I click
> through
> a few of them, I'll get my preview or print out. I've found one other user
> getting it, are there any others?
>
> Thanks!
>
> Mark W.
>
>



[Non-text portions of this message have been removed]
Brian /Mark -

Support had me re-run conversions 100 & 130 and this seems to have
solved this problem. I don't understand why this worked.

Dan Sirow

Independent Components Corp.


--- In vantage@yahoogroups.com, Brian Johnson <bjohnson@...> wrote:
>
> Hi Mark,
> I'm currently working on this problem too. Although in this case it's
> not happening randomly, it will do it every time I run a "stock
status"
> report.
>
> Brian Johnson -- Epi-Center <http://epi-ctr.com>
> Developer | direct: 413-531-2859
>
>
> Mark Wonsil wrote:
> >
> >
> > I was getting this error about violating DB constraints whenever I
print
> > anything but not regularly:
> >
> > Table: SysRptLst
> > DCDUserID=''
> > WorkStationID=''
> > CreateDate='(null)'
> > CreateTime='0' RecSeq='0'
> > RowIdent='0x0000000000d10b8e':
> > Column 'CreateDate' does not allow DBNull.Value
> >
> > The RowIdent changes but it just pops up every so often. If I click
> > through
> > a few of them, I'll get my preview or print out. I've found one
other user
> > getting it, are there any others?
> >
> > Thanks!
> >
> > Mark W.
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>
I had run conversion 130 yesterday before leaving, but didn't have time
to test it. This did fix this error for me as well.

Brian Johnson -- Epi-Center <http://epi-ctr.com>
Developer | direct: 413-531-2859

dansirow wrote:
>
>
>
> Brian /Mark -
>
> Support had me re-run conversions 100 & 130 and this seems to have
> solved this problem. I don't understand why this worked.
>
> Dan Sirow
>
> Independent Components Corp.
>
> _,___




[Non-text portions of this message have been removed]
I tried this fix and unfortunately it didn't fix the issue for us.
vantage@yahoogroups.com wrote:
> I tried this fix and unfortunately it didn't fix the issue for us.
>

I just upgraded my test server to 504A and the issue came back. I re-ran
100, 130, 140, and 150 and it went away. I'm not sure which one fixed the
problem.

Mark W.
Ire-ran coversion programs 100, 130, 140 & 150 again and it didn't solve the issue for us.

Thanks,

Troy

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> vantage@yahoogroups.com wrote:
> > I tried this fix and unfortunately it didn't fix the issue for us.
> >
>
> I just upgraded my test server to 504A and the issue came back. I re-ran
> 100, 130, 140, and 150 and it went away. I'm not sure which one fixed the
> problem.
>
> Mark W.
>
vantage@yahoogroups.com wrote:
> Ire-ran coversion programs 100, 130, 140 & 150 again and it
> didn't solve the issue for us.

Would you please repost the error message that you're getting?

Thanks,

Mark W.
Mark,

Here is the error message.

Thanks,

Troy

Error Detail
============
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Table: SysRptLst
DCDUserID='' WorkStationID='' CreateDate='(null)' CreateTime='0' RecSeq='0' RowIdent='0x000000000168318d': Column 'CreateDate' does not allow DBNull.Value.


Stack Trace
===========
at Epicor.Mfg.Pro.Convert.copyDataTable(DataTable sourceDT, DataTable targetDT)
at Epicor.Mfg.Pro.Convert.ToDataSet(DataSet tempDataSet, DataSet ds)
at Epicor.Mfg.Proxy.ReportMonitorImpl.GetRowsKeepIdleTime(String whereClauseSysRptLst, Int32 pageSize, Int32 absolutePage, Boolean& morePages)
at Epicor.Mfg.UI.Adapters.ReportMonitorAdapter.GetRowsKeepIdleTime(SearchOptions opts, Boolean& MorePages)

Inner Exception
===============
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Inner Stack Trace
=================
at System.Data.DataSet.FailedEnableConstraints()
at System.Data.DataSet.EnableConstraints()
at System.Data.DataSet.set_EnforceConstraints(Boolean value)
at System.Data.DataTable.EndLoadData()
at Epicor.Mfg.Pro.Convert.copyDataTable(DataTable sourceDT, DataTable targetDT

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> vantage@yahoogroups.com wrote:
> > Ire-ran coversion programs 100, 130, 140 & 150 again and it
> > didn't solve the issue for us.
>
> Would you please repost the error message that you're getting?
>
> Thanks,
>
> Mark W.
>
Hi Troy,

Which report are you trying to run when you get this error message?

Thanks,


CHRIS




________________________________
From: troy.richman <troyr@...>
To: vantage@yahoogroups.com
Sent: Monday, 17 August, 2009 19:41:03
Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors

Â
Mark,

Here is the error message.

Thanks,

Troy

Error Detail
============
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Table: SysRptLst
DCDUserID='' WorkStationID= '' CreateDate=' (null)' CreateTime=' 0' RecSeq='0' RowIdent='0x0000000 00168318d' : Column 'CreateDate' does not allow DBNull.Value.

Stack Trace
===========
at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT)
at Epicor.Mfg.Pro. Convert.ToDataSe t(DataSet tempDataSet, DataSet ds)
at Epicor.Mfg.Proxy. ReportMonitorImp l.GetRowsKeepIdl eTime(String whereClauseSysRptLs t, Int32 pageSize, Int32 absolutePage, Boolean& morePages)
at Epicor.Mfg.UI. Adapters. ReportMonitorAda pter.GetRowsKeep IdleTime( SearchOptions opts, Boolean& MorePages)

Inner Exception
============ ===
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Inner Stack Trace
============ =====
at System.Data. DataSet.FailedEn ableConstraints( )
at System.Data. DataSet.EnableCo nstraints( )
at System.Data. DataSet.set_ EnforceConstrain ts(Boolean value)
at System.Data. DataTable. EndLoadData( )
at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT

--- In vantage@yahoogroups .com, "Mark Wonsil" <mark_wonsil@ ...> wrote:
>
> vantage@yahoogroups .com wrote:
> > Ire-ran coversion programs 100, 130, 140 & 150 again and it
> > didn't solve the issue for us.
>
> Would you please repost the error message that you're getting?
>
> Thanks,
>
> Mark W.
>







[Non-text portions of this message have been removed]
Chris,

This error occurs on all reports but it doesn't happen every time. Typically it will happen once every ten times.

Thanks,

Troy

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi Troy,
>
> Which report are you trying to run when you get this error message?
>
> Thanks,
>
>
> CHRIS
>
>
>
>
> ________________________________
> From: troy.richman <troyr@...>
> To: vantage@yahoogroups.com
> Sent: Monday, 17 August, 2009 19:41:03
> Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
>
> Â
> Mark,
>
> Here is the error message.
>
> Thanks,
>
> Troy
>
> Error Detail
> ============
> Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
>
> Table: SysRptLst
> DCDUserID='' WorkStationID= '' CreateDate=' (null)' CreateTime=' 0' RecSeq='0' RowIdent='0x0000000 00168318d' : Column 'CreateDate' does not allow DBNull.Value.
>
> Stack Trace
> ===========
> at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT)
> at Epicor.Mfg.Pro. Convert.ToDataSe t(DataSet tempDataSet, DataSet ds)
> at Epicor.Mfg.Proxy. ReportMonitorImp l.GetRowsKeepIdl eTime(String whereClauseSysRptLs t, Int32 pageSize, Int32 absolutePage, Boolean& morePages)
> at Epicor.Mfg.UI. Adapters. ReportMonitorAda pter.GetRowsKeep IdleTime( SearchOptions opts, Boolean& MorePages)
>
> Inner Exception
> ============ ===
> Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
>
> Inner Stack Trace
> ============ =====
> at System.Data. DataSet.FailedEn ableConstraints( )
> at System.Data. DataSet.EnableCo nstraints( )
> at System.Data. DataSet.set_ EnforceConstrain ts(Boolean value)
> at System.Data. DataTable. EndLoadData( )
> at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT
>
> --- In vantage@yahoogroups .com, "Mark Wonsil" <mark_wonsil@ ...> wrote:
> >
> > vantage@yahoogroups .com wrote:
> > > Ire-ran coversion programs 100, 130, 140 & 150 again and it
> > > didn't solve the issue for us.
> >
> > Would you please repost the error message that you're getting?
> >
> > Thanks,
> >
> > Mark W.
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Is there anyone else having similar issues to this in 504?

We are due to upgrade from 503B to 504 but we have just managed to get all of our reports working properly in 503B - I dont want it to be a upgrade that causes more problems.

Were you on 503B before?

If so has anything stopped working in 504 that was working in 503B?




________________________________
From: troy.richman <troyr@...>
To: vantage@yahoogroups.com
Sent: Tuesday, 18 August, 2009 15:12:39
Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors

Â
Chris,

This error occurs on all reports but it doesn't happen every time. Typically it will happen once every ten times.

Thanks,

Troy

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Hi Troy,
>
> Which report are you trying to run when you get this error message?
>
> Thanks,
>
>
> CHRIS
>
>
>
>
> ____________ _________ _________ __
> From: troy.richman <troyr@...>
> To: vantage@yahoogroups .com
> Sent: Monday, 17 August, 2009 19:41:03
> Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
>
> Â
> Mark,
>
> Here is the error message.
>
> Thanks,
>
> Troy
>
> Error Detail
> ============
> Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
>
> Table: SysRptLst
> DCDUserID='' WorkStationID= '' CreateDate=' (null)' CreateTime=' 0' RecSeq='0' RowIdent='0x0000000 00168318d' : Column 'CreateDate' does not allow DBNull.Value.
>
> Stack Trace
> ===========
> at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT)
> at Epicor.Mfg.Pro. Convert.ToDataSe t(DataSet tempDataSet, DataSet ds)
> at Epicor.Mfg.Proxy. ReportMonitorImp l.GetRowsKeepIdl eTime(String whereClauseSysRptLs t, Int32 pageSize, Int32 absolutePage, Boolean& morePages)
> at Epicor.Mfg.UI. Adapters. ReportMonitorAda pter.GetRowsKeep IdleTime( SearchOptions opts, Boolean& MorePages)
>
> Inner Exception
> ============ ===
> Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
>
> Inner Stack Trace
> ============ =====
> at System.Data. DataSet.FailedEn ableConstraints( )
> at System.Data. DataSet.EnableCo nstraints( )
> at System.Data. DataSet.set_ EnforceConstrain ts(Boolean value)
> at System.Data. DataTable. EndLoadData( )
> at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT
>
> --- In vantage@yahoogroups .com, "Mark Wonsil" <mark_wonsil@ ...> wrote:
> >
> > vantage@yahoogroups .com wrote:
> > > Ire-ran coversion programs 100, 130, 140 & 150 again and it
> > > didn't solve the issue for us.
> >
> > Would you please repost the error message that you're getting?
> >
> > Thanks,
> >
> > Mark W.
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]
Chris,

We were running 503B previously.

This error does not prevent us from printing and Epicor support have been unable to reproduce the issue and claim it is our environment.

Troy

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Is there anyone else having similar issues to this in 504?
>
> We are due to upgrade from 503B to 504 but we have just managed to get all of our reports working properly in 503B - I dont want it to be a upgrade that causes more problems.
>
> Were you on 503B before?
>
> If so has anything stopped working in 504 that was working in 503B?
>
>
>
>
> ________________________________
> From: troy.richman <troyr@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, 18 August, 2009 15:12:39
> Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
>
> Â
> Chris,
>
> This error occurs on all reports but it doesn't happen every time. Typically it will happen once every ten times.
>
> Thanks,
>
> Troy
>
> --- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
> >
> > Hi Troy,
> >
> > Which report are you trying to run when you get this error message?
> >
> > Thanks,
> >
> >
> > CHRIS
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: troy.richman <troyr@>
> > To: vantage@yahoogroups .com
> > Sent: Monday, 17 August, 2009 19:41:03
> > Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
> >
> > Â
> > Mark,
> >
> > Here is the error message.
> >
> > Thanks,
> >
> > Troy
> >
> > Error Detail
> > ============
> > Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
> >
> > Table: SysRptLst
> > DCDUserID='' WorkStationID= '' CreateDate=' (null)' CreateTime=' 0' RecSeq='0' RowIdent='0x0000000 00168318d' : Column 'CreateDate' does not allow DBNull.Value.
> >
> > Stack Trace
> > ===========
> > at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT)
> > at Epicor.Mfg.Pro. Convert.ToDataSe t(DataSet tempDataSet, DataSet ds)
> > at Epicor.Mfg.Proxy. ReportMonitorImp l.GetRowsKeepIdl eTime(String whereClauseSysRptLs t, Int32 pageSize, Int32 absolutePage, Boolean& morePages)
> > at Epicor.Mfg.UI. Adapters. ReportMonitorAda pter.GetRowsKeep IdleTime( SearchOptions opts, Boolean& MorePages)
> >
> > Inner Exception
> > ============ ===
> > Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
> >
> > Inner Stack Trace
> > ============ =====
> > at System.Data. DataSet.FailedEn ableConstraints( )
> > at System.Data. DataSet.EnableCo nstraints( )
> > at System.Data. DataSet.set_ EnforceConstrain ts(Boolean value)
> > at System.Data. DataTable. EndLoadData( )
> > at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT
> >
> > --- In vantage@yahoogroups .com, "Mark Wonsil" <mark_wonsil@ ...> wrote:
> > >
> > > vantage@yahoogroups .com wrote:
> > > > Ire-ran coversion programs 100, 130, 140 & 150 again and it
> > > > didn't solve the issue for us.
> > >
> > > Would you please repost the error message that you're getting?
> > >
> > > Thanks,
> > >
> > > Mark W.
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Has anyone who had this problem solved it? Does anyone else still have this problem printing with 9.04.504?
Thanks for info.
Dan

--- In vantage@yahoogroups.com, "troy.richman" <troyr@...> wrote:
>
> Chris,
>
> We were running 503B previously.
>
> This error does not prevent us from printing and Epicor support have been unable to reproduce the issue and claim it is our environment.
>
> Troy
>
> --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> >
> > Is there anyone else having similar issues to this in 504?
> >
> > We are due to upgrade from 503B to 504 but we have just managed to get all of our reports working properly in 503B - I dont want it to be a upgrade that causes more problems.
> >
> > Were you on 503B before?
> >
> > If so has anything stopped working in 504 that was working in 503B?
> >
> >
> >
> >
> > ________________________________
> > From: troy.richman <troyr@>
> > To: vantage@yahoogroups.com
> > Sent: Tuesday, 18 August, 2009 15:12:39
> > Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
> >
> > Â
> > Chris,
> >
> > This error occurs on all reports but it doesn't happen every time. Typically it will happen once every ten times.
> >
> > Thanks,
> >
> > Troy
> >
> > --- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
> > >
> > > Hi Troy,
> > >
> > > Which report are you trying to run when you get this error message?
> > >
> > > Thanks,
> > >
> > >
> > > CHRIS
> > >
> > >
> > >
> > >
> > > ____________ _________ _________ __
> > > From: troy.richman <troyr@>
> > > To: vantage@yahoogroups .com
> > > Sent: Monday, 17 August, 2009 19:41:03
> > > Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
> > >
> > > Â
> > > Mark,
> > >
> > > Here is the error message.
> > >
> > > Thanks,
> > >
> > > Troy
> > >
> > > Error Detail
> > > ============
> > > Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
> > >
> > > Table: SysRptLst
> > > DCDUserID='' WorkStationID= '' CreateDate=' (null)' CreateTime=' 0' RecSeq='0' RowIdent='0x0000000 00168318d' : Column 'CreateDate' does not allow DBNull.Value.
> > >
> > > Stack Trace
> > > ===========
> > > at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT)
> > > at Epicor.Mfg.Pro. Convert.ToDataSe t(DataSet tempDataSet, DataSet ds)
> > > at Epicor.Mfg.Proxy. ReportMonitorImp l.GetRowsKeepIdl eTime(String whereClauseSysRptLs t, Int32 pageSize, Int32 absolutePage, Boolean& morePages)
> > > at Epicor.Mfg.UI. Adapters. ReportMonitorAda pter.GetRowsKeep IdleTime( SearchOptions opts, Boolean& MorePages)
> > >
> > > Inner Exception
> > > ============ ===
> > > Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
> > >
> > > Inner Stack Trace
> > > ============ =====
> > > at System.Data. DataSet.FailedEn ableConstraints( )
> > > at System.Data. DataSet.EnableCo nstraints( )
> > > at System.Data. DataSet.set_ EnforceConstrain ts(Boolean value)
> > > at System.Data. DataTable. EndLoadData( )
> > > at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT
> > >
> > > --- In vantage@yahoogroups .com, "Mark Wonsil" <mark_wonsil@ ...> wrote:
> > > >
> > > > vantage@yahoogroups .com wrote:
> > > > > Ire-ran coversion programs 100, 130, 140 & 150 again and it
> > > > > didn't solve the issue for us.
> > > >
> > > > Would you please repost the error message that you're getting?
> > > >
> > > > Thanks,
> > > >
> > > > Mark W.
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Dan,

We still have this issue and have not been able to resolve it to date.

We are currently running 9.04.504b.

Troy

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dansirow
Sent: September-10-09 12:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors



Has anyone who had this problem solved it? Does anyone else still have this problem printing with 9.04.504?
Thanks for info.
Dan

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "troy.richman" <troyr@...> wrote:
>
> Chris,
>
> We were running 503B previously.
>
> This error does not prevent us from printing and Epicor support have been unable to reproduce the issue and claim it is our environment.
>
> Troy
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Chris Thompson <chriselectrix@> wrote:
> >
> > Is there anyone else having similar issues to this in 504?
> >
> > We are due to upgrade from 503B to 504 but we have just managed to get all of our reports working properly in 503B - I dont want it to be a upgrade that causes more problems.
> >
> > Were you on 503B before?
> >
> > If so has anything stopped working in 504 that was working in 503B?
> >
> >
> >
> >
> > ________________________________
> > From: troy.richman <troyr@>
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Sent: Tuesday, 18 August, 2009 15:12:39
> > Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
> >
> >
> > Chris,
> >
> > This error occurs on all reports but it doesn't happen every time. Typically it will happen once every ten times.
> >
> > Thanks,
> >
> > Troy
> >
> > --- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
> > >
> > > Hi Troy,
> > >
> > > Which report are you trying to run when you get this error message?
> > >
> > > Thanks,
> > >
> > >
> > > CHRIS
> > >
> > >
> > >
> > >
> > > ____________ _________ _________ __
> > > From: troy.richman <troyr@>
> > > To: vantage@yahoogroups .com
> > > Sent: Monday, 17 August, 2009 19:41:03
> > > Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
> > >
> > >
> > > Mark,
> > >
> > > Here is the error message.
> > >
> > > Thanks,
> > >
> > > Troy
> > >
> > > Error Detail
> > > ============
> > > Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
> > >
> > > Table: SysRptLst
> > > DCDUserID='' WorkStationID= '' CreateDate=' (null)' CreateTime=' 0' RecSeq='0' RowIdent='0x0000000 00168318d' : Column 'CreateDate' does not allow DBNull.Value.
> > >
> > > Stack Trace
> > > ===========
> > > at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT)
> > > at Epicor.Mfg.Pro. Convert.ToDataSe t(DataSet tempDataSet, DataSet ds)
> > > at Epicor.Mfg.Proxy. ReportMonitorImp l.GetRowsKeepIdl eTime(String whereClauseSysRptLs t, Int32 pageSize, Int32 absolutePage, Boolean& morePages)
> > > at Epicor.Mfg.UI. Adapters. ReportMonitorAda pter.GetRowsKeep IdleTime( SearchOptions opts, Boolean& MorePages)
> > >
> > > Inner Exception
> > > ============ ===
> > > Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
> > >
> > > Inner Stack Trace
> > > ============ =====
> > > at System.Data. DataSet.FailedEn ableConstraints( )
> > > at System.Data. DataSet.EnableCo nstraints( )
> > > at System.Data. DataSet.set_ EnforceConstrain ts(Boolean value)
> > > at System.Data. DataTable. EndLoadData( )
> > > at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT, DataTable targetDT
> > >
> > > --- In vantage@yahoogroups .com, "Mark Wonsil" <mark_wonsil@ ...> wrote:
> > > >
> > > > vantage@yahoogroups .com wrote:
> > > > > Ire-ran coversion programs 100, 130, 140 & 150 again and it
> > > > > didn't solve the issue for us.
> > > >
> > > > Would you please repost the error message that you're getting?
> > > >
> > > > Thanks,
> > > >
> > > > Mark W.
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>



[Non-text portions of this message have been removed]
I've had the same issue, it hasn't prevented us from printing - I have
reported it and not heard back.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Troy Richman
Sent: Thursday, September 10, 2009 3:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Epicor 9.04.504 Printing Errors





Dan,

We still have this issue and have not been able to resolve it to date.

We are currently running 9.04.504b.

Troy

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of dansirow
Sent: September-10-09 12:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors

Has anyone who had this problem solved it? Does anyone else still have
this problem printing with 9.04.504?
Thanks for info.
Dan

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, "troy.richman" <troyr@...> wrote:
>
> Chris,
>
> We were running 503B previously.
>
> This error does not prevent us from printing and Epicor support have
been unable to reproduce the issue and claim it is our environment.
>
> Troy
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, Chris Thompson <chriselectrix@>
wrote:
> >
> > Is there anyone else having similar issues to this in 504?
> >
> > We are due to upgrade from 503B to 504 but we have just managed to
get all of our reports working properly in 503B - I dont want it to be a
upgrade that causes more problems.
> >
> > Were you on 503B before?
> >
> > If so has anything stopped working in 504 that was working in 503B?
> >
> >
> >
> >
> >










Alison Levy | IT Manager | Mats Inc.
dir: 781-573-0291 | cell: 781-964-1698 | fax: 781-232-5191
alevy@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



________________________________

> > From: troy.richman <troyr@>
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Sent: Tuesday, 18 August, 2009 15:12:39
> > Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
> >
> >
> > Chris,
> >
> > This error occurs on all reports but it doesn't happen every time.
Typically it will happen once every ten times.
> >
> > Thanks,
> >
> > Troy
> >
> > --- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
> > >
> > > Hi Troy,
> > >
> > > Which report are you trying to run when you get this error
message?
> > >
> > > Thanks,
> > >
> > >
> > > CHRIS
> > >
> > >
> > >
> > >
> > > ____________ _________ _________ __
> > > From: troy.richman <troyr@>
> > > To: vantage@yahoogroups .com
> > > Sent: Monday, 17 August, 2009 19:41:03
> > > Subject: [Vantage] Re: Epicor 9.04.504 Printing Errors
> > >
> > >
> > > Mark,
> > >
> > > Here is the error message.
> > >
> > > Thanks,
> > >
> > > Troy
> > >
> > > Error Detail
> > > ============
> > > Failed to enable constraints. One or more rows contain values
violating non-null, unique, or foreign-key constraints.
> > >
> > > Table: SysRptLst
> > > DCDUserID='' WorkStationID= '' CreateDate=' (null)' CreateTime='
0' RecSeq='0' RowIdent='0x0000000 00168318d' : Column 'CreateDate' does
not allow DBNull.Value.
> > >
> > > Stack Trace
> > > ===========
> > > at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT,
DataTable targetDT)
> > > at Epicor.Mfg.Pro. Convert.ToDataSe t(DataSet tempDataSet, DataSet
ds)
> > > at Epicor.Mfg.Proxy. ReportMonitorImp l.GetRowsKeepIdl
eTime(String whereClauseSysRptLs t, Int32 pageSize, Int32 absolutePage,
Boolean& morePages)
> > > at Epicor.Mfg.UI. Adapters. ReportMonitorAda pter.GetRowsKeep
IdleTime( SearchOptions opts, Boolean& MorePages)
> > >
> > > Inner Exception
> > > ============ ===
> > > Failed to enable constraints. One or more rows contain values
violating non-null, unique, or foreign-key constraints.
> > >
> > > Inner Stack Trace
> > > ============ =====
> > > at System.Data. DataSet.FailedEn ableConstraints( )
> > > at System.Data. DataSet.EnableCo nstraints( )
> > > at System.Data. DataSet.set_ EnforceConstrain ts(Boolean value)
> > > at System.Data. DataTable. EndLoadData( )
> > > at Epicor.Mfg.Pro. Convert.copyData Table(DataTable sourceDT,
DataTable targetDT
> > >
> > > --- In vantage@yahoogroups .com, "Mark Wonsil" <mark_wonsil@ ...>
wrote:
> > > >
> > > > vantage@yahoogroups .com wrote:
> > > > > Ire-ran coversion programs 100, 130, 140 & 150 again and it
> > > > > didn't solve the issue for us.
> > > >
> > > > Would you please repost the error message that you're getting?
> > > >
> > > > Thanks,
> > > >
> > > > Mark W.
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
Tory wrote:
>
> We still have this issue and have not been able to resolve it to date.
>
> We are currently running 9.04.504b.
>

Same here. 504B has brought us a slew of new issues:

- Configurator takes ten minutes to finish a Get Details after the Input
Phase
- Can't invoice Sales Kits or Serialized Parts
- Can't put multiple G/L lines on a AP Voucher
- Various printing issues including this one

504A breaks Mass Issue if you don't have AMM.

Mark W.
We just put 504B on a test machine so I havent done much testing yet, but all of our parts are serialized. What happens when you try to invoice a serialized part? Is the error during Get Shipments in AP Invoice Entry?

--- On Thu, 9/10/09, Mark Wonsil <mark_wonsil@...> wrote:


From: Mark Wonsil <mark_wonsil@...>
Subject: RE: [Vantage] Re: Epicor 9.04.504 Printing Errors
To: vantage@yahoogroups.com
Date: Thursday, September 10, 2009, 7:46 PM


Â



Tory wrote:
>
> We still have this issue and have not been able to resolve it to date.
>
> We are currently running 9.04.504b.
>

Same here. 504B has brought us a slew of new issues:

- Configurator takes ten minutes to finish a Get Details after the Input
Phase
- Can't invoice Sales Kits or Serialized Parts
- Can't put multiple G/L lines on a AP Voucher
- Various printing issues including this one

504A breaks Mass Issue if you don't have AMM.

Mark W.



















[Non-text portions of this message have been removed]
vantage@yahoogroups.com wrote:
> We just put 504B on a test machine so I havent done much
> testing yet, but all of our parts are serialized. What
> happens when you try to invoice a serialized part? Is the
> error during Get Shipments in AP Invoice Entry?

I was out of the office today so I didn't see it first hand - I just got a
bazillion emails and one of them said that she can't print Invoices with
Sales Kits on them and JOBS won't close if they have Serial Numbers on them.
The person who closes jobs also invoices, so I got the two mixed up in my
previous email. Sorry about that.

The other Mark W.