Hello, I'm tying to use the NCOA Proccessing utility/reort to create an export file.
I fill out all of the required fields, as well as some of the optional ones, but no matter what values I choose, Tessitura always gives me the following error...
"Retrieve argument 6 does not match expected type"
It's pretty vague, I thought maybe that refered to the 6th paremeter on the list (Include Address Types) but after playing around with various combinations, I don't think the "6" has anything to do with that.
Has anyone seen an error like this? Not sure what I should do to get this export to work correctly.
Porter Venn, San Francisco Opera.
Hi Porter,
Good day.
based on info from d_ncoa_process and info from [dbo].[AP_NCOA_PROCESS],
this is a bug.
execute dbo.AP_NCOA_PROCESS;1 @cAction = :cAction, @lNCOASession = :lNCOASession, @sExportFileName = :sExportFileName, @sImportFileName = :sImportFileName, @nLimitToCountry = :nLimitToCountry, @nIncludeList = :nIncludeList, @nExcludeList = :nExcludeList, @sIncludeConstituencySet = :sIncludeConstituencySet, @sExcludeConstituencySet = :sExcludeConstituencySet, @lBeginningCustomerNo = :lBeginningCustomerNo, @cAddressFormat = :cAddressFormat, @cTelephoneAppend = :cTelephoneAppend, @nPhoneType = :nPhoneType, @nPhoneTypeApp = :nPhoneTypeApp, @cRemoveUnconfirmedPhone = :cRemoveUnconfirmedPhone
ALTER PROCEDURE [dbo].[AP_NCOA_PROCESS] (@cAction char(1), -- E)xport, I)mport, P)rocess@lNCOASession int = 0,@sExportFilename varchar(255) = NULL,@sImportFilename varchar(255) = NULL,@nLimitToCountry int = 1,@sAddressType varchar(255) = NULL, -- RAP FP1340. Use null to include all address_types@nIncludeList int = 0,@nExcludeList int = 0,@sIncludeConstituencySet varchar(255) = NULL,@sExcludeConstituencySet varchar(255) = NULL,@lBeginningCustomerNo int = 1,@cAddressFormat char(1) = 'S',@cTelephoneAppend char(1) = 'Y',@nPhoneType int = 1,@nPhoneTypeApp int = 1,@cRemoveUnconfirmedPhone char(1) = 'N',@cDebug char(1) = 'N')
have fun
Ben
Thanks for the tips guys, yup it looks like a bug. I'm going to submit a TASK ticket.
Porter