Help with Error

Epicor ERP 10
1

Hoping that someone else has come across this before as I am clueless on where to look. I get this when I try to run a report that I made with an RDD made up of BAQs. Thanks in advance.

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.InvalidCastException: Failed to convert parameter value from a Int64 to a Byte[]. ---> System.InvalidCastException: Invalid cast from 'System.Int64' to 'System.Byte[]'.
   at System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider)
   at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming)
   --- End of inner exception stack trace ---
   at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming)
   at System.Data.SqlClient.SqlParameter.GetCoercedValue()
   at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc)
   at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParameterCollection parameters, Boolean includeReturnValue)
   at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior, String commandText, SqlParameterCollection parameters, _SqlRPC& rpc)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Ice.Core.RptBase.BaqDataWriter.WriteTable(QueryRef queryRef, IDataReader dataReader) in C:\_Releases\ICE\UD10.2.500.6FW\Source\Server\Internal\Lib\TaskLib\RptBase\BaqDataWriter.cs:line 63
   at Ice.Core.RptBase.BaqDataWriter.WriteTables(HierarchicalQueryResult queryResults) in C:\_Releases\ICE\UD10.2.500.6FW\Source\Server\Internal\Lib\TaskLib\RptBase\BaqDataWriter.cs:line 48
   at Ice.Core.RptBase.BaqDataWriter.WriteTables() in C:\_Releases\ICE\UD10.2.500.6FW\Source\Server\Internal\Lib\TaskLib\RptBase\BaqDataWriter.cs:line 44
   at Ice.Core.RptBase.ReportDataBuilderBase.XMLClose() in C:\_Releases\ICE\UD10.2.500.6FW\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDataBuilderBase.cs:line 230
   at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in C:\_Releases\ICE\UD10.2.500.6FW\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 91
   at Ice.Core.RptTaskBase`1.XMLClose() in C:\_Releases\ICE\UD10.2.500.6FW\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 229
   at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:\_Releases\ICE\UD10.2.500.6FW\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 83
   at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:\_Releases\ICE\UD10.2.500.6FW\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 117
   at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_Releases\ICE\UD10.2.500.6FW\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 59
   at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:\_Releases\ICE\RL10.2.500.0FW\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
   at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:\_Releases\ICE\RL10.2.500.0FW\Source\Server\Services\Lib\RunTask\RunTask.cs:line 452
2

In case anyone else comes across this error.

I found that it was one of my BAQs that was causing it and looked at the columns that were included. One of them was SysRevID and once I removed it, it ran fine.

1 Like