This is just a guess, but is your number_key column nullable? It would appear from the error message that it fetched a NULL value, which perhaps it would have choked on while performing the modulus function.

Or, perhaps like you said, it may be attempting to select from a system table or view that I may not have access to. I don't think anyone here as access to the source code either. The required database privileges are well documented. If you want to do your homework in that area, just search. Good luck!

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius

Tell/Ask your DBA to partition your dev table since prod is partitioned. I dislike the fact that dev and prod are not mirrors in terms of setup. Unless of course you are testing a new aspect in dev and it has not migrated to prod yet.

True that DEV will most likely not have the same volume of data as prod, but your interaction with the tables should be similar. You should not write special code in dev vs prod. Should work in both.

Add To FavoritesView next topicView previous topic
You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forum