search

jbossdemocentral / bpms-travel-agency-demo

A JBoss BPM Suite demo project around a travel agency booking workflow.
35 stars 43 forks source link

JdbcSQLException: Table "PROCESSINSTANCELOG" not found; SQL statement #6

Closed pbaker01 closed 9 years ago

pbaker01 commented 9 years ago

The install looks clean but I'm unable to launch the demo. The server logs contains several errors about missing table: PROCESSINSTANCELOG.
Envt: Windows 7 x64

I tried installing on several machines, all receive the same error.

Am I missing a step?

End of Install: Connected to Management Interface.

1 /profile=default/subsystem=web/virtual-server=default-host/sso=configuration:add()

2 /profile=full/subsystem=web/virtual-server=default-host/sso=configuration:add()

3 /profile=ha/subsystem=web/virtual-server=default-host/sso=configuration:add()

4 /profile=full-ha/subsystem=web/virtual-server=default-host/sso=configuration:add()

The batch executed successfully Script S:\JBoss\demos\bpms-travel-agency-demo-master\target\/jboss-eap-6.1/cli-scripts/add-sso-conf-domain.cli ran successfully. Starting process Shutdown domain (58/60) Trying to connect to Management Interface...(1/5). Connected to Management Interface. {"outcome" => "success"}

The connection to the controller has been closed as the result of the shutdown operation. (Although the command prompt will wrongly indicate connection until the next line is entered) Application Server successfully stopped. Starting process Cleanup (59/60) Successfully wrote properties to: S:\JBoss\demos\bpms-travel-agency-demo-master\target\jboss-eap-6.1\standalone\configuration\logging.properties Starting process Clean up (60/60) [ Processing finished ] [ Automated installation done ]

Error trying to start server (standalone.bat)

13:14:52,853 ERROR [org.jboss.dashboard.dataset.sql.SQLDataSet](ServerService Thread Pool -- 68) Error in load() SQLDataset. SQL = select total.processname, ifnull(total.instances,0) total, ifnull(active.instances_act,0) active, ifnull(completed.instances_compl,0) completed, ifnull(pending.instances_pend,0) pending, ifnull(suspended.instances_susp,0) suspended, ifnull(aborted.instances_abrt,0) aborted from (select pi.processinstanceid as pId, pi.processname as processname, count(*) as instances

            from processinstancelog pi group by pi.processinstanceid,processname) as total
            left outer join
            (select pi.processinstanceid as pId, count(*) as instances_act
            from processinstancelog pi
            where pi.status=1 group by pi.processinstanceid) as active
            on (total.pId=active.pId)
            left outer join
            (select pi.processinstanceid as pId, count(*) as instances_compl
            from processinstancelog pi
            where pi.status=2 group by pi.processinstanceid) as completed
            on (total.pId=completed.pId)
            left outer join
            (select pi.processinstanceid as pId, count(*) as instances_pend
            from processinstancelog pi
            where pi.status=0 group by pi.processinstanceid) as pending
            on (total.pId=pending.pId)
            left outer join
            (select pi.processinstanceid as pId, count(*) as instances_susp
            from processinstancelog pi
            where pi.status=4 group by pi.processinstanceid) as suspended
            on (total.pId=suspended.pId)
            left outer join
            (select pi.processinstanceid as pId, count(*) as instances_abrt
            from processinstancelog pi
            where pi.status=3 group by pi.processinstanceid) as aborted
            on (total.pId=aborted.pId)
            where 1 = 1
            order by processname: org.h2.jdbc.JdbcSQLException: Table "PROCESSINSTANCELOG" not found; SQL statement:

