Difference between revisions of "COUNT field incorrect"
Jump to navigation
Jump to search
Doug.Gracie (talk | contribs) (Created page with "==Issue== You get an ConnectR error from a superset saying something like: Stored Procedure ExtractOrderItem_CMS, EventSequenceID: 15686, Error: SQL State 07001, Native Error ...") |
John.Buckley (talk | contribs) |
||
Line 1: | Line 1: | ||
+ | [[Category:ConnectR]] | ||
==Issue== | ==Issue== | ||
You get an ConnectR error from a superset saying something like: Stored Procedure ExtractOrderItem_CMS, EventSequenceID: 15686, Error: SQL State 07001, Native Error 0, Message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error | You get an ConnectR error from a superset saying something like: Stored Procedure ExtractOrderItem_CMS, EventSequenceID: 15686, Error: SQL State 07001, Native Error 0, Message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error |
Latest revision as of 20:00, 26 November 2012
Issue
You get an ConnectR error from a superset saying something like: Stored Procedure ExtractOrderItem_CMS, EventSequenceID: 15686, Error: SQL State 07001, Native Error 0, Message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
Reasons
- Your parameters don't match up in your ConnectR mesasge definition and your stored procedure in the works database.
- Execute permissions are not granted to idxusers role on stored procedure
Resolution
Parameters don't match up
- In the works DB in SQL studio type the name of the SP, in this case : ExtractOrderItem_CMS and highlight it and press alt f1, this will tell you how many parameters the SP has.
- Go to the message definition for the offending message and see how many parameters it has(the first 11 will not be visible since they are inputs).
- Make the connectR message definition parameters match up, in this case the WRONG parameter needs to be removed, do this by highlighting the row and clicking delete on your keyboard.
- Re-File the message.