Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

error aserep.sh invalid column name 'action'

6 posts in replicator Last posting was on 2005-05-24 19:15:44.0Z
Leandro Rennó Posted on 2005-05-19 17:50:55.0Z
Sender: 8bb.4280bb28.1804289383@sybase.com
From: Leandro Rennó
Newsgroups: sybase.public.ase.replicator
Subject: error aserep.sh invalid column name 'action'
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <428cd1fb.1b08.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-2-dub428cd1fb"
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 19 May 2005 10:50:51 -0700, 10.22.241.42
Lines: 537
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 May 2005 10:50:52 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 May 2005 10:50:55 -0700
X-Trace: forums-1-dub 1116525055 10.22.108.75 (19 May 2005 10:50:55 -0700)
X-Original-Trace: 19 May 2005 10:50:55 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:75
Article PK: 103322

I executed aserep.sh for a replication and got the following
error: (attached system.log and trace.log)


ASE Replicator/12.5.2//P/generic/JDK 1.3.1/main/301/VM: Sun
Microsystems Inc. 1.3.1_10/OPT/Fri Mar 12 17:18:28 MST 2004

Confidential property of Sybase, Inc.
(c) Copyright Sybase Inc. 1998-2004
All rights reserved.
Use, duplication, or disclosure by the United States
Government
is subject to restrictions as set forth in FAR subparagraphs
52.227-19 (a)-(d) for civilian agency contracts and DFARS
252.227-7013
(c)(1)(ii) for Department of Defense contracts. Sybase
reserves all
unpublished rights under the copyright laws of the United
States.
Sybase, Inc., One Sybase Drive, Dublin, CA 94568-7902

ASE Replicator requesting Java Virtual Machine exit with
message: ASE Replicator initialization error in component
<DDBAdmin>. Component message: Error encountered checking
environement: S0022: Invalid column name 'action'.

ASE Replicator initialization error in component <DDBAdmin>.
Component message: Error encountered checking environement:
S0022: Invalid column name 'action'.


Victoria Handros Posted on 2005-05-19 19:40:16.0Z
Message-ID: <428CEBA0.97EF66DE@sybase.com>
From: Victoria Handros <vhandros@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.replicator
Subject: Re: error aserep.sh invalid column name 'action'
References: <428cd1fb.1b08.1681692777@sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vhandros2k.sybase.com
X-Original-NNTP-Posting-Host: vhandros2k.sybase.com
Date: 19 May 2005 12:40:16 -0700
X-Trace: forums-1-dub 1116531616 10.22.85.220 (19 May 2005 12:40:16 -0700)
X-Original-Trace: 19 May 2005 12:40:16 -0700, vhandros2k.sybase.com
Lines: 51
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:76
Article PK: 103323

Hi Leandro,
Replicator is trying to verify that it's system user has "Create Table" and "Create
Procedure" permission in the Distribution Database. In order to do that, it executes
'sp_helprotect' stored procedure and examines the results. It can't find the 'action'
column in the query's result set.

I would execute the stored procedure outside of Replicator and check the results.

Thanks,
Victoria.

Leandro, Rennó wrote:

> I executed aserep.sh for a replication and got the following
> error: (attached system.log and trace.log)
>
> ASE Replicator/12.5.2//P/generic/JDK 1.3.1/main/301/VM: Sun
> Microsystems Inc. 1.3.1_10/OPT/Fri Mar 12 17:18:28 MST 2004
>
> Confidential property of Sybase, Inc.
> (c) Copyright Sybase Inc. 1998-2004
> All rights reserved.
> Use, duplication, or disclosure by the United States
> Government
> is subject to restrictions as set forth in FAR subparagraphs
> 52.227-19 (a)-(d) for civilian agency contracts and DFARS
> 252.227-7013
> (c)(1)(ii) for Department of Defense contracts. Sybase
> reserves all
> unpublished rights under the copyright laws of the United
> States.
> Sybase, Inc., One Sybase Drive, Dublin, CA 94568-7902
>
> ASE Replicator requesting Java Virtual Machine exit with
> message: ASE Replicator initialization error in component
> <DDBAdmin>. Component message: Error encountered checking
> environement: S0022: Invalid column name 'action'.
>
> ASE Replicator initialization error in component <DDBAdmin>.
> Component message: Error encountered checking environement:
> S0022: Invalid column name 'action'.
>
> ------------------------------------------------------------------------
> Name: system.log
> system.log Type: Text Document (application/x-unknown-content-type-txtfile)
> Encoding: base64
>
> Name: trace.log
> trace.log Type: Text Document (application/x-unknown-content-type-txtfile)
> Encoding: base64


