Merci Amine pour la recherche de la source du problème. Je corrigerai
dans HEAD si l'erreur est toujours présente.
Peter
Le dimanche 11 février 2007 à 14:26 +0100, Amine AZZI a écrit :
> Oui effectivement, le problème était dans la methode
> org.ofbiz.accounting.staticdata.GlPeriodWorker findAllOrderBy
>
> return delegator.findAll( "GlPeriod",
> UtilMisc.toList("glPeriodTypeEnumId", "parentPeriodIdNum DESC",
> "glPeriodTypeEnumId", "fromDate DESC") );
>
> l'attribut glPeriodTypeEnumId est mentionné deux fois dans la liste de
> order by. Domage je travail sur la version téléchargé par http donc je
> ne peux pas faire un patch. Enfin ça devrait intéréssé que ceux qui
> utilisent MS SQL server ce qui est rare dans le monde open source.
>
> Amine.
>
> 2007/2/11, Peter Goron <peter.goron@...>:
> Bonjour Amine,
>
> Je pense qu'il faut que tu vérifies en priorité le composant
> car je
> doute que ça vienne de l'entity engine (qui pourrait cependant
> détecter
> ce type de mauvaise utilisation).
>
> Il faut que tu trouves la requête à l'origine de cette erreur
> et que tu
> contrôles la construction de la liste orderBy.
>
>
> Peter
>
> Le dimanche 11 février 2007 à 12:03 +0100, Amine AZZI a
> écrit :
> > Bonjour,
> >
> > On utilisant Neogia 0.9.4 avec SQL server 2005 je reçois
> certaines
> > erreurs dans le module comptabilité que je ne recevais pas
> avec Derby.
> > L'erreur est clair il s'agit d'une colone qui est reprise
> deux fois
> > dans liste de order by. Comment faire pour changer ça
> repidement
> > s'agit il d'un bug dans l'entity engine ou dans le composant
> lui
> > même?
> >
> > Cordialement.
> > Amine.
> >
> > voici le log que j'ai reçu en essayant l'ecran de
> configuration.
> >
> > 75224375[ TransactionUtil.java:287:INFO ]
> > [TransactionUtil.setRollbackOnly] transaction rollback only
> not set,
> > rollback only is already set.
> > 75224375[AccountTypeServices.java:106:ERROR] Error in
> findByAndCache
> > for Enumeration :The current transaction is marked for
> rollback, not
> > beginning a new transaction and aborting current operation;
> the
> > rollbackOnly was caused by: Failure in findByCondition
> operation for
> > entity [GlPeriod]:
> org.ofbiz.entity.GenericDataSourceException: SQL
> > Exception while executing the following:SELECT ID_NUM,
> ID_NAME,
> > FROM_DATE, THRU_DATE, PERIOD_STATUS_STATUS_ID,
> PARENT_PERIOD_ID_NUM,
> > GL_PERIOD_TYPE_ENUM_ID, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP,
> > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.GL_PERIOD ORDER BY
> > GL_PERIOD_TYPE_ENUM_ID ASC, PARENT_PERIOD_ID_NUM DESC,
> > GL_PERIOD_TYPE_ENUM_ID ASC, FROM_DATE DESC (A column has
> been
> > specified more than once in the order by list. Columns in
> the order by
> > list must be unique.). Rolling back
> > transaction.org.ofbiz.entity.GenericDataSourceException: SQL
> Exception
> > while executing the following:SELECT ID_NUM, ID_NAME,
> FROM_DATE,
> > THRU_DATE, PERIOD_STATUS_STATUS_ID, PARENT_PERIOD_ID_NUM,
> > GL_PERIOD_TYPE_ENUM_ID, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP,
> > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.GL_PERIOD ORDER BY
> > GL_PERIOD_TYPE_ENUM_ID ASC, PARENT_PERIOD_ID_NUM DESC,
> > GL_PERIOD_TYPE_ENUM_ID ASC, FROM_DATE DESC (A column has
> been
> > specified more than once in the order by list. Columns in
> the order by
> > list must be unique.) (SQL Exception while executing the
> > following:SELECT ID_NUM, ID_NAME, FROM_DATE, THRU_DATE,
> > PERIOD_STATUS_STATUS_ID, PARENT_PERIOD_ID_NUM,
> GL_PERIOD_TYPE_ENUM_ID,
> > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> > CREATED_TX_STAMP FROM dbo.GL_PERIOD ORDER BY
> GL_PERIOD_TYPE_ENUM_ID
> > ASC, PARENT_PERIOD_ID_NUM DESC, GL_PERIOD_TYPE_ENUM_ID ASC,
> FROM_DATE
> > DESC (A column has been specified more than once in the
> order by list.
> > Columns in the order by list must be unique.))
> > 75224375[ BshUtil.java:176:WARN ]
> > ---- exception report
> > ----------------------------------------------------------
> > WARNING: no cause (from getCause) found for BSH EvalError:
> Sourced
> > file:
> >
> component://naccounting/script/widgetActions/staticdata/developed/AccountingConfiguration.bsh : Method Invocation AccountTypeWorker.findAllForDropDown : at Line: 44 : in file: component://naccounting/script/widgetActions/staticdata/developed/AccountingConfiguration.bsh : AccountTypeWorker .findAllForDropDown ( delegator )
> >
> > Target exception: java.lang.NullPointerException
> >
> > Exception: bsh.TargetError
> > Message: Sourced file:
> >
> component://naccounting/script/widgetActions/staticdata/developed/AccountingConfiguration.bsh : Method Invocation
> >
> -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web
> services, security?
> > Get stuff done quickly with pre-integrated technology to
> make your job easier.
> > Download IBM WebSphere Application Server v.1.0.1 based on
> Apache Geronimo
> >
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> Neogia-ofbiz-fr mailing list
> Neogia-ofbiz-fr@...
> https://lists.sourceforge.net/lists/listinfo/neogia-ofbiz-fr
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web
> services, security?
> Get stuff done quickly with pre-integrated technology to make
> your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on
> Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Neogia-ofbiz-fr mailing list
> Neogia-ofbiz-fr@...
> https://lists.sourceforge.net/lists/listinfo/neogia-ofbiz-fr
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________ Neogia-ofbiz-fr mailing list Neogia-ofbiz-fr@... https://lists.sourceforge.net/lists/listinfo/neogia-ofbiz-fr
|