Quote Print Preview on Epicor ERP10

Epicor ERP 10
1

when print previewing our customer quote we get an error in the system monitor im hoping someone also has had a similar issue

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: SysRowID
Stack Trace:
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at Ice.Core.RptBase.OutputRelationDataWriter.WriteRowsForKeyValues(IDataReader reader, IList1 keyParameters, IDataSource relatedTable, Object[] keyValues) in C:\_Releases\ICE\ICE3.2.400.23\Source\Server\Internal\Lib\TaskLib\RptBase\OutputRelationDataWriter.cs:line 112 at Ice.Core.RptBase.OutputRelationDataWriter.WriteRowsForKeyValues(IDbCommand sqlCommand, IList1 keyParameters, IDataSource relatedTable, Object[] keyValues) in C:_Releases\ICE\ICE3.2.400.23\Source\Server\Internal\Lib\TaskLib\RptBase\OutputRelationDataWriter.cs:line 84
at Ice.Core.RptBase.OutputRelationDataWriter.WriteRows(IDbCommand sqlCommand, IList1 keyParameters, IDataSource relatedTable, UniqueKeyCollection relationKeys) in C:\_Releases\ICE\ICE3.2.400.23\Source\Server\Internal\Lib\TaskLib\RptBase\OutputRelationDataWriter.cs:line 163 at Ice.Core.RptBase.OutputRelationDataWriter.WriteTable(DataSourceRelationship relationship, IDataSource relatedTable, DataColumnCollection keyColumns, UniqueKeyCollection keyValues) in C:\_Releases\ICE\ICE3.2.400.23\Source\Server\Internal\Lib\TaskLib\RptBase\OutputRelationDataWriter.cs:line 190 at Ice.Core.RptBase.OutputRelationDataWriter.WriteTables() in C:\_Releases\ICE\ICE3.2.400.23\Source\Server\Internal\Lib\TaskLib\RptBase\OutputRelationDataWriter.cs:line 44 at Ice.Core.RptBase.ReportDataBuilderBase.XMLClose() in C:\_Releases\ICE\ICE3.2.400.23\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDataBuilderBase.cs:line 229 at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in C:\_Releases\ICE\ICE3.2.400.23\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 91 at Ice.Core.RptTaskBase1.XMLClose() in C:_Releases\ICE\ICE3.2.400.23\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 229
at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ICE\ICE3.2.400.23\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 47
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_Releases\ICE\ICE3.2.400.23\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 98
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_Releases\ICE\ICE3.2.400.23\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 57
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_Releases\ICE\ICE3.2.400.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_Releases\ICE\ICE3.2.400.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 592

2

When trouble shooting reports, the first thing to do is try it with the built-in style (it typically shows as “Standard - SSRS”). If that works then the issue is in your report’s RDD or it RDL

If the standard doesn’t work, try changing some of the options.

1 Like
3

so i took the REPORT DATABASE: 5b0b7c1de89f4820850b61a04bf2fc98 and placed it in standard and did not work however if i print preview it in standard it works also our custom one works back in test how can i transfer that to live ?

4

Depending on how your Apps were setup in EAC, your live and test environements might use different DB’s and datasource settings. If that is the case, then data generated in the test environment isn’t available to your live environment.

Do the standard and custom reports use the same RDD?

Or was a customized RDD made, and then specified on the custom report style?

5

Hello,

The custom report runs off its own data definition

6

The RDD’s for that report (the one in Live and the One in Test) are identical?

Were any UD fields added to related tables in the Test environment, that haven’t been added in Live yet? If there were UD fields added, has the Live environment has the “Regenerate Data Model” been performed?

7

I know a few weeks ago our server had an issue and we had to regen the data model on live and it’s stopped working since