Error when using the NCOA Processing Utility

Former Member
Former Member $organization

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.

 

 

 

Parents
  • Hi Porter

    It normally means there's a mismatch of data types between how Parameter 6 (in this case) is defined in the Report Setup utility (a string) and what Infomaker expects the parameter to be (integer, string, datetime).

    I have looked at the Infomaker object as it stands in the Tessitura Version 9 library and it looks as if the Include Address Types parameter is missing completely (open the Infomaker report, right click on the Column Specifications panel, select Stored Procedure, then click on Arguments).

    Looks like this is the culprit. Parameter 6 in the Infomaker object (nIncludeList) is an integer while the Address Type parameter being passed is a string.

    Might need to escalate this to Tessitura Help Desk.

    Regards

    David Joyce

Reply
  • Hi Porter

    It normally means there's a mismatch of data types between how Parameter 6 (in this case) is defined in the Report Setup utility (a string) and what Infomaker expects the parameter to be (integer, string, datetime).

    I have looked at the Infomaker object as it stands in the Tessitura Version 9 library and it looks as if the Include Address Types parameter is missing completely (open the Infomaker report, right click on the Column Specifications panel, select Stored Procedure, then click on Arguments).

    Looks like this is the culprit. Parameter 6 in the Infomaker object (nIncludeList) is an integer while the Address Type parameter being passed is a string.

    Might need to escalate this to Tessitura Help Desk.

    Regards

    David Joyce

Children
No Data