Ik wil massaal verkoopfacturen aanmaken in Exact Online met het volgende statement, waarbij de tabel temp_invoices@sql een tabel is met de gegevens van facturen:
use DIVISIONCODE@eol
begin transaction
insert into ExactOnlineREST..SalesInvoices@eol
( InvoiceTo
, InvoiceToContactPerson
, DeliverTo
, OrderedBy
, YourRef
, Description
, Currency
, InvoiceDate
, Journal
, Type
)
select pie.InvoiceInvoiceToId
, pie.InvoiceToContactPerson
, pie.InvoiceDeliverToId
, pie.InvoiceOrderedBy
, pie.InvoiceYourRef
, pie.InvoiceDescription
, pie.InvoiceCurrency
, pie.InvoiceDate
, pie.InvoiceJournal
, pie.InvoiceType
from temp_invoices@sql pie
identified by pie.InvoiceIdentifiedBy
insert into ExactOnlineREST..SalesInvoiceLines@eol
( StartTime
, EndTime
, Item
, Quantity
, Description
)
select to_date('${NEXT_YEAR}0101', 'YYYYMMDD')
, to_date('${NEXT_YEAR}1231', 'YYYYMMDD')
, itm.Id
, pie.InvoiceQuantity
, pie.InvoiceLineDescription
from temp_invoices@sql pie
join ExactOnlineREST..Items@eol itm
on itm.Code = pie.InvoiceItemCode
attach to pie.InvoiceIdentifiedBy
commit
De transactiegewijze insert op ExactOnlineREST..SalesInvoices faalt met:
itgensql697
Missing expression name.
met call stack:
InvantiveSystemException
at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Nullable1 isRecoverable, String poolIdentityId, String url, Nullable1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId) at Invantive.Basics.InvantiveSystemException..ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Boolean isRecoverable, String poolIdentityId, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
at Invantive.Sql.V1.ProjectionIterator.<>c__DisplayClass2_0.b__0(AggregationMetadata , Int32 )
at System.Linq.Enumerable.d__52.MoveNext() at System.Linq.Enumerable.<ConcatIterator>d__591.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext() at System.Linq.Buffer1..ctor(IEnumerable1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable1 source)
at Invantive.Sql.V1.FirehoseResultSet.QualifyFields(GlobalState owner, ExecutionOptions executionOptions, String scope, IEnumerable1 fields) at Invantive.Sql.V1.ProjectionIterator..ctor(GlobalState owner, ExecutionOptions executionOptions, IProviderManager manager, FirehoseResultSet sourceFirehoseResultSet, AggregationMetadata[] selectParts) at Invantive.Sql.V1.SelectStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SparseArrayPool sparseArrayPool, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.InsertStatementTree.<Fetch>d__37.MoveNext() at Invantive.Data.CompressedEnumerable1.d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.d__71.MoveNext()
…
Dit werkte wel onder 24.0, maar blijkbaar niet meer in 25.0.141.
Hoe los ik dit op?