7:56 a.m.
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Configuration, Deployment, Process flow
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for identity
column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:11 a.m.
New subject: [JBoss JIRA] Commented: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=comments#action_12412969 ]
Kevin Conner commented on JBESB-1722:
-------------------------------------
These files are generated by hibernate, on behalf of jBPM. They should be copied across
to the SOA build from the build of jBPM.
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Configuration, Process flow, Deployment
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:45 a.m.
New subject: [JBoss JIRA] Assigned: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=all ]
Trevor Kirby reassigned JBESB-1722:
-----------------------------------
Assignee: Tom Baeyens
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Configuration, Process flow, Deployment
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Assigned To: Tom Baeyens
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:57 a.m.
New subject: [JBoss JIRA] Assigned: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=all ]
Kevin Conner reassigned JBESB-1722:
-----------------------------------
Assignee: (was: Tom Baeyens)
Keeping this part in ESB for now
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Configuration, Process flow, Deployment
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:38 a.m.
New subject: [JBoss JIRA] Commented: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=comments#action_12412988 ]
Kevin Conner commented on JBESB-1722:
-------------------------------------
It looks as if it will be safe to remove the pre-population of the jBPM tables, as it is
just example data (see linked SOA issue).
We will remove this for the CP and see what breaks.
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Configuration, Process flow, Deployment
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:04 a.m.
New subject: [JBoss JIRA] Assigned: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=all ]
Daniel Bevenius reassigned JBESB-1722:
--------------------------------------
Assignee: Daniel Bevenius
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Deployment, Configuration, Process flow
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Assigned To: Daniel Bevenius
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:52 a.m.
New subject: [JBoss JIRA] Assigned: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=all ]
Daniel Bevenius reassigned JBESB-1722:
--------------------------------------
Assignee: (was: Daniel Bevenius)
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Deployment, Configuration, Process flow
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:52 a.m.
New subject: [JBoss JIRA] Assigned: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=all ]
Tom Fennelly reassigned JBESB-1722:
-----------------------------------
Assignee: Tom Fennelly
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Deployment, Configuration, Process flow
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Assigned To: Tom Fennelly
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:52 a.m.
New subject: [JBoss JIRA] Work started: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=all ]
Work on JBESB-1722 started by Tom Fennelly.
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Deployment, Configuration, Process flow
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Assigned To: Tom Fennelly
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:03 a.m.
New subject: [JBoss JIRA] Assigned: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=all ]
Kevin Conner reassigned JBESB-1722:
-----------------------------------
Assignee: Kevin Conner (was: Tom Fennelly)
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Deployment, Configuration, Process flow
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Assigned To: Kevin Conner
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:05 a.m.
New subject: [JBoss JIRA] Closed: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[ http://jira.jboss.com/jira/browse/JBESB-1722?page=all ]
Kevin Conner closed JBESB-1722.
-------------------------------
Resolution: Done
CP fixed in revision 20252.
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: http://jira.jboss.com/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Deployment, Configuration, Process flow
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Assigned To: Kevin Conner
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:47 p.m.
New subject: [JBoss JIRA] Commented: (JBESB-1722) MSSQL: Unable to populate JBPM_ID_... tables
[
https://jira.jboss.org/jira/browse/JBESB-1722?page=com.atlassian.jira.plu...
]
Darrin Mison commented on JBESB-1722:
-------------------------------------
Proposed SOA 4.2 TP02 Release Note:
MSSQL: Initialisation of example data has been removed
MSSQL: Unable to populate JBPM_ID_... tables
--------------------------------------------
Key: JBESB-1722
URL: https://jira.jboss.org/jira/browse/JBESB-1722
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Configuration, Deployment, Process flow
Affects Versions: 4.2.1 CP2
Reporter: Martin Vecera
Assignee: Kevin Conner
Priority: Blocker
Fix For: 4.2.1 CP3
deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mssql.sql creates the MSSQL tables in a way that
prevents direct (concrete value) primary key insertion.
This makes SQL statements in deploy/jbpm.esb/jbpm-sql/import.sql fail:
08:40:01,503 WARN [ServiceController] Problem starting service
jboss.esb:service=JBPMDatabaseInitializer
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for
identity column in table 'JBPM_ID_USER' when IDENTITY_INSERT is set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at
org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5985
days inactive
6056
days old
11 comments
6 participants
participants (6)
-
Daniel Bevenius (JIRA) -
Darrin Mison (JIRA)
-
Kevin Conner (JIRA)
-
Martin Vecera (JIRA)
-
Tom Fennelly (JIRA)
-
Trevor Kirby (JIRA)