When running a map that uses a GP Rolling Column, the map hangs up and never finishes processing. If you look in the Windows event viewer, you will see one of 2 possible errors:
1. ‘Could not find stored procedure ‘TWO.dbo.E1_SC_GetNextNumber”
2. ‘Could not retrieve the next number in the sequence’
If you run the map from Excel, you will get this error:
1. SmartConnect Webservice: Error Could not retrieve the next number in the sequence.
This is caused when the E1_SC_GetNextNumber procedure does not get created, or does not get proper permissions set to it. This can be resolved by downloading and running the attached script: E1_SC_GetNextNumber
