Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved error running install_appeon_cache SQL SERVER

  1. Issue
0
Votes
Undo
  1. Andres Slachevsky
    Andres Slachevsky
  2. PowerServer 2020 or older (Obsolete)
  3. Wednesday, 13 June 2018 12:17 PM UTC

Hello All
Running install_appeon_cache_MSSQL

I have this error in all the databases:
Mens 4121, Nivel 16, Estado 1, Procedimiento appeon_procdataobjects, Línea 18
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.AppeonF_ViewMapTable", or the name is ambiguous.
 

i am connected thru the SQL Management Studio as a Owner of the database.

 

 

  1. PowerServer
Which config file is used by appeondotnetcomponent...
If i want to deploy my app, why do i have to start...
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 13 June 2018 14:21 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Andres;

   Have you tried running this script through the iSQL command line vs SSMS? Sometimes we see that one of these mechanisms works whereas the other does not. It seems to be related to either SS configuration, the presence of other DBMS and/or DB tools installed.

Regards ... Chris

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 14 June 2018 14:26 PM UTC
BTW: What version of SS are you using?

  1. Helpful
Andres Slachevsky
  1. Andres Slachevsky
  2. Friday, 15 June 2018 12:39 PM UTC
Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )



This is the version i used in the development server.



Microsoft Data Access Components (MDAC) 6.1.7601.17514 (win7sp1_rtm.101119-1850)



Microsoft MSXML 3.0 5.0 6.0 



Microsoft Internet Explorer 9.11.9600.18638



Microsoft .NET Framework 2.0.50727.5485



Sistema operativo 6.1.7601



 



the second time was executed in the prod server by our DBA (i do not have access to the prod server)

running the application it shows no error in the Appeon Error log after running the scripts and set the Datawindow cache in the AEM



 

  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 15 June 2018 17:00 PM UTC
Ahhh .. then the iSQL script's execution probably replies on the fact that the DB User running the script must have DBA & DBO rights (which your DB ID probably does not.

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.