Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: WS on June 24, 2009, 09:43:17 AM
-
Have a procedure that i want to invoke from a strategy.When i directly run the query from the strategy that i have used in my procedure ,it works fine with configured DAP and DB server .So there may not be any issue with DAP ,DB svr ,URS and DB connectivity and set up. When i use the same query inside a procedure and try to invoke the procedure from a SQL editor tool ,it works fine but when invoking the same procedure from strategy get following error -
09:14:50.990 Dbg 10741 'App (DV_URS_P,Host name here ,0)' has put request id='31' into queue
09:14:50.990 Dbg 10737 Forwarding request '31' from 'App (DV_URS_P,Host name here ,0)' to 'Oracle: 530215.1'
09:14:50.990 Dbg 10743 'Oracle: 530215.1' is spare
09:14:51.102 Dbg 10739 Oracle: id='530215.1' req='31' execute sp: GETEMPLOYEEID Login='85469',EmployeeID='',Switch='',Workgroup=''
+0111 ocierror: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "CONFIG_USER.GETEMPLOYEEID", line 13
ORA-06512: at line 2
+0111 MSG_ERROR status='3' msg='ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "CONFIG_USER.GETEMPLOYEEID", line 13
ORA-06512: at line 2
The parameters are defined with '%type ' so there can't be any size issue . Plus it works fine from SQL tools. What could be the issue ?
-
URS log snippet here -
09:14:50.989_T_I_006e01b3909eb073 [14:0c] EventRouteRequest is received for tserver DV_TServer[] (this dn=84108)
_T_I_006e01b3909eb073 [14:09] add DN DV_TServer 84108 <84108@> (CDN 71 006e01b3909eb073) to the call 372-113130b70 truly:11
_T_I_006e01b3909eb073 [14:08] check delayed proc
_I_I_006e01b3909eb073 [14:33] strategy: *0x65*TestDBProcedure is attached to the call
09:14:50.989 Int 20001 interaction 006e01b3909eb073 is started
_I_I_006e01b3909eb073 [01:14] current call classification: media=voice(100), service=default(200), segment=default(300)
09:14:50.989_I_I_006e01b3909eb073 [09:06] >>>>>>>>>>>>start interpretator
_I_I_006e01b3909eb073 [09:04] ASSIGN: __Return(SCRIPT) <- STRING:
_I_I_006e01b3909eb073 [07:46] no error mode for this call
_I_I_006e01b3909eb073 [09:04] ASSIGN: __Return(SCRIPT) <- STRING:
_I_I_006e01b3909eb073 [09:04] ASSIGN: __DBReturn(SCRIPT) <- STRING:
_I_I_006e01b3909eb073 [09:04] ASSIGN: __DBStrReturn(SCRIPT) <- STRING:
_I_I_006e01b3909eb073 [09:04] ASSIGN: __TargetVar(SCRIPT) <- STRING:
_I_I_006e01b3909eb073 [09:04] ASSIGN: Login(LOCAL) <- STRING: 85469
09:14:50.989_I_I_006e01b3909eb073 [07:38] HERE IS XDATA
_D_I_ [07:38] request 31 to dbserver cfg_dbserver sent: GETEMPLOYEEID Login='85469',EmployeeID='',Switch='',Workgroup=''
09:14:50.989_I_I_006e01b3909eb073 [09:04] <<<<<<<<<<<<suspend interpretator(XDATA_EX), timers:00010
DEvent: nMsgID=MSG_ERROR; nServer=4; nStatus=3; nRequestID=31; nProfileTime 111 szSQLCmd=''; pRecord=0x131236b0
key dbmerror [String] value: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "CONFIG_USER.GETEMPLOYEEID", line 13
ORA-06512: at line 2
"
09:14:51.102_D_E_006e01b3909eb073 [05:02] MSG_ERROR is received from dbserver cfg_dbserver, call is in status CALL_STATUS_XDATA
09:14:51.102 Int 21001 interaction 006e01b3909eb073 data lookup fails
09:14:51.102_I_I_006e01b3909eb073 [09:05] >>>>>>>>>>>>resume interpretator(0)
_I_E_006e01b3909eb073 [09:05] error in strategy: 0013 Remote error
_I_I_006e01b3909eb073 [09:04] ASSIGN: __DBReturn(SCRIPT) <- STRING:
_I_I_006e01b3909eb073 [09:04] ASSIGN: Error(LOCAL) <- STRING: 0013 Remote Server Error