Help Troubleshooting an DB Write Step

Unanswered Question
May 30th, 2008
User Badges:

Hi Everybody,


I'm using with success an DBGET and a DBREAD to read my oracle database.


Now I'm trying to use the DBWRITE step (using the same DSN) but is not working.


When I execute the query below, i receive OK from my script my the Oracle database is not updated


UPDATE totem.dbpoupexonline

SET cadastrodataalt = SYSDATE,

cadastrouseralt = $CPF,

bloqueio_senha_ura = '1',

cadastroaplicalt = 'URA',

cadastroaplicobs = $NumeroDiscador WHERE cadastrocpf = $CPF


All the variables are string.


Is there any way to know exactly what the IPCC is sending to Oracle and what the Oracle is returning

to IPCC ??


Any tip will be welcome


My Best Regards,


Thanks in Advanced



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
ebreniz Thu, 06/05/2008 - 14:23
User Badges:
  • Silver, 250 points or more

Here is a working statement for updating a table (using DB Write step)


UPDATE Afterhours SET Afterhours = 1 WHERE BranchNumber = $strBranchNumber

This link is to enable the Database Subsystem.

http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_administration_guide_chapter09186a008018e98d.html#1056609


Once it's enabled and you are connected to the database you can use the DB steps to get, write , read and release the database.


lomonaco Thu, 06/12/2008 - 14:40
User Badges:

Hi Ebreniz,


Thanks for your reply...


Now Im using the correct SQL Syntax, but I found another issue..


I can make just one SQL UPDATE in my Oracle 9i Database. After that, I cannot connect to my database, even using an SQL SELECT. I have to wait sometime to be able to connect...


Thanks a Lot


My Best Regards,


Andre Lomonaco

Chavdar_Baramov Thu, 06/12/2008 - 22:31
User Badges:

You have to release the DB before using it again. It uses from the ammount of connections you specify at CRS>Subsystems>Database

"Max Connections" for some time than a timeout (from CRS or Oracle) kicks in and connection is released.


Better use DB Release node in your script.


Personaly i have a script which updates and inserts values in a Oracle table max 15 times a min.

lomonaco Tue, 06/17/2008 - 05:20
User Badges:

Hi Chavdar_Baramov,


Thanks a lot for your reply...


I agree 100% with you....


I'm using Max Connections = 7 and every time I use DBREAD or DBWRITE I include after a DB Release in all options


What version of IPCC and Oracle are you using ?


Did you made any special configuration in your Oracle Database ?


if is possible, can you share your script to me ? I wanna test him in my network


Or if you wanna help more, I can send you my script to you take a quickly look...


My Best Regards,


Andre Lomonaco


Actions

This Discussion