Te fijaste que valor tiene en la tabla, digo en la base de datos directamente??
me suena que tiene ya el autonumerado, y por eso falla,
--
A/S Juan Manuel Azpiroz
San José - Uruguay
-- El 2 de marzo de 2012 10:00, Ricardo Calella <rcalella@profesionalesasociados.com> escribió:
Hola pude comprobar que se corrigió el error que me daba al hacer el deploy de los procesos , pero ahora me da error en el proceso de reorg en varias tablas
Export business processes for deployment Success
========== Retrieve Workflow Runtime Version From Database started ==========
Current version: 10.1.06
Retrieve Workflow Runtime Version From Database Success
========== Upgrade workflow tables from version '10.1.06' to version '10.2.00' started ==========
Executing tables reorganization 'WFUpgReorgXev1U4_Xev2'...
Table DWFInstance has 0 records
Table DWFItems has 0 records
...
...
...
Updating table DWFUsrRoles . STARTED
Waiting for 54 submitted procs to end...
java.sql.SQLException: Cannot insert explicit value for identity column in table 'GXA0011' when IDENTITY_INSERT is set to OFF.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
Updating table WFInstPrc . FAILED
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
Updating table DWFItems . ENDED
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
Updating table CAApp . STARTED
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
Updating table DWFUsers . ENDED
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
Updating table CAAudCon . STARTED
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at com.genexus.db.driver.GXPreparedStatement.executeUpdate(Unknown Source)
at com.genexus.db.UpdateCursor.postExecute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at com.gxflow.wfinstprcconversion.privateExecute(wfinstprcconversion.java:210)
at com.gxflow.wfinstprcconversion.execute_int(wfinstprcconversion.java:39)
at com.gxflow.wfinstprcconversion.execute(wfinstprcconversion.java:31)
at com.gxflow.reorg.ReorganizeWFInstPrc(reorg.java:275)
at com.gxflow.reorg.submitReorg(reorg.java:3247)
at com.genexus.util.ReorgSubmitThread.run(Unknown Source)
Updating table CAAudCon . ENDED
Updating table CAConMd . STARTED
....
...
...
Updating table WFWrkItems . STARTED
java.sql.SQLException: IDENTITY_INSERT is already ON for table 'sigebasexev1.dbo.GXA0011'. Cannot perform SET operation for table 'GXA0141'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1120)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1073)
at com.genexus.db.driver.GXStatement.executeUpdate(Unknown Source)
at com.genexus.db.DBConnectionManager.executeStatement(Unknown Source)
at com.genexus.ExecuteDirectSQL.execute(Unknown Source)
at com.gxflow.wfwrkitemsconversion.privateExecute(wfwrkitemsconversion.java:45)
at com.gxflow.wfwrkitemsconversion.execute_int(wfwrkitemsconversion.java:39)
at com.gxflow.wfwrkitemsconversion.execute(wfwrkitemsconversion.java:31)
at com.gxflow.reorg.ReorganizeWFWrkItems(reorg.java:2037)
at com.gxflow.reorg.submitReorg(reorg.java:3493)
at com.genexus.util.ReorgSubmitThread.run(Unknown Source)
java.sql.SQLException: Cannot insert explicit value for identity column in table 'GXA0141' when IDENTITY_INSERT is set to OFF.
Updating table WFWrkItems . FAILED
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
The reorganization process was not successfully completed.
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at com.genexus.db.driver.GXPreparedStatement.executeUpdate(Unknown Source)
at com.genexus.db.UpdateCursor.postExecute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at com.gxflow.wfwrkitemsconversion.privateExecute(wfwrkitemsconversion.java:359)
at com.gxflow.wfwrkitemsconversion.execute_int(wfwrkitemsconversion.java:39)
at com.gxflow.wfwrkitemsconversion.execute(wfwrkitemsconversion.java:31)
at com.gxflow.reorg.ReorganizeWFWrkItems(reorg.java:2037)
at com.gxflow.reorg.submitReorg(reorg.java:3493)
at com.genexus.util.ReorgSubmitThread.run(Unknown Source)
Updating table WFProcess . FAILED
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getCatalog(ConnectionJDBC2.java:2036)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:617)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:420)
at com.genexus.db.driver.GXPreparedStatement.executeUpdate(Unknown Source)
at com.genexus.db.UpdateCursor.postExecute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at com.gxflow.wfprocessconversion.privateExecute(wfprocessconversion.java:272)
at com.gxflow.wfprocessconversion.execute_int(wfprocessconversion.java:39)
at com.gxflow.wfprocessconversion.execute(wfprocessconversion.java:31)
at com.gxflow.reorg.ReorganizeWFProcess(reorg.java:1147)
at com.gxflow.reorg.submitReorg(reorg.java:3403)
at com.genexus.util.ReorgSubmitThread.run(Unknown Source)
Updating table WFURRst . ENDED
Updating table WFWrkUsers . STARTED
DBConnectionManager.disconnectAll: java.sql.SQLException: Invalid state, the Connection object is closed.
java.lang.IllegalArgumentException: Can't find user information for handle 445654152
at com.genexus.db.DBConnectionManager.getUserInformation(Unknown Source)
Updating table WFTask . FAILED
at com.genexus.db.DefaultExceptionErrorHandler.handleSQLError(Unknown Source)
at com.genexus.db.DataStoreProvider.readNext(Unknown Source)
at com.gxflow.wftaskconversion.privateExecute(wftaskconversion.java:933)
at com.gxflow.wftaskconversion.execute_int(wftaskconversion.java:39)
at com.gxflow.wftaskconversion.execute(wftaskconversion.java:31)
at com.gxflow.reorg.ReorganizeWFTask(reorg.java:1444)
at com.gxflow.reorg.submitReorg(reorg.java:3433)
at com.genexus.util.ReorgSubmitThread.run(Unknown Source)
Upgrade workflow tables from version '10.1.06' to version '10.2.00' Failed
========== Update Static Workflow Metadata started ==========
Exception in thread "main" java.sql.SQLException: Invalid object name 'WFNotTpl'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at com.genexus.db.driver.GXDBMSsqlserver.executeQuery(Unknown Source)
at com.genexus.db.driver.GXPreparedStatement.executeQuery(Unknown Source)
at com.genexus.db.ForEachCursor.postExecute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at com.gxflow.pwfloaddataxml.privateExecute(pwfloaddataxml.java:1631)
at com.gxflow.pwfloaddataxml.execute_int(pwfloaddataxml.java:52)
at com.gxflow.pwfloaddataxml.execute(pwfloaddataxml.java:41)
at com.gxflow.apwfwinloaddataxml.privateExecute(apwfwinloaddataxml.java:87)
at com.gxflow.apwfwinloaddataxml.execute_int(apwfwinloaddataxml.java:75)
at com.gxflow.apwfwinloaddataxml.execute(apwfwinloaddataxml.java:65)
at com.gxflow.apwfwinloaddataxml.executeCmdLine(apwfwinloaddataxml.java:40)
at com.gxflow.apwfwinloaddataxml.main(apwfwinloaddataxml.java:25)
Update Static Workflow Metadata Failed
error: Build cancelled.
error: Operation Canceled by the user
Build Developer Menu Failed
Saludos
-- Ricardo Calella Profesionales Asociados Neuquén CP 8300 Argentina Celular : 0299 (15)5 887920
A/S Juan Manuel Azpiroz
San José - Uruguay
Por favor tenga en cuenta el Medio Ambiente, preservarlo depende de todos
Has recibido este mensaje porque estás suscrito al grupo "GeneXus" de Grupos de Google.
Para publicar una entrada en este grupo, envía un correo electrónico a genexus@googlegroups.com.
Para anular tu suscripción a este grupo, envía un correo electrónico a genexus+unsubscribe@googlegroups.com
Para tener acceso a más opciones, visita el grupo en http://groups.google.com/group/genexus?hl=es.
0 Response to "Re: [xev2] Error en reorganización de WF"
Publicar un comentario