Control Compliance Suite

 View Only
Back to discussions
Expand all | Collapse all

Unable to proceed with External data Integration (Dumping data schema to transient storage failed)

  • 1.  Unable to proceed with External data Integration (Dumping data schema to transient storage failed)

    Posted Aug 31, 2014 07:35 AM

    Hey, 

    I have a problem with the integration of external data. I always get the same error (no matter if I try it with CSV or ODBC) 

    Dumping data schema to transient storage failed

    If I go to logs the following error is displayed:

    Dumping data schema SymantecResponseAssessment_3ccc9ab9-21fd-48aa-bd15-710ca711edb5 to transient storage failed. Inner exception details: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

    I tried different ways with the data type but everytime the same results. I also tried the same data connection on a different machine and it worked so I guess it has something to do with my SQL database. I have all the newest SU/PU/PACU  installed and using SQL Server 2008.

    Does someone know how to fix this problem?

    Many greetings and thanks in advance

     



  • 2.  RE: Unable to proceed with External data Integration (Dumping data schema to transient storage failed)

    Posted Sep 09, 2014 01:32 PM

    from the message it looks like you have a field that is of the "datetime" data type.   You will need to make sure that you pick the appropriate data type in processing the data field.  Make sure you pick the appropriate date format.   If you are using a SQL Query, you may need to convert the field into the appropriate data type.  

    Hope that helps.