[ 
https://issues.apache.org/jira/browse/AIRAVATA-606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13477240#comment-13477240
 ] 

Raminderjeet Singh commented on AIRAVATA-606:
---------------------------------------------

Showing the err thing was my database client. but problem is someplace else. I 
am getting following error while adding a host. 

Caused by: <openjpa-2.2.0-r422266:1244990 fatal general error> 
org.apache.openjpa.persistence.PersistenceException: INSERT on table 
'HOST_DESCRIPTOR' caused a violation of foreign key constraint 
'SQL121016163503891' for key (default).  The statement has been rolled back. 
{prepstmnt 778011205 
INSERT INTO Host_Descriptor (gateway_name, host_descriptor_ID, 
        host_descriptor_xml, updated_user) 
    VALUES (?, ?, ?, ?) 
[params=(String) default, (String) mytest, (byte[]) [B@6197cc, (String) admin]} 
[code=-1, state=23503]
FailedObject: 
org.apache.airavata.persistance.registry.jpa.model.Host_Descriptor@26420e44
        at 
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4912)
        at 
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
        at 
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
        at 
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
        at 
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:143)
        at 
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
        at 
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99)
        at 
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87)
        at 
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
        at 
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
        at 
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
        at 
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
        at 
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
        at 
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:713)
        at 
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
                
> Host Description registration from local xbaya to remote registry not working
> -----------------------------------------------------------------------------
>
>                 Key: AIRAVATA-606
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-606
>             Project: Airavata
>          Issue Type: Bug
>    Affects Versions: 0.5
>            Reporter: Raminderjeet Singh
>            Priority: Blocker
>
> I updated to latest trunk code and getting Err into HOST_DESCRIPTOR_XML. I 
> dont see any error while starting registry. Data in CONFIGURATION table is 
> populated correctly. I am not able to create a application because of this. 
> GATEWAY_NAME     UPDATED_USER     HOST_DESCRIPTOR_ID     HOST_DESCRIPTOR_XML  
>   
>  ---------------  ---------------  ---------------------  
> ---------------------- 
>  default          admin            LocalHost              Err                 
>    
>  default          admin            lonestar               Err                 
>    
>  default          admin            ranger                 Err                 
>    
>  default          admin            trestles               Err                 
>    
>  default          admin            ember                  Err                 
>    
>  default          admin            kraken                 Err                 
>    

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to