Re: [xev2] Error en reorganización de WF

Publicado por Zina ,

Esto parece ser porque está tratando de retomar la reorganización anterior. Elimina el archivo resumereorg.txt que te quedó en el directorio "Web" del modelo Java.


2012/3/2 Ricardo Calella <rcalella@profesionalesasociados.com>
Hola Germán probe un par de veces y sigue con errores, aunque no los mismos

Updating table DWFItems . STARTED

Updating table DWFItems . ENDED
Updating table DWFUsrRoles . STARTED
java.sql.SQLException: Cannot find the object "GXA0011" because it does not exist or you do not have permissions.

    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)
Updating table DWFUsers . STARTED

    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.wfinstprcconversion.privateExecute(wfinstprcconversion.java:45)

    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)
java.sql.SQLException: Invalid object name 'GXA0020'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
Updating table DWFUsrRoles . FAILED

    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.genexus.db.DataStoreProvider.execute(Unknown Source)
    at com.gxflow.dwfusrrolesconversion.privateExecute(dwfusrrolesconversion.java:46)
    at com.gxflow.dwfusrrolesconversion.execute_int(dwfusrrolesconversion.java:39)
    at com.gxflow.dwfusrrolesconversion.execute(dwfusrrolesconversion.java:31)
    at com.gxflow.reorg.ReorganizeDWFUsrRoles(reorg.java:419)
    at com.gxflow.reorg.submitReorg(reorg.java:3259)
    at com.genexus.util.ReorgSubmitThread.run(Unknown Source)
Updating table CAApp . STARTED
Updating table CAApp . ENDED

Updating table CAConMd . STARTED
Updating table CAConMd . FAILED
java.sql.SQLException: Invalid object name 'GXA0030'.

    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.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.genexus.db.DataStoreProvider.execute(Unknown Source)
    at com.gxflow.caconmdconversion.privateExecute(caconmdconversion.java:46)
    at com.gxflow.caconmdconversion.execute_int(caconmdconversion.java:39)
    at com.gxflow.caconmdconversion.execute(caconmdconversion.java:31)
    at com.gxflow.reorg.ReorganizeCAConMd(reorg.java:493)
    at com.gxflow.reorg.submitReorg(reorg.java:3277)
    at com.genexus.util.ReorgSubmitThread.run(Unknown Source)
java.sql.SQLException: Invalid object name 'GXA0019'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
Updating table DWFUsers . FAILED

    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)
Updating table WFInstPrc . FAILED

    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.genexus.db.DataStoreProvider.execute(Unknown Source)
    at com.gxflow.dwfusersconversion.privateExecute(dwfusersconversion.java:46)

Updating table CAAudCon . STARTED
    at com.gxflow.dwfusersconversion.execute_int(dwfusersconversion.java:39)

Updating table CAAudCon . ENDED
    at com.gxflow.dwfusersconversion.execute(dwfusersconversion.java:31)
Updating table CAConMdMV . STARTED
    at com.gxflow.reorg.ReorganizeDWFUsers(reorg.java:389)
    at com.gxflow.reorg.submitReorg(reorg.java:3253)
    at com.genexus.util.ReorgSubmitThread.run(Unknown Source)
java.sql.SQLException: Invalid object name 'GXA0011'.

    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.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)
Waiting for 43 submitted procs to end...
java.sql.SQLException: Invalid object name 'GXA0031'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
Updating table CAConMdMV . FAILED

    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.genexus.db.DataStoreProvider.execute(Unknown Source)
    at com.gxflow.caconmdmvconversion.privateExecute(caconmdmvconversion.java:46)
    at com.gxflow.caconmdmvconversion.execute_int(caconmdmvconversion.java:39)
    at com.gxflow.caconmdmvconversion.execute(caconmdmvconversion.java:31)
    at com.gxflow.reorg.ReorganizeCAConMdMV(reorg.java:538)
    at com.gxflow.reorg.submitReorg(reorg.java:3283)
    at com.genexus.util.ReorgSubmitThread.run(Unknown Source)


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

El 02/03/2012 02:39 p.m., Germán Asiz escribió:
Hola Ricardo,
este es un problema aleatorio con esa reorg. que lo estamos viendo. Podrías restablecer la base de tu aplicación al estado previo a la migración y volver a probar?. 

saludos,
Germán Asiz.

2012/3/2 Ricardo Calella <rcalella@profesionalesasociados.com>
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

El 02/03/2012 09:02 a.m., Juan Manuel escribió:
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
 
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

Suscribirse a: Enviar comentarios (Atom)