Broken new record detection (timestamp or incrementing value) - Database Oracle

Jan Koszty

• July 12, 2023 09:23

Bartender 2022 - Integration Builder when connecting the Oracle database with the Integration builder, I cannot update the value to "next expected" in the new record detection. It always loads the first one in the database. Does anyone know what I'm doing? Will there be an error in the database settings or in the Bartender settings? If I create a table in Excel with the same values, everything works as it should. Thanks for the help

1

• 

  Xabier Clemente

  Moderator

  ★ BarTender Hero ★

  • August 08, 2023 08:53

  Hello Jan,
  
  Welcome to the BarTender Community Forum! 

  Here are a few steps you can take to troubleshoot and potentially resolve the issue:

  • Check Database Settings: Make sure that your Oracle database connection settings in BarTender are correct. Double-check the connection string, credentials, and any other relevant details. Ensure that you have proper permissions to access and update the required tables in the database.
    
    
  • Review Integration Builder Configuration: Within BarTender's Integration Builder, review your configuration for the new record detection process. Ensure that you have set up the conditions correctly to detect and select the "next expected" record. If you're using any filters or conditions, verify that they are properly configured.
    
    
  • Testing with Excel: Since you mentioned that everything works as expected when using an Excel table, it's worth comparing the structure and data of the Excel table with the Oracle table. This could help you identify any differences that might be causing the issue.
    
    
  • Data Quality and Integrity: Ensure that the data in your Oracle database is clean and consistent. Incorrect data types, missing values, or data inconsistencies could impact the way Integration Builder processes the records.
    
    
  • Integration Builder Logging: BarTender's Integration Builder provides logging and error messages that can help you diagnose the issue. Check the logs for any error messages or warnings that might give you more insights into what's going wrong.
    
    
  • Update BarTender: Ensure that you're using the latest version of BarTender. Our software updates often include bug fixes and improvements that could potentially address the issue you're facing. You can find our latest BarTender 2022 version here.

  
  I hope this helps!

  0

Please sign in to leave a comment.