cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
505
Views
10
Helpful
5
Replies

Help Troubleshooting an DB Write Step

lomonaco
Level 1
Level 1

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

5 Replies 5

ebreniz
Level 6
Level 6

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.

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

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.

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

IPCC 7.2

CRS 4.0(4)

Oracle 9.2

Write me to chochko@gmail.com and i`ll send you one of my scripts with DBWRITE.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: