Hi I am getting Error executineg query. Error in advanced query , Unknown column error when executing the SQL advanced query, This is working as expected in dev environment but in testing environment its not working. I checked the connection string and its fine and alsp checked the column name in table and the column name is present. I caompared the code with Developer environment and to that of testing environment and the code is also not having nay issues and its ditto, like to know how to resolve this environment issue ?
Thanks and Regards,
Ramya
Hi,
Can you please check the service centre log.in service center log you can identify which column is missing.
Thanks
Cv
hallo @Ramya somashekaraiah ,
in case table and column is same both environment , can you check in dependance if there are any out of date .
Hi @Ramya somashekaraiah
try to execute executing query in database.
Hi Ramya,
What you'd typically do is load the module in Service Studio in the environment where it goes wrong (if it's not production, you can't test queries in production), make a copy of the query, and comment out or remove parts of the query to nail down what causes the problem.
Since your query is executed on an external database and you have access to that server, try using SQL Profiler on the database connected to the test environment to capture the actual SQL statement that was executed. This should help identify the issue.
btw do verify that your extension is using the correct Database connection.