sami23 - 2006-09-16

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