Genexus

Juan Manuel entiendo el mensaje del error, pero yo planteo el error porque estas tablas las crea y mantiene automaticamente la api de WF, por lo tanto estos problemas los deberia resolver lel proceso de migración de la ev1 a la ev2.
Aclaro que estoy con el NB 54280 y sql 2008.

Saludos

Ricardo Calella Profesionales Asociados Neuquén CP 8300 Argentina Celular : 0299 (15)5 887920

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,

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

http://uy.linkedin.com/in/juanmazpiroz

 

Por favor tenga en cuenta el Medio Ambiente, preservarlo depende de todos