Guest User

Untitled

a guest
Jan 18th, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.29 KB | None | 0 0
  1. Cannot convert argument "0", with value: "002374E4DBEC", for "LaunchClientApplication" to type "WebServiceProxy.ExternalId": "Cannot convert the "002374E4DBEC" value of type "System.String" to type "WebServiceProxy.ExternalId"."
  2. At C:PowerShellScriptsCrawler.ps1:72 char:50
  3. + $guid = $OSSNBranchWS.LaunchClientApplication <<<< ($FTCSTBExternalID.Ext_Device_ID,$applicationUri)
  4. + CategoryInfo : NotSpecified: (:) [], MethodException
  5. + FullyQualifiedErrorId : MethodArgumentConversionInvalidCastArgument
  6.  
  7. ### Crawler
  8.  
  9. ### SQL Login
  10. $SQLUser = "USERNAME"
  11. $SQLPassword = "PASSWORD"
  12.  
  13. $SQLServer = "SQLSERVERDB"
  14. $SQLDBName = "SQLDB"
  15.  
  16. $SqlQuery = "select a.externalID as Acct_Number, d.externalId as Ext_Device_ID
  17. from bm_account a inner join
  18. bm_device d on a.accountId = d.accountId
  19. where a.externalId='9999999999'
  20. order by Acct_Number,Ext_Device_ID"
  21.  
  22. $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
  23. $SqlConnection.ConnectionString = "Server = $SQLServer; Database = $SQLDBName; User ID = $SQLUser; Password = $SQLPassword;"
  24.  
  25. $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
  26. $SqlCmd.CommandText = $SqlQuery
  27. $SqlCmd.Connection = $SqlConnection
  28.  
  29. $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
  30. $SqlAdapter.SelectCommand = $SqlCmd
  31.  
  32. $DataSet = New-Object System.Data.DataSet
  33. $rowCount = $SqlAdapter.Fill($DataSet)
  34.  
  35. $SqlConnection.Close()
  36.  
  37. $FTCSTBExternalIDs = $DataSet.Tables[0]
  38.  
  39. $Domain = 'DM'
  40. $UserName = 'USERNAME'
  41. $Password = 'PASSWORD'
  42.  
  43. $UsernameDomain = $Domain+''+$UserName
  44.  
  45. $SecurePassword=ConvertTo-SecureString -String $Password -AsPlainText -Force
  46.  
  47. $Credential = New-Object System.Management.Automation.PSCredential $UsernameDomain,$SecurePassword
  48.  
  49. $OSSNBranchWS = New-WebServiceProxy -Uri "http://mediaroomserver/ossNotificationsWS/UI.asmx?wsdl" -Namespace WebServiceProxy -Credential $Credential
  50.  
  51. $applicationUri = "page:http://mediaroomserver.com/FTCPFApps/STBScrollingMessages/MediaroomPage.aspx"
  52.  
  53. ForEach ($FTCSTBExternalID in $FTCSTBExternalIDs)
  54. {
  55. $msg_time = Get-Date -UFormat "%Y-%m-%d %r"
  56. $message = $msg_time+' - FTC Account Number: "'+$FTCSTBExternalID.Acct_Number+'", Device ID: "'+$FTCSTBExternalID.Ext_Device_ID+'"' | Out-File $log_file -Append
  57.  
  58. $guid = $OSSNBranchWS.LaunchClientApplication($FTCSTBExternalID.Ext_Device_ID,$applicationUri)
  59. }
Add Comment
Please, Sign In to add comment