DSN Database Error
I am having an issue where the system DSN is working properly, and in the script editor, I can query the database/refresh the schema properly, but when I try and run the script it errors out. I already have worked with my DBA and he is seeing 0 errors on his side. Any pointers on where I should start?
- Forums Topic:
Recommended Reading:
Guy, No worries... glad I
Guy,
No worries... glad I could help.
Alex
Alex, After I did a reactive
Alex,
After I did a reactive debug I found the error, one of my variables was not setting properly before I did the database steps. The MIVR log also helped.
Thanks a bunch,
Guy
Guyxterra, I would likely say
Guyxterra,
I would likely say you are having a runtime error in your script. Most likely causes are that you are using an undeclared variable, a value that cannot be converted between UCCX and your DB system, or a variable with no value ( NULL Value ).
That being said, your best friend to determine this will be to gather the MIVR Logs from the UCCX server. Goto C:\program files\wfavvid\logs\MIRV\ and gather the logs relivant to the time period in which you are running the reactive debug.
You can post the logs here, and someone can likely find the error, or you can email me at ahannah@uccx.net.
Also, have your DBA run a profile analyzer ( if it's SQL Server ), TOAD if it's Oracle. This is a tool that will show you real time what is being sent to the SQL Server.
Thanks,
Alex