Leandro Rennó Posted on 2005-05-19 20:25:40.0Z
Sender: 65f7.428cf1d9.1804289383@sybase.com
From: Leandro Rennó
Newsgroups: sybase.public.ase.replicator
Subject: Re: error aserep.sh invalid column name 'action'
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <428cf644.661b.1681692777@sybase.com>
References: <428CEBA0.97EF66DE@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 May 2005 13:25:40 -0700
X-Trace: forums-1-dub 1116534340 10.22.241.41 (19 May 2005 13:25:40 -0700)
X-Original-Trace: 19 May 2005 13:25:40 -0700, 10.22.241.41
Lines: 128
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:77
Article PK: 103325

Hi Victoria,

I executed stored procedure sp_helprotect that he returned
me the following result: (the action column exists)

grantor,grantee,type,action,object,column,grantable
'dbo','public','Grant','Execute','sp_aux_getsize','All','FALSE'
'dbo','public','Grant','Execute','sp_configure','All','FALSE'
'dbo','public','Grant','Execute','sp_dboption','All','FALSE'
'dbo','public','Grant','Execute','sp_dropdevice','All','FALSE'
'dbo','public','Grant','Execute','sp_getmessage','All','FALSE'
'dbo','public','Grant','Execute','sp_procxmode','All','FALSE'
'dbo','public','Grant','Execute','sp_validlang','All','FALSE'
'dbo','public','Grant','Select','ijdbc_function_escapes','All'
,'FALSE'
'dbo','public','Grant','Select','jdbc_function_escapes','All'
,'FALSE'
'dbo','public','Grant','Select','spt_ijdbc_conversion','All'
,'FALSE'
'dbo','public','Grant','Select','spt_ijdbc_mda','All','FALSE'
'dbo','public','Grant','Select','spt_ijdbc_table_types','All'
,'FALSE'
'dbo','public','Grant','Select','spt_jdbc_conversion','All','FALSE'
'dbo','public','Grant','Select','spt_jdbc_table_types','All'
,'FALSE'
'dbo','public','Grant','Select','spt_jtext','All','FALSE'
'dbo','public','Grant','Select','spt_limit_types','All','FALSE'
'dbo','public','Grant','Select','spt_mda','All','FALSE'
'dbo','public','Grant','Select','spt_monitor','All','FALSE'
'dbo','public','Grant','Select','spt_values','All','FALSE'
'dbo','public','Grant','Select','sysalternates','All','FALSE'
'dbo','public','Grant','Select','sysattributes','All','FALSE'
'dbo','public','Grant','Select','syscharsets','All','FALSE'
'dbo','public','Grant','Select','syscolumns','All','FALSE'
'dbo','public','Grant','Select','syscomments','All','FALSE'
'dbo','public','Grant','Select','sysconfigures','All','FALSE'
'dbo','public','Grant','Select','sysconstraints','All','FALSE'
'dbo','public','Grant','Select','syscurconfigs','All','FALSE'
'dbo','public','Grant','Select','sysdatabases','All','FALSE'
'dbo','public','Grant','Select','sysdatabases','crdate','FALSE'
'dbo','public','Grant','Select','sysdatabases','dbid','FALSE'
'dbo','public','Grant','Select','sysdatabases','def_remote_loc'
,'FALSE'
'dbo','public','Grant','Select','sysdatabases','def_remote_type'
,'FALSE'
'dbo','public','Grant','Select','sysdatabases','dumptrdate','FALSE'
'dbo','public','Grant','Select','sysdatabases','logptr','FALSE'
'dbo','public','Grant','Select','sysdatabases','name','FALSE'
'dbo','public','Grant','Select','sysdatabases','status','FALSE'
'dbo','public','Grant','Select','sysdatabases','status2','FALSE'
'dbo','public','Grant','Select','sysdatabases','status3','FALSE'
'dbo','public','Grant','Select','sysdatabases','status4','FALSE'
'dbo','public','Grant','Select','sysdatabases','suid','FALSE'
'dbo','public','Grant','Select','sysdatabases','version','FALSE'
'dbo','public','Grant','Select','sysdepends','All','FALSE'
'dbo','public','Grant','Select','sysdevices','All','FALSE'
'dbo','public','Grant','Select','sysindexes','All','FALSE'
'dbo','public','Grant','Select','sysjars','All','FALSE'
'dbo','public','Grant','Select','syskeys','All','FALSE'
'dbo','public','Grant','Select','syslanguages','All','FALSE'
'dbo','public','Grant','Select','syslocks','All','FALSE'
'dbo','public','Grant','Select','syslogins','accdate','FALSE'
'dbo','public','Grant','Select','syslogins','dbname','FALSE'
'dbo','public','Grant','Select','syslogins','fullname','FALSE'
'dbo','public','Grant','Select','syslogins','language','FALSE'
'dbo','public','Grant','Select','syslogins','logincount','FALSE'
'dbo','public','Grant','Select','syslogins','name','FALSE'
'dbo','public','Grant','Select','syslogins','procid','FALSE'
'dbo','public','Grant','Select','syslogins','pwdate','FALSE'
'dbo','public','Grant','Select','syslogins','resultlimit','FALSE'
'dbo','public','Grant','Select','syslogins','spacelimit','FALSE'
'dbo','public','Grant','Select','syslogins','srvname','FALSE'
'dbo','public','Grant','Select','syslogins','status','FALSE'
'dbo','public','Grant','Select','syslogins','suid','FALSE'
'dbo','public','Grant','Select','syslogins','timelimit','FALSE'
'dbo','public','Grant','Select','syslogins','totcpu','FALSE'
'dbo','public','Grant','Select','syslogins','totio','FALSE'
'dbo','public','Grant','Select','syslogs','All','FALSE'
'dbo','public','Grant','Select','sysmessages','All','FALSE'
'dbo','public','Grant','Select','sysobjects','cache','FALSE'
'dbo','public','Grant','Select','sysobjects','ckfirst','FALSE'
'dbo','public','Grant','Select','sysobjects','crdate','FALSE'
'dbo','public','Grant','Select','sysobjects','deltrig','FALSE'
'dbo','public','Grant','Select','sysobjects','expdate','FALSE'
'dbo','public','Grant','Select','sysobjects','id','FALSE'
'dbo','public','Grant','Select','sysobjects','indexdel','FALSE'
'dbo','public','Grant','Select','sysobjects','instrig','FALSE'
'dbo','public','Grant','Select','sysobjects','loginame','FALSE'
'dbo','public','Grant','Select','sysobjects','name','FALSE'
'dbo','public','Grant','Select','sysobjects','objspare','FALSE'
'dbo','public','Grant','Select','sysobjects','schemacnt','FALSE'
'dbo','public','Grant','Select','sysobjects','seltrig','FALSE'
'dbo','public','Grant','Select','sysobjects','sysstat','FALSE'
'dbo','public','Grant','Select','sysobjects','sysstat2','FALSE'
'dbo','public','Grant','Select','sysobjects','type','FALSE'
'dbo','public','Grant','Select','sysobjects','uid','FALSE'
'dbo','public','Grant','Select','sysobjects','updtrig','FALSE'
'dbo','public','Grant','Select','sysobjects','userstat','FALSE'
'dbo','public','Grant','Select','sysobjects','versionts','FALSE'
'dbo','public','Grant','Select','syspartitions','All','FALSE'
'dbo','public','Grant','Select','sysprocedures','All','FALSE'
'dbo','public','Grant','Select','sysprocesses','All','FALSE'
'dbo','public','Grant','Select','sysprotects','All','FALSE'
'dbo','public','Grant','Select','sysqueryplans','All','FALSE'
'dbo','public','Grant','Select','sysreferences','All','FALSE'
'dbo','public','Grant','Select','sysremotelogins','All','FALSE'
'dbo','public','Grant','Select','sysresourcelimits','All','FALSE'
'dbo','public','Grant','Select','sysroles','All','FALSE'
'dbo','public','Grant','Select','syssegments','All','FALSE'
'dbo','public','Grant','Select','sysservers','All','FALSE'
'dbo','public','Grant','Select','sysstatistics','All','FALSE'
'dbo','public','Grant','Select','systabstats','All','FALSE'
'dbo','public','Grant','Select','systhresholds','All','FALSE'
'dbo','public','Grant','Select','systimeranges','All','FALSE'
'dbo','public','Grant','Select','systransactions','All','FALSE'
'dbo','public','Grant','Select','systypes','All','FALSE'
'dbo','public','Grant','Select','sysusages','All','FALSE'
'dbo','public','Grant','Select','sysusermessages','All','FALSE'
'dbo','public','Grant','Select','sysusers','All','FALSE'
'dbo','public','Grant','Select','sysxtypes','All','FALSE'
'dbo','sso_role','Grant','Select','sysdatabases','All','FALSE'
'dbo','sso_role','Grant','Select','syslogins','All','FALSE'
'dbo','sso_role','Grant','Select','sysobjects','All','FALSE'



