Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > Products are getting SQL error View modes: 
User avatar
Certified Developer v7
Certified  Developer v7
Gitesh - 2/13/2011 2:55:24 PM
   
Products are getting SQL error
Hi,

I have created some products and I don't want it any more.
But when I click on a product it gives me this error:

"[DataConnection.ExecuteQuery]: Query: SELECT TOP 1 * FROM View_NewtonSeed_Product_Joined WHERE (((SiteName = N'newtonseed') AND (DocumentCulture = N'en-us')) AND (NodeAliasPath = N'/Products/Vegetable-Seeds/Tomatoes/Tomato--Currant-Sweet-Pea-(Organic)')) : caused exception: Invalid object name 'NewtonSeed_Product'.
Could not use view or function 'View_NewtonSeed_Product_Joined' because of binding errors."

Ans also I can't delete the product because of it.

Can someone help me please?

Thanks
Gitesh Shah

User avatar
Kentico Consulting
Kentico Consulting
kentico_borisp - 2/14/2011 3:15:39 AM
   
RE:Products are getting SQL error
Hello,

Could you please try to refresh the mentioned view in the database? The syntax below should work:

sp_refreshview 'View_NewtonSeed_Product_Joined'

For more information please check the following article.

Best regards,
Boris Pocatko

User avatar
Certified Developer v7
Certified  Developer v7
Gitesh - 2/14/2011 2:39:41 PM
   
RE:Products are getting SQL error
Hi Boris,

Thanks for your help.

I tried doing that but it didn't help.

Then I also tried adding a simple SQL Select statement"
SELECT * FROM View_NewtonSeed_Product_Joined"

and it gave me the following error:
"Msg 208, Level 16, State 1, Line 1
Invalid object name 'NewtonSeed_Product'.
Msg 4413, Level 16, State 1, Line 1
Could not use view or function 'View_NewtonSeed_Product_Joined' because of binding errors.
"

May be if this is helpful to you in answering.

Cheers
Gitesh Shah

User avatar
Kentico Consulting
Kentico Consulting
kentico_borisp - 2/23/2011 10:38:50 AM
   
RE:Products are getting SQL error
Hello,

Could you please check if the mentioned table is in the database present?
Could you please let me know what database schema are you using? Is it the same on every table?

Best regards,
Boris Pocatko