Symantec IGA

 View Only
  • 1.  SBT Database Export is not Working

    Posted Mar 06, 2020 11:47 PM
    I am trying to import local CFG file into database using EXPORT SQL command but it is not working when the specified configuration is already present.
    Suppose if the given configuration is not present in database then it is creating the configurations file in DB otherwise it is not and old configuratio n is still exists in the database. Also i could not see the logs for this batch script

    Here is what my scripts

    <!--  <!--  **********************************************************************  * File name : SQL_EXPORT.SBT* Description : TARGET_CFG, OVERWRITE, BULK_INSERT and SHARE_DIR attributes are optional. *               SHARE_DIR is valid only when BULK_INSERT is TRUE.***********************************************************************  --> 
    <BATCH LOGS="..\logs\exports_db.log">       
    <COMMAND         ACTION="EXPORT SQL"
    SQL_SERVER_TYPE="ORACLE" 
    SERVER="IGSERVICE"
    USER="IGSDB"
    PASSWORD=""       
    SOURCE_CFG="..\output\RE_model.cfg"
    SOURCE_UDB="..\output\RE_model.udb"
    SOURCE_RDB="..\output\RE_model.rdb"       
    OVERWRITE_DB="TRUE"     
      BULK_INSERT="TRUE"       
    TARGET_CFG="SQL://RE_model_test.cfg"
    TARGET_UDB="SQL://RE_model_test.udb"
    TARGET_RDB="SQL://RE_model_test.rdb"       
    OVERWRITE_USERS_DB="TRUE"     
      OVERWRITE_RES_DB="TRUE"        />

    </BATCH>


  • 2.  RE: SBT Database Export is not Working

    Broadcom Employee
    Posted Mar 09, 2020 11:00 AM
    Hello,

    You mentioned you did not see logs, however did you see any error messages?  
    Maybe check if there are any SQL server error messages.



    ------------------------------
    Thanks,
    Marc

    ====================
    Perhaps there are others in the communities who have experience in doing this and we invite them to comment here also.

    Another option may be to reach out to our partner HCL Technologies to see in what way they can assist further. The Enterprise Studio team of HCL can be reached at enterprisestudio@hcl.com. https://www.hcltech.com/enterprise-studio
    ------------------------------



  • 3.  RE: SBT Database Export is not Working

    Posted Mar 09, 2020 11:00 AM
    Not sure what is the issue, but here are few things you can test.  
    DATABASE="db" is supposed to be a required parameter.
    If you use Bulk insert, SHARE_DIR is supposed to be a required parameter

    It is not common to use the 3 target parameters (they are optional), so maybe there is a bug when these are used.  Can you try deleting these and retest?