Thanks,
Leandro


Victoria Handros Posted on 2005-05-19 21:26:17.0Z
Message-ID: <428D0479.91244608@sybase.com>
From: Victoria Handros <vhandros@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.replicator
Subject: Re: error aserep.sh invalid column name 'action'
References: <428CEBA0.97EF66DE@sybase.com> <428cf644.661b.1681692777@sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vhandros2k.sybase.com
X-Original-NNTP-Posting-Host: vhandros2k.sybase.com
Date: 19 May 2005 14:26:17 -0700
X-Trace: forums-1-dub 1116537977 10.22.85.220 (19 May 2005 14:26:17 -0700)
X-Original-Trace: 19 May 2005 14:26:17 -0700, vhandros2k.sybase.com
Lines: 134
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:78
Article PK: 103324

Leandro,
did you execute 'sp_helprotect' against the Distribution Database? This
result
looks like master to me.

Leandro, Rennó wrote:

> Hi Victoria,
>
> I executed stored procedure sp_helprotect that he returned
> me the following result: (the action column exists)
>
> grantor,grantee,type,action,object,column,grantable
> 'dbo','public','Grant','Execute','sp_aux_getsize','All','FALSE'
> 'dbo','public','Grant','Execute','sp_configure','All','FALSE'
> 'dbo','public','Grant','Execute','sp_dboption','All','FALSE'
> 'dbo','public','Grant','Execute','sp_dropdevice','All','FALSE'
> 'dbo','public','Grant','Execute','sp_getmessage','All','FALSE'
> 'dbo','public','Grant','Execute','sp_procxmode','All','FALSE'
> 'dbo','public','Grant','Execute','sp_validlang','All','FALSE'
> 'dbo','public','Grant','Select','ijdbc_function_escapes','All'
> ,'FALSE'
> 'dbo','public','Grant','Select','jdbc_function_escapes','All'
> ,'FALSE'
> 'dbo','public','Grant','Select','spt_ijdbc_conversion','All'
> ,'FALSE'
> 'dbo','public','Grant','Select','spt_ijdbc_mda','All','FALSE'
> 'dbo','public','Grant','Select','spt_ijdbc_table_types','All'
> ,'FALSE'
> 'dbo','public','Grant','Select','spt_jdbc_conversion','All','FALSE'
> 'dbo','public','Grant','Select','spt_jdbc_table_types','All'
> ,'FALSE'
> 'dbo','public','Grant','Select','spt_jtext','All','FALSE'
> 'dbo','public','Grant','Select','spt_limit_types','All','FALSE'
> 'dbo','public','Grant','Select','spt_mda','All','FALSE'
> 'dbo','public','Grant','Select','spt_monitor','All','FALSE'
> 'dbo','public','Grant','Select','spt_values','All','FALSE'
> 'dbo','public','Grant','Select','sysalternates','All','FALSE'
> 'dbo','public','Grant','Select','sysattributes','All','FALSE'
> 'dbo','public','Grant','Select','syscharsets','All','FALSE'
> 'dbo','public','Grant','Select','syscolumns','All','FALSE'
> 'dbo','public','Grant','Select','syscomments','All','FALSE'
> 'dbo','public','Grant','Select','sysconfigures','All','FALSE'
> 'dbo','public','Grant','Select','sysconstraints','All','FALSE'
> 'dbo','public','Grant','Select','syscurconfigs','All','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','All','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','crdate','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','dbid','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','def_remote_loc'
> ,'FALSE'
> 'dbo','public','Grant','Select','sysdatabases','def_remote_type'
> ,'FALSE'
> 'dbo','public','Grant','Select','sysdatabases','dumptrdate','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','logptr','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','name','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','status','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','status2','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','status3','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','status4','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','suid','FALSE'
> 'dbo','public','Grant','Select','sysdatabases','version','FALSE'
> 'dbo','public','Grant','Select','sysdepends','All','FALSE'
> 'dbo','public','Grant','Select','sysdevices','All','FALSE'
> 'dbo','public','Grant','Select','sysindexes','All','FALSE'
> 'dbo','public','Grant','Select','sysjars','All','FALSE'
> 'dbo','public','Grant','Select','syskeys','All','FALSE'
> 'dbo','public','Grant','Select','syslanguages','All','FALSE'
> 'dbo','public','Grant','Select','syslocks','All','FALSE'
> 'dbo','public','Grant','Select','syslogins','accdate','FALSE'
> 'dbo','public','Grant','Select','syslogins','dbname','FALSE'
> 'dbo','public','Grant','Select','syslogins','fullname','FALSE'
> 'dbo','public','Grant','Select','syslogins','language','FALSE'
> 'dbo','public','Grant','Select','syslogins','logincount','FALSE'
> 'dbo','public','Grant','Select','syslogins','name','FALSE'
> 'dbo','public','Grant','Select','syslogins','procid','FALSE'
> 'dbo','public','Grant','Select','syslogins','pwdate','FALSE'
> 'dbo','public','Grant','Select','syslogins','resultlimit','FALSE'
> 'dbo','public','Grant','Select','syslogins','spacelimit','FALSE'
> 'dbo','public','Grant','Select','syslogins','srvname','FALSE'
> 'dbo','public','Grant','Select','syslogins','status','FALSE'
> 'dbo','public','Grant','Select','syslogins','suid','FALSE'
> 'dbo','public','Grant','Select','syslogins','timelimit','FALSE'
> 'dbo','public','Grant','Select','syslogins','totcpu','FALSE'
> 'dbo','public','Grant','Select','syslogins','totio','FALSE'
> 'dbo','public','Grant','Select','syslogs','All','FALSE'
> 'dbo','public','Grant','Select','sysmessages','All','FALSE'
> 'dbo','public','Grant','Select','sysobjects','cache','FALSE'
> 'dbo','public','Grant','Select','sysobjects','ckfirst','FALSE'
> 'dbo','public','Grant','Select','sysobjects','crdate','FALSE'
> 'dbo','public','Grant','Select','sysobjects','deltrig','FALSE'
> 'dbo','public','Grant','Select','sysobjects','expdate','FALSE'
> 'dbo','public','Grant','Select','sysobjects','id','FALSE'
> 'dbo','public','Grant','Select','sysobjects','indexdel','FALSE'
> 'dbo','public','Grant','Select','sysobjects','instrig','FALSE'
> 'dbo','public','Grant','Select','sysobjects','loginame','FALSE'
> 'dbo','public','Grant','Select','sysobjects','name','FALSE'
> 'dbo','public','Grant','Select','sysobjects','objspare','FALSE'
> 'dbo','public','Grant','Select','sysobjects','schemacnt','FALSE'
> 'dbo','public','Grant','Select','sysobjects','seltrig','FALSE'
> 'dbo','public','Grant','Select','sysobjects','sysstat','FALSE'
> 'dbo','public','Grant','Select','sysobjects','sysstat2','FALSE'
> 'dbo','public','Grant','Select','sysobjects','type','FALSE'
> 'dbo','public','Grant','Select','sysobjects','uid','FALSE'
> 'dbo','public','Grant','Select','sysobjects','updtrig','FALSE'
> 'dbo','public','Grant','Select','sysobjects','userstat','FALSE'
> 'dbo','public','Grant','Select','sysobjects','versionts','FALSE'
> 'dbo','public','Grant','Select','syspartitions','All','FALSE'
> 'dbo','public','Grant','Select','sysprocedures','All','FALSE'
> 'dbo','public','Grant','Select','sysprocesses','All','FALSE'
> 'dbo','public','Grant','Select','sysprotects','All','FALSE'
> 'dbo','public','Grant','Select','sysqueryplans','All','FALSE'
> 'dbo','public','Grant','Select','sysreferences','All','FALSE'
> 'dbo','public','Grant','Select','sysremotelogins','All','FALSE'
> 'dbo','public','Grant','Select','sysresourcelimits','All','FALSE'
> 'dbo','public','Grant','Select','sysroles','All','FALSE'
> 'dbo','public','Grant','Select','syssegments','All','FALSE'
> 'dbo','public','Grant','Select','sysservers','All','FALSE'
> 'dbo','public','Grant','Select','sysstatistics','All','FALSE'
> 'dbo','public','Grant','Select','systabstats','All','FALSE'
> 'dbo','public','Grant','Select','systhresholds','All','FALSE'
> 'dbo','public','Grant','Select','systimeranges','All','FALSE'
> 'dbo','public','Grant','Select','systransactions','All','FALSE'
> 'dbo','public','Grant','Select','systypes','All','FALSE'
> 'dbo','public','Grant','Select','sysusages','All','FALSE'
> 'dbo','public','Grant','Select','sysusermessages','All','FALSE'
> 'dbo','public','Grant','Select','sysusers','All','FALSE'
> 'dbo','public','Grant','Select','sysxtypes','All','FALSE'
> 'dbo','sso_role','Grant','Select','sysdatabases','All','FALSE'
> 'dbo','sso_role','Grant','Select','syslogins','All','FALSE'
> 'dbo','sso_role','Grant','Select','sysobjects','All','FALSE'
>
> Thanks,
> Leandro


