03-16-2012 04:35 AM - edited 03-19-2019 04:35 AM
7.1.5 does not have the option to change the voicemail profile on a line by using a custom file. I found a way to update the voicemail profle via a Run SQL statement via a SSH session to the Publisher.
I have five thousand (5000) of these to do a day over the next 7 days.
My issue is when I try to copy more then one line at a time the second line does not get pasted correctly and fails. It appears the clip board is trying to paste the info in to fast. I need to get a pause or something.
I have tried putting several carriage returns in after each line -- that did not work.
I have played with the CR - LF parameter in Tera Term -- that did not work.
Here is what I get when I paste in 9 lines:
admin:
admin:
admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550023'
Rows: 1
admin:ofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550024'
Executed command unsuccessfully
No valid command entered
admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550031'
Rows: 1
admin:kvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550047'
Executed command unsuccessfully
No valid command entered
admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550108'
Rows: 1
admin:lan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550110'
Executed command unsuccessfully
No valid command entered
admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550112'
Rows: 1
admin:ssagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550115'
Executed command unsuccessfully
No valid command entered
admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550122'
Rows: 1
admin:
admin:
Out of the 9 lines pasted in only 5 completed successfully.
Thanks in advance for any suggestions!
Del
Solved! Go to Solution.
03-16-2012 04:57 AM
Hi Del
Helpful Answer first :
Generally you should use the CLI for prototyping your commands, then download the 'AxlSqlToolkit' from the plugins page. You can embed multiple SQL commands into the input file, start it up and off it goes...
Check the readme as they've done a really poor job of making it user friendly. Test it out with some selects until you are confident!
Cisco-Sponsored Answer:
Don't change the DB directly, use AXL. Then use SQL when AXL fails :-)
Aaron
03-16-2012 04:57 AM
Hi Del
Helpful Answer first :
Generally you should use the CLI for prototyping your commands, then download the 'AxlSqlToolkit' from the plugins page. You can embed multiple SQL commands into the input file, start it up and off it goes...
Check the readme as they've done a really poor job of making it user friendly. Test it out with some selects until you are confident!
Cisco-Sponsored Answer:
Don't change the DB directly, use AXL. Then use SQL when AXL fails :-)
Aaron
03-16-2012 05:02 AM
Thanks Aaron, I will give that a whirl!
This is what I got back from Cisco yesterday when I asked my account team to run my sql statement but the internal dev team. I LOVE disclaimers
Direct updates to the ccm database via SQL statements are not supported by TAC. It is possible to do fast and irreparable damage with direct SQL statements. Take a backup before attempting any update and be prepared to restore from backup in case of any failure. PKIDs vary by install so statements must be tailored to the install.
03-16-2012 05:05 AM
Hi
Yeah, don't sweat that. It's equally possible to do 'fast and irreparable' damage with BAT and a little imagination :-)
The DB is actually quite well structured and enforces links between tables so it's not so risky as people make out.
Aaron
03-16-2012 06:28 AM
I found the below links that helped me get the AxlSqlToolkit going. I hope this helps others.
Del
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide