Due to scheduled maintenance, some areas of our site are currently inaccessible. Thank you for your patience.

Please reach out to sales@eonesolutions.com with any questions.


Map hangs when using a GP Rolling Column

Published: Dec 08, 2011
Post Author Written by David Youngquist

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

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.