Leandro Rennó Posted on 2005-05-23 21:37:38.0Z
Sender: 3249.42923041.1804289383@sybase.com
From: Leandro Rennó
Newsgroups: sybase.public.ase.replicator
Subject: Re: error aserep.sh invalid column name 'action'
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42924d22.335b.1681692777@sybase.com>
References: <428D0479.91244608@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 May 2005 14:37:38 -0700
X-Trace: forums-1-dub 1116884258 10.22.241.41 (23 May 2005 14:37:38 -0700)
X-Original-Trace: 23 May 2005 14:37:38 -0700, 10.22.241.41
Lines: 59
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:80
Article PK: 103326

Hi Victoria,

I executed stored procedure sp_helprotect (distribution
database) that he returned me the following result: (the
action column exists)

grantor,grantee,type,action,object,column,grantable
'dbo','public','Grant','Select','sysalternates','All','FALSE'
'dbo','public','Grant','Select','sysattributes','All','FALSE'
'dbo','public','Grant','Select','syscolumns','All','FALSE'
'dbo','public','Grant','Select','syscomments','All','FALSE'
'dbo','public','Grant','Select','sysconstraints','All','FALSE'
'dbo','public','Grant','Select','sysdepends','All','FALSE'
'dbo','public','Grant','Select','sysindexes','All','FALSE'
'dbo','public','Grant','Select','sysjars','All','FALSE'
'dbo','public','Grant','Select','syskeys','All','FALSE'
'dbo','public','Grant','Select','syslogs','All','FALSE'
'dbo','public','Grant','Select','sysobjects','cache','FALSE'
'dbo','public','Grant','Select','sysobjects','ckfirst','FALSE'
'dbo','public','Grant','Select','sysobjects','crdate','FALSE'
'dbo','public','Grant','Select','sysobjects','deltrig','FALSE'
'dbo','public','Grant','Select','sysobjects','expdate','FALSE'
'dbo','public','Grant','Select','sysobjects','id','FALSE'
'dbo','public','Grant','Select','sysobjects','indexdel','FALSE'
'dbo','public','Grant','Select','sysobjects','instrig','FALSE'
'dbo','public','Grant','Select','sysobjects','loginame','FALSE'
'dbo','public','Grant','Select','sysobjects','name','FALSE'
'dbo','public','Grant','Select','sysobjects','objspare','FALSE'
'dbo','public','Grant','Select','sysobjects','schemacnt','FALSE'
'dbo','public','Grant','Select','sysobjects','seltrig','FALSE'
'dbo','public','Grant','Select','sysobjects','sysstat','FALSE'
'dbo','public','Grant','Select','sysobjects','sysstat2','FALSE'
'dbo','public','Grant','Select','sysobjects','type','FALSE'
'dbo','public','Grant','Select','sysobjects','uid','FALSE'
'dbo','public','Grant','Select','sysobjects','updtrig','FALSE'
'dbo','public','Grant','Select','sysobjects','userstat','FALSE'
'dbo','public','Grant','Select','sysobjects','versionts','FALSE'
'dbo','public','Grant','Select','syspartitions','All','FALSE'
'dbo','public','Grant','Select','sysprocedures','All','FALSE'
'dbo','public','Grant','Select','sysprotects','All','FALSE'
'dbo','public','Grant','Select','sysqueryplans','All','FALSE'
'dbo','public','Grant','Select','sysreferences','All','FALSE'
'dbo','public','Grant','Select','sysroles','All','FALSE'
'dbo','public','Grant','Select','syssegments','All','FALSE'
'dbo','public','Grant','Select','sysstatistics','All','FALSE'
'dbo','public','Grant','Select','systabstats','All','FALSE'
'dbo','public','Grant','Select','systhresholds','All','FALSE'
'dbo','public','Grant','Select','systypes','All','FALSE'
'dbo','public','Grant','Select','sysusermessages','All','FALSE'
'dbo','public','Grant','Select','sysusers','All','FALSE'
'dbo','public','Grant','Select','sysxtypes','All','FALSE'
'dbo','sso_role','Grant','Select','sysobjects','All','FALSE'
'dbo','testerep','Grant','Create Procedure','
','All','FALSE'
'dbo','testerep','Grant','Create Table',' ','All','FALSE'


