Hello,
We rebuilt Ofbiz to get the NPM to load all the files and we now get the
following error on our website.
*Type* Exception Report
*Message* Could not get next sequenced ID for sequence name: Visit
*Description* The server encountered an unexpected condition that prevented
it from fulfilling the request.
*Exception*
java.lang.IllegalArgumentException: Could not get next sequenced ID
for sequence name: Visit
org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2362)
org.apache.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2349)
org.apache.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:726)
org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:784)
org.apache.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:189)
org.apache.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:100)
org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:214)
org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96)
javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:45)
org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185)
org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156)
javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57)
org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71)
*Note* The full stack trace of the root cause is available in the server
logs.
On Sun, Nov 14, 2021 at 1:22 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:
> Hi Justine,
>
> Actually it's normally loaded by npm when you build OFBiz with Gradle.
> Gradle uses the
> https://plugins.gradle.org/plugin/com.github.node-gradle.node plugin for
> executing loading few js libs.
>
> What are you actually doing "When [you] go to open the JS files tomcat"?
>
>
> Le 14/11/2021 à 06:17, Justine Nowak a écrit :
> > Hi Jacques,
> >
> > When I go to open the JS files tomcat gives me this output- The requested
> > resource [/common/js/node_modules/jquery/dist/jquery.min.js] is not
> > available
> >
> > Where do I download the JS libs or does NPM do that?
> >
> >
> > On Sat, Nov 13, 2021 at 2:48 AM Jacques Le Roux <
> > jacques.le.r...@les7arts.com> wrote:
> >
> >> Forgot: note that when I speak about trunk and R18 I always speak about
> >> the HEAD versions, ie the last up to date versions.
> >>
> >> Le 13/11/2021 à 09:38, Jacques Le Roux a écrit :
> >>> Hi Justine,
> >>>
> >>> Mmm, that's no good. I know you made a versions mix at a moment. Which
> >> version are you now using? Or at least what is your primarily version?
> >>> Because in trunk we now use npm to dynamically load (once) some js libs
> >> (jQuery is one) but in R18 all js libs are preloaded.
> >>> As I see jquery-ui-1.13.0.min.js, I can conclude that you are rather
> >> basically using a R18 version. In trunk, npm dynamically loads jquery-ui
> >> and we
> >>> no longer put the version in the file name (it's anyway inside the
> >> file). So check that you have all the js libs downloaded.
> >>> I think you can neglect the 2nd point. It's a [Report Only]:
> >>>
> >>
> https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Content-Security-Policy-Report-Only
> >>> This said where do you get this error (URL)?
> >>>
> >>> HTH
> >>>
> >>> Jacques
> >>>
> >>>
> >>> Le 13/11/2021 à 06:39, Justine Nowak a écrit :
> >>>> Hi Jacques,
> >>>>
> >>>> This is what shows when we check the Console.
> >>>>
> >>>> Uncaught ReferenceError: jQuery is not defined
> >>>> at jquery-ui-1.13.0.min.js:6
> >>>> at jquery-ui-1.13.0.min.js:6
> >>>>
> >>>> [Report Only] Refused to load the stylesheet '
> >>>>
> >>
> https://fonts.googleapis.com/css2?family=Quicksand:wght@300;400;500;600;700&display=swap
> >> '
> >>>> because it violates the following Content Security Policy directive:
> >>>> "default-src 'self'". Note that 'style-src-elem' was not explicitly
> >> set, so
> >>>> 'default-src' is used as a fallback.
> >>>>
> >>>>
> >>>>
> >>>> On Fri, Nov 12, 2021 at 1:52 AM Jacques Le Roux <
> >>>> jacques.le.r...@les7arts.com> wrote:
> >>>>
> >>>>> Hi,
> >>>>>
> >>>>> You did not give enough information to help you. I suggest to have a
> >> look
> >>>>> with the js console in your browser (F12 key there)
> >>>>>
> >>>>> Jacques
> >>>>>
> >>>>> Le 11/11/2021 à 03:38, Justine Nowak a écrit :
> >>>>>> Hello,
> >>>>>>
> >>>>>> We got everything fixed, the CSS has not loaded and the system
> >> upgrade is
> >>>>>> finished. But once again we run into a product, non of the
> javascript
> >> is
> >>>>>> working, the button inside of the text field to bring up the popup
> >> search
> >>>>>> isn't showing and non of the expanded forms are opening up.
> >>>>>>
> >>>>>> How do we fix this?
> >>>>>>
> >>>>>>
> >>>>>> On Sun, Nov 7, 2021 at 2:18 AM Pierre Smits <pierresm...@apache.org
> >
> >>>>> wrote:
> >>>>>>> Goeiemoarn Justine,
> >>>>>>>
> >>>>>>> If the backend database of your OFBiz implementation is
> professional
> >>>>> grade
> >>>>>>> (meaning anything else than the default integrated Apache Derby),
> >>>>> cleanAll
> >>>>>>> won't delete your data.
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> Met vriendelijke groet,
> >>>>>>>
> >>>>>>> Pierre Smits
> >>>>>>> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/
> >
> >>>>> since
> >>>>>>> 2008 (without privileges)
> >>>>>>> Proud contributor to the ASF since 2006
> >>>>>>>
> >>>>>>> *Apache Directory <https://directory.apache.org>, PMC Member*
> >>>>>>>
> >>>>>>>
> >>>>>>> On Sun, Nov 7, 2021 at 7:42 AM Jacques Le Roux <
> >>>>>>> jacques.le.r...@les7arts.com>
> >>>>>>> wrote:
> >>>>>>>
> >>>>>>>> Hi Justine,
> >>>>>>>>
> >>>>>>>> It will "only" replace the current DB content by the demo data. So
> >> if
> >>>>> you
> >>>>>>>> have important data there you need to keep a dump and then
> >> meticulously
> >>>>>>>> replace it again. If you don't want all the demo date load only
> the
> >>>>> seed.
> >>>>>>>> checkhttps://
> >>>>>>>>
> >>
> ci.apache.org/projects/ofbiz/site/trunk/readme/html5/README.html#data-loading-tasks
> >>>>>>>> out
> >>>>>>>>
> >>>>>>>> With something like|<<gradlew "ofbiz --load-data
> >>>>>>>> readers=seed,seed-initial,ext,ext-demo">> you don't have to fear
> for
> >>>>> you
> >>>>>>>> own templates. Only data will be affected. Jacques |
> >>>>>>>>
> >>>>>>>> Le 06/11/2021 à 22:32, Justine Nowak a écrit :
> >>>>>>>>> Thank you for this information Jacques,
> >>>>>>>>>
> >>>>>>>>> gradlew cleanData loadAll - If we do this will it remove our
> >> database
> >>>>>>>>> content, or will it just load the ofbiz files. And if we have
> >>>>>>> customized
> >>>>>>>>> template files can we just save them and reupload them after?
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> On Sat, Nov 6, 2021 at 2:58 PM Jacques Le Roux<
> >>>>>>>> jacques.le.r...@les7arts.com>
> >>>>>>>>> wrote:
> >>>>>>>>>
> >>>>>>>>>> Hi Justine,
> >>>>>>>>>>
> >>>>>>>>>> Inline...
> >>>>>>>>>>
> >>>>>>>>>> Le 06/11/2021 à 20:46, Justine Nowak a écrit :
> >>>>>>>>>>> maybe mixing trunk data with 18 design perhaps??
> >>>>>>>>>>>
> >>>>>>>>>>> I believe that is the issue, how would we go with resolving
> this?
> >>>>>>>>>> I believe a simple "gradlew cleanData loadAll" should work if
> you
> >>>>> have
> >>>>>>>> not
> >>>>>>>>>> mixed code between R18 and trunk. If you mixed code then you
> must
> >>>>>>> start
> >>>>>>>>>> from scratch being sure that you keep the your own modified
> code.
> >>>>>>>>>>> Also,version 18.12 doesn't include the Helveticus themes.
> >>>>>>>>>> If you want Helveticus then you must use trunk
> >>>>>>>>>>
> >>>>>>>>>> HTH
> >>>>>>>>>>
> >>>>>>>>>> Jacques
> >>>>>>>>>>
> >>>>>>>>>>> -Justine
> >>>>>>>>>>>
> >>>>>>>>>>> On Sat, Nov 6, 2021 at 7:35 AM Pierre Smits<
> >> pierresm...@apache.org>
> >>>>>>>>>> wrote:
> >>>>>>>>>>>> Bonjour Justine,
> >>>>>>>>>>>>
> >>>>>>>>>>>> As the 18 branch has come available as a demo site, we can now
> >> - in
> >>>>>>> a
> >>>>>>>>>> handy
> >>>>>>>>>>>> kind of way - compare local implementations against what is in
> >> the
> >>>>>>>> repo.
> >>>>>>>>>>>> See e.ghttps://demo-stable.ofbiz.apache.org/accounting
> >>>>>>>>>>>>
> >>>>>>>>>>>> As it shows nothing wrong there, it seems that a mixup of
> >> events at
> >>>>>>>> your
> >>>>>>>>>>>> side (maybe mixing trunk data with 18 design perhaps??) led to
> >> the
> >>>>>>>> issue
> >>>>>>>>>>>> you reported here.
> >>>>>>>>>>>>
> >>>>>>>>>>>> I trust everything is ok now.
> >>>>>>>>>>>>
> >>>>>>>>>>>> Met vriendelijke groet,
> >>>>>>>>>>>>
> >>>>>>>>>>>> Pierre Smits
> >>>>>>>>>>>> *Proud* *contributor** of* Apache OFBiz<
> >> https://ofbiz.apache.org/>
> >>>>>>>>>> since
> >>>>>>>>>>>> 2008 (without privileges)
> >>>>>>>>>>>> Proud contributor to the ASF since 2006
> >>>>>>>>>>>>
> >>>>>>>>>>>> *Apache Directory<https://directory.apache.org>, PMC Member*
> >>>>>>>>>>>>
> >>>>>>>>>>>>
> >>>>>>>>>>>> On Sat, Nov 6, 2021 at 1:10 AM Justine Nowak<
> >> cougar11...@gmail.com
> >>>>>>>>>>>> wrote:
> >>>>>>>>>>>>
> >>>>>>>>>>>>> Are you confident that data sets were loaded correctly?
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> I'm not sure they were, we did try to upgrade Ofbiz last week
> >> to
> >>>>>>>> 18.12
> >>>>>>>>>>>> but
> >>>>>>>>>>>>> that was unsuccessful so we reverted back to the Trunk
> version.
> >>>>>>>>>>>>>
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> On Fri, Nov 5, 2021 at 2:40 AM Pierre Smits<
> >>>>> pierresm...@apache.org
> >>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>
> >>>>>>>>>>>>>> Bore Da Justine,
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>> Weird. I tried it using the various applications with the
> >> themes
> >>>>>>>>>>>>> available
> >>>>>>>>>>>>>> in trunk this morning, and could not detect anything wrong
> on
> >>>>>>> first
> >>>>>>>>>>>>> sight
> >>>>>>>>>>>>>> (visual inspection in browser and in log).
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>> Are you confident that data sets were loaded correctly?
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>> Met vriendelijke groet,
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>> Pierre Smits
> >>>>>>>>>>>>>> *Proud* *contributor** of* Apache OFBiz<
> >>>>> https://ofbiz.apache.org/
> >>>>>>>>>>>>> since
> >>>>>>>>>>>>>> 2008 (without privileges)
> >>>>>>>>>>>>>> Proud contributor to the ASF since 2006
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>> *Apache Directory<https://directory.apache.org>, PMC
> Member*
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>> On Thu, Nov 4, 2021 at 6:43 PM Justine Nowak<
> >>>>>>> cougar11...@gmail.com>
> >>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>>> Hi Pierre,
> >>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>> We are using the Trunk version and there are no custom CSS
> /
> >>>>>>>> themes.
> >>>>>>>>>>>>>>> On Thu, Nov 4, 2021 at 4:09 AM Pierre Smits<
> >>>>>>> pierresm...@apache.org
> >>>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> Bonjour Justine,
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> Unfortunately, settings regarding this mailing list
> doesn't
> >>>>>>> allow
> >>>>>>>>>>>>>>>> attachments to come through.
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> Can you tell which OFBiz version you are using, and
> whether
> >> the
> >>>>>>>>>>>>>> theme/css
> >>>>>>>>>>>>>>>> is custom?
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> Met vriendelijke groet,
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> Pierre Smits
> >>>>>>>>>>>>>>>> *Proud* *contributor** of* Apache OFBiz <
> >>>>>>>> https://ofbiz.apache.org/
> >>>>>>>>>>>>>>> since
> >>>>>>>>>>>>>>>> 2008 (without privileges)
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> *Apache Directory<https://directory.apache.org>, PMC
> >> Member*
> >>>>>>>>>>>>>>>> Apache Incubator<https://incubator.apache.org>, committer
> >>>>>>>>>>>>>>>> Apache Steve<https://steve.apache.org>, committer
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> On Wed, Nov 3, 2021 at 9:49 PM Justine Nowak <
> >>>>>>>>>>>> cougar11...@gmail.com>
> >>>>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>> Hello,
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>> The past few days our css in our backend applications
> >>>>> (catalog,
> >>>>>>>>>>>>>>> partymgr,
> >>>>>>>>>>>>>>>>> webtools) has not been loading.
> >>>>>>>>>>>>>>>>> [image: Screen Shot 2021-11-03 at 3.47.51 PM.png]
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>> The HTML code shows the CSS link connected but it doesn't
> >>>>>>> render
> >>>>>>>>>>>>> it.
> >>>>>>>>>>>>>>> Even
> >>>>>>>>>>>>>>>>> after refreshing and clearing all cookies, and on
> multiple
> >>>>>>>>>>>> devices.
> >>>>>>>>>>>>>>>>> How do we fix this?
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>> -Justine
> >>>>>>>>>>>>>>>>>
>
