You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by BJ Freeman <bj...@free-man.net> on 2008/07/11 18:47:37 UTC
Table missing so can't login
[java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not
in any table in the FROM list or appears within a join specification and
is outside the scope of the join specification or appears in a HAVING
clause and is not in the GROUP BY list. If this is a CREATE or ALTER
TABLE statement then 'USER_LDAP_DN' is not a column in the target table.
I check the entityengine.xml and is shows to update
<datasource name="localderby"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="OFBIZ"
field-type-name="derby"
check-on-start="true"
add-missing-on-start="true"
use-pk-constraint-names="false"
use-indices-unique="false"
alias-view-columns="false">
<read-data reader-name="seed"/>
<read-data reader-name="seed-initial"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
jdbc-uri="jdbc:derby:ofbiz;create=true"
jdbc-username="ofbiz"
jdbc-password="ofbiz"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"/>
<!-- <jndi-jdbc jndi-server-name="localjndi"
jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
</datasource>
Re: Table missing so can't login
Posted by BJ Freeman <bj...@free-man.net>.
guess I will have to dig into the code that connects the db and find out
what happen to the loging.
thanks.
Adrian Crum sent the following on 7/11/2008 10:58 AM:
> I'm not having those problems on my local copy.
>
> -Adrian
>
> BJ Freeman wrote:
>> This is an old db that I keep to find migration errors
>>
>> I believe the update part of the database
>>>>>> check-on-start="true"
>>>>>> add-missing-on-start="true"
>> are not be done or are erroring.
>> however I can not find any entries in the logs that show me any
>> interaction with the database updates.
>>
>>
>> Adrian Crum sent the following on 7/11/2008 10:30 AM:
>>> UserLdapDn is a field that was recently added to the userLogin entity.
>>> It sounds like you are running new code on an old version of the entity.
>>>
>>> -Adrian
>>>
>>> BJ Freeman wrote:
>>>> ant clean
>>>> ant run-install-seed
>>>>
>>>> Adrian Crum sent the following on 7/11/2008 10:01 AM:
>>>>> Did you run ant run-install?
>>>>>
>>>>> -Adrian
>>>>>
>>>>> BJ Freeman wrote:
>>>>>> [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is
>>>>>> either not
>>>>>> in any table in the FROM list or appears within a join specification
>>>>>> and
>>>>>> is outside the scope of the join specification or appears in a HAVING
>>>>>> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
>>>>>> TABLE statement then 'USER_LDAP_DN' is not a column in the target
>>>>>> table.
>>>>>>
>>>>>> I check the entityengine.xml and is shows to update
>>>>>> <datasource name="localderby"
>>>>>>
>>>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>>>>> schema-name="OFBIZ"
>>>>>> field-type-name="derby"
>>>>>> check-on-start="true"
>>>>>> add-missing-on-start="true"
>>>>>> use-pk-constraint-names="false"
>>>>>> use-indices-unique="false"
>>>>>> alias-view-columns="false">
>>>>>> <read-data reader-name="seed"/>
>>>>>> <read-data reader-name="seed-initial"/>
>>>>>> <read-data reader-name="demo"/>
>>>>>> <read-data reader-name="ext"/>
>>>>>> <inline-jdbc
>>>>>> jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
>>>>>> jdbc-uri="jdbc:derby:ofbiz;create=true"
>>>>>> jdbc-username="ofbiz"
>>>>>> jdbc-password="ofbiz"
>>>>>> isolation-level="ReadCommitted"
>>>>>> pool-minsize="2"
>>>>>> pool-maxsize="250"/>
>>>>>> <!-- <jndi-jdbc jndi-server-name="localjndi"
>>>>>> jndi-name="java:/DerbyDataSource"
>>>>>> isolation-level="ReadCommitted"/> -->
>>>>>> </datasource>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>
>>
>
>
>
Re: Table missing so can't login
Posted by Jacques Le Roux <ja...@les7arts.com>.
I also get an error with a clean instance (svn st being ok) after a clean-all and run-install. I have not this issue if I only clean
the olap base (So it"s not relate to the changes I made recently removing all entitygroup.xml but BI's)
[java] 2008-07-11 19:52:08,734 (main) [ GenericDAO.java:970:INFO ] Count select sql: SELECT COUNT(1) FROM
OFBIZ.ENTITY_KEY_STORE
[java] 2008-07-11 19:52:16,937 (main) [ GenericDelegator.java:2404:ERROR]
[java] ---- exception report ----------------------------------------------------------
[java] Failure in findListIteratorByCondition operation for entity [DynamicView]: org.ofbiz.entity.GenericDataSourceException:
SQL Exception while executing the following:SELECT COUNT(1) FROM OFBIZ.ENTI
TY_KEY_STORE (Schema 'OFBIZ' does not exist). Rolling back transaction.
[java] Exception: org.ofbiz.entity.GenericDataSourceException
[java] Message: SQL Exception while executing the following:SELECT COUNT(1) FROM OFBIZ.ENTITY_KEY_STORE (Schema 'OFBIZ' does
not exist)
[java] ---- stack trace ---------------------------------------------------------------
[java] org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT COUNT(1) FROM
OFBIZ.ENTITY_KEY_STORE (Schema 'OFBIZ' does not exist)
[java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:384)
[java] org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:973)
[java] org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(GenericHelperDAO.java:149)
[java] org.ofbiz.entity.GenericDelegator.findCountByCondition(GenericDelegator.java:2398)
[java] org.ofbiz.entity.util.EntityCrypto.<init>(EntityCrypto.java:58)
[java] org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:248)
[java] org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:130)
[java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:193)
[java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
[java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
[java] org.ofbiz.base.start.Start.startServer(Start.java:312)
[java] org.ofbiz.base.start.Start.start(Start.java:316)
[java] org.ofbiz.base.start.Start.main(Start.java:399)
[java] java.sql.SQLException: Schema 'OFBIZ' does not exist
[java] org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
[java] org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
[java] org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
[java] org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
[java] org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
[java] org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
[java] org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
[java] org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
[java] org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
[java] org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
[java] org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
[java] org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
[java] org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:264)
[java] org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:264)
[java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:372)
[java] org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:973)
[java] org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(GenericHelperDAO.java:149)
[java] org.ofbiz.entity.GenericDelegator.findCountByCondition(GenericDelegator.java:2398)
[java] org.ofbiz.entity.util.EntityCrypto.<init>(EntityCrypto.java:58)
[java] org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:248)
[java] org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:130)
[java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:193)
[java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
[java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
[java] org.ofbiz.base.start.Start.startServer(Start.java:312)
[java] org.ofbiz.base.start.Start.start(Start.java:316)
[java] org.ofbiz.base.start.Start.main(Start.java:399)
[java] Caused by: ERROR 42Y07: Schema 'OFBIZ' does not exist
[java] org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
[java] org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)
[java] org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
[java] org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
[java] org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
[java] org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
[java] org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
[java] org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
[java] org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
[java] org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
[java] org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
[java] org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
[java] org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
[java] org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
[java] ... 21 more
[java] --------------------------------------------------------------------------------
[java]
[java] 2008-07-11 19:52:16,937 (main) [ TransactionUtil.java:275:ERROR]
[java] ---- exception report ----------------------------------------------------------
As you can see it says that the OFBiz schema is missing....
Looking above it seems that BJ is right there is something weird
[java] 2008-07-11 19:51:46,031 (main) [ UtilXml.java:241:INFO ] XML Read 0.094s:
D:/workspace/ofbizClean/specialpurpose/bi/entitydef/entitymodel.xml
[java] 2008-07-11 19:51:46,156 (main) [ ModelViewEntity.java:470:WARN ] Conversion for complex-alias needs to be implemented
for cache and in-memory eval stuff to work correctly, will not work for ali
as: statusDelay of view-entity ExampleStatusDetail
[java] 2008-07-11 19:51:46,812 (main) [ ModelViewEntity.java:470:WARN ] Conversion for complex-alias needs to be implemented
for cache and in-memory eval stuff to work correctly, will not work for ali
as: quantityOrdered of view-entity OrderItemQuantityReportGroupByItem
[java] 2008-07-11 19:51:46,812 (main) [ ModelViewEntity.java:470:WARN ] Conversion for complex-alias needs to be implemented
for cache and in-memory eval stuff to work correctly, will not work for ali
as: quantityOpen of view-entity OrderItemQuantityReportGroupByItem
[java] 2008-07-11 19:51:46,812 (main) [ ModelViewEntity.java:470:WARN ] Conversion for complex-alias needs to be implemented
for cache and in-memory eval stuff to work correctly, will not work for ali
as: quantityOrdered of view-entity OrderItemQuantityReportGroupByProduct
[java] 2008-07-11 19:51:46,812 (main) [ ModelViewEntity.java:470:WARN ] Conversion for complex-alias needs to be implemented
for cache and in-memory eval stuff to work correctly, will not work for ali
as: quantityOpen of view-entity OrderItemQuantityReportGroupByProduct
[java] 2008-07-11 19:51:46,828 (main) [ ModelViewEntity.java:470:WARN ] Conversion for complex-alias needs to be implemented
for cache and in-memory eval stuff to work correctly, will not work for ali
as: quantityOrdered of view-entity OrderItemAndShipGrpInvResAndItemSum
[java] 2008-07-11 19:51:46,828 (main) [ ModelViewEntity.java:470:WARN ] Conversion for complex-alias needs to be implemented
for cache and in-memory eval stuff to work correctly, will not work for ali
as: totQuantityAvailable of view-entity OrderItemAndShipGrpInvResAndItemSum
[java] 2008-07-11 19:51:47,187 (main) [ ModelReader.java:388:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=757
#ViewEntities=195 #Fields=7784 #Relationships=2630 #AutoRelationships=1939
[java] 2008-07-11 19:51:47,218 (main) [ UtilXml.java:241:INFO ] XML Read 0.031s:
D:/workspace/ofbizClean/specialpurpose/bi/entitydef/entitygroup.xml
Adding at least one entitygroup.xml file (I reverted changes I made in assetmain) solves this issue so it seems that something is
wrong from r672822. I will try now to remove reference to the entitygroup.xml file in ofbiz-component in assetmain...
I'm looking at it...
Jacques
----- Original Message -----
From: "Adrian Crum" <ad...@hlmksw.com>
To: <us...@ofbiz.apache.org>
Sent: Friday, July 11, 2008 7:58 PM
Subject: Re: Table missing so can't login
> I'm not having those problems on my local copy.
>
> -Adrian
>
> BJ Freeman wrote:
>> This is an old db that I keep to find migration errors
>>
>> I believe the update part of the database
>>>>>> check-on-start="true"
>>>>>> add-missing-on-start="true"
>> are not be done or are erroring.
>> however I can not find any entries in the logs that show me any
>> interaction with the database updates.
>>
>>
>> Adrian Crum sent the following on 7/11/2008 10:30 AM:
>>> UserLdapDn is a field that was recently added to the userLogin entity.
>>> It sounds like you are running new code on an old version of the entity.
>>>
>>> -Adrian
>>>
>>> BJ Freeman wrote:
>>>> ant clean
>>>> ant run-install-seed
>>>>
>>>> Adrian Crum sent the following on 7/11/2008 10:01 AM:
>>>>> Did you run ant run-install?
>>>>>
>>>>> -Adrian
>>>>>
>>>>> BJ Freeman wrote:
>>>>>> [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not
>>>>>> in any table in the FROM list or appears within a join specification
>>>>>> and
>>>>>> is outside the scope of the join specification or appears in a HAVING
>>>>>> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
>>>>>> TABLE statement then 'USER_LDAP_DN' is not a column in the target
>>>>>> table.
>>>>>>
>>>>>> I check the entityengine.xml and is shows to update
>>>>>> <datasource name="localderby"
>>>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>>>>> schema-name="OFBIZ"
>>>>>> field-type-name="derby"
>>>>>> check-on-start="true"
>>>>>> add-missing-on-start="true"
>>>>>> use-pk-constraint-names="false"
>>>>>> use-indices-unique="false"
>>>>>> alias-view-columns="false">
>>>>>> <read-data reader-name="seed"/>
>>>>>> <read-data reader-name="seed-initial"/>
>>>>>> <read-data reader-name="demo"/>
>>>>>> <read-data reader-name="ext"/>
>>>>>> <inline-jdbc
>>>>>> jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
>>>>>> jdbc-uri="jdbc:derby:ofbiz;create=true"
>>>>>> jdbc-username="ofbiz"
>>>>>> jdbc-password="ofbiz"
>>>>>> isolation-level="ReadCommitted"
>>>>>> pool-minsize="2"
>>>>>> pool-maxsize="250"/>
>>>>>> <!-- <jndi-jdbc jndi-server-name="localjndi"
>>>>>> jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
>>>>>> </datasource>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>
>>
>
Re: Table missing so can't login
Posted by Adrian Crum <ad...@hlmksw.com>.
I'm not having those problems on my local copy.
-Adrian
BJ Freeman wrote:
> This is an old db that I keep to find migration errors
>
> I believe the update part of the database
>>>>> check-on-start="true"
>>>>> add-missing-on-start="true"
> are not be done or are erroring.
> however I can not find any entries in the logs that show me any
> interaction with the database updates.
>
>
> Adrian Crum sent the following on 7/11/2008 10:30 AM:
>> UserLdapDn is a field that was recently added to the userLogin entity.
>> It sounds like you are running new code on an old version of the entity.
>>
>> -Adrian
>>
>> BJ Freeman wrote:
>>> ant clean
>>> ant run-install-seed
>>>
>>> Adrian Crum sent the following on 7/11/2008 10:01 AM:
>>>> Did you run ant run-install?
>>>>
>>>> -Adrian
>>>>
>>>> BJ Freeman wrote:
>>>>> [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not
>>>>> in any table in the FROM list or appears within a join specification
>>>>> and
>>>>> is outside the scope of the join specification or appears in a HAVING
>>>>> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
>>>>> TABLE statement then 'USER_LDAP_DN' is not a column in the target
>>>>> table.
>>>>>
>>>>> I check the entityengine.xml and is shows to update
>>>>> <datasource name="localderby"
>>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>>>> schema-name="OFBIZ"
>>>>> field-type-name="derby"
>>>>> check-on-start="true"
>>>>> add-missing-on-start="true"
>>>>> use-pk-constraint-names="false"
>>>>> use-indices-unique="false"
>>>>> alias-view-columns="false">
>>>>> <read-data reader-name="seed"/>
>>>>> <read-data reader-name="seed-initial"/>
>>>>> <read-data reader-name="demo"/>
>>>>> <read-data reader-name="ext"/>
>>>>> <inline-jdbc
>>>>> jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
>>>>> jdbc-uri="jdbc:derby:ofbiz;create=true"
>>>>> jdbc-username="ofbiz"
>>>>> jdbc-password="ofbiz"
>>>>> isolation-level="ReadCommitted"
>>>>> pool-minsize="2"
>>>>> pool-maxsize="250"/>
>>>>> <!-- <jndi-jdbc jndi-server-name="localjndi"
>>>>> jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
>>>>> </datasource>
>>>>>
>>>>>
>>>>
>>>
>>
>>
>
>
Re: Table missing so can't login
Posted by BJ Freeman <bj...@free-man.net>.
This is an old db that I keep to find migration errors
I believe the update part of the database
>>>> check-on-start="true"
>>>> add-missing-on-start="true"
are not be done or are erroring.
however I can not find any entries in the logs that show me any
interaction with the database updates.
Adrian Crum sent the following on 7/11/2008 10:30 AM:
> UserLdapDn is a field that was recently added to the userLogin entity.
> It sounds like you are running new code on an old version of the entity.
>
> -Adrian
>
> BJ Freeman wrote:
>> ant clean
>> ant run-install-seed
>>
>> Adrian Crum sent the following on 7/11/2008 10:01 AM:
>>> Did you run ant run-install?
>>>
>>> -Adrian
>>>
>>> BJ Freeman wrote:
>>>> [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not
>>>> in any table in the FROM list or appears within a join specification
>>>> and
>>>> is outside the scope of the join specification or appears in a HAVING
>>>> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
>>>> TABLE statement then 'USER_LDAP_DN' is not a column in the target
>>>> table.
>>>>
>>>> I check the entityengine.xml and is shows to update
>>>> <datasource name="localderby"
>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>>> schema-name="OFBIZ"
>>>> field-type-name="derby"
>>>> check-on-start="true"
>>>> add-missing-on-start="true"
>>>> use-pk-constraint-names="false"
>>>> use-indices-unique="false"
>>>> alias-view-columns="false">
>>>> <read-data reader-name="seed"/>
>>>> <read-data reader-name="seed-initial"/>
>>>> <read-data reader-name="demo"/>
>>>> <read-data reader-name="ext"/>
>>>> <inline-jdbc
>>>> jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
>>>> jdbc-uri="jdbc:derby:ofbiz;create=true"
>>>> jdbc-username="ofbiz"
>>>> jdbc-password="ofbiz"
>>>> isolation-level="ReadCommitted"
>>>> pool-minsize="2"
>>>> pool-maxsize="250"/>
>>>> <!-- <jndi-jdbc jndi-server-name="localjndi"
>>>> jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
>>>> </datasource>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
>
Re: Table missing so can't login
Posted by Adrian Crum <ad...@hlmksw.com>.
UserLdapDn is a field that was recently added to the userLogin entity.
It sounds like you are running new code on an old version of the entity.
-Adrian
BJ Freeman wrote:
> ant clean
> ant run-install-seed
>
> Adrian Crum sent the following on 7/11/2008 10:01 AM:
>> Did you run ant run-install?
>>
>> -Adrian
>>
>> BJ Freeman wrote:
>>> [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not
>>> in any table in the FROM list or appears within a join specification and
>>> is outside the scope of the join specification or appears in a HAVING
>>> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
>>> TABLE statement then 'USER_LDAP_DN' is not a column in the target table.
>>>
>>> I check the entityengine.xml and is shows to update
>>> <datasource name="localderby"
>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>> schema-name="OFBIZ"
>>> field-type-name="derby"
>>> check-on-start="true"
>>> add-missing-on-start="true"
>>> use-pk-constraint-names="false"
>>> use-indices-unique="false"
>>> alias-view-columns="false">
>>> <read-data reader-name="seed"/>
>>> <read-data reader-name="seed-initial"/>
>>> <read-data reader-name="demo"/>
>>> <read-data reader-name="ext"/>
>>> <inline-jdbc
>>> jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
>>> jdbc-uri="jdbc:derby:ofbiz;create=true"
>>> jdbc-username="ofbiz"
>>> jdbc-password="ofbiz"
>>> isolation-level="ReadCommitted"
>>> pool-minsize="2"
>>> pool-maxsize="250"/>
>>> <!-- <jndi-jdbc jndi-server-name="localjndi"
>>> jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
>>> </datasource>
>>>
>>>
>>
>>
>
>
Re: Table missing so can't login
Posted by BJ Freeman <bj...@free-man.net>.
ant clean
ant run-install-seed
Adrian Crum sent the following on 7/11/2008 10:01 AM:
> Did you run ant run-install?
>
> -Adrian
>
> BJ Freeman wrote:
>> [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not
>> in any table in the FROM list or appears within a join specification and
>> is outside the scope of the join specification or appears in a HAVING
>> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
>> TABLE statement then 'USER_LDAP_DN' is not a column in the target table.
>>
>> I check the entityengine.xml and is shows to update
>> <datasource name="localderby"
>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>> schema-name="OFBIZ"
>> field-type-name="derby"
>> check-on-start="true"
>> add-missing-on-start="true"
>> use-pk-constraint-names="false"
>> use-indices-unique="false"
>> alias-view-columns="false">
>> <read-data reader-name="seed"/>
>> <read-data reader-name="seed-initial"/>
>> <read-data reader-name="demo"/>
>> <read-data reader-name="ext"/>
>> <inline-jdbc
>> jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
>> jdbc-uri="jdbc:derby:ofbiz;create=true"
>> jdbc-username="ofbiz"
>> jdbc-password="ofbiz"
>> isolation-level="ReadCommitted"
>> pool-minsize="2"
>> pool-maxsize="250"/>
>> <!-- <jndi-jdbc jndi-server-name="localjndi"
>> jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
>> </datasource>
>>
>>
>
>
>
Re: Table missing so can't login
Posted by Adrian Crum <ad...@hlmksw.com>.
Did you run ant run-install?
-Adrian
BJ Freeman wrote:
> [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not
> in any table in the FROM list or appears within a join specification and
> is outside the scope of the join specification or appears in a HAVING
> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
> TABLE statement then 'USER_LDAP_DN' is not a column in the target table.
>
> I check the entityengine.xml and is shows to update
> <datasource name="localderby"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> schema-name="OFBIZ"
> field-type-name="derby"
> check-on-start="true"
> add-missing-on-start="true"
> use-pk-constraint-names="false"
> use-indices-unique="false"
> alias-view-columns="false">
> <read-data reader-name="seed"/>
> <read-data reader-name="seed-initial"/>
> <read-data reader-name="demo"/>
> <read-data reader-name="ext"/>
> <inline-jdbc
> jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
> jdbc-uri="jdbc:derby:ofbiz;create=true"
> jdbc-username="ofbiz"
> jdbc-password="ofbiz"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"/>
> <!-- <jndi-jdbc jndi-server-name="localjndi"
> jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
> </datasource>
>
>
Re: Table missing so can't login
Posted by BJ Freeman <bj...@free-man.net>.
I am using 674908
will update
Jacques Le Roux sent the following on 7/11/2008 10:08 AM:
> Could it be related to the changes I made in r675947 and the fix I put
> in r676022? I doubt but could you check please ?
>
> Jacques
>
> From: "BJ Freeman" <bj...@free-man.net>
>> [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not
>> in any table in the FROM list or appears within a join specification and
>> is outside the scope of the join specification or appears in a HAVING
>> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
>> TABLE statement then 'USER_LDAP_DN' is not a column in the target table.
>>
>> I check the entityengine.xml and is shows to update
>> <datasource name="localderby"
>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>> schema-name="OFBIZ"
>> field-type-name="derby"
>> check-on-start="true"
>> add-missing-on-start="true"
>> use-pk-constraint-names="false"
>> use-indices-unique="false"
>> alias-view-columns="false">
>> <read-data reader-name="seed"/>
>> <read-data reader-name="seed-initial"/>
>> <read-data reader-name="demo"/>
>> <read-data reader-name="ext"/>
>> <inline-jdbc
>> jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
>> jdbc-uri="jdbc:derby:ofbiz;create=true"
>> jdbc-username="ofbiz"
>> jdbc-password="ofbiz"
>> isolation-level="ReadCommitted"
>> pool-minsize="2"
>> pool-maxsize="250"/>
>> <!-- <jndi-jdbc jndi-server-name="localjndi"
>> jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
>> </datasource>
>>
>
>
>
Re: Table missing so can't login
Posted by Jacques Le Roux <ja...@les7arts.com>.
Could it be related to the changes I made in r675947 and the fix I put in r676022? I doubt but could you check please ?
Jacques
From: "BJ Freeman" <bj...@free-man.net>
> [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not
> in any table in the FROM list or appears within a join specification and
> is outside the scope of the join specification or appears in a HAVING
> clause and is not in the GROUP BY list. If this is a CREATE or ALTER
> TABLE statement then 'USER_LDAP_DN' is not a column in the target table.
>
> I check the entityengine.xml and is shows to update
> <datasource name="localderby"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> schema-name="OFBIZ"
> field-type-name="derby"
> check-on-start="true"
> add-missing-on-start="true"
> use-pk-constraint-names="false"
> use-indices-unique="false"
> alias-view-columns="false">
> <read-data reader-name="seed"/>
> <read-data reader-name="seed-initial"/>
> <read-data reader-name="demo"/>
> <read-data reader-name="ext"/>
> <inline-jdbc
> jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver"
> jdbc-uri="jdbc:derby:ofbiz;create=true"
> jdbc-username="ofbiz"
> jdbc-password="ofbiz"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"/>
> <!-- <jndi-jdbc jndi-server-name="localjndi"
> jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
> </datasource>
>