Hi,
I'm using DD 4.1.9 and NSS-5.0.6 and NRec-9.0.7
The system works fine using all static Voice 'Built In' grammar ( number, digits, date, ecc ) but , if I try to use a static Voice 'Custom' grammar the application have a crash.
MPP give me an 'unknow reason' while NSS log give me a 'WinsockError=10047'.
Could you help me ?
Thanks
Marco

MPP log
@2010-02-17 15:02:03,601||FINE|VB|6553|Session=avasvil01-2010048140159-12|grammar load failed for an unknown reason|avasvil01####

NUANCE LOG
Feb 17 15:02:11.74|TUCPU=3000|TKCPU=3218|0||swi:SBinet|244||URL=http://appl_server:9090/TEST_ASR/data/italian/grammars/anno-nuance-osr.grxml

Feb 17 15:02:11.74|TUCPU=3000|TKCPU=3218|0||swi:SBinet|264||

Feb 17 15:02:14.01|TUCPU=3000|TKCPU=3218|0||swi:SBinet|500||Func=connect|WinsockError=10047

Feb 17 15:02:14.01|TUCPU=3000|TKCPU=3218|0||swi:SBinet|244||URL=http://appl_server:9090/TEST_ASR/data/italian/grammars/anno-nuance-osr.grxml

Hi,
my current configuration is : DD 4.1.9 - Eclipse 3.2.2 - Jdk 1.5.0.12 - Tomcat 5.5.25 ) . what is the right configuration to update my system at DD ver. 5.xx ?
I found the cause of the problem which does not allow the connection to update the status of the procedure. I need to perform an update of the runtime form 4.1.9 to 4.1.10.1. The problem was : "JDBC : wi00230807
Med
JDBC Connector
Cursor remains open after stored procedure is called "
Do you think it is better to directly use the version 5.0 ?
regards

Marco

Ross,
I'm using DD 4.1.9.

I'm not able to add
//}}END:CLASS:CONSTRUCTOR
protected void updateBeforeExecute(PreparedStatement statement) throws SQLException
   {
      statement.setQueryTimeout(30);
      super.updateBeforeExecute(statement);
   }      


super.updateBeforeExecute(statement) is not allowed.
Could you help me ?

Marco

One more thing... If I don't set manually a timeout ...there is ( and where ) a default connection timeout for DB operation con DD ??

Thanks again

Marco

It's all right !
using the timeout hope to solve the problems of waiting too long but .. do who have any idea for the other problem...It is happen sometimes : when the package was recompiled DD catch 'invalid package' again and the only way to solve the problem was to perform stop and start of Tomcat....as if the state 'invalid package' was maintained from DD connection. Do you know something about this problem ?
Thanks
Marco

Thanks Ross !
There is an other little problem...Sometimes a procedure package is marked 'invalid' and the DD application cacth an Oracle Exception. For example "RA-04061: existing state of has been invalidated
ORA-04061: existing state of package "CBR_ADM.CBR_RICERCA_CLIENTE_20100108" has been invalidated"
It's right...When package is recompiled DD application works again. Sometimes, DD application catch this Exception after recompiled operation too and I must restart Tomcat to works again. Sometimes DD application don't catch this Exception but it seems...wait until the package is compiled again.( a lot of minutes..... ) Do you give me some help about this problem. After setting timeout connection can I be sure that the system dosn't wait for a long time ?
Thanks again and ...sorry for my English !

hi,
I'm executing a stored procedure using DataBase Operation node and I need to set a connection timeout

I don't understand very well... where to put the code below

protected void updateBeforeExecute(PreparedStatement statement) throws SQLException {
statement.setQueryTimeout(xxxx);
super.updateBeforeExecute(statement);
}

Generated DD code for my application is :

public class ScriviTransaction_Prod extends com.avaya.sce.runtime.connectivity.db.DbQuery {

   //{{START:CLASS:FIELDS
   //}}END:CLASS:FIELDS

