MRole.saveError: AccessTableNoView Error

To err is to be human, to help each other is joy. Tell your Compiere needs in your own words. Let's figure out together.

Moderator: azaharizaman

MRole.saveError: AccessTableNoView Error

Postby eric100 » Sat Sep 16, 2006 7:09 pm

Hi,

Am facing an usual error with 253b when i access with system administratror role and in the client rules i cant see the intial client setup workflow and when i access the client window i can see just the system client but not my other client whitch i had successfully created. this error occurs in the log :
MRole.saveError: AccessTableNoView - Required=2(Client Data) != UserLevel=S

I reinstalled several times and dropped and created the databases many times but in vain

here is the whole log file :
-------------------------------
10:41:32.843 AccessSqlParser.parse: AccessSqlParser[AD_Tree|0] [13]
10:41:32.843 MFieldVO.create: AD_Tree_Campaign_ID [13]
10:41:32.843 AccessSqlParser.parse: AccessSqlParser[AD_Tree|0] [13]
10:41:32.843 MFieldVO.create: AD_Tree_Activity_ID [13]
10:41:32.843 AccessSqlParser.parse: AccessSqlParser[AD_Tree|0] [13]
10:41:32.859 MFieldVO.create: AD_Org_ID [13]
10:41:32.859 MLookupFactory.getLookup_TableDir: ColumnName=AD_Org_ID - SELECT AD_Org.AD_Org_ID,NULL,AD_Org.Name,AD_Org.IsActive FROM AD_Org ORDER BY 3 [13]
10:41:32.859 AccessSqlParser.parse: AccessSqlParser[AD_Org|0] [13]
10:41:32.859 MFieldVO.create: IsActive [13]
10:41:32.859 MTabVO.create: #2 [13]
===========> MRole.saveError: AccessTableNoView - Required=2(Client Data) != UserLevel=S [13]

