OFBiz › OFBiz - User

Table missing so can't login

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

11 messages Options

BJ Freeman

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"/>

</datasource>

Adrian Crum

Re: Table missing so can't login

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"/>
> 
> </datasource>
>
>

Jacques Le Roux

Re: Table missing so can't login

Administrator

In reply to this post by BJ Freeman

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" <[hidden email]>

BJ Freeman

Re: Table missing so can't login

In reply to this post by Adrian Crum

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"/>
>> 
>> </datasource>
>>
>>
>
>
>

BJ Freeman

Re: Table missing so can't login

In reply to this post by Jacques Le Roux

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" <[hidden email]>
>> [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"/>
>> 
>> </datasource>
>>
>
>
>

Adrian Crum

Re: Table missing so can't login

In reply to this post by BJ Freeman

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"/>
>>> 
>>> </datasource>
>>>
>>>
>>
>>
>
>

BJ Freeman

Re: Table missing so can't login

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"/>
>>>> 
>>>> </datasource>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
>

Adrian Crum

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"/>
>>>>> 
>>>>> </datasource>
>>>>>
>>>>>
>>>>
>>>
>>
>>
>
>

BJ Freeman

Re: Table missing so can't login

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"/>
>>>>>> 
>>>>>> </datasource>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>
>>
>
>
>

Jacques Le Roux

Re: Table missing so can't login

Administrator

In reply to this post by Adrian Crum

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" <[hidden email]>
To: <[hidden email]>
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"/>
>>>>>> 
>>>>>> </datasource>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>
>>
>

Jacques Le Roux

Re: Table missing so can't login

Administrator

In reply to this post by BJ Freeman

Both files are needed, so for now at least one entitygroup.xml and an ofbiz-component.xml file referencing the entity-group
org.ofbiz defined in the sole entitygroup.xml file.

I revet in assetmaint and continue to search why...

Jacques

----- Original Message -----
From: "Jacques Le Roux" <[hidden email]>
To: <[hidden email]>
Sent: Friday, July 11, 2008 9:09 PM
Subject: Re: Table missing so can't login

>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" <[hidden email]>
> To: <[hidden email]>
> 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"/>
>>>>>>> 
>>>>>>> </datasource>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>