[SWSDEV]

While opening the treeview during debug, a bad index exception occurs. HEre's the screenshot, and I assume that this debug file will give you what you need...

error

error.jpg (112.74 KiB) Viewed 460 times

START_CALLFLOW_EXECUTION: Main.flow - Build: 270
VARIABLE_CHANGED: application.Main_AllowNoAccountNumber=0
VARIABLE_CHANGED: application.Main_AttemptNumber=1
VARIABLE_CHANGED: application.Main_CallerID=
VARIABLE_CHANGED: application.Main_LogMessage=
VARIABLE_CHANGED: application.Main_MaxAttempts=5
VARIABLE_CHANGED: application.Main_NextComponentUri$=
VARIABLE_CHANGED: application.Main_NextDisconnectHandlerUri$=
VARIABLE_CHANGED: application.Main_NextErrorHandlerUri$=
VARIABLE_CHANGED: application.Main_StoreAccountNumber=
VARIABLE_CHANGED: application.Main_StoreRsnNumber=
VARIABLE_CHANGED: application.MenuResult_InvalidOption=InvalidOption
VARIABLE_CHANGED: application.MenuResult_Timeout=Timeout
VARIABLE_CHANGED: application.MenuResult_ValidOption=ValidOption
VARIABLE_CHANGED: application.RecordResult_Completed=Completed
VARIABLE_CHANGED: application.RecordResult_NothingRecorded=NothingRecorded
VARIABLE_CHANGED: application.RecordResult_StopBySilence=StopBySilence
VARIABLE_CHANGED: application.RecordResult_StopDigit=StopDigit
VARIABLE_CHANGED: application.UserInputResult_InvalidDigits=InvalidDigits
VARIABLE_CHANGED: application.UserInputResult_Timeout=Timeout
VARIABLE_CHANGED: application.UserInputResult_ValidDigits=ValidDigits
VARIABLE_CHANGED: application.project$_CurrentErrorDescription$=
VARIABLE_CHANGED: application.project$_CurrentErrorName$=
VARIABLE_CHANGED: application.project$_SystemDsnName=IVROnCall
VARIABLE_CHANGED: application.project$_WorkOrderAudioPath=C:\ProgramData\3CX\Data\Work Order Audio
VARIABLE_CHANGED: application.project$_WorkingDirectory$=C:\ProgramData\3CX\Data\Http\Interface\ivr\OnCall_Debug_270
VARIABLE_CHANGED: application.project$_sqlDatabaseName=PBXDEV
VARIABLE_CHANGED: application.project$_sqlDatabaseServer=Dataserver
VARIABLE_CHANGED: application.project$_sqlPassword=pbx1
VARIABLE_CHANGED: application.project$_sqlUser=pbx
VARIABLE_CHANGED: session.ani=841
VARIABLE_CHANGED: session.callid=From_841_To_844_Menu_844_#0/24
VARIABLE_CHANGED: session.dnis=844
END_EXECUTION: Main.flow - - MF
VARIABLE_CHANGED: application.Logging_WriteLogEntry_LogMessage=New call from 841
VARIABLE_CHANGED: application.Logging_WriteLogEntry_NextComponentUri$=Main_MF_logBeginCall_Suffix.vxml
VARIABLE_CHANGED: application.Logging_WriteLogEntry_NextDisconnectHandlerUri$=Main_DisconnectHandler.vxml
VARIABLE_CHANGED: application.Logging_WriteLogEntry_NextErrorHandlerUri$=Main_ErrorHandler.vxml
VARIABLE_CHANGED: application.Main_logBeginCall_LogMessage=
END_EXECUTION: Main.flow - logBeginCall - MF
END_EXECUTION: Logging\WriteLogEntry.comp - - MF
VARIABLE_CHANGED: Logging_WriteLogEntry_writeToIvrLog_ScalarResult=
VARIABLE_CHANGED: Logging_WriteLogEntry_writeToIvrLog_NonQueryResult=0
VARIABLE_CHANGED: Logging_WriteLogEntry_writeToIvrLog_QueryResult=
END_EXECUTION: Logging\WriteLogEntry.comp - writeToIvrLog - MF
VARIABLE_CHANGED: application.Main_logBeginCall_LogMessage=New call from 841
END_EXECUTION: Main.flow - logBeginCall - MF
VARIABLE_CHANGED: application.LoadConfigValues_AllowNoAccount=0
VARIABLE_CHANGED: application.LoadConfigValues_NextComponentUri$=Main_MF_LoadConfigValues_Suffix.vxml
VARIABLE_CHANGED: application.LoadConfigValues_NextDisconnectHandlerUri$=Main_DisconnectHandler.vxml
VARIABLE_CHANGED: application.LoadConfigValues_NextErrorHandlerUri$=Main_ErrorHandler.vxml
VARIABLE_CHANGED: application.LoadConfigValues_ivrQuery_GetStoreFromANI=
VARIABLE_CHANGED: application.Main_LoadConfigValues_AllowNoAccount=0
VARIABLE_CHANGED: application.Main_LoadConfigValues_ivrQuery_GetStoreFromANI=
END_EXECUTION: Main.flow - LoadConfigValues - MF
END_EXECUTION: LoadConfigValues.comp - - MF
VARIABLE_CHANGED: LoadConfigValues_queryAllowNoAccountNumber_ScalarResult=
VARIABLE_CHANGED: LoadConfigValues_queryAllowNoAccountNumber_NonQueryResult=0
VARIABLE_CHANGED: LoadConfigValues_queryAllowNoAccountNumber_QueryResult=['False', 'SELECT * FROM dbo.fn_CallerIDLookup(\'{0}\',\'Store\') ']
END_EXECUTION: LoadConfigValues.comp - queryAllowNoAccountNumber - MF
VARIABLE_CHANGED: LoadConfigValues_AllowNoAccount=False
END_EXECUTION: LoadConfigValues.comp - assignAllowNoAcount - MF
VARIABLE_CHANGED: LoadConfigValues_ivrQuery_GetStoreFromANI=SELECT * FROM dbo.fn_CallerIDLookup('{0}','Store')
END_EXECUTION: LoadConfigValues.comp - assign_GetStoreFromANI - MF
VARIABLE_CHANGED: application.LoadConfigValues_logConfigLookup_LogMessage=
VARIABLE_CHANGED: application.Logging_WriteLogEntry_LogMessage=Loaded config values: "Allow no account num" = False. "GetStoreANIQuery" = SELECT * FROM dbo.fn_CallerIDLookup('{0}','Store')
VARIABLE_CHANGED: application.Logging_WriteLogEntry_NextComponentUri$=LoadConfigValues_MF_logConfigLookup_Suffix.vxml
VARIABLE_CHANGED: application.Logging_WriteLogEntry_NextDisconnectHandlerUri$=LoadConfigValues_DisconnectHandler.vxml
VARIABLE_CHANGED: application.Logging_WriteLogEntry_NextErrorHandlerUri$=LoadConfigValues_ErrorHandler.vxml
END_EXECUTION: LoadConfigValues.comp - logConfigLookup - MF
END_EXECUTION: Logging\WriteLogEntry.comp - - MF
VARIABLE_CHANGED: Logging_WriteLogEntry_writeToIvrLog_ScalarResult=
VARIABLE_CHANGED: Logging_WriteLogEntry_writeToIvrLog_NonQueryResult=0
VARIABLE_CHANGED: Logging_WriteLogEntry_writeToIvrLog_QueryResult=
END_EXECUTION: Logging\WriteLogEntry.comp - writeToIvrLog - MF
VARIABLE_CHANGED: application.LoadConfigValues_logConfigLookup_LogMessage=Loaded config values: "Allow no account num" = False. "GetStoreANIQuery" = SELECT * FROM dbo.fn_CallerIDLookup('{0}','Store')
END_EXECUTION: LoadConfigValues.comp - logConfigLookup - MF
VARIABLE_CHANGED: application.Main_LoadConfigValues_AllowNoAccount=False
VARIABLE_CHANGED: application.Main_LoadConfigValues_ivrQuery_GetStoreFromANI=SELECT * FROM dbo.fn_CallerIDLookup('{0}','Store')
END_EXECUTION: Main.flow - LoadConfigValues - MF
VARIABLE_CHANGED: application.Activities_CreateDynamicPrompts_EnterAccountNumberString=
VARIABLE_CHANGED: application.Activities_CreateDynamicPrompts_MainGreetingString=
VARIABLE_CHANGED: application.Activities_CreateDynamicPrompts_NextComponentUri$=Main_MF_createDynamicPrompts_Suffix.vxml
VARIABLE_CHANGED: application.Activities_CreateDynamicPrompts_NextDisconnectHandlerUri$=Main_DisconnectHandler.vxml
VARIABLE_CHANGED: application.Activities_CreateDynamicPrompts_NextErrorHandlerUri$=Main_ErrorHandler.vxml
END_EXECUTION: Main.flow - createDynamicPrompts - MF
END_EXECUTION: Activities\CreateDynamicPrompts.comp - - MF
VARIABLE_CHANGED: application.Activities_CreateDynamicPrompts_logCreatingDynamicAudio_LogMessage=
VARIABLE_CHANGED: application.Logging_WriteLogEntry_LogMessage=Creating dynamic files...
VARIABLE_CHANGED: application.Logging_WriteLogEntry_NextComponentUri$=Activities_CreateDynamicPrompts_MF_logCreatingDynamicAudio_Suffix.vxml
VARIABLE_CHANGED: application.Logging_WriteLogEntry_NextDisconnectHandlerUri$=Activities_CreateDynamicPrompts_DisconnectHandler.vxml
VARIABLE_CHANGED: application.Logging_WriteLogEntry_NextErrorHandlerUri$=Activities_CreateDynamicPrompts_ErrorHandler.vxml
END_EXECUTION: Activities\CreateDynamicPrompts.comp - logCreatingDynamicAudio - MF
END_EXECUTION: Logging\WriteLogEntry.comp - - MF
VARIABLE_CHANGED: Logging_WriteLogEntry_writeToIvrLog_ScalarResult=
VARIABLE_CHANGED: Logging_WriteLogEntry_writeToIvrLog_NonQueryResult=0
VARIABLE_CHANGED: Logging_WriteLogEntry_writeToIvrLog_QueryResult=
END_EXECUTION: Logging\WriteLogEntry.comp - writeToIvrLog - MF
VARIABLE_CHANGED: application.Activities_CreateDynamicPrompts_logCreatingDynamicAudio_LogMessage=Creating dynamic files...
END_EXECUTION: Activities\CreateDynamicPrompts.comp - logCreatingDynamicAudio - MF
VARIABLE_CHANGED: Activities_CreateDynamicPrompts_queryDynamicAudio_ScalarResult=
VARIABLE_CHANGED: Activities_CreateDynamicPrompts_queryDynamicAudio_NonQueryResult=0
VARIABLE_CHANGED: Activities_CreateDynamicPrompts_queryDynamicAudio_QueryResult=['Hello. My name is Joe.', 'Hello, my name is Bob']
END_EXECUTION: Activities\CreateDynamicPrompts.comp - queryDynamicAudio - MF

[VAD_Support]

We'll investigate this, thanks for reporting the bug.
Is this happening when you try to expand a specific element in the tree? Or you get that expanding any element?

[SWSDEV]

Just the $callflow variables.

I am in a sub component also.

[VAD_Support]

Thanks for the information, we'll investigate it and fix the problem.

[SWSDEV]

I have confirmed that pulling < and > characters from the database was breaking the User Interface, as well as creating a badfetch error. When I removed those I got past the error (although I needed those symbols in my query)

[VAD_Support]

OK, thanks for the additional information, this is very useful to fix the bug.

[SWSDEV]

Now I get this problem. see attached.

[VAD_Support]

Are you in the same scenario than before? The error seems to be the same, right?

[SWSDEV]

Similar, but no < or > characters this time