0

Union to TreeJoin results in error

I have a dataflow with multiple tree joins and I'm trying to use a Centerprise Union item as one of the sources for the tree join. When I run the process, I get the following error. If I replace the Union item with its SQL equivalent the process completes successfully.

Status: TerminatedDueToError

Error Message
bad parameter or other API misuse
not an error

Error Stack
   at Astera.Database.DbProviderBase.ExecuteNonQuery(IDbCommand command)
   at Astera.Transfer.Dataflow.TreeJoinProcessor.ProcessRight(IDataflowTask task)
   at Astera.Transfer.Dataflow.JoinProcessorBase.Process(IDataflowTask task)

Additional Info: INSERT INTO Sorter (Field_0,Field_1,Field_2,Field_3,Field_4,Data) VALUES (?,?,?,?,?,?)

Message : bad parameter or other API misuse
not an error

Product Version: 8.5.4.889
OS Info: Microsoft Windows NT 6.2.9200.0

Exception Class Name: Astera.Core.DbProviderException

Stacktrace:    at Astera.Database.DbProviderBase.ExecuteNonQuery(IDbCommand command)
   at Astera.Transfer.Dataflow.TreeJoinProcessor.ProcessRight(IDataflowTask task)
   at Astera.Transfer.Dataflow.JoinProcessorBase.Process(IDataflowTask task)

0 comments

Please sign in to leave a comment.