IPIVR DB Write with SQL table with identity column
I am looking into using the IPIVR DB Access module to write a simple transaction log. I have created a IVR script which happily reads data from one databse but when I want to write selected records with variable data to a new table I keep hitting null pointer errors but when I write explicit data then everything works fine. In the DB Write SQL I have entered
INSERT INTO Calls (DateTime, DNIS, ANI, UD1, UD2) VALUES ('2008-09-12', $varDNIS, $varANI, $varUD1, $varUD2)
where varxxx is an IPIVR script varaiable holding the variable contents, this operation fails. If I change to
INSERT INTO Calls (DateTime, DNIS, ANI, UD1, UD2) VALUES ('2008-09-12', 'DNIS', 'ANI', 'UD1', 'UD2')
i.e. explicit data, it works fine. The SQL table has an extra column, CallID, which is defined as primary key and also an Identity column (so automatically populated, as I don't want to manage the primary key column. Is this supported and is this the root of my problem ? If not any ideas why the INSERT is not working with variable data ?
Finally is there a way to capture the current Date and Time inside the IVR script to make up and populate the DateTime field, ala ICM DateTime field, in the INSERT command ?
Re: IPIVR DB Write with SQL table with identity column
I have created a second table, without the identity column setting for the primary key and I get exactly the same problem, i.e. I can write explicit (static) data withotu problem but when trying to use the $varname method I get a null exception pointer error. Is there some trick to configuring the variables (mine are all string and SQL columns are all char).
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...
If you have 2 ISR routers, one acting as Failover, do we need to have both the same number of SRST licenses on the 2 routers?
No. You will only need the SRST licenses on the primary router. Because this feature...