1 Reply Latest reply on Sep 19, 2011 5:57 AM by Navneet NameToUpdate

    Best way to export/import jobs sharing BLPackages

    Jose Angel de las Heras

       

      In an important Project, our partner is having problems when trying to export &imprt jobs with BLPackages that contain variables.

       

      They want to import in Production the Jobs they use in Preproduction.

       

      For many jobs they use the same BLPackage but with different variables.

       

      Is there a better way to do the export & import?

       

      This is how the error appears:

       

      1.- They export Job1 with BLPackage 1.1 asociated (BLPackage + Software ...)

       

      2.- They import Job1 with BLPackage 1.1, NO PROBLEM

       

      3.- They export Job2 with BLPackage 1.1 asociated (BLPackage + Software ...)

       

      4.-  They import Job2 with BLPackage 1.1,they get the error that the BLPackage already exist (IT IS OK)

       

      5.-  They export Job2 with BLPackage 1.1 asociated  without BLPackage (The job has properties modified of the BLPackage )

       

      6.- They import Job 2 OK, but get an error ) see attached file image002-jpg

       

      This is the LOG:

       

      [16 Sep 2011 12:47:51,375] [Client-Connections-Thread-7] [ERROR] [BLAdmin:BLAdmins:10.116.154.181] [Client] Failed to save object.

      SPropertySetClass; Node Id = 226071;modifiedByUserId=1000010 abstract=false deprecated=false dateModified=2011/09/16 12:47:51+0200 instanceTableName= blAclId=2001005 visible=true modifiedByRoleId=1000010 deleted=false modelObject=true createdByRoleId=1000010 createdByUserId=1000010 description= name=JMS createBindings superTypeId=1025 builtIn=false dataTypeId=2010243 dateCreated=2011/09/16 12:47:51+0200 synchronize=true custom=false

      com.bladelogic.mfw.util.BlException: Failed to save object.

      SPropertySetClass; Node Id = 226071;modifiedByUserId=1000010 abstract=false deprecated=false dateModified=2011/09/16 12:47:51+0200 instanceTableName= blAclId=2001005 visible=true modifiedByRoleId=1000010 deleted=false modelObject=true createdByRoleId=1000010 createdByUserId=1000010 description= name=JMS createBindings superTypeId=1025 builtIn=false dataTypeId=2010243 dateCreated=2011/09/16 12:47:51+0200 synchronize=true custom=false

             at com.bladelogic.model.base.dependency.graph.ModelObject.db_save(ModelObject.java:203)

             at com.bladelogic.model.base.dependency.graph.ModelObject.save(ModelObject.java:132)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveModelObject(DefaultObjectImporter.java:262)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:141)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:100)

             at com.bladelogic.model.importexport.PropertyObjectImporter.importObject(PropertyObjectImporter.java:57)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:67)

             at com.bladelogic.model.importexport.PropertySetInstanceOverriddenValueMapObjectImporter.importObject(PropertySetInstanceOverriddenValueMapObjectImporter.java:46)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.PropertySetInstanceObjectImporter.importObject(PropertySetInstanceObjectImporter.java:22)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.BlValueObjectImporter.importObject(BlValueObjectImporter.java:274)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:128)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.JobObjectImporter.importObject(JobObjectImporter.java:60)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.saveObjectGraphToDatabase(ModelObjectImporter.java:3383)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.access$000(ModelObjectImporter.java:105)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter$1.doDBOperation(ModelObjectImporter.java:246)

             at com.bladelogic.app.db.TransactionalOperation.manageTransaction(TransactionalOperation.java:174)

             at com.bladelogic.app.db.TransactionalOperation.execute(TransactionalOperation.java:136)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.saveImportedObject(ModelObjectImporter.java:249)

             at com.bladelogic.message.model.frame.ModelFrame.service(ModelFrame.java:116)

             at com.bladelogic.mfw.net.ClientWorkerThread.processRequest(ClientWorkerThread.java:370)

             at com.bladelogic.mfw.net.ClientWorkerThread.processClientRequest(ClientWorkerThread.java:280)

             at com.bladelogic.mfw.net.ClientWorkerThread.handleClientRequest(ClientWorkerThread.java:180)

             at com.bladelogic.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:99)

             at com.bladelogic.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:25)

             at com.bladelogic.app.service.thread.BlBlockingThread.run(BlBlockingThread.java:92)

      Caused by: com.bladelogic.shared.db.PrimaryKeyConstraintViolationException: ORA-00001: unique constraint (BLADELOGIC.XPKPROPERTY_SET_CLASS) violated

       

             at com.bladelogic.shared.db.BlDbStatement.handleSqlException(BlDbStatement.java:46)

             at com.bladelogic.shared.db.BlPreparedStatement.executeUpdate(BlPreparedStatement.java:67)

             at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:892)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:568)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:553)

             at com.bladelogic.model.base.dependency.graph.ModelObject.db_save(ModelObject.java:200)

             ... 33 more

      Caused by: java.sql.SQLException: ORA-00001: unique constraint (BLADELOGIC.XPKPROPERTY_SET_CLASS) violated

       

             at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

             at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

             at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

             at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)

             at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)

             at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)

             at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)

             at com.bladelogic.shared.db.BlPreparedStatement.executeUpdate(BlPreparedStatement.java:63)

             ... 38 more

      [16 Sep 2011 12:47:51,380] [Client-Connections-Thread-7] [DEBUG] [BLAdmin:BLAdmins:10.116.154.181] [Client] Failed to save object.

      SPropertySetClass; Node Id = 226071;modifiedByUserId=1000010 abstract=false deprecated=false dateModified=2011/09/16 12:47:51+0200 instanceTableName= blAclId=2001005 visible=true modifiedByRoleId=1000010 deleted=false modelObject=true createdByRoleId=1000010 createdByUserId=1000010 description= name=JMS createBindings superTypeId=1025 builtIn=false dataTypeId=2010243 dateCreated=2011/09/16 12:47:51+0200 synchronize=true custom=false

      com.bladelogic.mfw.util.BlException: Failed to save object.

      SPropertySetClass; Node Id = 226071;modifiedByUserId=1000010 abstract=false deprecated=false dateModified=2011/09/16 12:47:51+0200 instanceTableName= blAclId=2001005 visible=true modifiedByRoleId=1000010 deleted=false modelObject=true createdByRoleId=1000010 createdByUserId=1000010 description= name=JMS createBindings superTypeId=1025 builtIn=false dataTypeId=2010243 dateCreated=2011/09/16 12:47:51+0200 synchronize=true custom=false

             at com.bladelogic.model.base.dependency.graph.ModelObject.db_save(ModelObject.java:203)

             at com.bladelogic.model.base.dependency.graph.ModelObject.save(ModelObject.java:132)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveModelObject(DefaultObjectImporter.java:262)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:141)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:100)

             at com.bladelogic.model.importexport.PropertyObjectImporter.importObject(PropertyObjectImporter.java:57)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:67)

             at com.bladelogic.model.importexport.PropertySetInstanceOverriddenValueMapObjectImporter.importObject(PropertySetInstanceOverriddenValueMapObjectImporter.java:46)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.PropertySetInstanceObjectImporter.importObject(PropertySetInstanceObjectImporter.java:22)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.BlValueObjectImporter.importObject(BlValueObjectImporter.java:274)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:128)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.JobObjectImporter.importObject(JobObjectImporter.java:60)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.saveObjectGraphToDatabase(ModelObjectImporter.java:3383)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.access$000(ModelObjectImporter.java:105)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter$1.doDBOperation(ModelObjectImporter.java:246)

             at com.bladelogic.app.db.TransactionalOperation.manageTransaction(TransactionalOperation.java:174)

             at com.bladelogic.app.db.TransactionalOperation.execute(TransactionalOperation.java:136)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.saveImportedObject(ModelObjectImporter.java:249)

             at com.bladelogic.message.model.frame.ModelFrame.service(ModelFrame.java:116)

             at com.bladelogic.mfw.net.ClientWorkerThread.processRequest(ClientWorkerThread.java:370)

             at com.bladelogic.mfw.net.ClientWorkerThread.processClientRequest(ClientWorkerThread.java:280)

             at com.bladelogic.mfw.net.ClientWorkerThread.handleClientRequest(ClientWorkerThread.java:180)

             at com.bladelogic.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:99)

             at com.bladelogic.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:25)

             at com.bladelogic.app.service.thread.BlBlockingThread.run(BlBlockingThread.java:92)

      Caused by: com.bladelogic.shared.db.PrimaryKeyConstraintViolationException: ORA-00001: unique constraint (BLADELOGIC.XPKPROPERTY_SET_CLASS) violated

       

             at com.bladelogic.shared.db.BlDbStatement.handleSqlException(BlDbStatement.java:46)

             at com.bladelogic.shared.db.BlPreparedStatement.executeUpdate(BlPreparedStatement.java:67)

             at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:892)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:568)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:553)

             at com.bladelogic.model.base.dependency.graph.ModelObject.db_save(ModelObject.java:200)

             ... 33 more

      Caused by: java.sql.SQLException: ORA-00001: unique constraint (BLADELOGIC.XPKPROPERTY_SET_CLASS) violated

       

             at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

             at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

             at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

             at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)

             at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)

             at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)

             at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)

             at com.bladelogic.shared.db.BlPreparedStatement.executeUpdate(BlPreparedStatement.java:63)

             ... 38 more

      [16 Sep 2011 12:47:51,686] [Scheduled-System-Tasks-Thread-2] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 711458816,Free JVM (B): 253164616,Used JVM (B): 458294200,VSize (B): 3875094528,RSS (B): 1113600000,Used File Descriptors: 253

      [16 Sep 2011 12:47:56,355] [Authentication-Service-Thread-0] [WARN] [::10.241.196.135] [Appserver] Connection closed by /10.241.196.135:3608 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:47:56,357] [Authentication-Service-Thread-0] [INFO] [::10.241.196.135] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:48:18,804] [Authentication-Service-Thread-1] [WARN] [::10.241.196.134] [Appserver] Connection closed by /10.241.196.134:19048 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:48:18,804] [Authentication-Service-Thread-1] [INFO] [::10.241.196.134] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:48:26,391] [Authentication-Service-Thread-2] [WARN] [::10.241.196.135] [Appserver] Connection closed by /10.241.196.135:4079 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:48:26,392] [Authentication-Service-Thread-2] [INFO] [::10.241.196.135] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:48:48,874] [Authentication-Service-Thread-0] [WARN] [::10.241.196.134] [Appserver] Connection closed by /10.241.196.134:19529 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:48:48,874] [Authentication-Service-Thread-0] [INFO] [::10.241.196.134] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:48:51,691] [Scheduled-System-Tasks-Thread-3] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 708444160,Free JVM (B): 248031384,Used JVM (B): 460412776,VSize (B): 3875094528,RSS (B): 1111891968,Used File Descriptors: 253

      [16 Sep 2011 12:48:56,447] [Authentication-Service-Thread-1] [WARN] [::10.241.196.135] [Appserver] Connection closed by /10.241.196.135:4562 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:48:56,447] [Authentication-Service-Thread-1] [INFO] [::10.241.196.135] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:49:19,155] [Authentication-Service-Thread-2] [WARN] [::10.241.196.134] [Appserver] Connection closed by /10.241.196.134:20014 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:49:19,156] [Authentication-Service-Thread-2] [INFO] [::10.241.196.134] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:49:26,742] [Authentication-Service-Thread-0] [WARN] [::10.241.196.135] [Appserver] Connection closed by /10.241.196.135:5048 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:49:26,742] [Authentication-Service-Thread-0] [INFO] [::10.241.196.135] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:49:49,305] [Authentication-Service-Thread-1] [WARN] [::10.241.196.134] [Appserver] Connection closed by /10.241.196.134:20497 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:49:49,305] [Authentication-Service-Thread-1] [INFO] [::10.241.196.134] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:49:51,693] [Scheduled-System-Tasks-Thread-1] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 704446464,Free JVM (B): 239182032,Used JVM (B): 465264432,VSize (B): 3875094528,RSS (B): 1110253568,Used File Descriptors: 253

      [16 Sep 2011 12:49:56,853] [Authentication-Service-Thread-2] [WARN] [::10.241.196.135] [Appserver] Connection closed by /10.241.196.135:5529 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:49:56,853] [Authentication-Service-Thread-2] [INFO] [::10.241.196.135] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:50:19,523] [Authentication-Service-Thread-0] [WARN] [::10.241.196.134] [Appserver] Connection closed by /10.241.196.134:20978 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:50:19,524] [Authentication-Service-Thread-0] [INFO] [::10.241.196.134] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:50:27,025] [Authentication-Service-Thread-1] [WARN] [::10.241.196.135] [Appserver] Connection closed by /10.241.196.135:6002 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:50:27,026] [Authentication-Service-Thread-1] [INFO] [::10.241.196.135] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:50:49,549] [Authentication-Service-Thread-2] [WARN] [::10.241.196.134] [Appserver] Connection closed by /10.241.196.134:21458 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:50:49,549] [Authentication-Service-Thread-2] [INFO] [::10.241.196.134] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:50:51,701] [Scheduled-System-Tasks-Thread-1] [INFO] [System:System:] [Memory Monitor] Total JVM (B): 701497344,Free JVM (B): 227958656,Used JVM (B): 473538688,VSize (B): 3875094528,RSS (B): 1109463040,Used File Descriptors: 251

      [16 Sep 2011 12:50:57,072] [Authentication-Service-Thread-0] [WARN] [::10.241.196.135] [Appserver] Connection closed by /10.241.196.135:6490 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:50:57,072] [Authentication-Service-Thread-0] [INFO] [::10.241.196.135] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:51:19,598] [Authentication-Service-Thread-1] [WARN] [::10.241.196.134] [Appserver] Connection closed by /10.241.196.134:21931 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:51:19,598] [Authentication-Service-Thread-1] [INFO] [::10.241.196.134] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:51:27,116] [Authentication-Service-Thread-2] [WARN] [::10.241.196.135] [Appserver] Connection closed by /10.241.196.135:6975 before pre-authentication handshake could be completed.

      [16 Sep 2011 12:51:27,116] [Authentication-Service-Thread-2] [INFO] [::10.241.196.135] [Appserver] Authentication Connection closed

      [16 Sep 2011 12:51:38,633] [Client-Connections-Thread-1] [ERROR] [BLAdmin:BLAdmins:10.116.154.181] [Client] Failed to save object.

      SPropertySetClass; Node Id = 226837;modifiedByUserId=1000010 abstract=false deprecated=false dateModified=2011/09/16 12:51:38+0200 instanceTableName= blAclId=2001005 visible=true modifiedByRoleId=1000010 deleted=false modelObject=true createdByRoleId=1000010 createdByUserId=1000010 description= name=JMS createBindings superTypeId=1025 builtIn=false dataTypeId=2010243 dateCreated=2011/09/16 12:51:38+0200 synchronize=true custom=false

      com.bladelogic.mfw.util.BlException: Failed to save object.

      SPropertySetClass; Node Id = 226837;modifiedByUserId=1000010 abstract=false deprecated=false dateModified=2011/09/16 12:51:38+0200 instanceTableName= blAclId=2001005 visible=true modifiedByRoleId=1000010 deleted=false modelObject=true createdByRoleId=1000010 createdByUserId=1000010 description= name=JMS createBindings superTypeId=1025 builtIn=false dataTypeId=2010243 dateCreated=2011/09/16 12:51:38+0200 synchronize=true custom=false

             at com.bladelogic.model.base.dependency.graph.ModelObject.db_save(ModelObject.java:203)

             at com.bladelogic.model.base.dependency.graph.ModelObject.save(ModelObject.java:132)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveModelObject(DefaultObjectImporter.java:262)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:141)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:100)

             at com.bladelogic.model.importexport.PropertyObjectImporter.importObject(PropertyObjectImporter.java:57)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:67)

             at com.bladelogic.model.importexport.PropertySetInstanceOverriddenValueMapObjectImporter.importObject(PropertySetInstanceOverriddenValueMapObjectImporter.java:46)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.PropertySetInstanceObjectImporter.importObject(PropertySetInstanceObjectImporter.java:22)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.BlValueObjectImporter.importObject(BlValueObjectImporter.java:274)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:128)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.JobObjectImporter.importObject(JobObjectImporter.java:60)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.saveObjectGraphToDatabase(ModelObjectImporter.java:3383)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.access$000(ModelObjectImporter.java:105)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter$1.doDBOperation(ModelObjectImporter.java:246)

             at com.bladelogic.app.db.TransactionalOperation.manageTransaction(TransactionalOperation.java:174)

             at com.bladelogic.app.db.TransactionalOperation.execute(TransactionalOperation.java:136)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.saveImportedObject(ModelObjectImporter.java:249)

             at com.bladelogic.message.model.frame.ModelFrame.service(ModelFrame.java:116)

             at com.bladelogic.mfw.net.ClientWorkerThread.processRequest(ClientWorkerThread.java:370)

             at com.bladelogic.mfw.net.ClientWorkerThread.processClientRequest(ClientWorkerThread.java:280)

             at com.bladelogic.mfw.net.ClientWorkerThread.handleClientRequest(ClientWorkerThread.java:180)

             at com.bladelogic.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:99)

             at com.bladelogic.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:25)

             at com.bladelogic.app.service.thread.BlBlockingThread.run(BlBlockingThread.java:92)

      Caused by: com.bladelogic.shared.db.PrimaryKeyConstraintViolationException: ORA-00001: unique constraint (BLADELOGIC.XPKPROPERTY_SET_CLASS) violated

       

             at com.bladelogic.shared.db.BlDbStatement.handleSqlException(BlDbStatement.java:46)

             at com.bladelogic.shared.db.BlPreparedStatement.executeUpdate(BlPreparedStatement.java:67)

             at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:892)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:568)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:553)

             at com.bladelogic.model.base.dependency.graph.ModelObject.db_save(ModelObject.java:200)

             ... 33 more

      Caused by: java.sql.SQLException: ORA-00001: unique constraint (BLADELOGIC.XPKPROPERTY_SET_CLASS) violated

       

             at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

             at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

             at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

             at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)

             at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)

             at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)

             at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)

             at com.bladelogic.shared.db.BlPreparedStatement.executeUpdate(BlPreparedStatement.java:63)

             ... 38 more

      [16 Sep 2011 12:51:38,637] [Client-Connections-Thread-1] [DEBUG] [BLAdmin:BLAdmins:10.116.154.181] [Client] Failed to save object.

      SPropertySetClass; Node Id = 226837;modifiedByUserId=1000010 abstract=false deprecated=false dateModified=2011/09/16 12:51:38+0200 instanceTableName= blAclId=2001005 visible=true modifiedByRoleId=1000010 deleted=false modelObject=true createdByRoleId=1000010 createdByUserId=1000010 description= name=JMS createBindings superTypeId=1025 builtIn=false dataTypeId=2010243 dateCreated=2011/09/16 12:51:38+0200 synchronize=true custom=false

      com.bladelogic.mfw.util.BlException: Failed to save object.

      SPropertySetClass; Node Id = 226837;modifiedByUserId=1000010 abstract=false deprecated=false dateModified=2011/09/16 12:51:38+0200 instanceTableName= blAclId=2001005 visible=true modifiedByRoleId=1000010 deleted=false modelObject=true createdByRoleId=1000010 createdByUserId=1000010 description= name=JMS createBindings superTypeId=1025 builtIn=false dataTypeId=2010243 dateCreated=2011/09/16 12:51:38+0200 synchronize=true custom=false

             at com.bladelogic.model.base.dependency.graph.ModelObject.db_save(ModelObject.java:203)

             at com.bladelogic.model.base.dependency.graph.ModelObject.save(ModelObject.java:132)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveModelObject(DefaultObjectImporter.java:262)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:141)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:100)

             at com.bladelogic.model.importexport.PropertyObjectImporter.importObject(PropertyObjectImporter.java:57)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:67)

             at com.bladelogic.model.importexport.PropertySetInstanceOverriddenValueMapObjectImporter.importObject(PropertySetInstanceOverriddenValueMapObjectImporter.java:46)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.PropertySetInstanceObjectImporter.importObject(PropertySetInstanceObjectImporter.java:22)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.BlValueObjectImporter.importObject(BlValueObjectImporter.java:274)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:128)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.saveAdditionalObjects(DefaultObjectImporter.java:166)

             at com.bladelogic.model.base.dependency.importer.DefaultObjectImporter.importObject(DefaultObjectImporter.java:149)

             at com.bladelogic.model.importexport.JobObjectImporter.importObject(JobObjectImporter.java:60)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.saveObjectGraphToDatabase(ModelObjectImporter.java:3383)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.access$000(ModelObjectImporter.java:105)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter$1.doDBOperation(ModelObjectImporter.java:246)

             at com.bladelogic.app.db.TransactionalOperation.manageTransaction(TransactionalOperation.java:174)

             at com.bladelogic.app.db.TransactionalOperation.execute(TransactionalOperation.java:136)

             at com.bladelogic.model.base.dependency.importer.ModelObjectImporter.saveImportedObject(ModelObjectImporter.java:249)

             at com.bladelogic.message.model.frame.ModelFrame.service(ModelFrame.java:116)

             at com.bladelogic.mfw.net.ClientWorkerThread.processRequest(ClientWorkerThread.java:370)

             at com.bladelogic.mfw.net.ClientWorkerThread.processClientRequest(ClientWorkerThread.java:280)

             at com.bladelogic.mfw.net.ClientWorkerThread.handleClientRequest(ClientWorkerThread.java:180)

             at com.bladelogic.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:99)

             at com.bladelogic.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:25)

             at com.bladelogic.app.service.thread.BlBlockingThread.run(BlBlockingThread.java:92)

      Caused by: com.bladelogic.shared.db.PrimaryKeyConstraintViolationException: ORA-00001: unique constraint (BLADELOGIC.XPKPROPERTY_SET_CLASS) violated

       

             at com.bladelogic.shared.db.BlDbStatement.handleSqlException(BlDbStatement.java:46)

             at com.bladelogic.shared.db.BlPreparedStatement.executeUpdate(BlPreparedStatement.java:67)

             at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:892)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:568)

             at com.bladelogic.app.service.db.DatabaseServiceImpl.execute(DatabaseServiceImpl.java:553)

             at com.bladelogic.model.base.dependency.graph.ModelObject.db_save(ModelObject.java:200)

             ... 33 more

      Caused by: java.sql.SQLException: ORA-00001: unique constraint (BLADELOGIC.XPKPROPERTY_SET_CLASS) violated

       

             at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

             at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

             at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

             at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)

             at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)

             at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)

             at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)

             at com.bladelogic.shared.db.BlPreparedStatement.executeUpdate(BlPreparedStatement.java:63)

       

       

       

       

      Any help

       

      Thanks in advance

       

      José Ángel

        • 1. Best way to export/import jobs sharing BLPackages

          The steps you have followed seem to be correct. I was able to successfully import two such deploy jobs which were referring to a single BLPackage (a very simplistic one though) with a local property using the UI by making sure that Job1 is exported with the BLPackage while Job2 is exported without it. While importing Job2 the UI asked for re-mapping the missing BLPackage (it infact points to the right one too as it is at the same location on the target system) and allows me to continue with the import without any problem.

           

          Can you please provide details for your use case like whether you are invoking the CLI vs UI, the exported content (if it can be shared), the BSA version the customer has (both pre-production and production one), any screenshots etc. as I can test bit more to ascertain what the issue is. The error stack trace seems to indicate that a PSC/Property by name JMS createBindings already exists on the target and hence the primary key violation occurs.

           

          Also, just few general things you can try are:

           

          1. Run Delete:performFullDBCleanupJob CLI on the target system (production) to remove any remanants of earlier imports (I was facing some issues because of soft deleted objects).

           

          2. Try the same scenario with a simplistic BLPackage (like one for a file) and create two deploy jobs from it.

           

          3. Ensure that when you are exporting the Job without BLPackage you check all exclusion options like Depot Software, Depot File, etc.

           

          Navneet