Tag Info

New answers tagged

0

The application now is stable again. As a first step the innodb_thread_concurrency was reduced 2 * number of cores. That seems to reduce the problem slightly. But in the end the statement that the Magento-Shop has issued has been replace by a simpler statement that is adequate for the special situation of the concrete shop. The shop uses only one ...


1

I am not able to reproduce the issue with the code you have given. Am getting only one warning message in the line UPDATE #tmpImportData SET group_id = CAST(group_id_text AS INT) like invalid column name group_id(its because the column is added to the temp table dynamically) Can you recheck whether you are getting the issue with code you have given in ...


3

You need to perform the update in dynamic SQL too (or just create the table with all columns in the first place). The error is happening because the update with the new column is being parsed before the dynamic SQL has run. As an aside, you are probably only getting this error if you try to execute the stored procedure and choose 'Display estimated ...



Top 50 recent answers are included