Host = ind_pc : 1099 (2006-01-20)
LAN: Tunnel=false, Objects=false, Process=false
Database = ind_pc : 1521 / mabase.ind_pc.iamdg.net.ma
Schema = compiere
User/Contact = System
Role = System Administrator
Client = System
Organization = *
Date = 2006-09-16 00:00:00
Printer = Microsoft Office Document Image Writer
CompiereHome = c:\Compiere2
Language=[English,Locale=en_US,AD_Language=en_US,DatePattern=MM/DD/YYYY,DecimalPoint=true]
MClient[0-SYSTEM]
Multi Lingual Documents = true
BaseLanguage = true/true
PDF License=false
Java HotSpot(TM) Client VM 1.5.0_03-b07
Windows XP 5.1 Service Pack 2
=== Environment === -458639677
Compiere(r) Release 2.5.3b_2006-01-20 - Smart ERP & CRM - (c) 1999-2006 Compiere (r); Implementation: 2.5.3b 20060211-1822 - ComPiere Inc. (C) 1999-2005 Jorg Janke
ind_pc/196.217.214.68
CConnection[name=ind_pc{ind_pc-mabase.ind_pc.iamdg.net.ma-compiere},AppsHost=ind_pc,AppsPort=1099,Profile=L,type=Oracle,DBhost=ind_pc,DBport=1521,DBname=mabase.ind_pc.iamdg.net.ma,BQ=false,FW=false,FWhost=,FWport=1630,UID=compiere,PWD=compiere]
Database=Oracle - Oracle Database 10g Release 10.2.0.1.0 - Production - Driver =Oracle JDBC driver - 10.1.0.2.0 - via DataSource
DB_Oracle[jdbc:oracle:thin:@//ind_pc:1521/mabase.ind_pc.iamdg.net.ma-CompiereDS,ImplCache=true,MaxStmts=50]
AppsServerOK=true, DatabaseOK=true

=== Context ===
#AD_Client_ID == 0
#AD_Client_Name == System
#AD_Language == en_US
#AD_Org_ID == 0
#AD_Org_Name == *
#AD_PrintColor_ID == 100
#AD_PrintFont_ID == 130
#AD_PrintPaper_ID == 100
#AD_PrintTableFormat_ID == 100
#AD_Role_ID == 0
#AD_Role_Name == System Administrator
#AD_Session_ID == 1000019
#AD_User_ID == 0
#AD_User_Name == System
#C_ConversionType_ID == 114
#C_Country_ID == 100
#C_Region_ID == 142
#C_UOM_ID == 100
#Date == 2006-09-16 00:00:00
#Printer == Microsoft Office Document Image Writer
#SalesRep_ID == 0
#ShowAcct == N
#ShowAdvanced == Y
#ShowTrl == Y
#StdPrecision == 2
#SysAdmin == Y
#User_Level == S
#User_Org == 0
#YYYY == Y
0|WindowName == &Menu
1111|12059|AD_Tree.AD_Tree_ID == SELECT AD_Tree.AD_Tree_ID,NULL,AD_Tree.Name,AD_Tree.IsActive FROM AD_Tree WHERE AD_Tree.AD_Client_ID=0 AND AD_Tree.AD_Org_ID=0 ORDER BY 3
1111|12060|AD_Tree.AD_Tree_ID == SELECT AD_Tree.AD_Tree_ID,NULL,AD_Tree.Name,AD_Tree.IsActive FROM AD_Tree WHERE AD_Tree.AD_Client_ID=0 AND AD_Tree.AD_Org_ID=0 ORDER BY 3
1111|13074|AD_Ref_List.Value == SELECT NULL, AD_Ref_List.Value,AD_Ref_List.Name,AD_Ref_List.IsActive FROM AD_Ref_List WHERE AD_Ref_List.AD_Reference_ID=334 ORDER BY 2
1111|13246|AD_Ref_List.Value == SELECT NULL, AD_Ref_List.Value,AD_Ref_List.Name,AD_Ref_List.IsActive FROM AD_Ref_List WHERE AD_Ref_List.AD_Reference_ID=335 ORDER BY 2
1111|1983|C_AcctSchema.C_AcctSchema_ID == SELECT C_AcctSchema.C_AcctSchema_ID,NULL,C_AcctSchema.Name,C_AcctSchema.IsActive FROM C_AcctSchema WHERE C_AcctSchema.AD_Client_ID=0 AND C_AcctSchema.AD_Org_ID=0 ORDER BY 3
1111|2347|C_UOM.C_UOM_ID == SELECT C_UOM.C_UOM_ID,NULL,C_UOM.Name,C_UOM.IsActive FROM C_UOM WHERE C_UOM.AD_Client_ID=0 AND C_UOM.AD_Org_ID=0 ORDER BY 3
1111|2348|C_UOM.C_UOM_ID == SELECT C_UOM.C_UOM_ID,NULL,C_UOM.Name,C_UOM.IsActive FROM C_UOM WHERE C_UOM.AD_Client_ID=0 AND C_UOM.AD_Org_ID=0 ORDER BY 3
1111|2349|C_UOM.C_UOM_ID == SELECT C_UOM.C_UOM_ID,NULL,C_UOM.Name,C_UOM.IsActive FROM C_UOM WHERE C_UOM.AD_Client_ID=0 AND C_UOM.AD_Org_ID=0 ORDER BY 3
1111|2350|C_UOM.C_UOM_ID == SELECT C_UOM.C_UOM_ID,NULL,C_UOM.Name,C_UOM.IsActive FROM C_UOM WHERE C_UOM.AD_Client_ID=0 AND C_UOM.AD_Org_ID=0 ORDER BY 3
1111|2721|AD_Tree.AD_Tree_ID == SELECT AD_Tree.AD_Tree_ID,NULL,AD_Tree.Name,AD_Tree.IsActive FROM AD_Tree WHERE AD_Tree.AD_Client_ID=0 AND AD_Tree.AD_Org_ID=0 ORDER BY 3
1111|2722|AD_Tree.AD_Tree_ID == SELECT AD_Tree.AD_Tree_ID,NULL,AD_Tree.Name,AD_Tree.IsActive FROM AD_Tree WHERE AD_Tree.AD_Client_ID=0 AND AD_Tree.AD_Org_ID=0 ORDER BY 3
1111|2723|AD_Tree.AD_Tree_ID == SELECT AD_Tree.AD_Tree_ID,NULL,AD_Tree.Name,AD_Tree.IsActive FROM AD_Tree WHERE AD_Tree.AD_Client_ID=0 AND AD_Tree.AD_Org_ID=0 ORDER BY 3
1111|2724|AD_Tree.AD_Tree_ID == SELECT AD_Tree.AD_Tree_ID,NULL,AD_Tree.Name,AD_Tree.IsActive FROM AD_Tree WHERE AD_Tree.AD_Client_ID=0 AND AD_Tree.AD_Org_ID=0 ORDER BY 3
1111|2725|AD_Tree.AD_Tree_ID == SELECT AD_Tree.AD_Tree_ID,NULL,AD_Tree.Name,AD_Tree.IsActive FROM AD_Tree WHERE AD_Tree.AD_Client_ID=0 AND AD_Tree.AD_Org_ID=0 ORDER BY 3
1111|2726|AD_Tree.AD_Tree_ID == SELECT AD_Tree.AD_Tree_ID,NULL,AD_Tree.Name,AD_Tree.IsActive FROM AD_Tree WHERE AD_Tree.AD_Client_ID=0 AND AD_Tree.AD_Org_ID=0 ORDER BY 3
1111|414|AD_Org.AD_Org_ID == SELECT AD_Org.AD_Org_ID,NULL,AD_Org.Name,AD_Org.IsActive FROM AD_Org WHERE (AD_Org.IsSummary='N' OR AD_Org.AD_Org_ID=0) AND AD_Org.AD_Client_ID=0 AND AD_Org.AD_Org_ID=0 ORDER BY 3
1111|5956|C_Calendar.C_Calendar_ID == SELECT C_Calendar.C_Calendar_ID,NULL,C_Calendar.Name,C_Calendar.IsActive FROM C_Calendar WHERE C_Calendar.AD_Client_ID=0 AND C_Calendar.AD_Org_ID=0 ORDER BY 3
1111|6556|AD_Language.AD_Language == SELECT NULL,AD_Language.AD_Language,AD_Language.Name,AD_Language.IsActive FROM AD_Language WHERE (AD_Language.IsSystemLanguage='Y' OR AD_Language.IsBaseLanguage='Y') AND AD_Language.AD_Client_ID=0 AND AD_Language.AD_Org_ID=0 ORDER BY 3
AutoCommit == Y
AutoNew == N
P103|Type == S
P189|DataType == S
java.naming.provider.url == jnp://ind_pc:1099

=== System ===
COMPIERE_HOME=c:\Compiere2
COMPIERE_PRODUCT=0
awt.toolkit=sun.awt.windows.WToolkit
file.encoding=Cp1252
file.encoding.pkg=sun.io
file.separator=\
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=Compiere.jar;CompiereCLib.jar
java.class.version=49.0
java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_03\jre\lib\endorsed
java.ext.dirs=C:\Program Files\Java\jdk1.5.0_03\jre\lib\ext
java.home=C:\Program Files\Java\jdk1.5.0_03\jre
java.io.tmpdir=C:\DOCUME~1\mustapha\LOCALS~1\Temp\
java.library.path=C:\Program Files\Java\jdk1.5.0_03\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.5.0_03\bin;C:\Program Files\Java\jre1.5.0_03\bin;d:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\Program Files\cvsnt; ›’|
java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
java.runtime.version=1.5.0_03-b07
java.specification.name=Java Platform API Specification
java.specification.vendor=Sun Microsystems Inc.
java.specification.version=1.5
java.vendor=Sun Microsystems Inc.
java.vendor.url=http://java.sun.com/
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
java.version=1.5.0_03
java.vm.info=mixed mode, sharing
java.vm.name=Java HotSpot(TM) Client VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Sun Microsystems Inc.
java.vm.specification.version=1.0
java.vm.vendor=Sun Microsystems Inc.
java.vm.version=1.5.0_03-b07
line.separator=

os.arch=x86
os.name=Windows XP
os.version=5.1
path.separator=;
sun.arch.data.model=32
sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_03\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_03\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_03\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_03\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_03\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_03\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_03\jre\classes
sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_03\jre\bin
sun.cpu.endian=little
sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
sun.desktop=windows
sun.io.unicode.encoding=UnicodeLittle
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot Client Compiler
sun.os.patch.level=Service Pack 2
user.country=FR
user.dir=c:\Compiere2\lib
eric100
 
Posts: 9
Joined: Tue Aug 15, 2006 11:55 pm

Postby red1 » Sat Sep 16, 2006 8:05 pm

Check your DB whether that client record exist.

Why not recreate your new client again since this is just starting client?

Maybe u missed a step. Also in Role Access, if u can find the client or org info related to new client, try deleting the present org info and create again. Sometimes if DB record is there, its not pointing somehow and recreating the new org record solves it.
red1
Site Admin
 
Posts: 2760
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby eric100 » Sun Sep 17, 2006 8:07 am

Hi Red one,
Thanks for your reply, i just want to precise that the client records exist in the DB. I had already worked with (importing accounting schema, invoices...) i can see the client information(only not the system client) with my client role admin.
the workflow in the client rules disappeared for all roles.
i think something do not work well with my propreties file or something like that because the same error occurs with 253c. i dropped the database and reinstalled the server many times. (with source code in eclipse the same error)
If it is a bug i can ignore it. a muslum proverb says many problem can be resolved once ignored ;)

Thanks
eric100
 
Posts: 9
Joined: Tue Aug 15, 2006 11:55 pm

Postby red1 » Sun Sep 17, 2006 9:13 am

It may be just an ethnic group's proverb cos i havent heard such among Islamic teachings.

There is a somewhat similar Chinese Tao saying, that
Problems are never solved. U just stay aloof above them (not ignored)

There is advice from some other forum post that u avoid 253c as been buggy. Try things again in 253b or d.
red1
Site Admin
 
Posts: 2760
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby eric100 » Sun Sep 17, 2006 10:13 am

Hi,
You are right, i've read somewhere that the 253c will not be available for public download because they will pass directly to 253d as a stable release. But i can not find where to download neither the 253c neither its sources codes.

For the error i can now walk around it. I just login with the admin role of my client and i can see both client : system one and mine one.


[once again you are right about the proverb ! it is an arabic one. An islamic hadith says : do not let what you can do now for to morrow]
and who wants honey must bear bee's punctures !!

For the Admpiere Project, if you think i could be useful in anything, am ready to contibute.[/quote]
eric100
 
Posts: 9
Joined: Tue Aug 15, 2006 11:55 pm


Return to Ask RED1 personally

Who is online

Users browsing this forum: No registered users and 2 guests

cron