error running install_appeon_cache SQL SERVER

1
0
-1

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.

 

 

Question Tags: 

Answers

Chris Pollach answered error running install_appeon_cache SQL SERVER

1
0
-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

slachevsky@gmail.com's picture

Hello Chris.

we try using the command line and now we get this error:

>  Msg 2103, Level 15, State 1, Procedure tmp_factor, Line 1
>  Cannot create trigger 'appeonTr_cij.tmp_factor' because its schema
> is different from the schema of the target table or view.
>  @v_isNew = 1 || @v_newobjs = -1

Chris Pollach's picture

BTW: What version of SS are you using?

slachevsky@gmail.com's picture
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
 
Chris Pollach's picture

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.