Saltar al contenido principal

Búsqueda

Búsqueda

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

Comentarios

1 comentario

  • Avatar
    Xabier Clemente
    Moderador

    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

Iniciar sesión para dejar un comentario.