This might be becuase of changing the quote symbol name (from your previous post). The loader program and initial load from the installer not only load quote symbols, but also load a default number of holdings for each user; and the holding table contains the quote symbol---so if that symbol is no longer present, will be unable to locate it in the table to calculate current holding value, etc. No exceptions like these are trapped, by design, such that 500 errors are thrown back to the http client such that benchmarking software will show any such issues as errors.
If you want to change the way the quote data is loaded, here is a better strategy:
1) Use SQL Server Management studio to open a query windows against stocktraderdb. 2) Perform the following commands:
-DELETE FROM QUOTES -DELETE FROM ORDERS -DELETE FROM HOLDINGS
3) Load your new quote symbols 4) Now place orders against these new symbols as desired; all should be well, although no existing users will have any orders or holdings.
-Greg Greg Leake, Microsoft |