   /**
    * Constructor for ScriviTransaction_Prod.
    * Last generated by Dialog Designer at: 9 MARZO 2009 11.16.33 CET
    */
   public ScriviTransaction_Prod( com.avaya.sce.runtimecommon.SCESession mySession ) {
      //{{START:CLASS:CONSTRUCTOR
      super(mySession);

      setDataSourceName("jdbc/ScriviTransaction_Prod");
      setDbObjectName("KPIESE_ADM.IMPORT_IVRG.INS_TRANSACTION");
      setOperation(4);
      setReturnType(1);
      setSQLQuery("{ call KPIESE_ADM.IMPORT_IVRG.INS_TRANSACTION ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }");

      // List variable that may be used
      java.util.List list;

      // Parameters
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("TIMESTAMP",1,93, "ScriviTransaction_Prod:TIMESTAMP"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("IVR_SRV",1,12, "ScriviTransaction_Prod:IVR_SRV"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("TRANS_ERR",1,12, "ScriviTransaction_Prod:TRANS_ERR"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("STATUS",1,12, "ScriviTransaction_Prod:STATUS"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("ELAPSED_TIME",1,3, "ScriviTransaction_Prod:ELAPSED_TIME"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("CONNID",1,12, "ScriviTransaction_Prod:CONNID"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("ANI",1,12, "ScriviTransaction_Prod:ANI"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("SVC_NAME",1,12, "ScriviTransaction_Prod:SVC_NAME"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("CONNECTION_ACCEPTED",1,12, "ScriviTransaction_Prod:CONNECTION_ACCEPTED"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("REQUEST",1,12, "ScriviTransaction_Prod:REQUEST"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("RESPONSE",1,12, "ScriviTransaction_Prod:RESPONSE"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("REPLY",1,12, "ScriviTransaction_Prod:REPLY"));
      addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("ACK",1,12, "ScriviTransaction_Prod:ACK"));

      //}}END:CLASS:CONSTRUCTOR
   }

}

Anf DOP File is

?xml version="1.0" encoding="UTF-8"?>
<DbOp version="1.0">
<Datasource name="ScriviTransaction_Prod"/>
<DbObject name="KPIESE_ADM.IMPORT_IVRG.INS_TRANSACTION" returntype="1" selectall="false" type="procedure">
<DbObjectParam datatype="93" field="TIMESTAMP" function="" name="TIMESTAMP" tablename="" type="in" typename="TIMESTAMP" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="IVR_SRV" function="" name="IVR_SRV" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="TRANS_ERR" function="" name="TRANS_ERR" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="STATUS" function="" name="STATUS" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="3" field="ELAPSED_TIME" function="" name="ELAPSED_TIME" tablename="" type="in" typename="DECIMAL" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="CONNID" function="" name="CONNID" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="ANI" function="" name="ANI" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="SVC_NAME" function="" name="SVC_NAME" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="CONNECTION_ACCEPTED" function="" name="CONNECTION_ACCEPTED" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="REQUEST" function="" name="REQUEST" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="RESPONSE" function="" name="RESPONSE" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="REPLY" function="" name="REPLY" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
<DbObjectParam datatype="12" field="ACK" function="" name="ACK" tablename="" type="in" typename="VARCHAR" variable="ScriviTransaction_Prod"/>
</DbObject>
<Operation name="Execute"/>
<Clause>
<Where/>
</Clause>
<Clause>
<Order/>
</Clause>
<SQLQuery>{ call KPIESE_ADM.IMPORT_IVRG.INS_TRANSACTION ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }</SQLQuery>
</DbOp>

Thanks
Marco

hi,
I have forgotten the postgres password for VoicePortal DataBase. VoicePortal's user are below :
List of databases
Name | Owner | Encoding
-------------+----------+----------
VoicePortal | postgres | UTF8
postgres | postgres | UTF8

select * from pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
postgres | 10 | t | t | t | ******** | |
report | 17330 | f | f | f | ******** |

I need to install Avaya Voice Portal 4.1 Service Pack 4 and I don't know what I can I do. Installation procedure ask me for postgres user and password.
Can I change the password in the VoicePortale DB ? How can I do it ? If I can change this password...must I set the new password in the VPMS configuration ? Where ?
Thanks
Marco

Erik.
during my test I have tried to change the TTS IP Configuration ( on the VPMS ) too....so that the system is not able to find a TTS resource. DD application catch 'error.noresource.tts' always after about 15 sec. I have not found MPP or VPMS settings about this timeout . I'll trie to find this setting again !
Regarding DataBase I'll try to use the code as you have suggest.
Thanks again
Marco

Hi,
I need to set a timeout according the following places:
1 ) DataBase Operation
2 ) TTS Announcement
What is the right mode ?
I need to know is TTS is OK,KO or busy.
If TTS resource is not avaiable, I'm able to catch, in the AppRoot node, the event 'error.noresource.tts' but I do not know where
and how set a particular timeout for this event ( for example 5s ) . I have tried using an Item Properties, setting the fetch timeout and catching the
event 'error.badfecth' in the AppRoot node. It doesn't work..the system doesn't throw the event 'error.badfecth'
I have a similar problem using a DataBase Operation. Where I can set a connection and/or stored-execute timeout ? Instead using WebService Operation
I can set a connection timeout directly in the wsoperations file.
Thanks
Marco

Thanks a lot !
It's works !

Marco

Hi,
I have the following problem :
Data Source Configuration --> OK
New DB Operation file --> OK
Selection 'Execute' mode --> OK
Selection packege and stored --> OK

The selected stored show me a duplicate input/output fields

For example :
DB : PROCEDURE write_in_storico_push
(
P_CLI IN VARCHAR2,
P_ID_PUSH IN NUMBER,
P_OUT_STRING OUT VARCHAR2 )

DialogDesignes shows me

DB : PROCEDURE write_in_storico_push
(
P_CLI IN VARCHAR2,
P_CLI IN VARCHAR2,
P_CLI IN VARCHAR2,
P_ID_PUSH IN NUMBER,
P_ID_PUSH IN NUMBER,
P_ID_PUSH IN NUMBER,
P_OUT_STRING OUT VARCHAR2
P_OUT_STRING OUT VARCHAR2 )

If I choose 'Create one Complex Variable for ALL' the variable, Project.variables seems OK ( there is not the duplicate fields )
but if a try to execute the procedure using 'Execute' in SQL query ( file .dbop ) I need to fill all the duplicate fields
and the system give me an oracle exception 'wrong number'.
Thanks
Marco

I am fully agree with your analysis. The timeout problem in the procedure is very rare, but this procedure is concerned with the recognition of the caller and our client asked us to handle these cases. Unfortunately to handle these few cases I will have to make perform this procedure using the thread as described previously, and this obviously for all calls .. The important thing for me is that this way of calling the procedure causes no crach at runtime (so also in the case of normal operation of the procedure that usually takes a few thousandths of a second).
You summarize the steps that I will use (sorry but it is very important that the systems do not entru suddenly stalled ...)

1) I create a thread in the node 'Servlet' (the thread has the method 'run' synchronized)
2) Start the thread (method 'start')
2) The run method of the thread instantiates the class 'dbop', executes the procedure (method 'execute') and waits for the procedure to end
3) the main flow that started the thread, the thread waits for closure in a synchronized block up to a maximum of 5 seconds
synchronized (this)
{
this.wait (5000);
}
4) The thread that executes the procedure calls the method notifyAll () as soon as it ends 'execute'

PS
By doing these tests, I also noticed another incredible scenery ... After calling the method 'execute' call remains suspended is if the procedure takes a long time but even if you suddenly die .. .. the connection with DB!

The problem is born precisely because , in these particular cases, when a procedure for some reason does not respond , the system was stalled. So in theory I am not able to make sure that the threads that are waiting to be completed within a certain period (I guess after a few minutes you think the oracle driver to break the connection). But what I could not verify it works correctly and is managing the pool of tomcat . If I have eg 10 connections can be used , and all 10 are to be stalled, using this approach (ie, using the class dbop within a thread... ) can also pemettere to 10 calls to continue because I can simulate the procedure I responded with an error. As for the maximum number of threads that remain blocked .. should correspond to the parameter ' maxActive ' pool tomcat (in this example 10). All calls that come while the ' maxActive ' are stalled , waiting for just the ' maxWait ' and ending correctly the thread that uses the class dbop (it is in fact caught the exception " com.avaya.sce.runtimecommon.SCERuntimeException : No failover configurationorg.apache.tomcat.dbcp.dbcp.SQLNestedException : Can not get a connection , pool error Timeout waiting for idle object ..... "
Regards
Marco

Wonderful !
It works fine :wink:
But I have some doubts ..
I used the class created by the runtime (dbop class) within a thread and I called upon the execute () method.
The thread that executes the call is created by a parent process that waits for the maximum time set by me. At the end of the timeout, the parent process checks to see if it was properly set the output variable associated with the class dbop. If the output is not empty, then the procedure has answered correctly, otherwise it could have happened somewhere else (the stored continues to run but now my timeout has expired, or there is some other exception, however, I can manage. .)
According to you, there are problems with the JVM / DD runtime by using this management.
Keep in mind that the call load is very high and I would not want the number of threads created would send crash tomcat!
Regards