Skip to Content
avatar image
Former Member

Database table not updated

The message send from file system didnt reach reciever database table (say oracle database). So what are the troubleshooting steps we can perform. and in which area of oracle database we can check whether data in the table is updated?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 09, 2008 at 12:03 PM

    1. Check the Firewall settings at receiver side.

    2. Check the user id and pwd is correct to insert the data into database.

    3. Check the port no is correct.

    4. Check the table name is correct.

    5. Check you have given everyting in correct CASE, since it is case sensitive.

    6. Check in Moni & RWB.

    7. Check if the target message type has the correct sturcture to update the database.

    8. Check if all the drivers have been deployed & configured (JDBC or JMS)

    Regards,

    Sarvesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      > Thanks for the information. Can you just tell me where can we find JDBC drivers in xi?

      Hi,

      If you have installed the dirvers then you can see them in Visual Admin. And if not installed then follow the link which I have sent to you. You can deploy them by using SDM in XI.

      Regards,

      Sarvesh

  • avatar image
    Former Member
    Mar 12, 2008 at 05:33 AM

    Hi,

    Check whether You installed the drivers in XI ! If u need to connect to Oralce DB, then u have to install ojdbc14.jar in XI. So that you can able to connect to Oracle DB,

    and at the same time check the variables that are declared in DB and the structure defined in the XI, the names which u declared in the oracle table, and the XI should match with the exact CASE sensitive else the data will not be uploaded,

    Before that check every thing is fine in moni, and check in communication channel monitoring of the Receiver adapter..

    and revert back if any errors..

    regards,

    Sai

    Add comment
    10|10000 characters needed characters exceeded