select total.processname, ifnull(total.instances,0) total, ifnull(active.instances_act,0) active, ifnull(completed.instances_compl,0) completed, ifnull(pending.instances_pend,0) pending, ifnull(suspended.instances_susp,0) suspended, ifnull(aborted.instancesabrt,0) aborted from (select pi.processinstanceid as pId, pi.processname as processname, count() as instances from processinstancelog pi group by pi.processinstanceid,processname) as total left outer join (select pi.processinstanceid as pId, count(_) as instances_act

sabre1041 commented 9 years ago

Windows installation script did not have the most recent changes. Completed installation and tested demo successfully on Win7 x64 with the modifications in PR addressed in #7

pbaker01 commented 9 years ago

Thank you for following up. I'm still getting the same error using the updated init.bat script.

The install log looks clean but when I start the server (standalone) I receive errors for missing table (described in original post).

21:44:00,934 INFO [org.jboss.dashboard.kpi.KPIInitialModule](ServerService Thread Pool -- 57) Parsing KPI's XML file: WEB-INF/etc/appdata/initialData/jbpmKPIs.xml 21:44:00,981 INFO [org.jboss.weld.deployer](MSC service thread 1-11) JBAS016002: Processing weld deployment business-central.war 21:44:01,262 ERROR [org.jboss.dashboard.dataset.sql.SQLDataSet](ServerService Thread Pool -- 57) Error in load() SQLDataset. SQL = select total.processname, ifnull(total.instances,0) total, ifnull(ac tive.instances_act,0) active, ifnull(completed.instances_compl,0) completed, ifnull(pending.instances_pend,0) pending, ifnull(suspended.instances_susp,0) suspended, ifnull(aborted.instancesabrt,0) ab orted from (select pi.processinstanceid as pId, pi.processname as processname, count() as instances from processinstancelog pi group by pi.processinstanceid,processname) as total left outer join (select pi.processinstanceid as pId, count(_) as instancesact from processinstancelog pi where pi.status=1 group by pi.processinstanceid) as active on (total.pId=active.pId) left outer join (select pi.processinstanceid as pId, count() as instancescompl from processinstancelog pi where pi.status=2 group by pi.processinstanceid) as completed on (total.pId=completed.pId) left outer join (select pi.processinstanceid as pId, count() as instancespend from processinstancelog pi where pi.status=0 group by pi.processinstanceid) as pending on (total.pId=pending.pId) left outer join (select pi.processinstanceid as pId, count() as instancessusp from processinstancelog pi where pi.status=4 group by pi.processinstanceid) as suspended on (total.pId=suspended.pId) left outer join (select pi.processinstanceid as pId, count() as instances_abrt from processinstancelog pi where pi.status=3 group by pi.processinstanceid) as aborted on (total.pId=aborted.pId) where 1 = 1 order by processname: org.h2.jdbc.JdbcSQLException: Table "PROCESSINSTANCELOG" not found; SQL statement: select total.processname, ifnull(total.instances,0) total, ifnull(active.instances_act,0) active, ifnull(completed.instances_compl,0) completed, ifnull(pending.instances_pend,0) pending, ifnull(suspen ded.instances_susp,0) suspended, ifnull(aborted.instancesabrt,0) aborted from (select pi.processinstanceid as pId, pi.processname as processname, count() as instances from processinstancelog pi group by pi.processinstanceid,processname) as total left outer join (select pi.processinstanceid as pId, count(_) as instances_act from processinstancelog pi where pi.status=1 group by pi.processinstanceid) as active

Here is the init.bat contents. Please confirm if have the correct file.

@ECHO OFF setlocal

set PROJECT_HOME=%~dp0 set DEMO=Travel Agency Demo set AUTHORS=Nirja Patel, Shepherd Chengeta, Eric D. Schabell set PROJECT=git@github.com:jbossdemocentral/bpms-travel-agency-demo.git set PRODUCT=JBoss BPM Suite set JBOSS_HOME=%PROJECT_HOME%target\jboss-eap-6.1 set SERVER_DIR=%JBOSS_HOME%\standalone\deployments\ set SERVER_CONF=%JBOSS_HOME%\standalone\configuration\ set SERVER_BIN=%JBOSS_HOME%\bin set SRC_DIR=%PROJECT_HOME%installs set SUPPORT_DIR=%PROJECT_HOME%support set PRJ_DIR=%PROJECT_HOME%projects set BPMS=jboss-bpms-installer-6.0.3.GA-redhat-1.jar set VERSION=6.0.3

REM wipe screen. cls

echo. echo ################################################################# echo ## ##
echo ## Setting up the %DEMO% ## echo ## ##
echo ## ##
echo ## #### #### # # ### # # ##### ##### ##### ## echo ## # # # # # # # # # # # # # # ## echo ## #### #### # # # ## # # # # ### ## echo ## # # # # # # # # # # # ## echo ## #### # # # ### ##### ##### # ##### ## echo ## ##
echo ## ##
echo ## brought to you by, ##
echo ## %AUTHORS% ## echo ## ##
echo ## %PROJECT%## echo ## ##
echo ################################################################# echo.

REM make some checks first before proceeding.
if exist %SRC_DIR%\%BPMS% ( echo Product sources are present... echo. ) else ( echo Need to download %BPMS% package from the Customer Support Portal echo and place it in the %SRC_DIR% directory to proceed... echo. GOTO :EOF )

REM Move the old JBoss instance, if it exists, to the OLD position. if exist %JBOSS_HOME% ( echo - existing JBoss product install removed... echo. rmdir /s /q target" )

REM Run installer. echo Product installer running now... echo. call java -jar %SRC_DIR%/%BPMS% %SUPPORT_DIR%\installation-bpms -variablefile %SUPPORT_DIR%\installation-bpms.variables

if not "%ERRORLEVEL%" == "0" ( echo Error Occurred During %PRODUCT% Installation! echo. GOTO :EOF )

echo - setting up demo projects... echo.

echo - enabling demo accounts role setup in application-roles.properties file... echo. xcopy /Y /Q "%SUPPORT_DIR%\application-roles.properties" "%SERVER_CONF%" echo.

mkdir "%SERVER_BIN%.niogit\" xcopy /Y /Q /S "%SUPPORT_DIR%\bpm-suite-demo-niogit*" "%SERVER_BIN%.niogit\" echo.

echo. echo - setting up web services... echo. call mvn clean install -f %PRJ_DIR%/pom.xml xcopy /Y /Q "%PRJ_DIR%\acme-demo-flight-service\target\acme-flight-service-1.0.war" "%SERVER_DIR%" xcopy /Y /Q "%PRJ_DIR%\acme-demo-hotel-service\target\acme-hotel-service-1.0.war" "%SERVER_DIR%"

echo. echo - adding acmeDataModel-1.0.jar to business-central.war/WEB-INF/lib xcopy /Y /Q %PRJ_DIR%\acme-data-model\target\acmeDataModel-1.0.jar %SERVER_DIR%\business-central.war\WEB-INF\lib

echo. echo - deploying external-client-ui-form-1.0.war to EAP deployments directory xcopy /Y /Q %PRJ_DIR%\external-client-ui-form\target\external-client-ui-form-1.0.war %SERVER_DIR%

echo. echo - setting up standalone.xml configuration adjustments... echo. xcopy /Y /Q "%SUPPORT_DIR%\standalone.xml" "%SERVER_CONF%" echo.

echo. echo - updating the CustomWorkItemHandler.conf file to use the appropriate email server... xcopy /Y /Q %SUPPORT_DIR%\CustomWorkItemHandlers.conf %SERVER_DIR%\business-central.war\WEB-INF\classes\META-INF\

REM Optional: uncomment this to install mock data for BPM Suite REM REM echo - setting up mock bpm dashboard data... REM echo. REM xcopy /Y /Q "%SUPPORT_DIR%\1000_jbpm_demo_h2.sql" "%SERVER_DIR%\dashbuilder.war\WEB-INF\etc\sql" REM echo.

echo. echo ======================================================================== echo = = echo = You can now start the %PRODUCT% with: = echo = = echo = %SERVER_BIN%\standalone.bat = echo = = echo = Login into business central at: = echo = = echo = http://localhost:8080/business-central [u:erics / p:bpmsuite1!] = echo = = echo = See README.md for general details to run the various demo cases. = echo = = echo = %PRODUCT% %VERSION% %DEMO% Setup Complete. = echo = = echo ======================================================================== echo.

travebpmserr

sabre1041 commented 9 years ago

The script appears to be correct. Would you be able to confirm the following files are present on the BPMS file system:

If you would be able to detail your installation and server startup process along with any logs, it would also be helpful

eschabell commented 9 years ago

Just assigned to sabre1041 as he is able to test on windows, but I can throw out some ideas to check:

  1. make sure the deployments directory indeed contains the various war files that are build and deployed into the JBoss server on install (init.bat run).
  2. make sure ports are open on windows, often an issue.
  3. the last log you posted shows the process actually being started, but it fails to find the flight and hotel web services...
  4. run a clean install: remove entire bpms-travel-agency-demo/target directory, run init.bat (attach copy of output of the init.bat), start server, login, build&deploy process project, start a process with external UI or via dashboard, attach server.log and finally show the contents of the JBoss deployments directory.
eschabell commented 9 years ago

With no follow up assuming this has been taken care of, closing for now, feel free to re-open and update if needed.