Thanks,
Leandro


Victoria Handros Posted on 2005-05-24 19:15:44.0Z
Message-ID: <42937D5C.4539BDC5@sybase.com>
From: Victoria Handros <vhandros@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.replicator
Subject: Re: error aserep.sh invalid column name 'action'
References: <428D0479.91244608@sybase.com> <42924d22.335b.1681692777@sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Original-NNTP-Posting-Host: vhandros2k.sybase.com
X-Original-Trace: 24 May 2005 12:15:40 -0700, vhandros2k.sybase.com
Lines: 70
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 May 2005 12:15:41 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 May 2005 12:15:44 -0700
X-Trace: forums-1-dub 1116962144 10.22.108.75 (24 May 2005 12:15:44 -0700)
X-Original-Trace: 24 May 2005 12:15:44 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:81
Article PK: 103327

Hi Leandro,
this issue is happening due to a change in behavior in jConnect.
Replicator
fix for that is included in ASE 12.5.2 ESD #2( Replicator version
12.5.2.302P1).

Thanks,
Victoria.

Leandro, Rennó wrote:

> Hi Victoria,
>
> I executed stored procedure sp_helprotect (distribution
> database) that he returned me the following result: (the
> action column exists)
>
> grantor,grantee,type,action,object,column,grantable
> 'dbo','public','Grant','Select','sysalternates','All','FALSE'
> 'dbo','public','Grant','Select','sysattributes','All','FALSE'
> 'dbo','public','Grant','Select','syscolumns','All','FALSE'
> 'dbo','public','Grant','Select','syscomments','All','FALSE'
> 'dbo','public','Grant','Select','sysconstraints','All','FALSE'
> 'dbo','public','Grant','Select','sysdepends','All','FALSE'
> 'dbo','public','Grant','Select','sysindexes','All','FALSE'
> 'dbo','public','Grant','Select','sysjars','All','FALSE'
> 'dbo','public','Grant','Select','syskeys','All','FALSE'
> 'dbo','public','Grant','Select','syslogs','All','FALSE'
> 'dbo','public','Grant','Select','sysobjects','cache','FALSE'
> 'dbo','public','Grant','Select','sysobjects','ckfirst','FALSE'
> 'dbo','public','Grant','Select','sysobjects','crdate','FALSE'
> 'dbo','public','Grant','Select','sysobjects','deltrig','FALSE'
> 'dbo','public','Grant','Select','sysobjects','expdate','FALSE'
> 'dbo','public','Grant','Select','sysobjects','id','FALSE'
> 'dbo','public','Grant','Select','sysobjects','indexdel','FALSE'
> 'dbo','public','Grant','Select','sysobjects','instrig','FALSE'
> 'dbo','public','Grant','Select','sysobjects','loginame','FALSE'
> 'dbo','public','Grant','Select','sysobjects','name','FALSE'
> 'dbo','public','Grant','Select','sysobjects','objspare','FALSE'
> 'dbo','public','Grant','Select','sysobjects','schemacnt','FALSE'
> 'dbo','public','Grant','Select','sysobjects','seltrig','FALSE'
> 'dbo','public','Grant','Select','sysobjects','sysstat','FALSE'
> 'dbo','public','Grant','Select','sysobjects','sysstat2','FALSE'
> 'dbo','public','Grant','Select','sysobjects','type','FALSE'
> 'dbo','public','Grant','Select','sysobjects','uid','FALSE'
> 'dbo','public','Grant','Select','sysobjects','updtrig','FALSE'
> 'dbo','public','Grant','Select','sysobjects','userstat','FALSE'
> 'dbo','public','Grant','Select','sysobjects','versionts','FALSE'
> 'dbo','public','Grant','Select','syspartitions','All','FALSE'
> 'dbo','public','Grant','Select','sysprocedures','All','FALSE'
> 'dbo','public','Grant','Select','sysprotects','All','FALSE'
> 'dbo','public','Grant','Select','sysqueryplans','All','FALSE'
> 'dbo','public','Grant','Select','sysreferences','All','FALSE'
> 'dbo','public','Grant','Select','sysroles','All','FALSE'
> 'dbo','public','Grant','Select','syssegments','All','FALSE'
> 'dbo','public','Grant','Select','sysstatistics','All','FALSE'
> 'dbo','public','Grant','Select','systabstats','All','FALSE'
> 'dbo','public','Grant','Select','systhresholds','All','FALSE'
> 'dbo','public','Grant','Select','systypes','All','FALSE'
> 'dbo','public','Grant','Select','sysusermessages','All','FALSE'
> 'dbo','public','Grant','Select','sysusers','All','FALSE'
> 'dbo','public','Grant','Select','sysxtypes','All','FALSE'
> 'dbo','sso_role','Grant','Select','sysobjects','All','FALSE'
> 'dbo','testerep','Grant','Create Procedure','
> ','All','FALSE'
> 'dbo','testerep','Grant','Create Table',' ','All','FALSE'
>
> Thanks,
> Leandro